blob: b83bc31dcbc36ec9ab76cd57bb2c821c373b9184 [file] [log] [blame]
PREHOOK: query: CREATE TABLE test_tab_n1 (key STRING, value STRING)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe' STORED AS RCFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@test_tab_n1
POSTHOOK: query: CREATE TABLE test_tab_n1 (key STRING, value STRING)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe' STORED AS RCFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@test_tab_n1
PREHOOK: query: INSERT OVERWRITE TABLE test_tab_n1 SELECT * FROM src tablesample (10 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@test_tab_n1
POSTHOOK: query: INSERT OVERWRITE TABLE test_tab_n1 SELECT * FROM src tablesample (10 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@test_tab_n1
POSTHOOK: Lineage: test_tab_n1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: test_tab_n1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: DESC FORMATTED test_tab_n1
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@test_tab_n1
POSTHOOK: query: DESC FORMATTED test_tab_n1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_tab_n1
# col_name data_type comment
key string
value string
# Detailed Table Information
Database: default
#### A masked pattern was here ####
Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
bucketing_version 2
numFiles 1
numRows 10
rawDataSize 94
totalSize 185
#### A masked pattern was here ####
# Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
PREHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
165 val_165
238 val_238
255 val_255
27 val_27
278 val_278
311 val_311
409 val_409
484 val_484
86 val_86
98 val_98
PREHOOK: query: TRUNCATE TABLE test_tab_n1 COLUMNS (key)
PREHOOK: type: TRUNCATETABLE
PREHOOK: Input: default@test_tab_n1
PREHOOK: Output: default@test_tab_n1
POSTHOOK: query: TRUNCATE TABLE test_tab_n1 COLUMNS (key)
POSTHOOK: type: TRUNCATETABLE
POSTHOOK: Input: default@test_tab_n1
POSTHOOK: Output: default@test_tab_n1
PREHOOK: query: DESC FORMATTED test_tab_n1
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@test_tab_n1
POSTHOOK: query: DESC FORMATTED test_tab_n1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_tab_n1
# col_name data_type comment
key string
value string
# Detailed Table Information
Database: default
#### A masked pattern was here ####
Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
bucketing_version 2
numFiles 1
numRows 10
rawDataSize 94
totalSize 150
#### A masked pattern was here ####
# Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
PREHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
NULL val_165
NULL val_238
NULL val_255
NULL val_27
NULL val_278
NULL val_311
NULL val_409
NULL val_484
NULL val_86
NULL val_98
PREHOOK: query: INSERT OVERWRITE TABLE test_tab_n1 SELECT * FROM src tablesample (10 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@test_tab_n1
POSTHOOK: query: INSERT OVERWRITE TABLE test_tab_n1 SELECT * FROM src tablesample (10 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@test_tab_n1
POSTHOOK: Lineage: test_tab_n1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: test_tab_n1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: TRUNCATE TABLE test_tab_n1 COLUMNS (key, value)
PREHOOK: type: TRUNCATETABLE
PREHOOK: Input: default@test_tab_n1
PREHOOK: Output: default@test_tab_n1
POSTHOOK: query: TRUNCATE TABLE test_tab_n1 COLUMNS (key, value)
POSTHOOK: type: TRUNCATETABLE
POSTHOOK: Input: default@test_tab_n1
POSTHOOK: Output: default@test_tab_n1
PREHOOK: query: DESC FORMATTED test_tab_n1
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@test_tab_n1
POSTHOOK: query: DESC FORMATTED test_tab_n1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_tab_n1
# col_name data_type comment
key string
value string
# Detailed Table Information
Database: default
#### A masked pattern was here ####
Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
bucketing_version 2
numFiles 1
numRows 10
rawDataSize 94
totalSize 75
#### A masked pattern was here ####
# Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
PREHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
PREHOOK: query: TRUNCATE TABLE test_tab_n1 COLUMNS (key, value)
PREHOOK: type: TRUNCATETABLE
PREHOOK: Input: default@test_tab_n1
PREHOOK: Output: default@test_tab_n1
POSTHOOK: query: TRUNCATE TABLE test_tab_n1 COLUMNS (key, value)
POSTHOOK: type: TRUNCATETABLE
POSTHOOK: Input: default@test_tab_n1
POSTHOOK: Output: default@test_tab_n1
PREHOOK: query: DESC FORMATTED test_tab_n1
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@test_tab_n1
POSTHOOK: query: DESC FORMATTED test_tab_n1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_tab_n1
# col_name data_type comment
key string
value string
# Detailed Table Information
Database: default
#### A masked pattern was here ####
Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
bucketing_version 2
numFiles 1
numRows 10
rawDataSize 94
totalSize 75
#### A masked pattern was here ####
# Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
PREHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
PREHOOK: query: ALTER TABLE test_tab_n1 SET SERDE 'org.apache.hadoop.hive.serde2.columnar.LazyBinaryColumnarSerDe'
PREHOOK: type: ALTERTABLE_SERIALIZER
PREHOOK: Input: default@test_tab_n1
PREHOOK: Output: default@test_tab_n1
POSTHOOK: query: ALTER TABLE test_tab_n1 SET SERDE 'org.apache.hadoop.hive.serde2.columnar.LazyBinaryColumnarSerDe'
POSTHOOK: type: ALTERTABLE_SERIALIZER
POSTHOOK: Input: default@test_tab_n1
POSTHOOK: Output: default@test_tab_n1
PREHOOK: query: INSERT OVERWRITE TABLE test_tab_n1 SELECT * FROM src tablesample (10 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@test_tab_n1
POSTHOOK: query: INSERT OVERWRITE TABLE test_tab_n1 SELECT * FROM src tablesample (10 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@test_tab_n1
POSTHOOK: Lineage: test_tab_n1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: test_tab_n1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: DESC FORMATTED test_tab_n1
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@test_tab_n1
POSTHOOK: query: DESC FORMATTED test_tab_n1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_tab_n1
# col_name data_type comment
key string
value string
# Detailed Table Information
Database: default
#### A masked pattern was here ####
Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
bucketing_version 2
#### A masked pattern was here ####
numFiles 1
numRows 10
rawDataSize 94
totalSize 185
#### A masked pattern was here ####
# Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.columnar.LazyBinaryColumnarSerDe
InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
PREHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
165 val_165
238 val_238
255 val_255
27 val_27
278 val_278
311 val_311
409 val_409
484 val_484
86 val_86
98 val_98
PREHOOK: query: TRUNCATE TABLE test_tab_n1 COLUMNS (key)
PREHOOK: type: TRUNCATETABLE
PREHOOK: Input: default@test_tab_n1
PREHOOK: Output: default@test_tab_n1
POSTHOOK: query: TRUNCATE TABLE test_tab_n1 COLUMNS (key)
POSTHOOK: type: TRUNCATETABLE
POSTHOOK: Input: default@test_tab_n1
POSTHOOK: Output: default@test_tab_n1
PREHOOK: query: DESC FORMATTED test_tab_n1
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@test_tab_n1
POSTHOOK: query: DESC FORMATTED test_tab_n1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_tab_n1
# col_name data_type comment
key string
value string
# Detailed Table Information
Database: default
#### A masked pattern was here ####
Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
bucketing_version 2
#### A masked pattern was here ####
numFiles 1
numRows 10
rawDataSize 94
totalSize 150
#### A masked pattern was here ####
# Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.columnar.LazyBinaryColumnarSerDe
InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
PREHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
NULL val_165
NULL val_238
NULL val_255
NULL val_27
NULL val_278
NULL val_311
NULL val_409
NULL val_484
NULL val_86
NULL val_98
PREHOOK: query: TRUNCATE TABLE test_tab_n1 COLUMNS (key, value)
PREHOOK: type: TRUNCATETABLE
PREHOOK: Input: default@test_tab_n1
PREHOOK: Output: default@test_tab_n1
POSTHOOK: query: TRUNCATE TABLE test_tab_n1 COLUMNS (key, value)
POSTHOOK: type: TRUNCATETABLE
POSTHOOK: Input: default@test_tab_n1
POSTHOOK: Output: default@test_tab_n1
PREHOOK: query: DESC FORMATTED test_tab_n1
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@test_tab_n1
POSTHOOK: query: DESC FORMATTED test_tab_n1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_tab_n1
# col_name data_type comment
key string
value string
# Detailed Table Information
Database: default
#### A masked pattern was here ####
Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
bucketing_version 2
#### A masked pattern was here ####
numFiles 1
numRows 10
rawDataSize 94
totalSize 75
#### A masked pattern was here ####
# Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.columnar.LazyBinaryColumnarSerDe
InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
PREHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM test_tab_n1 ORDER BY value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_tab_n1
#### A masked pattern was here ####
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
PREHOOK: query: CREATE TABLE test_tab_part (key STRING, value STRING) PARTITIONED BY (part STRING) STORED AS RCFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@test_tab_part
POSTHOOK: query: CREATE TABLE test_tab_part (key STRING, value STRING) PARTITIONED BY (part STRING) STORED AS RCFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@test_tab_part
PREHOOK: query: INSERT OVERWRITE TABLE test_tab_part PARTITION (part = '1') SELECT * FROM src tablesample (10 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@test_tab_part@part=1
POSTHOOK: query: INSERT OVERWRITE TABLE test_tab_part PARTITION (part = '1') SELECT * FROM src tablesample (10 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@test_tab_part@part=1
POSTHOOK: Lineage: test_tab_part PARTITION(part=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: test_tab_part PARTITION(part=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: DESC FORMATTED test_tab_part PARTITION (part = '1')
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@test_tab_part
POSTHOOK: query: DESC FORMATTED test_tab_part PARTITION (part = '1')
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_tab_part
# col_name data_type comment
key string
value string
# Partition Information
# col_name data_type comment
part string
# Detailed Partition Information
Partition Value: [1]
Database: default
Table: test_tab_part
#### A masked pattern was here ####
Partition Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
numFiles 1
numRows 10
rawDataSize 94
totalSize 185
#### A masked pattern was here ####
# Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
PREHOOK: query: SELECT * FROM test_tab_part WHERE part = '1' ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@test_tab_part
PREHOOK: Input: default@test_tab_part@part=1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM test_tab_part WHERE part = '1' ORDER BY value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_tab_part
POSTHOOK: Input: default@test_tab_part@part=1
#### A masked pattern was here ####
165 val_165 1
238 val_238 1
255 val_255 1
27 val_27 1
278 val_278 1
311 val_311 1
409 val_409 1
484 val_484 1
86 val_86 1
98 val_98 1
PREHOOK: query: TRUNCATE TABLE test_tab_part PARTITION (part = '1') COLUMNS (key)
PREHOOK: type: TRUNCATETABLE
PREHOOK: Input: default@test_tab_part
PREHOOK: Output: default@test_tab_part@part=1
POSTHOOK: query: TRUNCATE TABLE test_tab_part PARTITION (part = '1') COLUMNS (key)
POSTHOOK: type: TRUNCATETABLE
POSTHOOK: Input: default@test_tab_part
POSTHOOK: Output: default@test_tab_part@part=1
PREHOOK: query: DESC FORMATTED test_tab_part PARTITION (part = '1')
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@test_tab_part
POSTHOOK: query: DESC FORMATTED test_tab_part PARTITION (part = '1')
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_tab_part
# col_name data_type comment
key string
value string
# Partition Information
# col_name data_type comment
part string
# Detailed Partition Information
Partition Value: [1]
Database: default
Table: test_tab_part
#### A masked pattern was here ####
Partition Parameters:
numFiles 1
numRows 10
rawDataSize 94
totalSize 150
#### A masked pattern was here ####
# Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
PREHOOK: query: SELECT * FROM test_tab_part WHERE part = '1' ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@test_tab_part
PREHOOK: Input: default@test_tab_part@part=1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM test_tab_part WHERE part = '1' ORDER BY value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_tab_part
POSTHOOK: Input: default@test_tab_part@part=1
#### A masked pattern was here ####
NULL val_165 1
NULL val_238 1
NULL val_255 1
NULL val_27 1
NULL val_278 1
NULL val_311 1
NULL val_409 1
NULL val_484 1
NULL val_86 1
NULL val_98 1