http://git-wip-us.apache.org/repos/asf/hive/blob/9bd040ad/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 deleted file mode 100644 index 15ae3d9..0000000 --- a/itests/hive-blobstore/src/test/results/clientpositive/parquet_nonstd_partitions_loc.q.out +++ /dev/null @@ -1,537 +0,0 @@ -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/9bd040ad/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 deleted file mode 100644 index 192b80f..0000000 --- a/itests/hive-blobstore/src/test/results/clientpositive/ptf_parquetfile.q.out +++ /dev/null @@ -1,104 +0,0 @@ -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
