You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by we...@apache.org on 2017/05/05 17:32:25 UTC
[38/51] [partial] hive git commit: HIVE-14671 : merge master into
hive-14535 (Wei Zheng)
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