subject:"\[02\/28\] hive git commit\: HIVE\-14355\: Schema evolution for ORC in llap is broken for int to string conversion \(Prasanth Jayachandran reviewed by Sergey Shelukhin\)"

[02/28] hive git commit: HIVE-14355: Schema evolution for ORC in llap is broken for int to string conversion (Prasanth Jayachandran reviewed by Sergey Shelukhin)

2016-08-03 Thread prasanthj

http://git-wip-us.apache.org/repos/asf/hive/blob/950b11fd/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_part_all_primitive.q.out
--
diff --git 
a/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_part_all_primitive.q.out
 
b/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_part_all_primitive.q.out
new file mode 100644
index 000..f924239
--- /dev/null
+++ 
b/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_part_all_primitive.q.out
@@ -0,0 +1,2903 @@
+PREHOOK: query: -- SORT_QUERY_RESULTS
+--
+-- FILE VARIATION: TEXTFILE, Non-Vectorized, MapWork, Partitioned --> all 
primitive conversions
+-- NOTE: the use of hive.vectorized.use.row.serde.deserialize above which 
enables doing
+--  vectorized reading of TEXTFILE format files using the row SERDE methods.
+--
+--
+-- SECTION: ALTER TABLE CHANGE COLUMNS Various --> Various
+--
+--
+--
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BYTE, 
SHORT, INT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, TIMESTAMP) --> BOOLEAN
+--
+CREATE TABLE part_change_various_various_boolean(insert_num int, c1 TINYINT, 
c2 SMALLINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 
STRING, c9 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@part_change_various_various_boolean
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+--
+-- FILE VARIATION: TEXTFILE, Non-Vectorized, MapWork, Partitioned --> all 
primitive conversions
+-- NOTE: the use of hive.vectorized.use.row.serde.deserialize above which 
enables doing
+--  vectorized reading of TEXTFILE format files using the row SERDE methods.
+--
+--
+-- SECTION: ALTER TABLE CHANGE COLUMNS Various --> Various
+--
+--
+--
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BYTE, 
SHORT, INT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, TIMESTAMP) --> BOOLEAN
+--
+CREATE TABLE part_change_various_various_boolean(insert_num int, c1 TINYINT, 
c2 SMALLINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 
STRING, c9 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@part_change_various_various_boolean
+PREHOOK: query: insert into table part_change_various_various_boolean 
partition(part=1)
+values(1, 255, 2000, 72909, 3244222, -29.0764, 470614135, 470614135, 
'true', '0004-09-22 18:26:29.51954', 'original'),
+  (2, 45, 1000, 483777, -23866739993, -3651.672121, 46114.284799488, 
46114.284799488, '', '2007-02-09 05:17:29.368756876', 'original'),
+  (3, 200, 72909, 3244222, -93222, 30.774, -66475.561431, 
-66475.561431, '1', '6229-06-28 02:54:28.970117179', 'original'),
+  (4, 1, 9, 754072151, 3289094, 46114.284799488 ,9250340.75, 
9250340.75, 'time will come', '2002-05-10 05:29:48.990818073', 'original')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@part_change_various_various_boolean@part=1
+POSTHOOK: query: insert into table part_change_various_various_boolean 
partition(part=1)
+values(1, 255, 2000, 72909, 3244222, -29.0764, 470614135, 470614135, 
'true', '0004-09-22 18:26:29.51954', 'original'),
+  (2, 45, 1000, 483777, -23866739993, -3651.672121, 46114.284799488, 
46114.284799488, '', '2007-02-09 05:17:29.368756876', 'original'),
+  (3, 200, 72909, 3244222, -93222, 30.774, -66475.561431, 
-66475.561431, '1', '6229-06-28 02:54:28.970117179', 'original'),
+  (4, 1, 9, 754072151, 3289094, 46114.284799488 ,9250340.75, 
9250340.75, 'time will come', '2002-05-10 05:29:48.990818073', 'original')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@part_change_various_various_boolean@part=1
+POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).b 
SIMPLE 
[(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11,
 type:string, comment:), ]
+POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).c1 
EXPRESSION 
[(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, 
type:string, comment:), ]
+POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).c2 
EXPRESSION 
[(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, 
type:string, comment:), ]
+POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).c3 
EXPRESSION 
[(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, 
type:string, comment:), ]
+POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).c4

[02/28] hive git commit: HIVE-14355: Schema evolution for ORC in llap is broken for int to string conversion (Prasanth Jayachandran reviewed by Sergey Shelukhin)

2016-07-30 Thread prasanthj

http://git-wip-us.apache.org/repos/asf/hive/blob/e769be99/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_part_all_primitive.q.out
--
diff --git 
a/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_part_all_primitive.q.out
 
b/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_part_all_primitive.q.out
new file mode 100644
index 000..f924239
--- /dev/null
+++ 
b/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_part_all_primitive.q.out
@@ -0,0 +1,2903 @@
+PREHOOK: query: -- SORT_QUERY_RESULTS
+--
+-- FILE VARIATION: TEXTFILE, Non-Vectorized, MapWork, Partitioned --> all 
primitive conversions
+-- NOTE: the use of hive.vectorized.use.row.serde.deserialize above which 
enables doing
+--  vectorized reading of TEXTFILE format files using the row SERDE methods.
+--
+--
+-- SECTION: ALTER TABLE CHANGE COLUMNS Various --> Various
+--
+--
+--
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BYTE, 
SHORT, INT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, TIMESTAMP) --> BOOLEAN
+--
+CREATE TABLE part_change_various_various_boolean(insert_num int, c1 TINYINT, 
c2 SMALLINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 
STRING, c9 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@part_change_various_various_boolean
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+--
+-- FILE VARIATION: TEXTFILE, Non-Vectorized, MapWork, Partitioned --> all 
primitive conversions
+-- NOTE: the use of hive.vectorized.use.row.serde.deserialize above which 
enables doing
+--  vectorized reading of TEXTFILE format files using the row SERDE methods.
+--
+--
+-- SECTION: ALTER TABLE CHANGE COLUMNS Various --> Various
+--
+--
+--
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BYTE, 
SHORT, INT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, TIMESTAMP) --> BOOLEAN
+--
+CREATE TABLE part_change_various_various_boolean(insert_num int, c1 TINYINT, 
c2 SMALLINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 
STRING, c9 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@part_change_various_various_boolean
+PREHOOK: query: insert into table part_change_various_various_boolean 
partition(part=1)
+values(1, 255, 2000, 72909, 3244222, -29.0764, 470614135, 470614135, 
'true', '0004-09-22 18:26:29.51954', 'original'),
+  (2, 45, 1000, 483777, -23866739993, -3651.672121, 46114.284799488, 
46114.284799488, '', '2007-02-09 05:17:29.368756876', 'original'),
+  (3, 200, 72909, 3244222, -93222, 30.774, -66475.561431, 
-66475.561431, '1', '6229-06-28 02:54:28.970117179', 'original'),
+  (4, 1, 9, 754072151, 3289094, 46114.284799488 ,9250340.75, 
9250340.75, 'time will come', '2002-05-10 05:29:48.990818073', 'original')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@part_change_various_various_boolean@part=1
+POSTHOOK: query: insert into table part_change_various_various_boolean 
partition(part=1)
+values(1, 255, 2000, 72909, 3244222, -29.0764, 470614135, 470614135, 
'true', '0004-09-22 18:26:29.51954', 'original'),
+  (2, 45, 1000, 483777, -23866739993, -3651.672121, 46114.284799488, 
46114.284799488, '', '2007-02-09 05:17:29.368756876', 'original'),
+  (3, 200, 72909, 3244222, -93222, 30.774, -66475.561431, 
-66475.561431, '1', '6229-06-28 02:54:28.970117179', 'original'),
+  (4, 1, 9, 754072151, 3289094, 46114.284799488 ,9250340.75, 
9250340.75, 'time will come', '2002-05-10 05:29:48.990818073', 'original')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@part_change_various_various_boolean@part=1
+POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).b 
SIMPLE 
[(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11,
 type:string, comment:), ]
+POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).c1 
EXPRESSION 
[(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, 
type:string, comment:), ]
+POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).c2 
EXPRESSION 
[(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, 
type:string, comment:), ]
+POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).c3 
EXPRESSION 
[(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, 
type:string, comment:), ]
+POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).c4

[02/28] hive git commit: HIVE-14355: Schema evolution for ORC in llap is broken for int to string conversion (Prasanth Jayachandran reviewed by Sergey Shelukhin)

[02/28] hive git commit: HIVE-14355: Schema evolution for ORC in llap is broken for int to string conversion (Prasanth Jayachandran reviewed by Sergey Shelukhin)

2 matches

Site Navigation

Mail list logo

Footer information