| --! qt:dataset:srcpart |
| set hive.mapred.mode=nonstrict; |
| CREATE TABLE dest1_n45(key INT, value STRING, hr STRING, ds STRING) STORED AS TEXTFILE; |
| |
| EXPLAIN EXTENDED |
| FROM srcpart |
| INSERT OVERWRITE TABLE dest1_n45 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'; |
| |
| FROM srcpart |
| INSERT OVERWRITE TABLE dest1_n45 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'; |
| |
| SELECT dest1_n45.* FROM dest1_n45; |
| |