PageRenderTime 22ms CodeModel.GetById 16ms app.highlight 1ms RepoModel.GetById 2ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientnegative/clusterbydistributeby.q

#
text | 8 lines | 7 code | 1 blank | 0 comment | 0 complexity | 055a9873e4dcee0b5787fdaa3a804d91 MD5 | raw file
1CREATE TABLE dest1(key INT, ten INT, one INT, value STRING) STORED AS TEXTFILE;
2
3FROM src
4INSERT OVERWRITE TABLE dest1
5MAP src.key, CAST(src.key / 10 AS INT), CAST(src.key % 10 AS INT), src.value
6USING '/bin/cat' AS (tkey, ten, one, tvalue)
7CLUSTER BY tvalue, tkey
8DISTRIBUTE BY tvalue, tkey;