| --! qt:dataset:srcpart |
| --! qt:dataset:src1 |
| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| set hive.explain.user=false; |
| -- SORT_QUERY_RESULTS |
| |
| explain select distinct src.* from src; |
| |
| -- SORT_QUERY_RESULTS |
| |
| select distinct src.* from src; |
| |
| select distinct * from src; |
| |
| explain select distinct * from src where key < '3'; |
| |
| select distinct * from src where key < '3'; |
| |
| from src a select distinct a.* where a.key = '238'; |
| |
| explain |
| SELECT distinct * from ( |
| select * from src1 |
| union all |
| select * from src )subq; |
| |
| SELECT distinct * from ( |
| select * from src1 |
| union all |
| select * from src )subq; |
| |
| drop view if exists sdi; |
| |
| explain create view sdi as select distinct * from src order by key limit 2; |
| |
| create view sdi as select distinct * from src order by key limit 2; |
| |
| describe extended sdi; |
| |
| describe formatted sdi; |
| |
| select * from sdi; |
| |
| select distinct * from src union all select distinct * from src1; |
| |
| select distinct * from src join src1 on src.key=src1.key; |
| |
| SELECT distinct * |
| FROM src1 x JOIN src y ON (x.key = y.key) |
| JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11); |
| |
| select * from (select distinct * from src)src1 |
| join |
| (select distinct * from src)src2 |
| on src1.key=src2.key; |
| |
| select distinct * from (select distinct * from src)src1; |
| |
| explain select distinct src.* from src; |
| |
| select distinct src.* from src; |
| |
| select distinct * from src; |
| |
| explain select distinct * from src where key < '3'; |
| |
| select distinct * from src where key < '3'; |
| |
| from src a select distinct a.* where a.key = '238'; |
| |
| explain |
| SELECT distinct * from ( |
| select * from src1 |
| union all |
| select * from src )subq; |
| |
| SELECT distinct * from ( |
| select * from src1 |
| union all |
| select * from src )subq; |
| |
| drop view if exists sdi; |
| |
| explain create view sdi as select distinct * from src order by key limit 2; |
| |
| create view sdi as select distinct * from src order by key limit 2; |
| |
| describe extended sdi; |
| |
| describe formatted sdi; |
| |
| select * from sdi; |
| |
| select distinct * from src union all select distinct * from src1; |
| |
| select distinct * from src join src1 on src.key=src1.key; |
| |
| SELECT distinct * |
| FROM src1 x JOIN src y ON (x.key = y.key) |
| JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11); |
| |
| select * from (select distinct * from src)src1 |
| join |
| (select distinct * from src)src2 |
| on src1.key=src2.key; |
| |
| select distinct * from (select distinct * from src)src1; |