| --! qt:dataset:srcpart |
| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| set hive.archive.enabled = true; |
| ; |
| |
| create database ac_test; |
| |
| create table ac_test.tstsrc like default.src; |
| insert overwrite table ac_test.tstsrc select key, value from default.src; |
| |
| create table ac_test.tstsrcpart like default.srcpart; |
| |
| insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-08', hr='11') |
| select key, value from default.srcpart where ds='2008-04-08' and hr='11'; |
| |
| insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-08', hr='12') |
| select key, value from default.srcpart where ds='2008-04-08' and hr='12'; |
| |
| insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-09', hr='11') |
| select key, value from default.srcpart where ds='2008-04-09' and hr='11'; |
| |
| insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-09', hr='12') |
| select key, value from default.srcpart where ds='2008-04-09' and hr='12'; |
| |
| |
| SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col |
| FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2; |
| |
| EXPLAIN ALTER TABLE ac_test.tstsrcpart ARCHIVE PARTITION (ds='2008-04-08'); |
| ALTER TABLE ac_test.tstsrcpart ARCHIVE PARTITION (ds='2008-04-08'); |
| |
| SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col |
| FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2; |
| |
| SELECT key, count(1) FROM ac_test.tstsrcpart WHERE ds='2008-04-08' AND hr='12' AND key='0' GROUP BY key; |
| |
| SELECT * FROM ac_test.tstsrcpart a JOIN ac_test.tstsrc b ON a.key=b.key |
| WHERE a.ds='2008-04-08' AND a.hr='12' AND a.key='0'; |
| |
| EXPLAIN ALTER TABLE ac_test.tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08'); |
| ALTER TABLE ac_test.tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08'); |
| |
| SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col |
| FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2; |