1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
CREATE EXTERNAL TABLE
external_schema.table_name
STORED AS PARQUET
LOCATION 's3://bucket/folder/'
AS
SELECT col1, col2 FROM external_schema.source_table
;
CREATE EXTERNAL TABLE
external_schema.table_name
STORED AS PARQUET
LOCATION 's3://bucket/folder/'
AS
SELECT * FROM external_schema.source_table
;
CREATE EXTERNAL TABLE
external_schema.table_name
PARTITIONED BY (col1 integer)
STORED AS PARQUET
LOCATION 's3://bucket/folder/'
AS
SELECT col1, col2 FROM external_schema.source_table
;
CREATE EXTERNAL TABLE
external_schema.table_name
PARTITIONED BY (col1 integer)
STORED AS PARQUET
LOCATION 's3://bucket/folder/'
AS
SELECT * FROM external_schema.source_table
;
CREATE EXTERNAL TABLE
external_schema.table_name
PARTITIONED BY (col1 integer, col2 integer)
STORED AS PARQUET
LOCATION 's3://bucket/folder/'
AS
SELECT col1, col2 FROM external_schema.source_table
;
CREATE EXTERNAL TABLE
external_schema.table_name
PARTITIONED BY (col1 integer, col2 integer)
STORED AS PARQUET
LOCATION 's3://bucket/folder/'
AS
SELECT * FROM external_schema.source_table
;
CREATE EXTERNAL TABLE
external_schema.table_name
PARTITIONED BY (col1 integer, col2 integer)
STORED AS PARQUET
LOCATION 's3://bucket/folder/'
AS (
SELECT col1, col2 FROM external_schema.source_table
)
;
CREATE EXTERNAL TABLE
external_schema.table_name
PARTITIONED BY (col1 integer, col2 integer)
ROW FORMAT DELIMITED LINES TERMINATED BY '\007'
STORED AS PARQUET
LOCATION 's3://bucket/folder/'
AS (
SELECT col1, col2 FROM external_schema.source_table
)
;
CREATE EXTERNAL TABLE
external_schema.table_name
PARTITIONED BY (col1 integer, col2 integer)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\007'
STORED AS PARQUET
LOCATION 's3://bucket/folder/'
AS (
SELECT col1, col2 FROM external_schema.source_table
)
;
CREATE EXTERNAL TABLE
external_schema.table_name
STORED AS PARQUET
LOCATION 's3://bucket/folder/'
TABLE PROPERTIES ('some_property1'='some_value1', 'some_property2'='some_value2')
AS
SELECT col1, col2 FROM external_schema.source_table
;
CREATE EXTERNAL TABLE spectrum.partitioned_lineitem
PARTITIONED BY (l_shipdate date, l_shipmode varchar(24))
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n\l'
STORED AS textfile
LOCATION 'S3://mybucket/cetas/partitioned_lineitem/'
AS SELECT l_orderkey, l_shipmode, l_shipdate, l_partkey FROM local_table;
|
