blob: ad94c292dd70117fe49839ad79fb461f41e66a6d [file] [log] [blame]
--! qt:dataset:src
set hive.mapred.mode=nonstrict;
SELECT key, value FROM src CLUSTER BY key, value;
SELECT key, value FROM src ORDER BY key ASC, value ASC;
SELECT key, value FROM src SORT BY key, value;
SELECT * FROM (SELECT key, value FROM src DISTRIBUTE BY key, value)t ORDER BY key, value;
SELECT key, value FROM src CLUSTER BY (key, value);
SELECT key, value FROM src ORDER BY key ASC, value ASC;
SELECT key, value FROM src SORT BY (key, value);
SELECT * FROM (SELECT key, value FROM src DISTRIBUTE BY (key, value))t ORDER BY key, value;