PageRenderTime 14ms CodeModel.GetById 11ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/input_part7.q

#
text | 14 lines | 13 code | 1 blank | 0 comment | 0 complexity | dfbc2eef624efbc87b2f9b1d35dd46bf MD5 | raw file
 1EXPLAIN EXTENDED
 2SELECT * FROM (
 3  SELECT X.* FROM SRCPART X WHERE X.ds = '2008-04-08' and X.key < 100
 4  UNION ALL
 5  SELECT Y.* FROM SRCPART Y WHERE Y.ds = '2008-04-08' and Y.key < 100
 6) A
 7SORT BY A.key, A.value, A.ds, A.hr;
 8
 9SELECT * FROM (
10  SELECT X.* FROM SRCPART X WHERE X.ds = '2008-04-08' and X.key < 100
11  UNION ALL
12  SELECT Y.* FROM SRCPART Y WHERE Y.ds = '2008-04-08' and Y.key < 100
13) A
14SORT BY A.key, A.value, A.ds, A.hr;