blob: 9b79077e7115e42ff4601f86dd9c286b85595088 [file] [log] [blame]
PREHOOK: query: CREATE table columnTable_Bigdata (key STRING, value STRING)
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
STORED AS
INPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileOutputFormat'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@columnTable_Bigdata
POSTHOOK: query: CREATE table columnTable_Bigdata (key STRING, value STRING)
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
STORED AS
INPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileOutputFormat'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@columnTable_Bigdata
PREHOOK: query: FROM (FROM src MAP src.key,src.value USING 'python dumpdata_script.py' AS (key,value) WHERE src.key = 10) subq
INSERT OVERWRITE TABLE columnTable_Bigdata SELECT subq.key, subq.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@columntable_bigdata
POSTHOOK: query: FROM (FROM src MAP src.key,src.value USING 'python dumpdata_script.py' AS (key,value) WHERE src.key = 10) subq
INSERT OVERWRITE TABLE columnTable_Bigdata SELECT subq.key, subq.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@columntable_bigdata
POSTHOOK: Lineage: columntable_bigdata.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: columntable_bigdata.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: describe columnTable_Bigdata
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@columntable_bigdata
POSTHOOK: query: describe columnTable_Bigdata
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@columntable_bigdata
key string
value string
PREHOOK: query: select count(columnTable_Bigdata.key) from columnTable_Bigdata
PREHOOK: type: QUERY
PREHOOK: Input: default@columntable_bigdata
PREHOOK: Output: hdfs://### HDFS PATH ###
POSTHOOK: query: select count(columnTable_Bigdata.key) from columnTable_Bigdata
POSTHOOK: type: QUERY
POSTHOOK: Input: default@columntable_bigdata
POSTHOOK: Output: hdfs://### HDFS PATH ###
5005500