--! qt:dataset:src

CREATE TABLE fact_daily_n1(x int) PARTITIONED BY (ds STRING);
CREATE TABLE fact_tz_n0(x int) PARTITIONED BY (ds STRING, hr STRING)
LOCATION 'pfile:${system:test.tmp.dir}/fact_tz';

INSERT OVERWRITE TABLE fact_tz_n0 PARTITION (ds='1', hr='1')
SELECT key+11 FROM src WHERE key=484;

ALTER TABLE fact_daily_n1 SET TBLPROPERTIES('EXTERNAL'='TRUE');
ALTER TABLE fact_daily_n1 ADD PARTITION (ds='1')
LOCATION 'pfile:${system:test.tmp.dir}/fact_tz/ds=1';

set mapred.input.dir.recursive=true;
set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;

SELECT * FROM fact_daily_n1 WHERE ds='1';

SELECT count(1) FROM fact_daily_n1 WHERE ds='1';