| --! qt:dataset:srcpart |
| --! qt:dataset:src1 |
| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| set hive.cbo.enable=true; |
| |
| select |
| interval_day_time('2 1:2:3'), |
| interval_day_time(cast('2 1:2:3' as string)), |
| interval_day_time(cast('2 1:2:3' as varchar(10))), |
| interval_day_time(cast('2 1:2:3' as char(10))), |
| interval_day_time('2 1:2:3') = interval '2 1:2:3' day to second |
| from src limit 1; |
| |
| select count(*) from srcpart join (select ds as ds, ds as `date` from srcpart group by ds) s on (srcpart.ds = s.ds) where s.`date` = '2008-04-08'; |
| |
| drop view t1_n107; |
| |
| create table t1_new (key string, value string) partitioned by (ds string); |
| |
| insert overwrite table t1_new partition (ds = '2011-10-15') |
| select 'key1', 'value1' from src tablesample (1 rows); |
| |
| insert overwrite table t1_new partition (ds = '2011-10-16') |
| select 'key2', 'value2' from src tablesample (1 rows); |
| |
| create view t1_n107 partitioned on (ds) as |
| select * from |
| ( |
| select key, value, ds from t1_new |
| union all |
| select key, value, ds from t1_new |
| )subq; |
| |
| select * from t1_n107 where ds = '2011-10-15'; |
| |
| |
| explain select array(1,2,3) from src; |
| |
| EXPLAIN |
| select key from (SELECT key from src where key = 1+3)s; |
| |
| select * from (select key from src where key = '1')subq; |
| |
| select '1'; |
| |
| select * from (select '1')subq; |
| |
| select * from (select key from src where false)subq; |
| |
| EXPLAIN |
| SELECT x.key, z.value, y.value |
| FROM src1 x JOIN src y ON (x.key = y.key and y.key = 1+2) |
| JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11+3); |
| |