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

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;