PageRenderTime 19ms CodeModel.GetById 15ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 14 lines | 10 code | 4 blank | 0 comment | 0 complexity | a511b909d052c9e0ae3b3e70164420df MD5 | raw file
 1EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3;
 2SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3;
 3
 4EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302;
 5SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302;
 6
 7EXPLAIN SELECT key FROM src GROUP BY key HAVING max(value) > "val_255";
 8SELECT key FROM src GROUP BY key HAVING max(value) > "val_255";
 9
10EXPLAIN SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255";
11SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255";
12
13EXPLAIN SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255";
14SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255";