PREHOOK: query: -- SORT_QUERY_RESULTS

DROP TABLE orc_create
PREHOOK: type: DROPTABLE
POSTHOOK: query: -- SORT_QUERY_RESULTS

DROP TABLE orc_create
POSTHOOK: type: DROPTABLE
PREHOOK: query: DROP TABLE orc_create_complex
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE orc_create_complex
POSTHOOK: type: DROPTABLE
PREHOOK: query: DROP TABLE orc_create_staging
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE orc_create_staging
POSTHOOK: type: DROPTABLE
PREHOOK: query: DROP TABLE orc_create_people_staging
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE orc_create_people_staging
POSTHOOK: type: DROPTABLE
PREHOOK: query: DROP TABLE orc_create_people
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE orc_create_people
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE orc_create_staging (
  str STRING,
  mp  MAP<STRING,STRING>,
  lst ARRAY<STRING>,
  strct STRUCT<A:STRING,B:STRING>
) ROW FORMAT DELIMITED
    FIELDS TERMINATED BY '|'
    COLLECTION ITEMS TERMINATED BY ','
    MAP KEYS TERMINATED BY ':'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@orc_create_staging
POSTHOOK: query: CREATE TABLE orc_create_staging (
  str STRING,
  mp  MAP<STRING,STRING>,
  lst ARRAY<STRING>,
  strct STRUCT<A:STRING,B:STRING>
) ROW FORMAT DELIMITED
    FIELDS TERMINATED BY '|'
    COLLECTION ITEMS TERMINATED BY ','
    MAP KEYS TERMINATED BY ':'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@orc_create_staging
PREHOOK: query: DESCRIBE FORMATTED orc_create_staging
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@orc_create_staging
POSTHOOK: query: DESCRIBE FORMATTED orc_create_staging
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@orc_create_staging
# col_name            	data_type           	comment             
	 	 
str                 	string              	                    
mp                  	map<string,string>  	                    
lst                 	array<string>       	                    
strct               	struct<A:string,B:string>	                    
	 	 
# Detailed Table Information	 	 
Database:           	default             	 
#### A masked pattern was here ####
Protect Mode:       	None                	 
Retention:          	0                   	 
#### A masked pattern was here ####
Table Type:         	MANAGED_TABLE       	 
Table Parameters:	 	 
#### A masked pattern was here ####
	 	 
# Storage Information	 	 
SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
Compressed:         	No                  	 
Num Buckets:        	-1                  	 
Bucket Columns:     	[]                  	 
Sort Columns:       	[]                  	 
Storage Desc Params:	 	 
	colelction.delim    	,                   
	field.delim         	|                   
	mapkey.delim        	:                   
	serialization.format	|                   
PREHOOK: query: CREATE TABLE orc_create (key INT, value STRING)
   PARTITIONED BY (ds string)
   STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@orc_create
POSTHOOK: query: CREATE TABLE orc_create (key INT, value STRING)
   PARTITIONED BY (ds string)
   STORED AS ORC
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@orc_create
PREHOOK: query: DESCRIBE FORMATTED orc_create
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@orc_create
POSTHOOK: query: DESCRIBE FORMATTED orc_create
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@orc_create
# col_name            	data_type           	comment             
	 	 
key                 	int                 	                    
value               	string              	                    
	 	 
# Partition Information	 	 
# col_name            	data_type           	comment             
	 	 
ds                  	string              	                    
	 	 
# Detailed Table Information	 	 
Database:           	default             	 
#### A masked pattern was here ####
Protect Mode:       	None                	 
Retention:          	0                   	 
#### A masked pattern was here ####
Table Type:         	MANAGED_TABLE       	 
Table Parameters:	 	 
#### A masked pattern was here ####
	 	 
# Storage Information	 	 
SerDe Library:      	org.apache.hadoop.hive.ql.io.orc.OrcSerde	 
InputFormat:        	org.apache.hadoop.hive.ql.io.orc.OrcInputFormat	 
OutputFormat:       	org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat	 
Compressed:         	No                  	 
Num Buckets:        	-1                  	 
Bucket Columns:     	[]                  	 
Sort Columns:       	[]                  	 
Storage Desc Params:	 	 
	serialization.format	1                   
PREHOOK: query: DROP TABLE orc_create
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orc_create
PREHOOK: Output: default@orc_create
POSTHOOK: query: DROP TABLE orc_create
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@orc_create
POSTHOOK: Output: default@orc_create
PREHOOK: query: CREATE TABLE orc_create (key INT, value STRING)
   PARTITIONED BY (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@orc_create
POSTHOOK: query: CREATE TABLE orc_create (key INT, value STRING)
   PARTITIONED BY (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@orc_create
PREHOOK: query: DESCRIBE FORMATTED orc_create
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@orc_create
POSTHOOK: query: DESCRIBE FORMATTED orc_create
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@orc_create
# col_name            	data_type           	comment             
	 	 
key                 	int                 	                    
value               	string              	                    
	 	 
# Partition Information	 	 
# col_name            	data_type           	comment             
	 	 
ds                  	string              	                    
	 	 
# Detailed Table Information	 	 
Database:           	default             	 
#### A masked pattern was here ####
Protect Mode:       	None                	 
Retention:          	0                   	 
#### A masked pattern was here ####
Table Type:         	MANAGED_TABLE       	 
Table Parameters:	 	 
#### A masked pattern was here ####
	 	 
# Storage Information	 	 
SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
Compressed:         	No                  	 
Num Buckets:        	-1                  	 
Bucket Columns:     	[]                  	 
Sort Columns:       	[]                  	 
Storage Desc Params:	 	 
	serialization.format	1                   
PREHOOK: query: ALTER TABLE orc_create SET FILEFORMAT ORC
PREHOOK: type: ALTERTABLE_FILEFORMAT
PREHOOK: Input: default@orc_create
PREHOOK: Output: default@orc_create
POSTHOOK: query: ALTER TABLE orc_create SET FILEFORMAT ORC
POSTHOOK: type: ALTERTABLE_FILEFORMAT
POSTHOOK: Input: default@orc_create
POSTHOOK: Output: default@orc_create
PREHOOK: query: DESCRIBE FORMATTED orc_create
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@orc_create
POSTHOOK: query: DESCRIBE FORMATTED orc_create
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@orc_create
# col_name            	data_type           	comment             
	 	 
key                 	int                 	                    
value               	string              	                    
	 	 
# Partition Information	 	 
# col_name            	data_type           	comment             
	 	 
ds                  	string              	                    
	 	 
# Detailed Table Information	 	 
Database:           	default             	 
#### A masked pattern was here ####
Protect Mode:       	None                	 
Retention:          	0                   	 
#### A masked pattern was here ####
Table Type:         	MANAGED_TABLE       	 
Table Parameters:	 	 
#### A masked pattern was here ####
	 	 
# Storage Information	 	 
SerDe Library:      	org.apache.hadoop.hive.ql.io.orc.OrcSerde	 
InputFormat:        	org.apache.hadoop.hive.ql.io.orc.OrcInputFormat	 
OutputFormat:       	org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat	 
Compressed:         	No                  	 
Num Buckets:        	-1                  	 
Bucket Columns:     	[]                  	 
Sort Columns:       	[]                  	 
Storage Desc Params:	 	 
	serialization.format	1                   
PREHOOK: query: DROP TABLE orc_create
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orc_create
PREHOOK: Output: default@orc_create
POSTHOOK: query: DROP TABLE orc_create
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@orc_create
POSTHOOK: Output: default@orc_create
PREHOOK: query: CREATE TABLE orc_create (key INT, value STRING)
   PARTITIONED BY (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@orc_create
POSTHOOK: query: CREATE TABLE orc_create (key INT, value STRING)
   PARTITIONED BY (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@orc_create
PREHOOK: query: DESCRIBE FORMATTED orc_create
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@orc_create
POSTHOOK: query: DESCRIBE FORMATTED orc_create
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@orc_create
# col_name            	data_type           	comment             
	 	 
key                 	int                 	                    
value               	string              	                    
	 	 
# Partition Information	 	 
# col_name            	data_type           	comment             
	 	 
ds                  	string              	                    
	 	 
# Detailed Table Information	 	 
Database:           	default             	 
#### A masked pattern was here ####
Protect Mode:       	None                	 
Retention:          	0                   	 
#### A masked pattern was here ####
Table Type:         	MANAGED_TABLE       	 
Table Parameters:	 	 
#### A masked pattern was here ####
	 	 
# Storage Information	 	 
SerDe Library:      	org.apache.hadoop.hive.ql.io.orc.OrcSerde	 
InputFormat:        	org.apache.hadoop.hive.ql.io.orc.OrcInputFormat	 
OutputFormat:       	org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat	 
Compressed:         	No                  	 
Num Buckets:        	-1                  	 
Bucket Columns:     	[]                  	 
Sort Columns:       	[]                  	 
Storage Desc Params:	 	 
	serialization.format	1                   
PREHOOK: query: CREATE TABLE orc_create_complex (
  str STRING,
  mp  MAP<STRING,STRING>,
  lst ARRAY<STRING>,
  strct STRUCT<A:STRING,B:STRING>
) STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@orc_create_complex
POSTHOOK: query: CREATE TABLE orc_create_complex (
  str STRING,
  mp  MAP<STRING,STRING>,
  lst ARRAY<STRING>,
  strct STRUCT<A:STRING,B:STRING>
) STORED AS ORC
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@orc_create_complex
PREHOOK: query: DESCRIBE FORMATTED orc_create_complex
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@orc_create_complex
POSTHOOK: query: DESCRIBE FORMATTED orc_create_complex
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@orc_create_complex
# col_name            	data_type           	comment             
	 	 
str                 	string              	                    
mp                  	map<string,string>  	                    
lst                 	array<string>       	                    
strct               	struct<A:string,B:string>	                    
	 	 
# Detailed Table Information	 	 
Database:           	default             	 
#### A masked pattern was here ####
Protect Mode:       	None                	 
Retention:          	0                   	 
#### A masked pattern was here ####
Table Type:         	MANAGED_TABLE       	 
Table Parameters:	 	 
#### A masked pattern was here ####
	 	 
# Storage Information	 	 
SerDe Library:      	org.apache.hadoop.hive.ql.io.orc.OrcSerde	 
InputFormat:        	org.apache.hadoop.hive.ql.io.orc.OrcInputFormat	 
OutputFormat:       	org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat	 
Compressed:         	No                  	 
Num Buckets:        	-1                  	 
Bucket Columns:     	[]                  	 
Sort Columns:       	[]                  	 
Storage Desc Params:	 	 
	serialization.format	1                   
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/orc_create.txt' OVERWRITE INTO TABLE orc_create_staging
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@orc_create_staging
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/orc_create.txt' OVERWRITE INTO TABLE orc_create_staging
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@orc_create_staging
PREHOOK: query: SELECT * from orc_create_staging
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_staging
#### A masked pattern was here ####
POSTHOOK: query: SELECT * from orc_create_staging
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_staging
#### A masked pattern was here ####
line1	{"key11":"value11","key12":"value12","key13":"value13"}	["a","b","c"]	{"a":"one","b":"two"}
line2	{"key21":"value21","key22":"value22","key23":"value23"}	["d","e","f"]	{"a":"three","b":"four"}
line3	{"key31":"value31","key32":"value32","key33":"value33"}	["g","h","i"]	{"a":"five","b":"six"}
PREHOOK: query: INSERT OVERWRITE TABLE orc_create_complex SELECT * FROM orc_create_staging
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_staging
PREHOOK: Output: default@orc_create_complex
POSTHOOK: query: INSERT OVERWRITE TABLE orc_create_complex SELECT * FROM orc_create_staging
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_staging
POSTHOOK: Output: default@orc_create_complex
POSTHOOK: Lineage: orc_create_complex.lst SIMPLE [(orc_create_staging)orc_create_staging.FieldSchema(name:lst, type:array<string>, comment:null), ]
POSTHOOK: Lineage: orc_create_complex.mp SIMPLE [(orc_create_staging)orc_create_staging.FieldSchema(name:mp, type:map<string,string>, comment:null), ]
POSTHOOK: Lineage: orc_create_complex.str SIMPLE [(orc_create_staging)orc_create_staging.FieldSchema(name:str, type:string, comment:null), ]
POSTHOOK: Lineage: orc_create_complex.strct SIMPLE [(orc_create_staging)orc_create_staging.FieldSchema(name:strct, type:struct<A:string,B:string>, comment:null), ]
PREHOOK: query: SELECT * from orc_create_complex
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_complex
#### A masked pattern was here ####
POSTHOOK: query: SELECT * from orc_create_complex
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_complex
#### A masked pattern was here ####
line1	{"key11":"value11","key12":"value12","key13":"value13"}	["a","b","c"]	{"A":"one","B":"two"}
line2	{"key21":"value21","key22":"value22","key23":"value23"}	["d","e","f"]	{"A":"three","B":"four"}
line3	{"key31":"value31","key32":"value32","key33":"value33"}	["g","h","i"]	{"A":"five","B":"six"}
PREHOOK: query: SELECT str from orc_create_complex
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_complex
#### A masked pattern was here ####
POSTHOOK: query: SELECT str from orc_create_complex
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_complex
#### A masked pattern was here ####
line1
line2
line3
PREHOOK: query: SELECT mp from orc_create_complex
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_complex
#### A masked pattern was here ####
POSTHOOK: query: SELECT mp from orc_create_complex
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_complex
#### A masked pattern was here ####
{"key11":"value11","key12":"value12","key13":"value13"}
{"key21":"value21","key22":"value22","key23":"value23"}
{"key31":"value31","key32":"value32","key33":"value33"}
PREHOOK: query: SELECT lst from orc_create_complex
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_complex
#### A masked pattern was here ####
POSTHOOK: query: SELECT lst from orc_create_complex
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_complex
#### A masked pattern was here ####
["a","b","c"]
["d","e","f"]
["g","h","i"]
PREHOOK: query: SELECT strct from orc_create_complex
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_complex
#### A masked pattern was here ####
POSTHOOK: query: SELECT strct from orc_create_complex
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_complex
#### A masked pattern was here ####
{"A":"five","B":"six"}
{"A":"one","B":"two"}
{"A":"three","B":"four"}
PREHOOK: query: CREATE TABLE orc_create_people_staging (
  id int,
  first_name string,
  last_name string,
  address string,
  salary decimal,
  start_date timestamp,
  state string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@orc_create_people_staging
POSTHOOK: query: CREATE TABLE orc_create_people_staging (
  id int,
  first_name string,
  last_name string,
  address string,
  salary decimal,
  start_date timestamp,
  state string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@orc_create_people_staging
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/orc_create_people.txt'
  OVERWRITE INTO TABLE orc_create_people_staging
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@orc_create_people_staging
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/orc_create_people.txt'
  OVERWRITE INTO TABLE orc_create_people_staging
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@orc_create_people_staging
PREHOOK: query: CREATE TABLE orc_create_people (
  id int,
  first_name string,
  last_name string,
  address string,
  salary decimal,
  start_date timestamp)
PARTITIONED BY (state string)
STORED AS orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@orc_create_people
POSTHOOK: query: CREATE TABLE orc_create_people (
  id int,
  first_name string,
  last_name string,
  address string,
  salary decimal,
  start_date timestamp)
PARTITIONED BY (state string)
STORED AS orc
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@orc_create_people
PREHOOK: query: INSERT OVERWRITE TABLE orc_create_people PARTITION (state)
  SELECT * FROM orc_create_people_staging
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people_staging
PREHOOK: Output: default@orc_create_people
POSTHOOK: query: INSERT OVERWRITE TABLE orc_create_people PARTITION (state)
  SELECT * FROM orc_create_people_staging
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people_staging
POSTHOOK: Output: default@orc_create_people@state=Ca
POSTHOOK: Output: default@orc_create_people@state=Or
POSTHOOK: Lineage: orc_create_people PARTITION(state=Ca).address SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:address, type:string, comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Ca).first_name SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:first_name, type:string, comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Ca).id SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:id, type:int, comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Ca).last_name SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:last_name, type:string, comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Ca).salary SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:salary, type:decimal(10,0), comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Ca).start_date SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:start_date, type:timestamp, comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).address SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:address, type:string, comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).first_name SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:first_name, type:string, comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).id SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:id, type:int, comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).last_name SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:last_name, type:string, comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).salary SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:salary, type:decimal(10,0), comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).start_date SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:start_date, type:timestamp, comment:null), ]
PREHOOK: query: -- test predicate push down with partition pruning
SELECT COUNT(*) FROM orc_create_people where id < 10 and state = 'Ca'
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
#### A masked pattern was here ####
POSTHOOK: query: -- test predicate push down with partition pruning
SELECT COUNT(*) FROM orc_create_people where id < 10 and state = 'Ca'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
#### A masked pattern was here ####
5
PREHOOK: query: -- test predicate push down
SELECT COUNT(*) FROM orc_create_people where id = 50
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
PREHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
POSTHOOK: query: -- test predicate push down
SELECT COUNT(*) FROM orc_create_people where id = 50
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
POSTHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
1
PREHOOK: query: SELECT COUNT(*) FROM orc_create_people where id between 10 and 20
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
PREHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
POSTHOOK: query: SELECT COUNT(*) FROM orc_create_people where id between 10 and 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
POSTHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
11
PREHOOK: query: SELECT COUNT(*) FROM orc_create_people where id > 10 and id < 100
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
PREHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
POSTHOOK: query: SELECT COUNT(*) FROM orc_create_people where id > 10 and id < 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
POSTHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
89
PREHOOK: query: SELECT COUNT(*) FROM orc_create_people where (id + 1) = 20
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
PREHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
POSTHOOK: query: SELECT COUNT(*) FROM orc_create_people where (id + 1) = 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
POSTHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
1
PREHOOK: query: SELECT COUNT(*) FROM orc_create_people where (id + 10) < 200
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
PREHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
POSTHOOK: query: SELECT COUNT(*) FROM orc_create_people where (id + 10) < 200
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
POSTHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
100
PREHOOK: query: SELECT COUNT(*) FROM orc_create_people where id < 30  or first_name = "Rafael"
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
PREHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
POSTHOOK: query: SELECT COUNT(*) FROM orc_create_people where id < 30  or first_name = "Rafael"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
POSTHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
30
PREHOOK: query: SELECT COUNT(*) FROM orc_create_people 
   where length(substr(first_name, 1, 2)) <= 2 and last_name like '%'
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
PREHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
POSTHOOK: query: SELECT COUNT(*) FROM orc_create_people 
   where length(substr(first_name, 1, 2)) <= 2 and last_name like '%'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
POSTHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
100
PREHOOK: query: SELECT COUNT(*) FROM orc_create_people where salary = 200.00
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
PREHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
POSTHOOK: query: SELECT COUNT(*) FROM orc_create_people where salary = 200.00
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
POSTHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
11
PREHOOK: query: SELECT COUNT(*) FROM orc_create_people WHERE start_date IS NULL
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
PREHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
POSTHOOK: query: SELECT COUNT(*) FROM orc_create_people WHERE start_date IS NULL
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
POSTHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
0
PREHOOK: query: SELECT COUNT(*) FROM orc_create_people WHERE YEAR(start_date) = 2014
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
PREHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
POSTHOOK: query: SELECT COUNT(*) FROM orc_create_people WHERE YEAR(start_date) = 2014
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
POSTHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
20
PREHOOK: query: -- test predicate push down with partition pruning
SELECT COUNT(*) FROM orc_create_people where salary = 200.00 and state = 'Ca'
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
#### A masked pattern was here ####
POSTHOOK: query: -- test predicate push down with partition pruning
SELECT COUNT(*) FROM orc_create_people where salary = 200.00 and state = 'Ca'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
#### A masked pattern was here ####
5
PREHOOK: query: -- test predicate push down with no column projection
SELECT id, first_name, last_name, address
  FROM orc_create_people WHERE id > 90
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people
PREHOOK: Input: default@orc_create_people@state=Ca
PREHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
POSTHOOK: query: -- test predicate push down with no column projection
SELECT id, first_name, last_name, address
  FROM orc_create_people WHERE id > 90
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Input: default@orc_create_people@state=Ca
POSTHOOK: Input: default@orc_create_people@state=Or
#### A masked pattern was here ####
100	Wang	Mitchell	4023 Lacinia. Ave
91	Genevieve	Wilkins	908 Turpis. Street
92	Thane	Oneil	6766 Lectus St.
93	Mariko	Cline	P.O. Box 329, 5375 Ac St.
94	Lael	Mclean	500-7010 Sit St.
95	Winifred	Hopper	Ap #140-8982 Velit Avenue
96	Rafael	England	P.O. Box 405, 7857 Eget Av.
97	Dana	Carter	814-601 Purus. Av.
98	Juliet	Battle	Ap #535-1965 Cursus St.
99	Wynter	Vincent	626-8492 Mollis Avenue
PREHOOK: query: DROP TABLE orc_create
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orc_create
PREHOOK: Output: default@orc_create
POSTHOOK: query: DROP TABLE orc_create
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@orc_create
POSTHOOK: Output: default@orc_create
PREHOOK: query: DROP TABLE orc_create_complex
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orc_create_complex
PREHOOK: Output: default@orc_create_complex
POSTHOOK: query: DROP TABLE orc_create_complex
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@orc_create_complex
POSTHOOK: Output: default@orc_create_complex
PREHOOK: query: DROP TABLE orc_create_staging
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orc_create_staging
PREHOOK: Output: default@orc_create_staging
POSTHOOK: query: DROP TABLE orc_create_staging
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@orc_create_staging
POSTHOOK: Output: default@orc_create_staging
PREHOOK: query: DROP TABLE orc_create_people_staging
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orc_create_people_staging
PREHOOK: Output: default@orc_create_people_staging
POSTHOOK: query: DROP TABLE orc_create_people_staging
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@orc_create_people_staging
POSTHOOK: Output: default@orc_create_people_staging
PREHOOK: query: DROP TABLE orc_create_people
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orc_create_people
PREHOOK: Output: default@orc_create_people
POSTHOOK: query: DROP TABLE orc_create_people
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@orc_create_people
POSTHOOK: Output: default@orc_create_people