http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/orc_buckets.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/orc_buckets.q.out b/itests/hive-blobstore/src/test/results/clientpositive/orc_buckets.q.out new file mode 100644 index 0000000..e54b84e --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/orc_buckets.q.out @@ -0,0 +1,183 @@ +PREHOOK: query: DROP TABLE blobstore_source +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE blobstore_source +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE blobstore_source(a STRING, b STRING, c DOUBLE) +ROW FORMAT DELIMITED +FIELDS TERMINATED BY ' ' +COLLECTION ITEMS TERMINATED BY '\t' +LINES TERMINATED BY '\n' +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/orc_buckets/blobstore_source +PREHOOK: Output: database:default +PREHOOK: Output: default@blobstore_source +POSTHOOK: query: CREATE TABLE blobstore_source(a STRING, b STRING, c DOUBLE) +ROW FORMAT DELIMITED +FIELDS TERMINATED BY ' ' +COLLECTION ITEMS TERMINATED BY '\t' +LINES TERMINATED BY '\n' +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/orc_buckets/blobstore_source +POSTHOOK: Output: database:default +POSTHOOK: Output: default@blobstore_source +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/3col_data.txt' INTO TABLE blobstore_source +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@blobstore_source +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/3col_data.txt' INTO TABLE blobstore_source +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@blobstore_source +PREHOOK: query: DROP TABLE orc_buckets +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE orc_buckets +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE orc_buckets (a STRING, value DOUBLE) +PARTITIONED BY (b STRING) +CLUSTERED BY (a) INTO 10 BUCKETS +STORED AS ORC +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/orc_buckets/orc_buckets +PREHOOK: Output: database:default +PREHOOK: Output: default@orc_buckets +POSTHOOK: query: CREATE TABLE orc_buckets (a STRING, value DOUBLE) +PARTITIONED BY (b STRING) +CLUSTERED BY (a) INTO 10 BUCKETS +STORED AS ORC +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/orc_buckets/orc_buckets +POSTHOOK: Output: database:default +POSTHOOK: Output: default@orc_buckets +PREHOOK: query: INSERT OVERWRITE TABLE orc_buckets +PARTITION (b) +SELECT a, c, b FROM blobstore_source +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_source +PREHOOK: Output: default@orc_buckets +POSTHOOK: query: INSERT OVERWRITE TABLE orc_buckets +PARTITION (b) +SELECT a, c, b FROM blobstore_source +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_source +POSTHOOK: Output: default@orc_buckets@b=abc +POSTHOOK: Output: default@orc_buckets@b=ajss +POSTHOOK: Output: default@orc_buckets@b=data +POSTHOOK: Output: default@orc_buckets@b=def +POSTHOOK: Output: default@orc_buckets@b=djns +POSTHOOK: Output: default@orc_buckets@b=ne +POSTHOOK: Output: default@orc_buckets@b=random +POSTHOOK: Lineage: orc_buckets PARTITION(b=abc).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=abc).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=ajss).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=ajss).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=data).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=data).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=def).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=def).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=djns).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=djns).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=ne).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=ne).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=random).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=random).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +PREHOOK: query: SELECT * FROM orc_buckets +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_buckets +PREHOOK: Input: default@orc_buckets@b=abc +PREHOOK: Input: default@orc_buckets@b=ajss +PREHOOK: Input: default@orc_buckets@b=data +PREHOOK: Input: default@orc_buckets@b=def +PREHOOK: Input: default@orc_buckets@b=djns +PREHOOK: Input: default@orc_buckets@b=ne +PREHOOK: Input: default@orc_buckets@b=random +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM orc_buckets +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_buckets +POSTHOOK: Input: default@orc_buckets@b=abc +POSTHOOK: Input: default@orc_buckets@b=ajss +POSTHOOK: Input: default@orc_buckets@b=data +POSTHOOK: Input: default@orc_buckets@b=def +POSTHOOK: Input: default@orc_buckets@b=djns +POSTHOOK: Input: default@orc_buckets@b=ne +POSTHOOK: Input: default@orc_buckets@b=random +#### A masked pattern was here #### +1 10.5 abc +3 90.23232 ajss +6 3.002 data +2 11.5 def +4 89.02002 djns +7 71.9084 ne +5 2.99 random +PREHOOK: query: INSERT INTO TABLE orc_buckets +PARTITION (b) +SELECT a, c, b FROM blobstore_source +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_source +PREHOOK: Output: default@orc_buckets +POSTHOOK: query: INSERT INTO TABLE orc_buckets +PARTITION (b) +SELECT a, c, b FROM blobstore_source +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_source +POSTHOOK: Output: default@orc_buckets@b=abc +POSTHOOK: Output: default@orc_buckets@b=ajss +POSTHOOK: Output: default@orc_buckets@b=data +POSTHOOK: Output: default@orc_buckets@b=def +POSTHOOK: Output: default@orc_buckets@b=djns +POSTHOOK: Output: default@orc_buckets@b=ne +POSTHOOK: Output: default@orc_buckets@b=random +POSTHOOK: Lineage: orc_buckets PARTITION(b=abc).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=abc).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=ajss).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=ajss).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=data).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=data).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=def).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=def).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=djns).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=djns).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=ne).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=ne).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=random).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: orc_buckets PARTITION(b=random).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +PREHOOK: query: SELECT * FROM orc_buckets +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_buckets +PREHOOK: Input: default@orc_buckets@b=abc +PREHOOK: Input: default@orc_buckets@b=ajss +PREHOOK: Input: default@orc_buckets@b=data +PREHOOK: Input: default@orc_buckets@b=def +PREHOOK: Input: default@orc_buckets@b=djns +PREHOOK: Input: default@orc_buckets@b=ne +PREHOOK: Input: default@orc_buckets@b=random +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM orc_buckets +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_buckets +POSTHOOK: Input: default@orc_buckets@b=abc +POSTHOOK: Input: default@orc_buckets@b=ajss +POSTHOOK: Input: default@orc_buckets@b=data +POSTHOOK: Input: default@orc_buckets@b=def +POSTHOOK: Input: default@orc_buckets@b=djns +POSTHOOK: Input: default@orc_buckets@b=ne +POSTHOOK: Input: default@orc_buckets@b=random +#### A masked pattern was here #### +1 10.5 abc +1 10.5 abc +3 90.23232 ajss +3 90.23232 ajss +6 3.002 data +6 3.002 data +2 11.5 def +2 11.5 def +4 89.02002 djns +4 89.02002 djns +7 71.9084 ne +7 71.9084 ne +5 2.99 random +5 2.99 random
http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/orc_format_nonpart.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/orc_format_nonpart.q.out b/itests/hive-blobstore/src/test/results/clientpositive/orc_format_nonpart.q.out new file mode 100644 index 0000000..f470568 --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/orc_format_nonpart.q.out @@ -0,0 +1,195 @@ +PREHOOK: query: DROP TABLE blobstore_source +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE blobstore_source +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE blobstore_source(a STRING, b STRING, c DOUBLE) +ROW FORMAT DELIMITED +FIELDS TERMINATED BY ' ' +COLLECTION ITEMS TERMINATED BY '\t' +LINES TERMINATED BY '\n' +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/orc_format_nonpart/blobstore_source +PREHOOK: Output: database:default +PREHOOK: Output: default@blobstore_source +POSTHOOK: query: CREATE TABLE blobstore_source(a STRING, b STRING, c DOUBLE) +ROW FORMAT DELIMITED +FIELDS TERMINATED BY ' ' +COLLECTION ITEMS TERMINATED BY '\t' +LINES TERMINATED BY '\n' +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/orc_format_nonpart/blobstore_source +POSTHOOK: Output: database:default +POSTHOOK: Output: default@blobstore_source +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/3col_data.txt' INTO TABLE blobstore_source +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@blobstore_source +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/3col_data.txt' INTO TABLE blobstore_source +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@blobstore_source +PREHOOK: query: DROP TABLE orc_table +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE orc_table +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE EXTERNAL TABLE orc_table (a INT, b STRING, value DOUBLE) STORED AS ORC +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/orc_format_nonpart/orc_table +PREHOOK: Output: database:default +PREHOOK: Output: default@orc_table +POSTHOOK: query: CREATE EXTERNAL TABLE orc_table (a INT, b STRING, value DOUBLE) STORED AS ORC +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/orc_format_nonpart/orc_table +POSTHOOK: Output: database:default +POSTHOOK: Output: default@orc_table +PREHOOK: query: INSERT OVERWRITE TABLE orc_table +SELECT * FROM blobstore_source +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_source +PREHOOK: Output: default@orc_table +POSTHOOK: query: INSERT OVERWRITE TABLE orc_table +SELECT * FROM blobstore_source +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_source +POSTHOOK: Output: default@orc_table +PREHOOK: query: SELECT * FROM orc_table +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM orc_table +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table +#### A masked pattern was here #### +1 abc 10.5 +2 def 11.5 +3 ajss 90.23232 +4 djns 89.02002 +5 random 2.99 +6 data 3.002 +7 ne 71.9084 +PREHOOK: query: SELECT a FROM orc_table GROUP BY a +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT a FROM orc_table GROUP BY a +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table +#### A masked pattern was here #### +1 +2 +3 +4 +5 +6 +7 +PREHOOK: query: SELECT b FROM orc_table GROUP BY b +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT b FROM orc_table GROUP BY b +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table +#### A masked pattern was here #### +abc +ajss +data +def +djns +ne +random +PREHOOK: query: SELECT value FROM orc_table GROUP BY value +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT value FROM orc_table GROUP BY value +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table +#### A masked pattern was here #### +2.99 +3.002 +10.5 +11.5 +71.9084 +89.02002 +90.23232 +PREHOOK: query: INSERT INTO TABLE orc_table +SELECT * FROM blobstore_source +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_source +PREHOOK: Output: default@orc_table +POSTHOOK: query: INSERT INTO TABLE orc_table +SELECT * FROM blobstore_source +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_source +POSTHOOK: Output: default@orc_table +PREHOOK: query: SELECT * FROM orc_table +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM orc_table +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table +#### A masked pattern was here #### +1 abc 10.5 +2 def 11.5 +3 ajss 90.23232 +4 djns 89.02002 +5 random 2.99 +6 data 3.002 +7 ne 71.9084 +1 abc 10.5 +2 def 11.5 +3 ajss 90.23232 +4 djns 89.02002 +5 random 2.99 +6 data 3.002 +7 ne 71.9084 +PREHOOK: query: SELECT a FROM orc_table GROUP BY a +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT a FROM orc_table GROUP BY a +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table +#### A masked pattern was here #### +1 +2 +3 +4 +5 +6 +7 +PREHOOK: query: SELECT b FROM orc_table GROUP BY b +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT b FROM orc_table GROUP BY b +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table +#### A masked pattern was here #### +abc +ajss +data +def +djns +ne +random +PREHOOK: query: SELECT value FROM orc_table GROUP BY value +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT value FROM orc_table GROUP BY value +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_table +#### A masked pattern was here #### +2.99 +3.002 +10.5 +11.5 +71.9084 +89.02002 +90.23232 http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/orc_format_part.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/orc_format_part.q.out b/itests/hive-blobstore/src/test/results/clientpositive/orc_format_part.q.out new file mode 100644 index 0000000..5d1319f --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/orc_format_part.q.out @@ -0,0 +1,274 @@ +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 ###/orc_format_part/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 ###/orc_format_part/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 orc_events +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE orc_events +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE orc_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 ORC +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/orc_format_part/orc_events +PREHOOK: Output: database:default +PREHOOK: Output: default@orc_events +POSTHOOK: query: CREATE TABLE orc_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 ORC +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/orc_format_part/orc_events +POSTHOOK: Output: database:default +POSTHOOK: Output: default@orc_events +PREHOOK: query: INSERT OVERWRITE TABLE orc_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@orc_events +POSTHOOK: query: INSERT OVERWRITE TABLE orc_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@orc_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Output: default@orc_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Output: default@orc_events@run_date=20121121/game_id=39/event_name=hq_change +POSTHOOK: Lineage: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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 orc_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@orc_events +POSTHOOK: query: SHOW PARTITIONS orc_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@orc_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 orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +200 +PREHOOK: query: SELECT COUNT(*) FROM orc_events WHERE run_date=20120921 +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events WHERE run_date=20120921 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +50 +PREHOOK: query: SELECT COUNT(*) FROM orc_events WHERE run_date=20121121 +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events WHERE run_date=20121121 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +100 +PREHOOK: query: INSERT OVERWRITE TABLE orc_events PARTITION (run_date=201211, game_id, event_name) +SELECT log_id,time,uid,user_id,type,event_data,session_id,full_uid,game_id,event_name FROM src_events +WHERE SUBSTR(run_date,1,6)='201211' +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@orc_events@run_date=201211 +POSTHOOK: query: INSERT OVERWRITE TABLE orc_events PARTITION (run_date=201211, game_id, event_name) +SELECT log_id,time,uid,user_id,type,event_data,session_id,full_uid,game_id,event_name FROM src_events +WHERE SUBSTR(run_date,1,6)='201211' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@orc_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: Lineage: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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 orc_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@orc_events +POSTHOOK: query: SHOW PARTITIONS orc_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@orc_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 orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +300 +PREHOOK: query: INSERT INTO TABLE orc_events PARTITION (run_date=201209, game_id=39, event_name) +SELECT log_id,time,uid,user_id,type,event_data,session_id,full_uid,event_name FROM src_events +WHERE SUBSTR(run_date,1,6)='201209' AND game_id=39 +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@orc_events@run_date=201209/game_id=39 +POSTHOOK: query: INSERT INTO TABLE orc_events PARTITION (run_date=201209, game_id=39, event_name) +SELECT log_id,time,uid,user_id,type,event_data,session_id,full_uid,event_name FROM src_events +WHERE SUBSTR(run_date,1,6)='201209' AND game_id=39 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@orc_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Lineage: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: SELECT COUNT(*) FROM orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +350 +PREHOOK: query: INSERT INTO TABLE orc_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' AND game_id=39 AND event_name='hq_change' +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@orc_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT INTO TABLE orc_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' AND game_id=39 AND event_name='hq_change' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@orc_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: query: SELECT COUNT(*) FROM orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +400 +PREHOOK: query: INSERT OVERWRITE TABLE orc_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' AND game_id=39 AND event_name='hq_change' +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@orc_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT OVERWRITE TABLE orc_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' AND game_id=39 AND event_name='hq_change' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@orc_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: query: SELECT COUNT(*) FROM orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +350 http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/orc_nonstd_partitions_loc.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/orc_nonstd_partitions_loc.q.out b/itests/hive-blobstore/src/test/results/clientpositive/orc_nonstd_partitions_loc.q.out new file mode 100644 index 0000000..70e72f7 --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/orc_nonstd_partitions_loc.q.out @@ -0,0 +1,513 @@ +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 ###/orc_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 ###/orc_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 orc_events +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE orc_events +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE orc_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 ORC +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/orc_nonstd_partitions_loc/orc_events +PREHOOK: Output: database:default +PREHOOK: Output: default@orc_events +POSTHOOK: query: CREATE TABLE orc_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 ORC +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/orc_nonstd_partitions_loc/orc_events +POSTHOOK: Output: database:default +POSTHOOK: Output: default@orc_events +PREHOOK: query: INSERT OVERWRITE TABLE orc_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@orc_events +POSTHOOK: query: INSERT OVERWRITE TABLE orc_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@orc_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Output: default@orc_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Output: default@orc_events@run_date=20121121/game_id=39/event_name=hq_change +POSTHOOK: Lineage: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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 orc_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@orc_events +POSTHOOK: query: SHOW PARTITIONS orc_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@orc_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 orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +200 +PREHOOK: query: ALTER TABLE orc_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 ###/orc_nonstd_partitions_loc/orc_nonstd_loc/ns-part-1 +PREHOOK: Output: default@orc_events +POSTHOOK: query: ALTER TABLE orc_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 ###/orc_nonstd_partitions_loc/orc_nonstd_loc/ns-part-1 +POSTHOOK: Output: default@orc_events +POSTHOOK: Output: default@orc_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: query: INSERT OVERWRITE TABLE orc_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@orc_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT OVERWRITE TABLE orc_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@orc_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: query: SHOW PARTITIONS orc_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@orc_events +POSTHOOK: query: SHOW PARTITIONS orc_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@orc_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 orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +300 +PREHOOK: query: INSERT INTO TABLE orc_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@orc_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT INTO TABLE orc_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@orc_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: query: SHOW PARTITIONS orc_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@orc_events +POSTHOOK: query: SHOW PARTITIONS orc_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@orc_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 orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +400 +PREHOOK: query: ALTER TABLE orc_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 ###/orc_nonstd_partitions_loc/orc_nonstd_loc/ns-part-2 +PREHOOK: Output: default@orc_events +POSTHOOK: query: ALTER TABLE orc_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 ###/orc_nonstd_partitions_loc/orc_nonstd_loc/ns-part-2 +POSTHOOK: Output: default@orc_events +POSTHOOK: Output: default@orc_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: query: INSERT OVERWRITE TABLE orc_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@orc_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT OVERWRITE TABLE orc_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@orc_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Lineage: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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 orc_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@orc_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT INTO TABLE orc_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@orc_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Lineage: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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 orc_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@orc_events +POSTHOOK: query: SHOW PARTITIONS orc_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@orc_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 orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +500 +PREHOOK: query: INSERT OVERWRITE TABLE orc_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@orc_events +POSTHOOK: query: INSERT OVERWRITE TABLE orc_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@orc_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Output: default@orc_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Output: default@orc_events@run_date=20121121/game_id=39/event_name=hq_change +POSTHOOK: Lineage: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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 orc_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@orc_events +POSTHOOK: query: SHOW PARTITIONS orc_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@orc_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 orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +500 +PREHOOK: query: ALTER TABLE orc_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 ###/orc_nonstd_partitions_loc/orc_nonstd_loc/ns-part-3 +PREHOOK: Output: default@orc_events +POSTHOOK: query: ALTER TABLE orc_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 ###/orc_nonstd_partitions_loc/orc_nonstd_loc/ns-part-3 +POSTHOOK: Output: default@orc_events +POSTHOOK: Output: default@orc_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: query: INSERT INTO TABLE orc_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@orc_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: query: INSERT INTO TABLE orc_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@orc_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: query: SHOW PARTITIONS orc_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@orc_events +POSTHOOK: query: SHOW PARTITIONS orc_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@orc_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 orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +PREHOOK: Input: default@orc_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: Input: default@orc_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: Input: default@orc_events@run_date=20120921/game_id=39/event_name=hq_change +PREHOOK: Input: default@orc_events@run_date=20121021/game_id=39/event_name=hq_change +PREHOOK: Input: default@orc_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: Input: default@orc_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +POSTHOOK: Input: default@orc_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: Input: default@orc_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Input: default@orc_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Input: default@orc_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Input: default@orc_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: Input: default@orc_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +550 +PREHOOK: query: INSERT OVERWRITE TABLE orc_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +PREHOOK: type: QUERY +PREHOOK: Input: default@src_events +PREHOOK: Output: default@orc_events +POSTHOOK: query: INSERT OVERWRITE TABLE orc_events PARTITION (run_date, game_id, event_name) +SELECT * FROM src_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_events +POSTHOOK: Output: default@orc_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Output: default@orc_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Output: default@orc_events@run_date=20121121/game_id=39/event_name=hq_change +POSTHOOK: Lineage: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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: orc_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 orc_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@orc_events +POSTHOOK: query: SHOW PARTITIONS orc_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@orc_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 orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +PREHOOK: Input: default@orc_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: Input: default@orc_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: Input: default@orc_events@run_date=20120921/game_id=39/event_name=hq_change +PREHOOK: Input: default@orc_events@run_date=20121021/game_id=39/event_name=hq_change +PREHOOK: Input: default@orc_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: Input: default@orc_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +POSTHOOK: Input: default@orc_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: Input: default@orc_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: Input: default@orc_events@run_date=20120921/game_id=39/event_name=hq_change +POSTHOOK: Input: default@orc_events@run_date=20121021/game_id=39/event_name=hq_change +POSTHOOK: Input: default@orc_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: Input: default@orc_events@run_date=20121121/game_id=39/event_name=hq_change +#### A masked pattern was here #### +550 +PREHOOK: query: ALTER TABLE orc_events DROP PARTITION (run_date=201211, game_id=39, event_name='hq_change') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: default@orc_events +PREHOOK: Output: default@orc_events@run_date=201211/game_id=39/event_name=hq_change +POSTHOOK: query: ALTER TABLE orc_events DROP PARTITION (run_date=201211, game_id=39, event_name='hq_change') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: default@orc_events +POSTHOOK: Output: default@orc_events@run_date=201211/game_id=39/event_name=hq_change +PREHOOK: query: ALTER TABLE orc_events DROP PARTITION (run_date=201209, game_id=39, event_name='hq_change') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: default@orc_events +PREHOOK: Output: default@orc_events@run_date=201209/game_id=39/event_name=hq_change +POSTHOOK: query: ALTER TABLE orc_events DROP PARTITION (run_date=201209, game_id=39, event_name='hq_change') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: default@orc_events +POSTHOOK: Output: default@orc_events@run_date=201209/game_id=39/event_name=hq_change +PREHOOK: query: ALTER TABLE orc_events DROP PARTITION (run_date=201207, game_id=39, event_name='hq_change') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: default@orc_events +PREHOOK: Output: default@orc_events@run_date=201207/game_id=39/event_name=hq_change +POSTHOOK: query: ALTER TABLE orc_events DROP PARTITION (run_date=201207, game_id=39, event_name='hq_change') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: default@orc_events +POSTHOOK: Output: default@orc_events@run_date=201207/game_id=39/event_name=hq_change +PREHOOK: query: SHOW PARTITIONS orc_events +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@orc_events +POSTHOOK: query: SHOW PARTITIONS orc_events +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@orc_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 orc_events +PREHOOK: type: QUERY +PREHOOK: Input: default@orc_events +#### A masked pattern was here #### +POSTHOOK: query: SELECT COUNT(*) FROM orc_events +POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_events +#### A masked pattern was here #### +200 http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/rcfile_buckets.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/rcfile_buckets.q.out b/itests/hive-blobstore/src/test/results/clientpositive/rcfile_buckets.q.out new file mode 100644 index 0000000..6bcfd0a --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/rcfile_buckets.q.out @@ -0,0 +1,183 @@ +PREHOOK: query: DROP TABLE blobstore_source +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE blobstore_source +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE blobstore_source(a STRING, b STRING, c DOUBLE) +ROW FORMAT DELIMITED +FIELDS TERMINATED BY ' ' +COLLECTION ITEMS TERMINATED BY '\t' +LINES TERMINATED BY '\n' +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/rcfile_buckets/blobstore_source +PREHOOK: Output: database:default +PREHOOK: Output: default@blobstore_source +POSTHOOK: query: CREATE TABLE blobstore_source(a STRING, b STRING, c DOUBLE) +ROW FORMAT DELIMITED +FIELDS TERMINATED BY ' ' +COLLECTION ITEMS TERMINATED BY '\t' +LINES TERMINATED BY '\n' +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/rcfile_buckets/blobstore_source +POSTHOOK: Output: database:default +POSTHOOK: Output: default@blobstore_source +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/3col_data.txt' INTO TABLE blobstore_source +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@blobstore_source +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/3col_data.txt' INTO TABLE blobstore_source +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@blobstore_source +PREHOOK: query: DROP TABLE rcfile_buckets +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE rcfile_buckets +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE rcfile_buckets (a STRING, value DOUBLE) +PARTITIONED BY (b STRING) +CLUSTERED BY (a) INTO 10 BUCKETS +STORED AS RCFILE +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/rcfile_buckets/rcfile_buckets +PREHOOK: Output: database:default +PREHOOK: Output: default@rcfile_buckets +POSTHOOK: query: CREATE TABLE rcfile_buckets (a STRING, value DOUBLE) +PARTITIONED BY (b STRING) +CLUSTERED BY (a) INTO 10 BUCKETS +STORED AS RCFILE +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/rcfile_buckets/rcfile_buckets +POSTHOOK: Output: database:default +POSTHOOK: Output: default@rcfile_buckets +PREHOOK: query: INSERT OVERWRITE TABLE rcfile_buckets +PARTITION (b) +SELECT a, c, b FROM blobstore_source +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_source +PREHOOK: Output: default@rcfile_buckets +POSTHOOK: query: INSERT OVERWRITE TABLE rcfile_buckets +PARTITION (b) +SELECT a, c, b FROM blobstore_source +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_source +POSTHOOK: Output: default@rcfile_buckets@b=abc +POSTHOOK: Output: default@rcfile_buckets@b=ajss +POSTHOOK: Output: default@rcfile_buckets@b=data +POSTHOOK: Output: default@rcfile_buckets@b=def +POSTHOOK: Output: default@rcfile_buckets@b=djns +POSTHOOK: Output: default@rcfile_buckets@b=ne +POSTHOOK: Output: default@rcfile_buckets@b=random +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=abc).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=abc).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=ajss).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=ajss).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=data).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=data).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=def).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=def).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=djns).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=djns).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=ne).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=ne).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=random).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=random).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +PREHOOK: query: SELECT * FROM rcfile_buckets +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_buckets +PREHOOK: Input: default@rcfile_buckets@b=abc +PREHOOK: Input: default@rcfile_buckets@b=ajss +PREHOOK: Input: default@rcfile_buckets@b=data +PREHOOK: Input: default@rcfile_buckets@b=def +PREHOOK: Input: default@rcfile_buckets@b=djns +PREHOOK: Input: default@rcfile_buckets@b=ne +PREHOOK: Input: default@rcfile_buckets@b=random +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM rcfile_buckets +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_buckets +POSTHOOK: Input: default@rcfile_buckets@b=abc +POSTHOOK: Input: default@rcfile_buckets@b=ajss +POSTHOOK: Input: default@rcfile_buckets@b=data +POSTHOOK: Input: default@rcfile_buckets@b=def +POSTHOOK: Input: default@rcfile_buckets@b=djns +POSTHOOK: Input: default@rcfile_buckets@b=ne +POSTHOOK: Input: default@rcfile_buckets@b=random +#### A masked pattern was here #### +1 10.5 abc +3 90.23232 ajss +6 3.002 data +2 11.5 def +4 89.02002 djns +7 71.9084 ne +5 2.99 random +PREHOOK: query: INSERT INTO TABLE rcfile_buckets +PARTITION (b) +SELECT a, c, b FROM blobstore_source +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_source +PREHOOK: Output: default@rcfile_buckets +POSTHOOK: query: INSERT INTO TABLE rcfile_buckets +PARTITION (b) +SELECT a, c, b FROM blobstore_source +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_source +POSTHOOK: Output: default@rcfile_buckets@b=abc +POSTHOOK: Output: default@rcfile_buckets@b=ajss +POSTHOOK: Output: default@rcfile_buckets@b=data +POSTHOOK: Output: default@rcfile_buckets@b=def +POSTHOOK: Output: default@rcfile_buckets@b=djns +POSTHOOK: Output: default@rcfile_buckets@b=ne +POSTHOOK: Output: default@rcfile_buckets@b=random +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=abc).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=abc).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=ajss).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=ajss).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=data).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=data).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=def).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=def).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=djns).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=djns).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=ne).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=ne).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=random).a SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:a, type:string, comment:null), ] +POSTHOOK: Lineage: rcfile_buckets PARTITION(b=random).value SIMPLE [(blobstore_source)blobstore_source.FieldSchema(name:c, type:double, comment:null), ] +PREHOOK: query: SELECT * FROM rcfile_buckets +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_buckets +PREHOOK: Input: default@rcfile_buckets@b=abc +PREHOOK: Input: default@rcfile_buckets@b=ajss +PREHOOK: Input: default@rcfile_buckets@b=data +PREHOOK: Input: default@rcfile_buckets@b=def +PREHOOK: Input: default@rcfile_buckets@b=djns +PREHOOK: Input: default@rcfile_buckets@b=ne +PREHOOK: Input: default@rcfile_buckets@b=random +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM rcfile_buckets +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_buckets +POSTHOOK: Input: default@rcfile_buckets@b=abc +POSTHOOK: Input: default@rcfile_buckets@b=ajss +POSTHOOK: Input: default@rcfile_buckets@b=data +POSTHOOK: Input: default@rcfile_buckets@b=def +POSTHOOK: Input: default@rcfile_buckets@b=djns +POSTHOOK: Input: default@rcfile_buckets@b=ne +POSTHOOK: Input: default@rcfile_buckets@b=random +#### A masked pattern was here #### +1 10.5 abc +1 10.5 abc +3 90.23232 ajss +3 90.23232 ajss +6 3.002 data +6 3.002 data +2 11.5 def +2 11.5 def +4 89.02002 djns +4 89.02002 djns +7 71.9084 ne +7 71.9084 ne +5 2.99 random +5 2.99 random http://git-wip-us.apache.org/repos/asf/hive/blob/187eb760/itests/hive-blobstore/src/test/results/clientpositive/rcfile_format_nonpart.q.out ---------------------------------------------------------------------- diff --git a/itests/hive-blobstore/src/test/results/clientpositive/rcfile_format_nonpart.q.out b/itests/hive-blobstore/src/test/results/clientpositive/rcfile_format_nonpart.q.out new file mode 100644 index 0000000..44a1f11 --- /dev/null +++ b/itests/hive-blobstore/src/test/results/clientpositive/rcfile_format_nonpart.q.out @@ -0,0 +1,195 @@ +PREHOOK: query: DROP TABLE blobstore_source +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE blobstore_source +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE blobstore_source(a STRING, b STRING, c DOUBLE) +ROW FORMAT DELIMITED +FIELDS TERMINATED BY ' ' +COLLECTION ITEMS TERMINATED BY '\t' +LINES TERMINATED BY '\n' +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/rcfile_format_nonpart/blobstore_source +PREHOOK: Output: database:default +PREHOOK: Output: default@blobstore_source +POSTHOOK: query: CREATE TABLE blobstore_source(a STRING, b STRING, c DOUBLE) +ROW FORMAT DELIMITED +FIELDS TERMINATED BY ' ' +COLLECTION ITEMS TERMINATED BY '\t' +LINES TERMINATED BY '\n' +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/rcfile_format_nonpart/blobstore_source +POSTHOOK: Output: database:default +POSTHOOK: Output: default@blobstore_source +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/3col_data.txt' INTO TABLE blobstore_source +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@blobstore_source +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/3col_data.txt' INTO TABLE blobstore_source +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@blobstore_source +PREHOOK: query: DROP TABLE rcfile_table +PREHOOK: type: DROPTABLE +POSTHOOK: query: DROP TABLE rcfile_table +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE rcfile_table (a INT, b STRING, value DOUBLE) STORED AS RCFILE +#### A masked pattern was here #### +PREHOOK: type: CREATETABLE +PREHOOK: Input: ### test.blobstore.path ###/rcfile_format_nonpart/rcfile_table +PREHOOK: Output: database:default +PREHOOK: Output: default@rcfile_table +POSTHOOK: query: CREATE TABLE rcfile_table (a INT, b STRING, value DOUBLE) STORED AS RCFILE +#### A masked pattern was here #### +POSTHOOK: type: CREATETABLE +POSTHOOK: Input: ### test.blobstore.path ###/rcfile_format_nonpart/rcfile_table +POSTHOOK: Output: database:default +POSTHOOK: Output: default@rcfile_table +PREHOOK: query: INSERT OVERWRITE TABLE rcfile_table +SELECT * FROM blobstore_source +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_source +PREHOOK: Output: default@rcfile_table +POSTHOOK: query: INSERT OVERWRITE TABLE rcfile_table +SELECT * FROM blobstore_source +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_source +POSTHOOK: Output: default@rcfile_table +PREHOOK: query: SELECT * FROM rcfile_table +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM rcfile_table +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +1 abc 10.5 +2 def 11.5 +3 ajss 90.23232 +4 djns 89.02002 +5 random 2.99 +6 data 3.002 +7 ne 71.9084 +PREHOOK: query: SELECT a FROM rcfile_table GROUP BY a +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT a FROM rcfile_table GROUP BY a +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +1 +2 +3 +4 +5 +6 +7 +PREHOOK: query: SELECT b FROM rcfile_table GROUP BY b +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT b FROM rcfile_table GROUP BY b +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +abc +ajss +data +def +djns +ne +random +PREHOOK: query: SELECT VALUE FROM rcfile_table GROUP BY VALUE +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT VALUE FROM rcfile_table GROUP BY VALUE +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +2.99 +3.002 +10.5 +11.5 +71.9084 +89.02002 +90.23232 +PREHOOK: query: INSERT INTO TABLE rcfile_table +SELECT * FROM blobstore_source +PREHOOK: type: QUERY +PREHOOK: Input: default@blobstore_source +PREHOOK: Output: default@rcfile_table +POSTHOOK: query: INSERT INTO TABLE rcfile_table +SELECT * FROM blobstore_source +POSTHOOK: type: QUERY +POSTHOOK: Input: default@blobstore_source +POSTHOOK: Output: default@rcfile_table +PREHOOK: query: SELECT * FROM rcfile_table +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT * FROM rcfile_table +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +1 abc 10.5 +2 def 11.5 +3 ajss 90.23232 +4 djns 89.02002 +5 random 2.99 +6 data 3.002 +7 ne 71.9084 +1 abc 10.5 +2 def 11.5 +3 ajss 90.23232 +4 djns 89.02002 +5 random 2.99 +6 data 3.002 +7 ne 71.9084 +PREHOOK: query: SELECT a FROM rcfile_table GROUP BY a +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT a FROM rcfile_table GROUP BY a +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +1 +2 +3 +4 +5 +6 +7 +PREHOOK: query: SELECT b FROM rcfile_table GROUP BY b +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT b FROM rcfile_table GROUP BY b +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +abc +ajss +data +def +djns +ne +random +PREHOOK: query: SELECT value FROM rcfile_table GROUP BY value +PREHOOK: type: QUERY +PREHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT value FROM rcfile_table GROUP BY value +POSTHOOK: type: QUERY +POSTHOOK: Input: default@rcfile_table +#### A masked pattern was here #### +2.99 +3.002 +10.5 +11.5 +71.9084 +89.02002 +90.23232