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

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

#
text | 12 lines | 10 code | 2 blank | 0 comment | 0 complexity | b68e1d00adcf60b04cbbf6faec7110fc MD5 | raw file
 1set hive.optimize.ppd=true;
 2
 3EXPLAIN
 4SELECT src1.c1 
 5FROM
 6(SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1
 7WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400'); 
 8
 9SELECT src1.c1 
10FROM
11(SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1
12WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400');