blob: 501bb6ab32f25e4aae2686be9fab25f71cd5d5d2 (
plain) (
blame)
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
|
CREATE TABLE `tmp_showcrt1`(
`key` smallint,
`value` float)
COMMENT 'temporary table'
CLUSTERED BY (
key)
SORTED BY (
value DESC)
INTO 5 BUCKETS
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
'file:/private/var/folders/36/cjkbrr953xg2p_krwrmn8h_r0000gn/T/sparkHiveWarehouse1201055597819413730/tmp_showcrt1'
TBLPROPERTIES (
'numFiles'='0',
'EXTERNAL'='FALSE',
'last_modified_by'='marmbrus',
'last_modified_time'='1413891329',
'transient_lastDdlTime'='1413891329',
'COLUMN_STATS_ACCURATE'='false',
'totalSize'='0',
'numRows'='-1',
'rawDataSize'='-1')
|