http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/default_constraint.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/default_constraint.q.out b/ql/src/test/results/clientpositive/llap/default_constraint.q.out deleted file mode 100644 index dd8cc4f..0000000 --- a/ql/src/test/results/clientpositive/llap/default_constraint.q.out +++ /dev/null @@ -1,2793 +0,0 @@ -PREHOOK: query: CREATE TABLE numericDataType(a TINYINT CONSTRAINT tinyint_constraint DEFAULT 127Y ENABLE, b SMALLINT DEFAULT 32767S, c INT DEFAULT 2147483647, - d BIGINT DEFAULT 9223372036854775807L, e DOUBLE DEFAULT 3.4E38, f DECIMAL(9,2) DEFAULT 1234567.89) - clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@numericDataType -POSTHOOK: query: CREATE TABLE numericDataType(a TINYINT CONSTRAINT tinyint_constraint DEFAULT 127Y ENABLE, b SMALLINT DEFAULT 32767S, c INT DEFAULT 2147483647, - d BIGINT DEFAULT 9223372036854775807L, e DOUBLE DEFAULT 3.4E38, f DECIMAL(9,2) DEFAULT 1234567.89) - clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@numericDataType -PREHOOK: query: DESC FORMATTED numericDataType -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@numericdatatype -POSTHOOK: query: DESC FORMATTED numericDataType -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@numericdatatype -# col_name data_type comment -a tinyint -b smallint -c int -d bigint -e double -f decimal(9,2) - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: - transactional true - transactional_properties default -#### 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: 2 -Bucket Columns: [a] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 - -# Constraints - -# Default Constraints -Table: default.numericdatatype -Constraint Name: #### A masked pattern was here #### -Column Name:b Default Value:32767S - -Constraint Name: #### A masked pattern was here #### -Column Name:c Default Value:2147483647 - -Constraint Name: #### A masked pattern was here #### -Column Name:d Default Value:9223372036854775807L - -Constraint Name: #### A masked pattern was here #### -Column Name:e Default Value:3.4E38 - -Constraint Name: #### A masked pattern was here #### -Column Name:f Default Value:1234567.89 - -Constraint Name: tinyint_constraint -Column Name:a Default Value:127Y - -PREHOOK: query: EXPLAIN INSERT INTO numericDataType(a) values(3Y) -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO numericDataType(a) values(3Y) -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct(3)) (type: array<struct<col1:int>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: col1 (type: int), 32767S (type: smallint), 2147483647 (type: int), 9223372036854775807L (type: bigint), 3.4E38D (type: double), 1234567.89 (type: decimal(9,2)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1 Data size: 136 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Map-reduce partition columns: UDFToByte(_col0) (type: tinyint) - Statistics: Num rows: 1 Data size: 136 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: int), _col1 (type: smallint), _col2 (type: int), _col3 (type: bigint), _col4 (type: double), _col5 (type: decimal(9,2)) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Select Operator - expressions: UDFToByte(VALUE._col0) (type: tinyint), VALUE._col1 (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), VALUE._col4 (type: double), VALUE._col5 (type: decimal(9,2)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.numericdatatype - Write Type: INSERT - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.numericdatatype - Write Type: INSERT - -PREHOOK: query: INSERT INTO numericDataType(a) values(3Y) -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@numericdatatype -POSTHOOK: query: INSERT INTO numericDataType(a) values(3Y) -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@numericdatatype -POSTHOOK: Lineage: numericdatatype.a SCRIPT [] -POSTHOOK: Lineage: numericdatatype.b SIMPLE [] -POSTHOOK: Lineage: numericdatatype.c SIMPLE [] -POSTHOOK: Lineage: numericdatatype.d SIMPLE [] -POSTHOOK: Lineage: numericdatatype.e SIMPLE [] -POSTHOOK: Lineage: numericdatatype.f SIMPLE [] -PREHOOK: query: SELECT * FROM numericDataType -PREHOOK: type: QUERY -PREHOOK: Input: default@numericdatatype -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM numericDataType -POSTHOOK: type: QUERY -POSTHOOK: Input: default@numericdatatype -#### A masked pattern was here #### -3 32767 2147483647 9223372036854775807 3.4E38 1234567.89 -PREHOOK: query: EXPLAIN INSERT INTO numericDataType(e,f) values(4.5, 678.4) -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO numericDataType(e,f) values(4.5, 678.4) -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct(4.5,678.4)) (type: array<struct<col1:decimal(2,1),col2:decimal(4,1)>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: 127Y (type: tinyint), 32767S (type: smallint), 2147483647 (type: int), 9223372036854775807L (type: bigint), col1 (type: decimal(2,1)), col2 (type: decimal(4,1)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Map-reduce partition columns: _col0 (type: tinyint) - Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col2 (type: int), _col3 (type: bigint), _col4 (type: decimal(2,1)), _col5 (type: decimal(4,1)) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Select Operator - expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), UDFToDouble(VALUE._col4) (type: double), CAST( VALUE._col5 AS decimal(9,2)) (type: decimal(9,2)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.numericdatatype - Write Type: INSERT - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.numericdatatype - Write Type: INSERT - -PREHOOK: query: INSERT INTO numericDataType(e,f) values(4.5, 678.4) -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@numericdatatype -POSTHOOK: query: INSERT INTO numericDataType(e,f) values(4.5, 678.4) -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@numericdatatype -POSTHOOK: Lineage: numericdatatype.a SIMPLE [] -POSTHOOK: Lineage: numericdatatype.b SIMPLE [] -POSTHOOK: Lineage: numericdatatype.c SIMPLE [] -POSTHOOK: Lineage: numericdatatype.d SIMPLE [] -POSTHOOK: Lineage: numericdatatype.e SCRIPT [] -POSTHOOK: Lineage: numericdatatype.f SCRIPT [] -PREHOOK: query: SELECT * FROM numericDataType -PREHOOK: type: QUERY -PREHOOK: Input: default@numericdatatype -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM numericDataType -POSTHOOK: type: QUERY -POSTHOOK: Input: default@numericdatatype -#### A masked pattern was here #### -3 32767 2147483647 9223372036854775807 3.4E38 1234567.89 -127 32767 2147483647 9223372036854775807 4.5 678.40 -PREHOOK: query: DROP TABLE numericDataType -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@numericdatatype -PREHOOK: Output: default@numericdatatype -POSTHOOK: query: DROP TABLE numericDataType -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@numericdatatype -POSTHOOK: Output: default@numericdatatype -PREHOOK: query: -- Date/time -CREATE TABLE table1(d DATE DEFAULT DATE'2018-02-14', t TIMESTAMP DEFAULT TIMESTAMP'2016-02-22 12:45:07.000000000', - tz timestamp with local time zone DEFAULT TIMESTAMPLOCALTZ'2016-01-03 12:26:34 America/Los_Angeles', - d1 DATE DEFAULT current_date() ENABLE, t1 TIMESTAMP DEFAULT current_timestamp() DISABLE) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@table1 -POSTHOOK: query: -- Date/time -CREATE TABLE table1(d DATE DEFAULT DATE'2018-02-14', t TIMESTAMP DEFAULT TIMESTAMP'2016-02-22 12:45:07.000000000', - tz timestamp with local time zone DEFAULT TIMESTAMPLOCALTZ'2016-01-03 12:26:34 America/Los_Angeles', - d1 DATE DEFAULT current_date() ENABLE, t1 TIMESTAMP DEFAULT current_timestamp() DISABLE) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@table1 -PREHOOK: query: DESC FORMATTED table1 -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@table1 -POSTHOOK: query: DESC FORMATTED table1 -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@table1 -# col_name data_type comment -d date -t timestamp -tz timestamp with local time zone('US/Pacific') -d1 date -t1 timestamp - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -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 - -# Constraints - -# Default Constraints -Table: default.table1 -Constraint Name: #### A masked pattern was here #### -Column Name:d1 Default Value:current_date() - -Constraint Name: #### A masked pattern was here #### -Column Name:d Default Value:DATE'2018-02-14' - -Constraint Name: #### A masked pattern was here #### -Column Name:t Default Value:TIMESTAMP'2016-02-22 12:45:07.000000000' - -Constraint Name: #### A masked pattern was here #### -Column Name:t1 Default Value:current_timestamp() - -Constraint Name: #### A masked pattern was here #### -Column Name:tz Default Value:TIMESTAMPLOCALTZ'2016-01-03 12:26:34 America/Los_Angeles' - -PREHOOK: query: EXPLAIN INSERT INTO table1(t) values ("1985-12-31 12:45:07") -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO table1(t) values ("1985-12-31 12:45:07") -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct('1985-12-31 12:45:07')) (type: array<struct<col1:string>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: DATE'2018-02-14' (type: date), CAST( col1 AS TIMESTAMP) (type: timestamp), TIMESTAMPLOCALTZ'2016-01-03 12:26:34.0 US/Pacific' (type: timestamp with local time zone), CURRENT_DATE() (type: date), null (type: timestamp) - outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 1 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.table1 - Execution mode: llap - LLAP IO: no inputs - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.table1 - -PREHOOK: query: INSERT INTO table1(t) values ("1985-12-31 12:45:07") -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@table1 -POSTHOOK: query: INSERT INTO table1(t) values ("1985-12-31 12:45:07") -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@table1 -POSTHOOK: Lineage: table1.d SIMPLE [] -POSTHOOK: Lineage: table1.d1 EXPRESSION [] -POSTHOOK: Lineage: table1.t SCRIPT [] -POSTHOOK: Lineage: table1.t1 SIMPLE [] -POSTHOOK: Lineage: table1.tz SIMPLE [] -PREHOOK: query: SELECT d, t, tz,d1=current_date(), t1 from table1 -PREHOOK: type: QUERY -PREHOOK: Input: default@table1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT d, t, tz,d1=current_date(), t1 from table1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@table1 -#### A masked pattern was here #### -2018-02-14 1985-12-31 12:45:07 2016-01-03 12:26:34.0 US/Pacific true NULL -PREHOOK: query: EXPLAIN INSERT INTO table1(d, t1) values ("1985-12-31", '2018-02-27 17:32:14.259') -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO table1(d, t1) values ("1985-12-31", '2018-02-27 17:32:14.259') -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct('1985-12-31','2018-02-27 17:32:14.259')) (type: array<struct<col1:string,col2:string>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: CAST( col1 AS DATE) (type: date), TIMESTAMP'2016-02-22 12:45:07.0' (type: timestamp), TIMESTAMPLOCALTZ'2016-01-03 12:26:34.0 US/Pacific' (type: timestamp with local time zone), CURRENT_DATE() (type: date), CAST( col2 AS TIMESTAMP) (type: timestamp) - outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 1 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.table1 - Execution mode: llap - LLAP IO: no inputs - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.table1 - -PREHOOK: query: INSERT INTO table1(d, t1) values ("1985-12-31", '2018-02-27 17:32:14.259') -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@table1 -POSTHOOK: query: INSERT INTO table1(d, t1) values ("1985-12-31", '2018-02-27 17:32:14.259') -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@table1 -POSTHOOK: Lineage: table1.d SCRIPT [] -POSTHOOK: Lineage: table1.d1 EXPRESSION [] -POSTHOOK: Lineage: table1.t SIMPLE [] -POSTHOOK: Lineage: table1.t1 SCRIPT [] -POSTHOOK: Lineage: table1.tz SIMPLE [] -PREHOOK: query: SELECT d, t, tz,d1=current_date(), t1=current_timestamp() from table1 -PREHOOK: type: QUERY -PREHOOK: Input: default@table1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT d, t, tz,d1=current_date(), t1=current_timestamp() from table1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@table1 -#### A masked pattern was here #### -2018-02-14 1985-12-31 12:45:07 2016-01-03 12:26:34.0 US/Pacific true NULL -1985-12-31 2016-02-22 12:45:07 2016-01-03 12:26:34.0 US/Pacific true false -PREHOOK: query: DROP TABLE table1 -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@table1 -PREHOOK: Output: default@table1 -POSTHOOK: query: DROP TABLE table1 -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@table1 -POSTHOOK: Output: default@table1 -PREHOOK: query: CREATE TABLE table2(i STRING DEFAULT 'current_database()', j STRING DEFAULT current_user(), - k STRING DEFAULT 'Current_User()', v varchar(350) DEFAULT cast('varchar_default_value' as varchar(350)), - c char(20) DEFAULT cast('char_value' as char(20))) - clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@table2 -POSTHOOK: query: CREATE TABLE table2(i STRING DEFAULT 'current_database()', j STRING DEFAULT current_user(), - k STRING DEFAULT 'Current_User()', v varchar(350) DEFAULT cast('varchar_default_value' as varchar(350)), - c char(20) DEFAULT cast('char_value' as char(20))) - clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@table2 -PREHOOK: query: DESC FORMATTED table2 -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@table2 -POSTHOOK: query: DESC FORMATTED table2 -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@table2 -# col_name data_type comment -i string -j string -k string -v varchar(350) -c char(20) - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: - transactional true - transactional_properties default -#### 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: 2 -Bucket Columns: [i] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 - -# Constraints - -# Default Constraints -Table: default.table2 -Constraint Name: #### A masked pattern was here #### -Column Name:j Default Value:current_user() - -Constraint Name: #### A masked pattern was here #### -Column Name:k Default Value:'Current_User()' - -Constraint Name: #### A masked pattern was here #### -Column Name:v Default Value:cast('varchar_default_value' as varchar(350)) - -Constraint Name: #### A masked pattern was here #### -Column Name:c Default Value:cast('char_value' as char(20)) - -Constraint Name: #### A masked pattern was here #### -Column Name:i Default Value:'current_database()' - -PREHOOK: query: EXPLAIN INSERT INTO table2(i) values('default') -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO table2(i) values('default') -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct('default')) (type: array<struct<col1:string>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: col1 (type: string), CURRENT_USER() (type: string), 'Current_User()' (type: string), CAST( 'varchar_default_value' AS varchar(350)) (type: varchar(350)), CAST( 'char_value' AS CHAR(20)) (type: char(20)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 1 Data size: 405 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 1 Data size: 405 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: varchar(350)), _col4 (type: char(20)) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Select Operator - expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: varchar(350)), VALUE._col4 (type: char(20)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 1 Data size: 405 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 405 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.table2 - Write Type: INSERT - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.table2 - Write Type: INSERT - -PREHOOK: query: INSERT INTO table2(i) values('default') -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@table2 -POSTHOOK: query: INSERT INTO table2(i) values('default') -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@table2 -POSTHOOK: Lineage: table2.c EXPRESSION [] -POSTHOOK: Lineage: table2.i SCRIPT [] -POSTHOOK: Lineage: table2.j EXPRESSION [] -POSTHOOK: Lineage: table2.k SIMPLE [] -POSTHOOK: Lineage: table2.v EXPRESSION [] -PREHOOK: query: SELECT i,j=current_user(),k,v,c FROM table2 -PREHOOK: type: QUERY -PREHOOK: Input: default@table2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT i,j=current_user(),k,v,c FROM table2 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@table2 -#### A masked pattern was here #### -default true Current_User() varchar_default_value char_value -PREHOOK: query: EXPLAIN INSERT INTO table2(v, c) values('varchar_default2', 'char') -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO table2(v, c) values('varchar_default2', 'char') -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct('varchar_default2','char')) (type: array<struct<col1:string,col2:string>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: 'current_database()' (type: string), CURRENT_USER() (type: string), 'Current_User()' (type: string), col1 (type: string), col2 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 1 Data size: 298 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 1 Data size: 298 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Select Operator - expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), CAST( VALUE._col3 AS varchar(350)) (type: varchar(350)), CAST( VALUE._col4 AS CHAR(20)) (type: char(20)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 1 Data size: 836 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 836 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.table2 - Write Type: INSERT - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.table2 - Write Type: INSERT - -PREHOOK: query: INSERT INTO table2(v, c) values('varchar_default2', 'char') -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@table2 -POSTHOOK: query: INSERT INTO table2(v, c) values('varchar_default2', 'char') -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@table2 -POSTHOOK: Lineage: table2.c SCRIPT [] -POSTHOOK: Lineage: table2.i SIMPLE [] -POSTHOOK: Lineage: table2.j EXPRESSION [] -POSTHOOK: Lineage: table2.k SIMPLE [] -POSTHOOK: Lineage: table2.v SCRIPT [] -PREHOOK: query: SELECT i,j=current_user(),k,v,c FROM table2 -PREHOOK: type: QUERY -PREHOOK: Input: default@table2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT i,j=current_user(),k,v,c FROM table2 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@table2 -#### A masked pattern was here #### -default true Current_User() varchar_default_value char_value -current_database() true Current_User() varchar_default2 char -PREHOOK: query: DROP TABLE table2 -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@table2 -PREHOOK: Output: default@table2 -POSTHOOK: query: DROP TABLE table2 -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@table2 -POSTHOOK: Output: default@table2 -PREHOOK: query: CREATE TABLE misc(b BOOLEAN DEFAULT true, b1 BINARY DEFAULT cast('bin' as binary)) - clustered by (b) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@misc -POSTHOOK: query: CREATE TABLE misc(b BOOLEAN DEFAULT true, b1 BINARY DEFAULT cast('bin' as binary)) - clustered by (b) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@misc -PREHOOK: query: DESC FORMATTED misc -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@misc -POSTHOOK: query: DESC FORMATTED misc -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@misc -# col_name data_type comment -b boolean -b1 binary - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: - transactional true - transactional_properties default -#### 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: 2 -Bucket Columns: [b] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 - -# Constraints - -# Default Constraints -Table: default.misc -Constraint Name: #### A masked pattern was here #### -Column Name:b Default Value:true - -Constraint Name: #### A masked pattern was here #### -Column Name:b1 Default Value:cast('bin' as binary) - -PREHOOK: query: EXPLAIN INSERT INTO misc(b) values(false) -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO misc(b) values(false) -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct(false)) (type: array<struct<col1:boolean>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: col1 (type: boolean), CAST( 'bin' AS BINARY) (type: binary) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Map-reduce partition columns: _col0 (type: boolean) - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: boolean), _col1 (type: binary) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Select Operator - expressions: VALUE._col0 (type: boolean), VALUE._col1 (type: binary) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.misc - Write Type: INSERT - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.misc - Write Type: INSERT - -PREHOOK: query: INSERT INTO misc(b) values(false) -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@misc -POSTHOOK: query: INSERT INTO misc(b) values(false) -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@misc -POSTHOOK: Lineage: misc.b SCRIPT [] -POSTHOOK: Lineage: misc.b1 EXPRESSION [] -PREHOOK: query: SELECT b, b1 from misc -PREHOOK: type: QUERY -PREHOOK: Input: default@misc -#### A masked pattern was here #### -POSTHOOK: query: SELECT b, b1 from misc -POSTHOOK: type: QUERY -POSTHOOK: Input: default@misc -#### A masked pattern was here #### -false bin -PREHOOK: query: EXPLAIN INSERT INTO misc(b1) values('011') -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO misc(b1) values('011') -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct('011')) (type: array<struct<col1:string>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: true (type: boolean), col1 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Map-reduce partition columns: _col0 (type: boolean) - Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: boolean), _col1 (type: string) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Select Operator - expressions: VALUE._col0 (type: boolean), CAST( VALUE._col1 AS BINARY) (type: binary) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 148 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 148 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.misc - Write Type: INSERT - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.misc - Write Type: INSERT - -PREHOOK: query: INSERT INTO misc(b) values(false) -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@misc -POSTHOOK: query: INSERT INTO misc(b) values(false) -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@misc -POSTHOOK: Lineage: misc.b SCRIPT [] -POSTHOOK: Lineage: misc.b1 EXPRESSION [] -PREHOOK: query: SELECT b, b1 from misc -PREHOOK: type: QUERY -PREHOOK: Input: default@misc -#### A masked pattern was here #### -POSTHOOK: query: SELECT b, b1 from misc -POSTHOOK: type: QUERY -POSTHOOK: Input: default@misc -#### A masked pattern was here #### -false bin -false bin -PREHOOK: query: DROP TABLE misc -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@misc -PREHOOK: Output: default@misc -POSTHOOK: query: DROP TABLE misc -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@misc -POSTHOOK: Output: default@misc -PREHOOK: query: CREATE table t11(i int default cast(cast(4 as double) as int), - b1 boolean default cast ('true' as boolean), b2 int default cast (5.67 as int), - b3 tinyint default cast (45 as tinyint), b4 float default cast (45.4 as float), - b5 bigint default cast (567 as bigint), b6 smallint default cast (88 as smallint), - j varchar(50) default cast(current_timestamp() as varchar(50)), - k string default cast(cast(current_user() as varchar(50)) as string), - tz1 timestamp with local time zone DEFAULT cast('2016-01-03 12:26:34 America/Los_Angeles' as timestamp with local time zone), - ts timestamp default cast('2016-01-01 12:01:01' as timestamp), - dc decimal(8,2) default cast(4.5 as decimal(8,2)), - c2 double default cast(5 as double), c4 char(2) default cast(cast(cast('ab' as string) as varchar(2)) as char(2))) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@t11 -POSTHOOK: query: CREATE table t11(i int default cast(cast(4 as double) as int), - b1 boolean default cast ('true' as boolean), b2 int default cast (5.67 as int), - b3 tinyint default cast (45 as tinyint), b4 float default cast (45.4 as float), - b5 bigint default cast (567 as bigint), b6 smallint default cast (88 as smallint), - j varchar(50) default cast(current_timestamp() as varchar(50)), - k string default cast(cast(current_user() as varchar(50)) as string), - tz1 timestamp with local time zone DEFAULT cast('2016-01-03 12:26:34 America/Los_Angeles' as timestamp with local time zone), - ts timestamp default cast('2016-01-01 12:01:01' as timestamp), - dc decimal(8,2) default cast(4.5 as decimal(8,2)), - c2 double default cast(5 as double), c4 char(2) default cast(cast(cast('ab' as string) as varchar(2)) as char(2))) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@t11 -PREHOOK: query: DESC FORMATTED t11 -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@t11 -POSTHOOK: query: DESC FORMATTED t11 -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@t11 -# col_name data_type comment -i int -b1 boolean -b2 int -b3 tinyint -b4 float -b5 bigint -b6 smallint -j varchar(50) -k string -tz1 timestamp with local time zone('US/Pacific') -ts timestamp -dc decimal(8,2) -c2 double -c4 char(2) - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -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 - -# Constraints - -# Default Constraints -Table: default.t11 -Constraint Name: #### A masked pattern was here #### -Column Name:tz1 Default Value:cast('2016-01-03 12:26:34 America/Los_Angeles' as timestamp with local time zone) - -Constraint Name: #### A masked pattern was here #### -Column Name:b1 Default Value:cast ('true' as boolean) - -Constraint Name: #### A masked pattern was here #### -Column Name:i Default Value:cast(cast(4 as double) as int) - -Constraint Name: #### A masked pattern was here #### -Column Name:b2 Default Value:cast (5.67 as int) - -Constraint Name: #### A masked pattern was here #### -Column Name:j Default Value:cast(current_timestamp() as varchar(50)) - -Constraint Name: #### A masked pattern was here #### -Column Name:b3 Default Value:cast (45 as tinyint) - -Constraint Name: #### A masked pattern was here #### -Column Name:k Default Value:cast(cast(current_user() as varchar(50)) as string) - -Constraint Name: #### A masked pattern was here #### -Column Name:b4 Default Value:cast (45.4 as float) - -Constraint Name: #### A masked pattern was here #### -Column Name:b5 Default Value:cast (567 as bigint) - -Constraint Name: #### A masked pattern was here #### -Column Name:b6 Default Value:cast (88 as smallint) - -Constraint Name: #### A masked pattern was here #### -Column Name:c2 Default Value:cast(5 as double) - -Constraint Name: #### A masked pattern was here #### -Column Name:c4 Default Value:cast(cast(cast('ab' as string) as varchar(2)) as char(2)) - -Constraint Name: #### A masked pattern was here #### -Column Name:ts Default Value:cast('2016-01-01 12:01:01' as timestamp) - -Constraint Name: #### A masked pattern was here #### -Column Name:dc Default Value:cast(4.5 as decimal(8,2)) - -PREHOOK: query: EXPLAIN INSERT INTO t11(c4) values('vi') -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO t11(c4) values('vi') -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct('vi')) (type: array<struct<col1:string>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: UDFToInteger(UDFToDouble(4)) (type: int), UDFToBoolean('true') (type: boolean), UDFToInteger(5.67) (type: int), UDFToByte(45) (type: tinyint), UDFToFloat(45.4) (type: float), UDFToLong(567) (type: bigint), UDFToShort(88) (type: smallint), CAST( CURRENT_TIMESTAMP() AS varchar(50)) (type: varchar(50)), UDFToString(CAST( CURRENT_USER() AS varchar(50))) (type: string), CAST( '2016-01-03 12:26:34 America/Los_Angeles' AS timestamp with local time zone) (type: timestamp with local time zone), CAST( '2016-01-01 12:01:01' AS TIMESTAMP) (type: timestamp), CAST( 4.5 AS decimal(8,2)) (type: decimal(8,2)), UDFToDouble(5) (type: double), CAST( col1 AS CHAR(2)) (type: char(2)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13 - Statistics: Num rows: 1 Data size: 522 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 522 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.t11 - Execution mode: llap - LLAP IO: no inputs - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.t11 - -PREHOOK: query: INSERT INTO t11(c4) values('vi') -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@t11 -POSTHOOK: query: INSERT INTO t11(c4) values('vi') -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@t11 -POSTHOOK: Lineage: t11.b1 EXPRESSION [] -POSTHOOK: Lineage: t11.b2 EXPRESSION [] -POSTHOOK: Lineage: t11.b3 EXPRESSION [] -POSTHOOK: Lineage: t11.b4 EXPRESSION [] -POSTHOOK: Lineage: t11.b5 EXPRESSION [] -POSTHOOK: Lineage: t11.b6 EXPRESSION [] -POSTHOOK: Lineage: t11.c2 EXPRESSION [] -POSTHOOK: Lineage: t11.c4 SCRIPT [] -POSTHOOK: Lineage: t11.dc EXPRESSION [] -POSTHOOK: Lineage: t11.i EXPRESSION [] -POSTHOOK: Lineage: t11.j EXPRESSION [] -POSTHOOK: Lineage: t11.k EXPRESSION [] -POSTHOOK: Lineage: t11.ts EXPRESSION [] -POSTHOOK: Lineage: t11.tz1 EXPRESSION [] -PREHOOK: query: SELECT ts, tz1, dc, b1,b2,b3,b4,b5,b6,j=cast(current_timestamp() as varchar(50)), k=cast(current_user() as string), c2, c4 from t11 -PREHOOK: type: QUERY -PREHOOK: Input: default@t11 -#### A masked pattern was here #### -POSTHOOK: query: SELECT ts, tz1, dc, b1,b2,b3,b4,b5,b6,j=cast(current_timestamp() as varchar(50)), k=cast(current_user() as string), c2, c4 from t11 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t11 -#### A masked pattern was here #### -2016-01-01 12:01:01 2016-01-03 12:26:34.0 US/Pacific 4.50 true 5 45 45.4 567 88 false true 5.0 vi -PREHOOK: query: EXPLAIN INSERT INTO t11(b1,c4) values(true,'ga') -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO t11(b1,c4) values(true,'ga') -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct(true,'ga')) (type: array<struct<col1:boolean,col2:string>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: UDFToInteger(UDFToDouble(4)) (type: int), col1 (type: boolean), UDFToInteger(5.67) (type: int), UDFToByte(45) (type: tinyint), UDFToFloat(45.4) (type: float), UDFToLong(567) (type: bigint), UDFToShort(88) (type: smallint), CAST( CURRENT_TIMESTAMP() AS varchar(50)) (type: varchar(50)), UDFToString(CAST( CURRENT_USER() AS varchar(50))) (type: string), CAST( '2016-01-03 12:26:34 America/Los_Angeles' AS timestamp with local time zone) (type: timestamp with local time zone), CAST( '2016-01-01 12:01:01' AS TIMESTAMP) (type: timestamp), CAST( 4.5 AS decimal(8,2)) (type: decimal(8,2)), UDFToDouble(5) (type: double), CAST( col2 AS CHAR(2)) (type: char(2)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13 - Statistics: Num rows: 1 Data size: 519 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 519 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.t11 - Execution mode: llap - LLAP IO: no inputs - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.t11 - -PREHOOK: query: INSERT INTO t11(c4) values('vi') -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@t11 -POSTHOOK: query: INSERT INTO t11(c4) values('vi') -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@t11 -POSTHOOK: Lineage: t11.b1 EXPRESSION [] -POSTHOOK: Lineage: t11.b2 EXPRESSION [] -POSTHOOK: Lineage: t11.b3 EXPRESSION [] -POSTHOOK: Lineage: t11.b4 EXPRESSION [] -POSTHOOK: Lineage: t11.b5 EXPRESSION [] -POSTHOOK: Lineage: t11.b6 EXPRESSION [] -POSTHOOK: Lineage: t11.c2 EXPRESSION [] -POSTHOOK: Lineage: t11.c4 SCRIPT [] -POSTHOOK: Lineage: t11.dc EXPRESSION [] -POSTHOOK: Lineage: t11.i EXPRESSION [] -POSTHOOK: Lineage: t11.j EXPRESSION [] -POSTHOOK: Lineage: t11.k EXPRESSION [] -POSTHOOK: Lineage: t11.ts EXPRESSION [] -POSTHOOK: Lineage: t11.tz1 EXPRESSION [] -PREHOOK: query: SELECT ts, tz1, dc, b1,b2,b3,b4,b5,b6,j=cast(current_timestamp() as varchar(50)), k=cast(current_user() as string), c2, c4 from t11 -PREHOOK: type: QUERY -PREHOOK: Input: default@t11 -#### A masked pattern was here #### -POSTHOOK: query: SELECT ts, tz1, dc, b1,b2,b3,b4,b5,b6,j=cast(current_timestamp() as varchar(50)), k=cast(current_user() as string), c2, c4 from t11 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t11 -#### A masked pattern was here #### -2016-01-01 12:01:01 2016-01-03 12:26:34.0 US/Pacific 4.50 true 5 45 45.4 567 88 false true 5.0 vi -2016-01-01 12:01:01 2016-01-03 12:26:34.0 US/Pacific 4.50 true 5 45 45.4 567 88 false true 5.0 vi -PREHOOK: query: DROP TABLE t11 -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@t11 -PREHOOK: Output: default@t11 -POSTHOOK: query: DROP TABLE t11 -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@t11 -POSTHOOK: Output: default@t11 -PREHOOK: query: CREATE TABLE numericDataType(a TINYINT CONSTRAINT tinyint_constraint DEFAULT 127Y ENABLE, b SMALLINT DEFAULT 32767S, c INT DEFAULT 2147483647, - d BIGINT DEFAULT 9223372036854775807L, e DOUBLE DEFAULT 3.4E38, f DECIMAL(9,2) DEFAULT 1234567.89) - clustered by (b) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@numericDataType -POSTHOOK: query: CREATE TABLE numericDataType(a TINYINT CONSTRAINT tinyint_constraint DEFAULT 127Y ENABLE, b SMALLINT DEFAULT 32767S, c INT DEFAULT 2147483647, - d BIGINT DEFAULT 9223372036854775807L, e DOUBLE DEFAULT 3.4E38, f DECIMAL(9,2) DEFAULT 1234567.89) - clustered by (b) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@numericDataType -PREHOOK: query: ALTER TABLE numericDataType DROP CONSTRAINT tinyint_constraint -PREHOOK: type: ALTERTABLE_DROPCONSTRAINT -POSTHOOK: query: ALTER TABLE numericDataType DROP CONSTRAINT tinyint_constraint -POSTHOOK: type: ALTERTABLE_DROPCONSTRAINT -PREHOOK: query: DESC FORMATTED numericDataType -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@numericdatatype -POSTHOOK: query: DESC FORMATTED numericDataType -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@numericdatatype -# col_name data_type comment -a tinyint -b smallint -c int -d bigint -e double -f decimal(9,2) - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: - transactional true - transactional_properties default -#### 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: 2 -Bucket Columns: [b] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 - -# Constraints - -# Default Constraints -Table: default.numericdatatype -Constraint Name: #### A masked pattern was here #### -Column Name:b Default Value:32767S - -Constraint Name: #### A masked pattern was here #### -Column Name:c Default Value:2147483647 - -Constraint Name: #### A masked pattern was here #### -Column Name:d Default Value:9223372036854775807L - -Constraint Name: #### A masked pattern was here #### -Column Name:e Default Value:3.4E38 - -Constraint Name: #### A masked pattern was here #### -Column Name:f Default Value:1234567.89 - -PREHOOK: query: EXPLAIN INSERT INTO numericDataType(b) values(456) -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO numericDataType(b) values(456) -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct(456)) (type: array<struct<col1:int>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: null (type: tinyint), col1 (type: int), 2147483647 (type: int), 9223372036854775807L (type: bigint), 3.4E38D (type: double), 1234567.89 (type: decimal(9,2)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1 Data size: 136 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Map-reduce partition columns: UDFToShort(_col1) (type: smallint) - Statistics: Num rows: 1 Data size: 136 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: tinyint), _col1 (type: int), _col2 (type: int), _col3 (type: bigint), _col4 (type: double), _col5 (type: decimal(9,2)) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Select Operator - expressions: VALUE._col0 (type: tinyint), UDFToShort(VALUE._col1) (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), VALUE._col4 (type: double), VALUE._col5 (type: decimal(9,2)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.numericdatatype - Write Type: INSERT - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.numericdatatype - Write Type: INSERT - -PREHOOK: query: INSERT INTO numericDataType(b) values(456) -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@numericdatatype -POSTHOOK: query: INSERT INTO numericDataType(b) values(456) -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@numericdatatype -POSTHOOK: Lineage: numericdatatype.a SIMPLE [] -POSTHOOK: Lineage: numericdatatype.b SCRIPT [] -POSTHOOK: Lineage: numericdatatype.c SIMPLE [] -POSTHOOK: Lineage: numericdatatype.d SIMPLE [] -POSTHOOK: Lineage: numericdatatype.e SIMPLE [] -POSTHOOK: Lineage: numericdatatype.f SIMPLE [] -PREHOOK: query: SELECT * from numericDataType -PREHOOK: type: QUERY -PREHOOK: Input: default@numericdatatype -#### A masked pattern was here #### -POSTHOOK: query: SELECT * from numericDataType -POSTHOOK: type: QUERY -POSTHOOK: Input: default@numericdatatype -#### A masked pattern was here #### -NULL 456 2147483647 9223372036854775807 3.4E38 1234567.89 -PREHOOK: query: ALTER TABLE numericDataType ADD CONSTRAINT uk1 UNIQUE(a,b) DISABLE NOVALIDATE -PREHOOK: type: ALTERTABLE_ADDCONSTRAINT -POSTHOOK: query: ALTER TABLE numericDataType ADD CONSTRAINT uk1 UNIQUE(a,b) DISABLE NOVALIDATE -POSTHOOK: type: ALTERTABLE_ADDCONSTRAINT -PREHOOK: query: DESC FORMATTED numericDataType -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@numericdatatype -POSTHOOK: query: DESC FORMATTED numericDataType -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@numericdatatype -# col_name data_type comment -a tinyint -b smallint -c int -d bigint -e double -f decimal(9,2) - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: - numFiles 1 - totalSize 1063 - transactional true - transactional_properties default -#### 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: 2 -Bucket Columns: [b] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 - -# Constraints - -# Unique Constraints -Table: default.numericdatatype -Constraint Name: uk1 -Column Name:a Key Sequence:1 -Column Name:b Key Sequence:2 - - -# Default Constraints -Table: default.numericdatatype -Constraint Name: #### A masked pattern was here #### -Column Name:b Default Value:32767S - -Constraint Name: #### A masked pattern was here #### -Column Name:c Default Value:2147483647 - -Constraint Name: #### A masked pattern was here #### -Column Name:d Default Value:9223372036854775807L - -Constraint Name: #### A masked pattern was here #### -Column Name:e Default Value:3.4E38 - -Constraint Name: #### A masked pattern was here #### -Column Name:f Default Value:1234567.89 - -PREHOOK: query: EXPLAIN INSERT INTO numericDataType(b) values(56) -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO numericDataType(b) values(56) -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct(56)) (type: array<struct<col1:int>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: null (type: tinyint), col1 (type: int), 2147483647 (type: int), 9223372036854775807L (type: bigint), 3.4E38D (type: double), 1234567.89 (type: decimal(9,2)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1 Data size: 136 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Map-reduce partition columns: UDFToShort(_col1) (type: smallint) - Statistics: Num rows: 1 Data size: 136 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: tinyint), _col1 (type: int), _col2 (type: int), _col3 (type: bigint), _col4 (type: double), _col5 (type: decimal(9,2)) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Select Operator - expressions: VALUE._col0 (type: tinyint), UDFToShort(VALUE._col1) (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), VALUE._col4 (type: double), VALUE._col5 (type: decimal(9,2)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.numericdatatype - Write Type: INSERT - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.numericdatatype - Write Type: INSERT - -PREHOOK: query: INSERT INTO numericDataType(b) values(456) -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@numericdatatype -POSTHOOK: query: INSERT INTO numericDataType(b) values(456) -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@numericdatatype -POSTHOOK: Lineage: numericdatatype.a SIMPLE [] -POSTHOOK: Lineage: numericdatatype.b SCRIPT [] -POSTHOOK: Lineage: numericdatatype.c SIMPLE [] -POSTHOOK: Lineage: numericdatatype.d SIMPLE [] -POSTHOOK: Lineage: numericdatatype.e SIMPLE [] -POSTHOOK: Lineage: numericdatatype.f SIMPLE [] -PREHOOK: query: SELECT * from numericDataType -PREHOOK: type: QUERY -PREHOOK: Input: default@numericdatatype -#### A masked pattern was here #### -POSTHOOK: query: SELECT * from numericDataType -POSTHOOK: type: QUERY -POSTHOOK: Input: default@numericdatatype -#### A masked pattern was here #### -NULL 456 2147483647 9223372036854775807 3.4E38 1234567.89 -NULL 456 2147483647 9223372036854775807 3.4E38 1234567.89 -PREHOOK: query: ALTER TABLE numericDataType CHANGE a a TINYINT CONSTRAINT second_null_constraint NOT NULL ENABLE -PREHOOK: type: ALTERTABLE_RENAMECOL -PREHOOK: Input: default@numericdatatype -PREHOOK: Output: default@numericdatatype -POSTHOOK: query: ALTER TABLE numericDataType CHANGE a a TINYINT CONSTRAINT second_null_constraint NOT NULL ENABLE -POSTHOOK: type: ALTERTABLE_RENAMECOL -POSTHOOK: Input: default@numericdatatype -POSTHOOK: Output: default@numericdatatype -PREHOOK: query: DESC FORMATTED numericDataType -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@numericdatatype -POSTHOOK: query: DESC FORMATTED numericDataType -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@numericdatatype -# col_name data_type comment -a tinyint -b smallint -c int -d bigint -e double -f decimal(9,2) - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: -#### A masked pattern was here #### - numFiles 2 - totalSize 2127 - transactional true - transactional_properties default -#### 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: 2 -Bucket Columns: [b] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 - -# Constraints - -# Unique Constraints -Table: default.numericdatatype -Constraint Name: uk1 -Column Name:a Key Sequence:1 -Column Name:b Key Sequence:2 - - -# Not Null Constraints -Table: default.numericdatatype -Constraint Name: second_null_constraint -Column Name: a - - -# Default Constraints -Table: default.numericdatatype -Constraint Name: #### A masked pattern was here #### -Column Name:b Default Value:32767S - -Constraint Name: #### A masked pattern was here #### -Column Name:c Default Value:2147483647 - -Constraint Name: #### A masked pattern was here #### -Column Name:d Default Value:9223372036854775807L - -Constraint Name: #### A masked pattern was here #### -Column Name:e Default Value:3.4E38 - -Constraint Name: #### A masked pattern was here #### -Column Name:f Default Value:1234567.89 - -PREHOOK: query: ALTER TABLE numericDataType CHANGE a a TINYINT CONSTRAINT default_constraint DEFAULT 127Y ENABLE -PREHOOK: type: ALTERTABLE_RENAMECOL -PREHOOK: Input: default@numericdatatype -PREHOOK: Output: default@numericdatatype -POSTHOOK: query: ALTER TABLE numericDataType CHANGE a a TINYINT CONSTRAINT default_constraint DEFAULT 127Y ENABLE -POSTHOOK: type: ALTERTABLE_RENAMECOL -POSTHOOK: Input: default@numericdatatype -POSTHOOK: Output: default@numericdatatype -PREHOOK: query: DESC FORMATTED numericDataType -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@numericdatatype -POSTHOOK: query: DESC FORMATTED numericDataType -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@numericdatatype -# col_name data_type comment -a tinyint -b smallint -c int -d bigint -e double -f decimal(9,2) - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: -#### A masked pattern was here #### - numFiles 2 - totalSize 2127 - transactional true - transactional_properties default -#### 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: 2 -Bucket Columns: [b] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 - -# Constraints - -# Unique Constraints -Table: default.numericdatatype -Constraint Name: uk1 -Column Name:a Key Sequence:1 -Column Name:b Key Sequence:2 - - -# Not Null Constraints -Table: default.numericdatatype -Constraint Name: second_null_constraint -Column Name: a - - -# Default Constraints -Table: default.numericdatatype -Constraint Name: #### A masked pattern was here #### -Column Name:b Default Value:32767S - -Constraint Name: #### A masked pattern was here #### -Column Name:c Default Value:2147483647 - -Constraint Name: #### A masked pattern was here #### -Column Name:d Default Value:9223372036854775807L - -Constraint Name: #### A masked pattern was here #### -Column Name:e Default Value:3.4E38 - -Constraint Name: #### A masked pattern was here #### -Column Name:f Default Value:1234567.89 - -Constraint Name: default_constraint -Column Name:a Default Value:127Y - -PREHOOK: query: EXPLAIN INSERT INTO numericDataType(f) values(847.45) -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO numericDataType(f) values(847.45) -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: array(const struct(847.45)) (type: array<struct<col1:decimal(5,2)>>) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - UDTF Operator - Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - function name: inline - Select Operator - expressions: 127Y (type: tinyint), 32767S (type: smallint), 2147483647 (type: int), 9223372036854775807L (type: bigint), 3.4E38D (type: double), col1 (type: decimal(5,2)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1 Data size: 28 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: enforce_constraint(127Y is not null) (type: boolean) - Statistics: Num rows: 1 Data size: 28 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Map-reduce partition columns: _col1 (type: smallint) - Statistics: Num rows: 1 Data size: 28 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col2 (type: int), _col3 (type: bigint), _col4 (type: double), _col5 (type: decimal(5,2)) - Execution mode: llap - LLAP IO: no inputs - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Select Operator - expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), VALUE._col4 (type: double), CAST( VALUE._col5 AS decimal(9,2)) (type: decimal(9,2)) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.numericdatatype - Write Type: INSERT - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.numericdatatype - Write Type: INSERT - -PREHOOK: query: --plan should have both DEFAULT and NOT NULL -INSERT INTO numericDataType(f) values(847.45) -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@numericdatatype -POSTHOOK: query: --plan should have both DEFAULT and NOT NULL -INSERT INTO numericDataType(f) values(847.45) -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@
<TRUNCATED>
