HIVE-17076 : typo in itests/src/test/resources/testconfiguration.properties
Signed-off-by: Ashutosh Chauhan <hashut...@apache.org> Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/dbd2d354 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/dbd2d354 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/dbd2d354 Branch: refs/heads/master Commit: dbd2d35424da462040f1dd003f890e78db73ba92 Parents: 499b136 Author: Eugene Koifman <ekoif...@hortonworks.com> Authored: Tue Jul 11 17:06:00 2017 -0700 Committer: Ashutosh Chauhan <hashut...@apache.org> Committed: Thu Nov 9 14:48:57 2017 -0800 ---------------------------------------------------------------------- .../test/resources/testconfiguration.properties | 3 +- .../insert_values_orig_table.q.out | 136 --- .../insert_values_orig_table_use_metadata.q.out | 1022 ----------------- .../llap/insert_values_orig_table.q.out | 136 +++ .../insert_values_orig_table_use_metadata.q.out | 1072 ++++++++++++++++++ 5 files changed, 1210 insertions(+), 1159 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/dbd2d354/itests/src/test/resources/testconfiguration.properties ---------------------------------------------------------------------- diff --git a/itests/src/test/resources/testconfiguration.properties b/itests/src/test/resources/testconfiguration.properties index 5f92321..1d16b65 100644 --- a/itests/src/test/resources/testconfiguration.properties +++ b/itests/src/test/resources/testconfiguration.properties @@ -68,7 +68,6 @@ minitez.query.files=acid_vectorization_original_tez.q,\ minillap.shared.query.files=insert_into1.q,\ insert_into2.q,\ - insert_values_orig_table.,\ llapdecider.q,\ mapreduce1.q,\ mapreduce2.q,\ @@ -542,6 +541,8 @@ minillaplocal.query.files=\ input16_cc.q,\ insert_dir_distcp.q,\ insert_into_with_schema.q,\ + insert_values_orig_table.q,\ + insert_values_orig_table_use_metadata.q,\ jdbc_handler.q,\ join1.q,\ join_acid_non_acid.q,\ http://git-wip-us.apache.org/repos/asf/hive/blob/dbd2d354/ql/src/test/results/clientpositive/insert_values_orig_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/insert_values_orig_table.q.out b/ql/src/test/results/clientpositive/insert_values_orig_table.q.out deleted file mode 100644 index d381d87..0000000 --- a/ql/src/test/results/clientpositive/insert_values_orig_table.q.out +++ /dev/null @@ -1,136 +0,0 @@ -PREHOOK: query: drop table if exists acid_ivot_stage -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table if exists acid_ivot_stage -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table acid_ivot_stage( - ctinyint TINYINT, - csmallint SMALLINT, - cint INT, - cbigint BIGINT, - cfloat FLOAT, - cdouble DOUBLE, - cstring1 STRING, - cstring2 STRING, - ctimestamp1 TIMESTAMP, - ctimestamp2 TIMESTAMP, - cboolean1 BOOLEAN, - cboolean2 BOOLEAN) stored as orc -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_ivot_stage -POSTHOOK: query: create table acid_ivot_stage( - ctinyint TINYINT, - csmallint SMALLINT, - cint INT, - cbigint BIGINT, - cfloat FLOAT, - cdouble DOUBLE, - cstring1 STRING, - cstring2 STRING, - ctimestamp1 TIMESTAMP, - ctimestamp2 TIMESTAMP, - cboolean1 BOOLEAN, - cboolean2 BOOLEAN) stored as orc -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_ivot_stage -PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot_stage -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@acid_ivot_stage -POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot_stage -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@acid_ivot_stage -PREHOOK: query: create table acid_ivot( - ctinyint TINYINT, - csmallint SMALLINT, - cint INT, - cbigint BIGINT, - cfloat FLOAT, - cdouble DOUBLE, - cstring1 STRING, - cstring2 STRING, - ctimestamp1 TIMESTAMP, - ctimestamp2 TIMESTAMP, - cboolean1 BOOLEAN, - cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: create table acid_ivot( - ctinyint TINYINT, - csmallint SMALLINT, - cint INT, - cbigint BIGINT, - cfloat FLOAT, - cdouble DOUBLE, - cstring1 STRING, - cstring2 STRING, - ctimestamp1 TIMESTAMP, - ctimestamp2 TIMESTAMP, - cboolean1 BOOLEAN, - cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_ivot -PREHOOK: query: insert into acid_ivot select * from acid_ivot_stage -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_ivot_stage -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: insert into acid_ivot select * from acid_ivot_stage -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_ivot_stage -POSTHOOK: Output: default@acid_ivot -POSTHOOK: Lineage: acid_ivot.cbigint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cbigint, type:bigint, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cboolean1 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cboolean1, type:boolean, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cboolean2 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cboolean2, type:boolean, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cdouble SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cdouble, type:double, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cfloat SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cfloat, type:float, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_ivot.csmallint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:csmallint, type:smallint, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cstring1 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cstring1, type:string, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cstring2 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cstring2, type:string, comment:null), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp1 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp2 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ] -POSTHOOK: Lineage: acid_ivot.ctinyint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:ctinyint, type:tinyint, comment:null), ] -PREHOOK: query: select count(*) from acid_ivot -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from acid_ivot -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -12288 -PREHOOK: query: insert into table acid_ivot values - (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true), - (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true) -PREHOOK: type: QUERY -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: insert into table acid_ivot values - (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true), - (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true) -POSTHOOK: type: QUERY -POSTHOOK: Output: default@acid_ivot -POSTHOOK: Lineage: acid_ivot.cbigint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cboolean1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cboolean2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cdouble EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cfloat EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.csmallint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cstring1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cstring2 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.ctinyint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: select count(*) from acid_ivot -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from acid_ivot -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -12290 http://git-wip-us.apache.org/repos/asf/hive/blob/dbd2d354/ql/src/test/results/clientpositive/insert_values_orig_table_use_metadata.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/insert_values_orig_table_use_metadata.q.out b/ql/src/test/results/clientpositive/insert_values_orig_table_use_metadata.q.out deleted file mode 100644 index 8e610c9..0000000 --- a/ql/src/test/results/clientpositive/insert_values_orig_table_use_metadata.q.out +++ /dev/null @@ -1,1022 +0,0 @@ -PREHOOK: query: drop table if exists acid_ivot_stage -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table if exists acid_ivot_stage -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table acid_ivot_stage( - ctinyint TINYINT, - csmallint SMALLINT, - cint INT, - cbigint BIGINT, - cfloat FLOAT, - cdouble DOUBLE, - cstring1 STRING, - cstring2 STRING, - ctimestamp1 TIMESTAMP, - ctimestamp2 TIMESTAMP, - cboolean1 BOOLEAN, - cboolean2 BOOLEAN) stored as orc -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_ivot_stage -POSTHOOK: query: create table acid_ivot_stage( - ctinyint TINYINT, - csmallint SMALLINT, - cint INT, - cbigint BIGINT, - cfloat FLOAT, - cdouble DOUBLE, - cstring1 STRING, - cstring2 STRING, - ctimestamp1 TIMESTAMP, - ctimestamp2 TIMESTAMP, - cboolean1 BOOLEAN, - cboolean2 BOOLEAN) stored as orc -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_ivot_stage -PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot_stage -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@acid_ivot_stage -POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot_stage -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@acid_ivot_stage -PREHOOK: query: create table acid_ivot( - ctinyint TINYINT, - csmallint SMALLINT, - cint INT, - cbigint BIGINT, - cfloat FLOAT, - cdouble DOUBLE, - cstring1 STRING, - cstring2 STRING, - ctimestamp1 TIMESTAMP, - ctimestamp2 TIMESTAMP, - cboolean1 BOOLEAN, - cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: create table acid_ivot( - ctinyint TINYINT, - csmallint SMALLINT, - cint INT, - cbigint BIGINT, - cfloat FLOAT, - cdouble DOUBLE, - cstring1 STRING, - cstring2 STRING, - ctimestamp1 TIMESTAMP, - ctimestamp2 TIMESTAMP, - cboolean1 BOOLEAN, - cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_ivot -PREHOOK: query: desc formatted acid_ivot -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@acid_ivot -POSTHOOK: query: desc formatted acid_ivot -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@acid_ivot -# col_name data_type comment -ctinyint tinyint -csmallint smallint -cint int -cbigint bigint -cfloat float -cdouble double -cstring1 string -cstring2 string -ctimestamp1 timestamp -ctimestamp2 timestamp -cboolean1 boolean -cboolean2 boolean - -# 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\":{\"cbigint\":\"true\",\"cboolean1\":\"true\",\"cboolean2\":\"true\",\"cdouble\":\"true\",\"cfloat\":\"true\",\"cint\":\"true\",\"csmallint\":\"true\",\"cstring1\":\"true\",\"cstring2\":\"true\",\"ctimestamp1\":\"true\",\"ctimestamp2\":\"true\",\"ctinyint\":\"true\"}} - numFiles 0 - numRows 0 - rawDataSize 0 - totalSize 0 - transactional true -#### 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: [cint] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: insert into acid_ivot select * from acid_ivot_stage -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_ivot_stage -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: insert into acid_ivot select * from acid_ivot_stage -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_ivot_stage -POSTHOOK: Output: default@acid_ivot -POSTHOOK: Lineage: acid_ivot.cbigint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cbigint, type:bigint, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cboolean1 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cboolean1, type:boolean, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cboolean2 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cboolean2, type:boolean, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cdouble SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cdouble, type:double, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cfloat SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cfloat, type:float, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_ivot.csmallint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:csmallint, type:smallint, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cstring1 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cstring1, type:string, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cstring2 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cstring2, type:string, comment:null), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp1 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp2 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ] -POSTHOOK: Lineage: acid_ivot.ctinyint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:ctinyint, type:tinyint, comment:null), ] -PREHOOK: query: desc formatted acid_ivot -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@acid_ivot -POSTHOOK: query: desc formatted acid_ivot -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@acid_ivot -# col_name data_type comment -ctinyint tinyint -csmallint smallint -cint int -cbigint bigint -cfloat float -cdouble double -cstring1 string -cstring2 string -ctimestamp1 timestamp -ctimestamp2 timestamp -cboolean1 boolean -cboolean2 boolean - -# 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 {} - numFiles 1 - numRows 0 - rawDataSize 0 - totalSize 295483 - transactional true -#### 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: [cint] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: explain select count(*) from acid_ivot -PREHOOK: type: QUERY -POSTHOOK: query: explain select count(*) from acid_ivot -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: acid_ivot - Statistics: Num rows: 1 Data size: 295483 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - Statistics: Num rows: 1 Data size: 295483 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: bigint) - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from acid_ivot -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from acid_ivot -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -12288 -PREHOOK: query: insert into table acid_ivot values - (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true), - (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true) -PREHOOK: type: QUERY -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: insert into table acid_ivot values - (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true), - (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true) -POSTHOOK: type: QUERY -POSTHOOK: Output: default@acid_ivot -POSTHOOK: Lineage: acid_ivot.cbigint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cboolean1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cboolean2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cdouble EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cfloat EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.csmallint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cstring1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cstring2 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.ctinyint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: select count(*) from acid_ivot -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from acid_ivot -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -12290 -PREHOOK: query: drop table acid_ivot -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@acid_ivot -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: drop table acid_ivot -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@acid_ivot -POSTHOOK: Output: default@acid_ivot -PREHOOK: query: create table acid_ivot( - ctinyint TINYINT, - csmallint SMALLINT, - cint INT, - cbigint BIGINT, - cfloat FLOAT, - cdouble DOUBLE, - cstring1 STRING, - cstring2 STRING, - ctimestamp1 TIMESTAMP, - ctimestamp2 TIMESTAMP, - cboolean1 BOOLEAN, - cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: create table acid_ivot( - ctinyint TINYINT, - csmallint SMALLINT, - cint INT, - cbigint BIGINT, - cfloat FLOAT, - cdouble DOUBLE, - cstring1 STRING, - cstring2 STRING, - ctimestamp1 TIMESTAMP, - ctimestamp2 TIMESTAMP, - cboolean1 BOOLEAN, - cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_ivot -PREHOOK: query: insert into table acid_ivot values - (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true), - (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true) -PREHOOK: type: QUERY -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: insert into table acid_ivot values - (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true), - (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true) -POSTHOOK: type: QUERY -POSTHOOK: Output: default@acid_ivot -POSTHOOK: Lineage: acid_ivot.cbigint EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cboolean1 EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col11, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cboolean2 EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col12, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cdouble EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cfloat EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cint EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.csmallint EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cstring1 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col7, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cstring2 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col8, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp1 EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col9, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp2 EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col10, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.ctinyint EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: desc formatted acid_ivot -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@acid_ivot -POSTHOOK: query: desc formatted acid_ivot -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@acid_ivot -# col_name data_type comment -ctinyint tinyint -csmallint smallint -cint int -cbigint bigint -cfloat float -cdouble double -cstring1 string -cstring2 string -ctimestamp1 timestamp -ctimestamp2 timestamp -cboolean1 boolean -cboolean2 boolean - -# 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 {} - numFiles 1 - numRows 0 - rawDataSize 0 - totalSize 1554 - transactional true -#### 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: [cint] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: explain select count(*) from acid_ivot -PREHOOK: type: QUERY -POSTHOOK: query: explain select count(*) from acid_ivot -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: acid_ivot - Statistics: Num rows: 1 Data size: 1554 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - Statistics: Num rows: 1 Data size: 1554 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: bigint) - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from acid_ivot -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from acid_ivot -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -2 -PREHOOK: query: insert into table acid_ivot values - (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true), - (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true) -PREHOOK: type: QUERY -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: insert into table acid_ivot values - (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true), - (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true) -POSTHOOK: type: QUERY -POSTHOOK: Output: default@acid_ivot -POSTHOOK: Lineage: acid_ivot.cbigint EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cboolean1 EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col11, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cboolean2 EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col12, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cdouble EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cfloat EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cint EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.csmallint EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cstring1 SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col7, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.cstring2 SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col8, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp1 EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col9, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp2 EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col10, type:string, comment:), ] -POSTHOOK: Lineage: acid_ivot.ctinyint EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: desc formatted acid_ivot -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@acid_ivot -POSTHOOK: query: desc formatted acid_ivot -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@acid_ivot -# col_name data_type comment -ctinyint tinyint -csmallint smallint -cint int -cbigint bigint -cfloat float -cdouble double -cstring1 string -cstring2 string -ctimestamp1 timestamp -ctimestamp2 timestamp -cboolean1 boolean -cboolean2 boolean - -# 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 {} - numFiles 2 - numRows 0 - rawDataSize 0 - totalSize 3109 - transactional true -#### 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: [cint] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: explain select count(*) from acid_ivot -PREHOOK: type: QUERY -POSTHOOK: query: explain select count(*) from acid_ivot -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: acid_ivot - Statistics: Num rows: 1 Data size: 3109 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - Statistics: Num rows: 1 Data size: 3109 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: bigint) - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from acid_ivot -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from acid_ivot -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -4 -PREHOOK: query: insert into acid_ivot select * from acid_ivot_stage -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_ivot_stage -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: insert into acid_ivot select * from acid_ivot_stage -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_ivot_stage -POSTHOOK: Output: default@acid_ivot -POSTHOOK: Lineage: acid_ivot.cbigint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cbigint, type:bigint, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cboolean1 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cboolean1, type:boolean, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cboolean2 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cboolean2, type:boolean, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cdouble SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cdouble, type:double, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cfloat SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cfloat, type:float, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_ivot.csmallint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:csmallint, type:smallint, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cstring1 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cstring1, type:string, comment:null), ] -POSTHOOK: Lineage: acid_ivot.cstring2 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cstring2, type:string, comment:null), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp1 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ] -POSTHOOK: Lineage: acid_ivot.ctimestamp2 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ] -POSTHOOK: Lineage: acid_ivot.ctinyint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:ctinyint, type:tinyint, comment:null), ] -PREHOOK: query: desc formatted acid_ivot -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@acid_ivot -POSTHOOK: query: desc formatted acid_ivot -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@acid_ivot -# col_name data_type comment -ctinyint tinyint -csmallint smallint -cint int -cbigint bigint -cfloat float -cdouble double -cstring1 string -cstring2 string -ctimestamp1 timestamp -ctimestamp2 timestamp -cboolean1 boolean -cboolean2 boolean - -# 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 {} - numFiles 3 - numRows 0 - rawDataSize 0 - totalSize 298592 - transactional true -#### 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: [cint] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: explain select count(*) from acid_ivot -PREHOOK: type: QUERY -POSTHOOK: query: explain select count(*) from acid_ivot -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: acid_ivot - Statistics: Num rows: 1 Data size: 298592 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - Statistics: Num rows: 1 Data size: 298592 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: bigint) - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: drop table acid_ivot -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@acid_ivot -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: drop table acid_ivot -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@acid_ivot -POSTHOOK: Output: default@acid_ivot -PREHOOK: query: create table acid_ivot like src -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: create table acid_ivot like src -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_ivot -PREHOOK: query: desc formatted acid_ivot -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@acid_ivot -POSTHOOK: query: desc formatted acid_ivot -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@acid_ivot -# col_name data_type comment -key string default -value string default - -# 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\"}} - numFiles 0 - numRows 0 - rawDataSize 0 - totalSize 0 -#### 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: insert overwrite table acid_ivot select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@acid_ivot -POSTHOOK: query: insert overwrite table acid_ivot select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@acid_ivot -POSTHOOK: Lineage: acid_ivot.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: acid_ivot.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: desc formatted acid_ivot -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@acid_ivot -POSTHOOK: query: desc formatted acid_ivot -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@acid_ivot -# col_name data_type comment -key string default -value string default - -# 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\"} - numFiles 1 - numRows 500 - rawDataSize 5312 - totalSize 5812 -#### 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: explain select count(*) from acid_ivot -PREHOOK: type: QUERY -POSTHOOK: query: explain select count(*) from acid_ivot -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-0 is a root stage - -STAGE PLANS: - Stage: Stage-0 - Fetch Operator - limit: 1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from acid_ivot -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from acid_ivot -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_ivot -#### A masked pattern was here #### -500 -PREHOOK: query: CREATE TABLE sp (key STRING COMMENT 'default', value STRING COMMENT 'default') -PARTITIONED BY (ds STRING, hr STRING) -STORED AS TEXTFILE -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@sp -POSTHOOK: query: CREATE TABLE sp (key STRING COMMENT 'default', value STRING COMMENT 'default') -PARTITIONED BY (ds STRING, hr STRING) -STORED AS TEXTFILE -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@sp -PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/kv1.txt" -OVERWRITE INTO TABLE sp PARTITION (ds="2008-04-08", hr="11") -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@sp -POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/kv1.txt" -OVERWRITE INTO TABLE sp PARTITION (ds="2008-04-08", hr="11") -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@sp -POSTHOOK: Output: default@sp@ds=2008-04-08/hr=11 -PREHOOK: query: desc formatted sp PARTITION (ds="2008-04-08", hr="11") -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@sp -POSTHOOK: query: desc formatted sp PARTITION (ds="2008-04-08", hr="11") -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@sp -# col_name data_type comment -key string default -value string default - -# Partition Information -# col_name data_type comment -ds string -hr string - -# Detailed Partition Information -Partition Value: [2008-04-08, 11] -Database: default -Table: sp -#### A masked pattern was here #### -Partition Parameters: - numFiles 1 - numRows 0 - rawDataSize 0 - totalSize 5812 -#### 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: explain select count(*) from sp where ds="2008-04-08" and hr="11" -PREHOOK: type: QUERY -POSTHOOK: query: explain select count(*) from sp where ds="2008-04-08" and hr="11" -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: sp - Statistics: Num rows: 1 Data size: 5812 Basic stats: PARTIAL Column stats: NONE - Select Operator - Statistics: Num rows: 1 Data size: 5812 Basic stats: PARTIAL Column stats: NONE - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: bigint) - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from sp where ds="2008-04-08" and hr="11" -PREHOOK: type: QUERY -PREHOOK: Input: default@sp -PREHOOK: Input: default@sp@ds=2008-04-08/hr=11 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from sp where ds="2008-04-08" and hr="11" -POSTHOOK: type: QUERY -POSTHOOK: Input: default@sp -POSTHOOK: Input: default@sp@ds=2008-04-08/hr=11 -#### A masked pattern was here #### -500 -PREHOOK: query: insert into table sp PARTITION (ds="2008-04-08", hr="11") values - ('1', '2'), ('3', '4') -PREHOOK: type: QUERY -PREHOOK: Output: default@sp@ds=2008-04-08/hr=11 -POSTHOOK: query: insert into table sp PARTITION (ds="2008-04-08", hr="11") values - ('1', '2'), ('3', '4') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@sp@ds=2008-04-08/hr=11 -POSTHOOK: Lineage: sp PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: sp PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -PREHOOK: query: desc formatted sp PARTITION (ds="2008-04-08", hr="11") -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@sp -POSTHOOK: query: desc formatted sp PARTITION (ds="2008-04-08", hr="11") -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@sp -# col_name data_type comment -key string default -value string default - -# Partition Information -# col_name data_type comment -ds string -hr string - -# Detailed Partition Information -Partition Value: [2008-04-08, 11] -Database: default -Table: sp -#### A masked pattern was here #### -Partition Parameters: - COLUMN_STATS_ACCURATE {} - numFiles 2 - numRows 0 - rawDataSize 0 - totalSize 5820 -#### 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: analyze table sp PARTITION (ds="2008-04-08", hr="11") compute statistics -PREHOOK: type: QUERY -PREHOOK: Input: default@sp -PREHOOK: Input: default@sp@ds=2008-04-08/hr=11 -PREHOOK: Output: default@sp -PREHOOK: Output: default@sp@ds=2008-04-08/hr=11 -POSTHOOK: query: analyze table sp PARTITION (ds="2008-04-08", hr="11") compute statistics -POSTHOOK: type: QUERY -POSTHOOK: Input: default@sp -POSTHOOK: Input: default@sp@ds=2008-04-08/hr=11 -POSTHOOK: Output: default@sp -POSTHOOK: Output: default@sp@ds=2008-04-08/hr=11 -PREHOOK: query: desc formatted sp PARTITION (ds="2008-04-08", hr="11") -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@sp -POSTHOOK: query: desc formatted sp PARTITION (ds="2008-04-08", hr="11") -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@sp -# col_name data_type comment -key string default -value string default - -# Partition Information -# col_name data_type comment -ds string -hr string - -# Detailed Partition Information -Partition Value: [2008-04-08, 11] -Database: default -Table: sp -#### A masked pattern was here #### -Partition Parameters: - COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} - numFiles 2 - numRows 502 - rawDataSize 5318 - totalSize 5820 -#### 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: explain select count(*) from sp where ds="2008-04-08" and hr="11" -PREHOOK: type: QUERY -POSTHOOK: query: explain select count(*) from sp where ds="2008-04-08" and hr="11" -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-0 is a root stage - -STAGE PLANS: - Stage: Stage-0 - Fetch Operator - limit: 1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from sp where ds="2008-04-08" and hr="11" -PREHOOK: type: QUERY -PREHOOK: Input: default@sp -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from sp where ds="2008-04-08" and hr="11" -POSTHOOK: type: QUERY -POSTHOOK: Input: default@sp -#### A masked pattern was here #### -502 http://git-wip-us.apache.org/repos/asf/hive/blob/dbd2d354/ql/src/test/results/clientpositive/llap/insert_values_orig_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/insert_values_orig_table.q.out b/ql/src/test/results/clientpositive/llap/insert_values_orig_table.q.out new file mode 100644 index 0000000..d381d87 --- /dev/null +++ b/ql/src/test/results/clientpositive/llap/insert_values_orig_table.q.out @@ -0,0 +1,136 @@ +PREHOOK: query: drop table if exists acid_ivot_stage +PREHOOK: type: DROPTABLE +POSTHOOK: query: drop table if exists acid_ivot_stage +POSTHOOK: type: DROPTABLE +PREHOOK: query: create table acid_ivot_stage( + ctinyint TINYINT, + csmallint SMALLINT, + cint INT, + cbigint BIGINT, + cfloat FLOAT, + cdouble DOUBLE, + cstring1 STRING, + cstring2 STRING, + ctimestamp1 TIMESTAMP, + ctimestamp2 TIMESTAMP, + cboolean1 BOOLEAN, + cboolean2 BOOLEAN) stored as orc +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@acid_ivot_stage +POSTHOOK: query: create table acid_ivot_stage( + ctinyint TINYINT, + csmallint SMALLINT, + cint INT, + cbigint BIGINT, + cfloat FLOAT, + cdouble DOUBLE, + cstring1 STRING, + cstring2 STRING, + ctimestamp1 TIMESTAMP, + ctimestamp2 TIMESTAMP, + cboolean1 BOOLEAN, + cboolean2 BOOLEAN) stored as orc +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@acid_ivot_stage +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot_stage +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@acid_ivot_stage +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot_stage +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@acid_ivot_stage +PREHOOK: query: create table acid_ivot( + ctinyint TINYINT, + csmallint SMALLINT, + cint INT, + cbigint BIGINT, + cfloat FLOAT, + cdouble DOUBLE, + cstring1 STRING, + cstring2 STRING, + ctimestamp1 TIMESTAMP, + ctimestamp2 TIMESTAMP, + cboolean1 BOOLEAN, + cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true') +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@acid_ivot +POSTHOOK: query: create table acid_ivot( + ctinyint TINYINT, + csmallint SMALLINT, + cint INT, + cbigint BIGINT, + cfloat FLOAT, + cdouble DOUBLE, + cstring1 STRING, + cstring2 STRING, + ctimestamp1 TIMESTAMP, + ctimestamp2 TIMESTAMP, + cboolean1 BOOLEAN, + cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true') +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@acid_ivot +PREHOOK: query: insert into acid_ivot select * from acid_ivot_stage +PREHOOK: type: QUERY +PREHOOK: Input: default@acid_ivot_stage +PREHOOK: Output: default@acid_ivot +POSTHOOK: query: insert into acid_ivot select * from acid_ivot_stage +POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_ivot_stage +POSTHOOK: Output: default@acid_ivot +POSTHOOK: Lineage: acid_ivot.cbigint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cbigint, type:bigint, comment:null), ] +POSTHOOK: Lineage: acid_ivot.cboolean1 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cboolean1, type:boolean, comment:null), ] +POSTHOOK: Lineage: acid_ivot.cboolean2 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cboolean2, type:boolean, comment:null), ] +POSTHOOK: Lineage: acid_ivot.cdouble SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cdouble, type:double, comment:null), ] +POSTHOOK: Lineage: acid_ivot.cfloat SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cfloat, type:float, comment:null), ] +POSTHOOK: Lineage: acid_ivot.cint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cint, type:int, comment:null), ] +POSTHOOK: Lineage: acid_ivot.csmallint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:csmallint, type:smallint, comment:null), ] +POSTHOOK: Lineage: acid_ivot.cstring1 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cstring1, type:string, comment:null), ] +POSTHOOK: Lineage: acid_ivot.cstring2 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:cstring2, type:string, comment:null), ] +POSTHOOK: Lineage: acid_ivot.ctimestamp1 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ] +POSTHOOK: Lineage: acid_ivot.ctimestamp2 SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ] +POSTHOOK: Lineage: acid_ivot.ctinyint SIMPLE [(acid_ivot_stage)acid_ivot_stage.FieldSchema(name:ctinyint, type:tinyint, comment:null), ] +PREHOOK: query: select count(*) from acid_ivot +PREHOOK: type: QUERY +PREHOOK: Input: default@acid_ivot +#### A masked pattern was here #### +POSTHOOK: query: select count(*) from acid_ivot +POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_ivot +#### A masked pattern was here #### +12288 +PREHOOK: query: insert into table acid_ivot values + (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true), + (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true) +PREHOOK: type: QUERY +PREHOOK: Output: default@acid_ivot +POSTHOOK: query: insert into table acid_ivot values + (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true), + (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true) +POSTHOOK: type: QUERY +POSTHOOK: Output: default@acid_ivot +POSTHOOK: Lineage: acid_ivot.cbigint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ] +POSTHOOK: Lineage: acid_ivot.cboolean1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ] +POSTHOOK: Lineage: acid_ivot.cboolean2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ] +POSTHOOK: Lineage: acid_ivot.cdouble EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ] +POSTHOOK: Lineage: acid_ivot.cfloat EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ] +POSTHOOK: Lineage: acid_ivot.cint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: acid_ivot.csmallint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: acid_ivot.cstring1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ] +POSTHOOK: Lineage: acid_ivot.cstring2 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ] +POSTHOOK: Lineage: acid_ivot.ctimestamp1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ] +POSTHOOK: Lineage: acid_ivot.ctimestamp2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ] +POSTHOOK: Lineage: acid_ivot.ctinyint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +PREHOOK: query: select count(*) from acid_ivot +PREHOOK: type: QUERY +PREHOOK: Input: default@acid_ivot +#### A masked pattern was here #### +POSTHOOK: query: select count(*) from acid_ivot +POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_ivot +#### A masked pattern was here #### +12290
