Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 2B090200C55 for ; Thu, 30 Mar 2017 01:54:05 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 29991160BA0; Wed, 29 Mar 2017 23:54:05 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id A2284160B8A for ; Thu, 30 Mar 2017 01:54:03 +0200 (CEST) Received: (qmail 90339 invoked by uid 500); 29 Mar 2017 23:54:02 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 90327 invoked by uid 99); 29 Mar 2017 23:54:02 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Mar 2017 23:54:02 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id B8FABDFBED; Wed, 29 Mar 2017 23:54:02 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: hashutosh@apache.org To: commits@hive.apache.org Date: Wed, 29 Mar 2017 23:54:02 -0000 Message-Id: <34c46720472a4931a817301853d8f705@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [1/3] hive git commit: HIVE-16288 : Add blobstore tests for ORC and RCFILE file formats (Thomas Poepping via Ashutosh Chauhan) archived-at: Wed, 29 Mar 2017 23:54:05 -0000 Repository: hive Updated Branches: refs/heads/branch-2 e222a076d -> 1ff14a277 http://git-wip-us.apache.org/repos/asf/hive/blob/1ff14a27/hive-blobstore/src/test/results/clientpositive/rcfile_nonstd_partitions_loc.q.out ---------------------------------------------------------------------- diff --git a/hive-blobstore/src/test/results/clientpositive/rcfile_nonstd_partitions_loc.q.out b/hive-blobstore/src/test/results/clientpositive/rcfile_nonstd_partitions_loc.q.out new file mode 100644 index 0000000..c6442f9 --- /dev/null +++ b/hive-blobstore/src/test/results/clientpositive/rcfile_nonstd_partitions_loc.q.out @@ -0,0 +1,533 @@ +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 ###/rcfile_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 ###/rcfile_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 rcfile_events +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE rcfile_events +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE rcfile_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 RCFILE +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/rcfile_nonstd_partitions_loc/rcfile_events +PREHOOK: Output: database:default +PREHOOK: Output: default@rcfile_events +POSTHOOK: query: CREATE TABLE rcfile_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 RCFILE +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/rcfile_nonstd_partitions_loc/rcfile_events +POSTHOOK: Output: database:default +POSTHOOK: Output: default@rcfile_events +PREHOOK: query: INSERT OVERWRITE TABLE rcfile_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@rcfile_events +POSTHOOK: query: INSERT OVERWRITE TABLE rcfile_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@rcfile_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Output: default@rcfile_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Output: default@rcfile_events@run_date=20121121/game_id=39/event_name=hq_change +POSTHOOK: Lineage: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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 rcfile_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@rcfile_events +POSTHOOK: query: SHOW PARTITIONS rcfile_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@rcfile_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 rcfile_events +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM rcfile_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_events +#### A masked pattern was here #### +200 +PREHOOK: query: ALTER TABLE rcfile_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 ###/rcfile_nonstd_partitions_loc/rcfile_nonstd_loc/ns-part-1 +PREHOOK: Output: default@rcfile_events +POSTHOOK: query: ALTER TABLE rcfile_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 ###/rcfile_nonstd_partitions_loc/rcfile_nonstd_loc/ns-part-1 +POSTHOOK: Output: default@rcfile_events +POSTHOOK: Output: default@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: query: INSERT OVERWRITE TABLE rcfile_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@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT OVERWRITE TABLE rcfile_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@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: query: SHOW PARTITIONS rcfile_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@rcfile_events +POSTHOOK: query: SHOW PARTITIONS rcfile_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@rcfile_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 rcfile_events +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM rcfile_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_events +#### A masked pattern was here #### +300 +PREHOOK: query: INSERT INTO TABLE rcfile_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@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT INTO TABLE rcfile_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@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: query: SHOW PARTITIONS rcfile_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@rcfile_events +POSTHOOK: query: SHOW PARTITIONS rcfile_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@rcfile_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 rcfile_events +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM rcfile_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_events +#### A masked pattern was here #### +400 +PREHOOK: query: ALTER TABLE rcfile_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 ###/rcfile_nonstd_partitions_loc/rcfile_nonstd_loc/ns-part-2 +PREHOOK: Output: default@rcfile_events +POSTHOOK: query: ALTER TABLE rcfile_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 ###/rcfile_nonstd_partitions_loc/rcfile_nonstd_loc/ns-part-2 +POSTHOOK: Output: default@rcfile_events +POSTHOOK: Output: default@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: query: INSERT INTO TABLE rcfile_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@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT INTO TABLE rcfile_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@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Lineage: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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 rcfile_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@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT INTO TABLE rcfile_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@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Lineage: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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 rcfile_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@rcfile_events +POSTHOOK: query: SHOW PARTITIONS rcfile_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@rcfile_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 rcfile_events +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_events +PREHOOK: Input: default@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=20120921/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=20121021/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM rcfile_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_events +POSTHOOK: Input: default@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +500 +PREHOOK: query: INSERT OVERWRITE TABLE rcfile_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@rcfile_events +POSTHOOK: query: INSERT OVERWRITE TABLE rcfile_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@rcfile_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Output: default@rcfile_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Output: default@rcfile_events@run_date=20121121/game_id=39/event_name=hq_change +POSTHOOK: Lineage: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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 rcfile_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@rcfile_events +POSTHOOK: query: SHOW PARTITIONS rcfile_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@rcfile_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 rcfile_events +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_events +PREHOOK: Input: default@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=20120921/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=20121021/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM rcfile_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_events +POSTHOOK: Input: default@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +500 +PREHOOK: query: ALTER TABLE rcfile_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 ###/rcfile_nonstd_partitions_loc/rcfile_nonstd_loc/ns-part-3 +PREHOOK: Output: default@rcfile_events +POSTHOOK: query: ALTER TABLE rcfile_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 ###/rcfile_nonstd_partitions_loc/rcfile_nonstd_loc/ns-part-3 +POSTHOOK: Output: default@rcfile_events +POSTHOOK: Output: default@rcfile_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: query: INSERT INTO TABLE rcfile_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@rcfile_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT INTO TABLE rcfile_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@rcfile_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: query: SHOW PARTITIONS rcfile_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@rcfile_events +POSTHOOK: query: SHOW PARTITIONS rcfile_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@rcfile_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 rcfile_events +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_events +PREHOOK: Input: default@rcfile_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=20120921/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=20121021/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM rcfile_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_events +POSTHOOK: Input: default@rcfile_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +550 +PREHOOK: query: INSERT OVERWRITE TABLE rcfile_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@rcfile_events +POSTHOOK: query: INSERT OVERWRITE TABLE rcfile_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@rcfile_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Output: default@rcfile_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Output: default@rcfile_events@run_date=20121121/game_id=39/event_name=hq_change +POSTHOOK: Lineage: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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: rcfile_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 rcfile_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@rcfile_events +POSTHOOK: query: SHOW PARTITIONS rcfile_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@rcfile_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 rcfile_events +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_events +PREHOOK: Input: default@rcfile_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=20120921/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=20121021/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: Input: default@rcfile_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM rcfile_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_events +POSTHOOK: Input: default@rcfile_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: Input: default@rcfile_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +550 +PREHOOK: query: ALTER TABLE rcfile_events DROP PARTITION (run_date=201211,game_id=39, event_name='hq_change') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: default@rcfile_events +PREHOOK: Output: default@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: query: ALTER TABLE rcfile_events DROP PARTITION (run_date=201211,game_id=39, event_name='hq_change') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: default@rcfile_events +POSTHOOK: Output: default@rcfile_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: query: ALTER TABLE rcfile_events DROP PARTITION (run_date=201209,game_id=39, event_name='hq_change') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: default@rcfile_events +PREHOOK: Output: default@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: query: ALTER TABLE rcfile_events DROP PARTITION (run_date=201209,game_id=39, event_name='hq_change') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: default@rcfile_events +POSTHOOK: Output: default@rcfile_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: query: ALTER TABLE rcfile_events DROP PARTITION (run_date=201207,game_id=39, event_name='hq_change') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: default@rcfile_events +PREHOOK: Output: default@rcfile_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: query: ALTER TABLE rcfile_events DROP PARTITION (run_date=201207,game_id=39, event_name='hq_change') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: default@rcfile_events +POSTHOOK: Output: default@rcfile_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: query: SHOW PARTITIONS rcfile_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@rcfile_events +POSTHOOK: query: SHOW PARTITIONS rcfile_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@rcfile_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 rcfile_events +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM rcfile_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_events +#### A masked pattern was here #### +200