Repository: hive Updated Branches: refs/heads/master c4c55d2ab -> b574bcdd0
http://git-wip-us.apache.org/repos/asf/hive/blob/b574bcdd/itests/hive-blobstore/src/test/results/clientpositive/parquet_nonstd_partitions_loc.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/parquet_nonstd_partitions_loc.q.out b/itests/hive-blobstore/src/test/results/clientpositive/parquet_nonstd_partitions_loc.q.out new file mode 100644 index 0000000..15ae3d9 --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/parquet_nonstd_partitions_loc.q.out @@ -0,0 +1,537 @@ +PREHOOK: query: DROP TABLE src_events +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE src_events +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE src_events +( + log_id BIGINT, + `time` BIGINT, + uid BIGINT, + user_id BIGINT, + type INT, + event_data STRING, + session_id STRING, + full_uid BIGINT, + run_date STRING, + game_id INT, + event_name STRING +) +ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/parquet_nonstd_partitions_loc/src_events +PREHOOK: Output: database:default +PREHOOK: Output: default@src_events +POSTHOOK: query: CREATE TABLE src_events +( + log_id BIGINT, + `time` BIGINT, + uid BIGINT, + user_id BIGINT, + type INT, + event_data STRING, + session_id STRING, + full_uid BIGINT, + run_date STRING, + game_id INT, + event_name STRING +) +ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/parquet_nonstd_partitions_loc/src_events +POSTHOOK: Output: database:default +POSTHOOK: Output: default@src_events +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/events.txt' INTO TABLE src_events +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@src_events +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/events.txt' INTO TABLE src_events +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@src_events +PREHOOK: query: DROP TABLE parquet_events +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE parquet_events +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE parquet_events +( + log_id BIGINT, + `time` BIGINT, + uid BIGINT, + user_id BIGINT, + type INT, + event_data STRING, + session_id STRING, + full_uid BIGINT +) +PARTITIONED BY (run_date STRING, game_id INT, event_name STRING) +STORED AS PARQUET +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/parquet_nonstd_partitions_loc/parquet_events +PREHOOK: Output: database:default +PREHOOK: Output: default@parquet_events +POSTHOOK: query: CREATE TABLE parquet_events +( + log_id BIGINT, + `time` BIGINT, + uid BIGINT, + user_id BIGINT, + type INT, + event_data STRING, + session_id STRING, + full_uid BIGINT +) +PARTITIONED BY (run_date STRING, game_id INT, event_name STRING) +STORED AS PARQUET +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/parquet_nonstd_partitions_loc/parquet_events +POSTHOOK: Output: database:default +POSTHOOK: Output: default@parquet_events +PREHOOK: query: INSERT OVERWRITE TABLE parquet_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@parquet_events +POSTHOOK: query: INSERT OVERWRITE TABLE parquet_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@parquet_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Output: default@parquet_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Output: default@parquet_events@run_date=20121121/game_id=39/event_name=hq_change +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +PREHOOK: query: SHOW PARTITIONS parquet_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@parquet_events +POSTHOOK: query: SHOW PARTITIONS parquet_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@parquet_events +run_date=20120921/game_id=39/event_name=hq_change +run_date=20121021/game_id=39/event_name=hq_change +run_date=20121121/game_id=39/event_name=hq_change +PREHOOK: query: SELECT COUNT(*) FROM parquet_events +PREHOOK: type: QUERY +PREHOOK: Input: default@parquet_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM parquet_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@parquet_events +#### A masked pattern was here #### +200 +PREHOOK: query: ALTER TABLE parquet_events ADD PARTITION (run_date=201211, game_id=39, event_name='hq_change') +#### A masked pattern was here #### +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: ### test.blobstore.path ###/parquet_nonstd_partitions_loc/parquet_nonstd_loc/ns-part-1 +PREHOOK: Output: default@parquet_events +POSTHOOK: query: ALTER TABLE parquet_events ADD PARTITION (run_date=201211, game_id=39, event_name='hq_change') +#### A masked pattern was here #### +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: ### test.blobstore.path ###/parquet_nonstd_partitions_loc/parquet_nonstd_loc/ns-part-1 +POSTHOOK: Output: default@parquet_events +POSTHOOK: Output: default@parquet_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: query: INSERT OVERWRITE TABLE parquet_events PARTITION (run_date=201211, game_id=39, event_name='hq_change') +SELECT log_id,`time`,uid,user_id,type,event_data,session_id,full_uid FROM src_events +WHERE SUBSTR(run_date,1,6)='201211' +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@parquet_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT OVERWRITE TABLE parquet_events PARTITION (run_date=201211, game_id=39, event_name='hq_change') +SELECT log_id,`time`,uid,user_id,type,event_data,session_id,full_uid FROM src_events +WHERE SUBSTR(run_date,1,6)='201211' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@parquet_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +PREHOOK: query: SHOW PARTITIONS parquet_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@parquet_events +POSTHOOK: query: SHOW PARTITIONS parquet_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@parquet_events +run_date=20120921/game_id=39/event_name=hq_change +run_date=20121021/game_id=39/event_name=hq_change +run_date=201211/game_id=39/event_name=hq_change +run_date=20121121/game_id=39/event_name=hq_change +PREHOOK: query: SELECT COUNT(*) FROM parquet_events +PREHOOK: type: QUERY +PREHOOK: Input: default@parquet_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM parquet_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@parquet_events +#### A masked pattern was here #### +300 +PREHOOK: query: INSERT INTO TABLE parquet_events PARTITION (run_date=201211, game_id=39, event_name='hq_change') +SELECT log_id,`time`,uid,user_id,type,event_data,session_id,full_uid FROM src_events +WHERE SUBSTR(run_date,1,6)='201211' +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@parquet_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT INTO TABLE parquet_events PARTITION (run_date=201211, game_id=39, event_name='hq_change') +SELECT log_id,`time`,uid,user_id,type,event_data,session_id,full_uid FROM src_events +WHERE SUBSTR(run_date,1,6)='201211' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@parquet_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201211,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +PREHOOK: query: SHOW PARTITIONS parquet_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@parquet_events +POSTHOOK: query: SHOW PARTITIONS parquet_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@parquet_events +run_date=20120921/game_id=39/event_name=hq_change +run_date=20121021/game_id=39/event_name=hq_change +run_date=201211/game_id=39/event_name=hq_change +run_date=20121121/game_id=39/event_name=hq_change +PREHOOK: query: SELECT COUNT(*) FROM parquet_events +PREHOOK: type: QUERY +PREHOOK: Input: default@parquet_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM parquet_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@parquet_events +#### A masked pattern was here #### +400 +PREHOOK: query: ALTER TABLE parquet_events ADD PARTITION (run_date=201209, game_id=39, event_name='hq_change') +#### A masked pattern was here #### +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: ### test.blobstore.path ###/parquet_nonstd_partitions_loc/parquet_nonstd_loc/ns-part-2 +PREHOOK: Output: default@parquet_events +POSTHOOK: query: ALTER TABLE parquet_events ADD PARTITION (run_date=201209, game_id=39, event_name='hq_change') +#### A masked pattern was here #### +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: ### test.blobstore.path ###/parquet_nonstd_partitions_loc/parquet_nonstd_loc/ns-part-2 +POSTHOOK: Output: default@parquet_events +POSTHOOK: Output: default@parquet_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: query: INSERT OVERWRITE TABLE parquet_events PARTITION (run_date=201209, game_id=39, event_name='hq_change') +SELECT log_id,`time`,uid,user_id,type,event_data,session_id,full_uid FROM src_events +WHERE SUBSTR(run_date,1,6)='201209' +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@parquet_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT OVERWRITE TABLE parquet_events PARTITION (run_date=201209, game_id=39, event_name='hq_change') +SELECT log_id,`time`,uid,user_id,type,event_data,session_id,full_uid FROM src_events +WHERE SUBSTR(run_date,1,6)='201209' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@parquet_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +PREHOOK: query: INSERT INTO TABLE parquet_events PARTITION (run_date=201209, game_id=39, event_name='hq_change') +SELECT log_id,`time`,uid,user_id,type,event_data,session_id,full_uid FROM src_events +WHERE SUBSTR(run_date,1,6)='201209' +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@parquet_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT INTO TABLE parquet_events PARTITION (run_date=201209, game_id=39, event_name='hq_change') +SELECT log_id,`time`,uid,user_id,type,event_data,session_id,full_uid FROM src_events +WHERE SUBSTR(run_date,1,6)='201209' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@parquet_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201209,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +PREHOOK: query: SHOW PARTITIONS parquet_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@parquet_events +POSTHOOK: query: SHOW PARTITIONS parquet_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@parquet_events +run_date=201209/game_id=39/event_name=hq_change +run_date=20120921/game_id=39/event_name=hq_change +run_date=20121021/game_id=39/event_name=hq_change +run_date=201211/game_id=39/event_name=hq_change +run_date=20121121/game_id=39/event_name=hq_change +PREHOOK: query: SELECT COUNT(*) FROM parquet_events +PREHOOK: type: QUERY +PREHOOK: Input: default@parquet_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM parquet_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@parquet_events +#### A masked pattern was here #### +500 +PREHOOK: query: INSERT OVERWRITE TABLE parquet_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@parquet_events +POSTHOOK: query: INSERT OVERWRITE TABLE parquet_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@parquet_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Output: default@parquet_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Output: default@parquet_events@run_date=20121121/game_id=39/event_name=hq_change +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +PREHOOK: query: SHOW PARTITIONS parquet_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@parquet_events +POSTHOOK: query: SHOW PARTITIONS parquet_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@parquet_events +run_date=201209/game_id=39/event_name=hq_change +run_date=20120921/game_id=39/event_name=hq_change +run_date=20121021/game_id=39/event_name=hq_change +run_date=201211/game_id=39/event_name=hq_change +run_date=20121121/game_id=39/event_name=hq_change +PREHOOK: query: SELECT COUNT(*) FROM parquet_events +PREHOOK: type: QUERY +PREHOOK: Input: default@parquet_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM parquet_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@parquet_events +#### A masked pattern was here #### +500 +PREHOOK: query: ALTER TABLE parquet_events ADD PARTITION (run_date=201207, game_id=39, event_name='hq_change') +#### A masked pattern was here #### +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: ### test.blobstore.path ###/parquet_nonstd_partitions_loc/parquet_nonstd_loc/ns-part-3 +PREHOOK: Output: default@parquet_events +POSTHOOK: query: ALTER TABLE parquet_events ADD PARTITION (run_date=201207, game_id=39, event_name='hq_change') +#### A masked pattern was here #### +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: ### test.blobstore.path ###/parquet_nonstd_partitions_loc/parquet_nonstd_loc/ns-part-3 +POSTHOOK: Output: default@parquet_events +POSTHOOK: Output: default@parquet_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: query: INSERT INTO TABLE parquet_events PARTITION (run_date=201207, game_id=39, event_name='hq_change') +SELECT log_id,`time`,uid,user_id,type,event_data,session_id,full_uid FROM src_events +WHERE SUBSTR(run_date,1,6)='201209' +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@parquet_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT INTO TABLE parquet_events PARTITION (run_date=201207, game_id=39, event_name='hq_change') +SELECT log_id,`time`,uid,user_id,type,event_data,session_id,full_uid FROM src_events +WHERE SUBSTR(run_date,1,6)='201209' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@parquet_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201207,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201207,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201207,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201207,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201207,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201207,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201207,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=201207,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +PREHOOK: query: SHOW PARTITIONS parquet_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@parquet_events +POSTHOOK: query: SHOW PARTITIONS parquet_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@parquet_events +run_date=201207/game_id=39/event_name=hq_change +run_date=201209/game_id=39/event_name=hq_change +run_date=20120921/game_id=39/event_name=hq_change +run_date=20121021/game_id=39/event_name=hq_change +run_date=201211/game_id=39/event_name=hq_change +run_date=20121121/game_id=39/event_name=hq_change +PREHOOK: query: SELECT COUNT(*) FROM parquet_events +PREHOOK: type: QUERY +PREHOOK: Input: default@parquet_events +PREHOOK: Input: default@parquet_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: Input: default@parquet_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: Input: default@parquet_events@run_date=20120921/game_id=39/event_name=hq_change +PREHOOK: Input: default@parquet_events@run_date=20121021/game_id=39/event_name=hq_change +PREHOOK: Input: default@parquet_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: Input: default@parquet_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM parquet_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@parquet_events +POSTHOOK: Input: default@parquet_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: Input: default@parquet_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Input: default@parquet_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Input: default@parquet_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Input: default@parquet_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: Input: default@parquet_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +550 +PREHOOK: query: INSERT OVERWRITE TABLE parquet_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@parquet_events +POSTHOOK: query: INSERT OVERWRITE TABLE parquet_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@parquet_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Output: default@parquet_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Output: default@parquet_events@run_date=20121121/game_id=39/event_name=hq_change +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20120921,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121021,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).event_data SIMPLE [(src_events)src_events.FieldSchema(name:event_data, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).full_uid SIMPLE [(src_events)src_events.FieldSchema(name:full_uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).log_id SIMPLE [(src_events)src_events.FieldSchema(name:log_id, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).session_id SIMPLE [(src_events)src_events.FieldSchema(name:session_id, type:string, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).time SIMPLE [(src_events)src_events.FieldSchema(name:time, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).type SIMPLE [(src_events)src_events.FieldSchema(name:type, type:int, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).uid SIMPLE [(src_events)src_events.FieldSchema(name:uid, type:bigint, comment:null), ] +POSTHOOK: Lineage: parquet_events PARTITION(run_date=20121121,game_id=39,event_name=hq_change).user_id SIMPLE [(src_events)src_events.FieldSchema(name:user_id, type:bigint, comment:null), ] +PREHOOK: query: SHOW PARTITIONS parquet_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@parquet_events +POSTHOOK: query: SHOW PARTITIONS parquet_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@parquet_events +run_date=201207/game_id=39/event_name=hq_change +run_date=201209/game_id=39/event_name=hq_change +run_date=20120921/game_id=39/event_name=hq_change +run_date=20121021/game_id=39/event_name=hq_change +run_date=201211/game_id=39/event_name=hq_change +run_date=20121121/game_id=39/event_name=hq_change +PREHOOK: query: SELECT COUNT(*) FROM parquet_events +PREHOOK: type: QUERY +PREHOOK: Input: default@parquet_events +PREHOOK: Input: default@parquet_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: Input: default@parquet_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: Input: default@parquet_events@run_date=20120921/game_id=39/event_name=hq_change +PREHOOK: Input: default@parquet_events@run_date=20121021/game_id=39/event_name=hq_change +PREHOOK: Input: default@parquet_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: Input: default@parquet_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM parquet_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@parquet_events +POSTHOOK: Input: default@parquet_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: Input: default@parquet_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Input: default@parquet_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Input: default@parquet_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Input: default@parquet_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: Input: default@parquet_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +550 +PREHOOK: query: ALTER TABLE parquet_events DROP PARTITION (run_date=201211, game_id=39, event_name='hq_change') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: default@parquet_events +PREHOOK: Output: default@parquet_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: query: ALTER TABLE parquet_events DROP PARTITION (run_date=201211, game_id=39, event_name='hq_change') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: default@parquet_events +POSTHOOK: Output: default@parquet_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: query: ALTER TABLE parquet_events DROP PARTITION (run_date=201209, game_id=39, event_name='hq_change') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: default@parquet_events +PREHOOK: Output: default@parquet_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: query: ALTER TABLE parquet_events DROP PARTITION (run_date=201209, game_id=39, event_name='hq_change') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: default@parquet_events +POSTHOOK: Output: default@parquet_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: query: ALTER TABLE parquet_events DROP PARTITION (run_date=201207, game_id=39, event_name='hq_change') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: default@parquet_events +PREHOOK: Output: default@parquet_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: query: ALTER TABLE parquet_events DROP PARTITION (run_date=201207, game_id=39, event_name='hq_change') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: default@parquet_events +POSTHOOK: Output: default@parquet_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: query: SHOW PARTITIONS parquet_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@parquet_events +POSTHOOK: query: SHOW PARTITIONS parquet_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@parquet_events +run_date=20120921/game_id=39/event_name=hq_change +run_date=20121021/game_id=39/event_name=hq_change +run_date=20121121/game_id=39/event_name=hq_change +PREHOOK: query: SELECT COUNT(*) FROM parquet_events +PREHOOK: type: QUERY +PREHOOK: Input: default@parquet_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM parquet_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@parquet_events +#### A masked pattern was here #### +200 http://git-wip-us.apache.org/repos/asf/hive/blob/b574bcdd/itests/hive-blobstore/src/test/results/clientpositive/ptf_parquetfile.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/ptf_parquetfile.q.out b/itests/hive-blobstore/src/test/results/clientpositive/ptf_parquetfile.q.out new file mode 100644 index 0000000..192b80f --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/ptf_parquetfile.q.out @@ -0,0 +1,104 @@ +PREHOOK: query: DROP TABLE part_parquet +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE part_parquet +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE part_parquet( + p_partkey int, + p_name string, + p_mfgr string, + p_brand string, + p_type string, + p_size int, + p_container string, + p_retailprice double, + p_comment string +) +STORED AS PARQUET +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/ptf_parquetfile/part_parquet +PREHOOK: Output: database:default +PREHOOK: Output: default@part_parquet +POSTHOOK: query: CREATE TABLE part_parquet( + p_partkey int, + p_name string, + p_mfgr string, + p_brand string, + p_type string, + p_size int, + p_container string, + p_retailprice double, + p_comment string +) +STORED AS PARQUET +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/ptf_parquetfile/part_parquet +POSTHOOK: Output: database:default +POSTHOOK: Output: default@part_parquet +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part.parquet' OVERWRITE INTO TABLE part_parquet +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@part_parquet +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part.parquet' OVERWRITE INTO TABLE part_parquet +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@part_parquet +PREHOOK: query: SELECT + p_mfgr, p_name, p_size, + RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS r, + DENSE_RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS dr, + SUM(p_retailprice) OVER ( + PARTITION BY p_mfgr + ORDER BY p_name ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW + ) AS s1 +FROM NOOP( + ON part_parquet + PARTITION BY p_mfgr + ORDER BY p_name +) +PREHOOK: type: QUERY +PREHOOK: Input: default@part_parquet +#### A masked pattern was here #### +POSTHOOK: query: SELECT + p_mfgr, p_name, p_size, + RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS r, + DENSE_RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS dr, + SUM(p_retailprice) OVER ( + PARTITION BY p_mfgr + ORDER BY p_name ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW + ) AS s1 +FROM NOOP( + ON part_parquet + PARTITION BY p_mfgr + ORDER BY p_name +) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@part_parquet +#### A masked pattern was here #### +Manufacturer#1 almond antique burnished rose metallic 2 1 1 1173.15 +Manufacturer#1 almond antique burnished rose metallic 2 1 1 2346.3 +Manufacturer#1 almond antique chartreuse lavender yellow 34 3 2 4100.06 +Manufacturer#1 almond antique salmon chartreuse burlywood 6 4 3 5702.650000000001 +Manufacturer#1 almond aquamarine burnished black steel 28 5 4 7117.070000000001 +Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5 8749.730000000001 +Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 1690.68 +Manufacturer#2 almond antique violet turquoise frosted 40 2 2 3491.38 +Manufacturer#2 almond aquamarine midnight light salmon 2 3 3 5523.360000000001 +Manufacturer#2 almond aquamarine rose maroon antique 25 4 4 7222.02 +Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5 5 8923.62 +Manufacturer#3 almond antique chartreuse khaki white 17 1 1 1671.68 +Manufacturer#3 almond antique forest lavender goldenrod 14 2 2 2861.95 +Manufacturer#3 almond antique metallic orange dim 19 3 3 4272.34 +Manufacturer#3 almond antique misty red olive 1 4 4 6195.32 +Manufacturer#3 almond antique olive coral navajo 45 5 5 7532.61 +Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 1620.67 +Manufacturer#4 almond antique violet mint lemon 39 2 2 2996.09 +Manufacturer#4 almond aquamarine floral ivory bisque 27 3 3 4202.35 +Manufacturer#4 almond aquamarine yellow dodger mint 7 4 4 6047.27 +Manufacturer#4 almond azure aquamarine papaya violet 12 5 5 7337.620000000001 +Manufacturer#5 almond antique blue firebrick mint 31 1 1 1789.69 +Manufacturer#5 almond antique medium spring khaki 6 2 2 3401.3500000000004 +Manufacturer#5 almond antique sky peru orange 2 3 3 5190.08 +Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 6208.18 +Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 7672.66