hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From the...@apache.org
Subject svn commit: r1529056 - in /hive/branches/branch-0.12/ql/src/test: queries/clientpositive/alter_varchar2.q results/clientpositive/alter_varchar2.q.out
Date Fri, 04 Oct 2013 01:16:38 GMT
Author: thejas
Date: Fri Oct  4 01:16:37 2013
New Revision: 1529056

URL: http://svn.apache.org/r1529056
Log:
HIVE-5394 : ObjectInspectorConverters.getConvertedOI() does not return the correct object
inspector for primitive type (add missing files) (Hari Sankar via Ashutosh Chauhan)

Added:
    hive/branches/branch-0.12/ql/src/test/queries/clientpositive/alter_varchar2.q
    hive/branches/branch-0.12/ql/src/test/results/clientpositive/alter_varchar2.q.out

Added: hive/branches/branch-0.12/ql/src/test/queries/clientpositive/alter_varchar2.q
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.12/ql/src/test/queries/clientpositive/alter_varchar2.q?rev=1529056&view=auto
==============================================================================
--- hive/branches/branch-0.12/ql/src/test/queries/clientpositive/alter_varchar2.q (added)
+++ hive/branches/branch-0.12/ql/src/test/queries/clientpositive/alter_varchar2.q Fri Oct
 4 01:16:37 2013
@@ -0,0 +1,22 @@
+
+-- alter column type, with partitioned table
+drop table if exists alter_varchar2;
+
+create table alter_varchar2 (
+  c1 varchar(255)
+) partitioned by (hr int);
+
+insert overwrite table alter_varchar2 partition (hr=1)
+  select value from src limit 1;
+
+select c1, length(c1) from alter_varchar2;
+
+alter table alter_varchar2 change column c1 c1 varchar(10);
+
+select hr, c1, length(c1) from alter_varchar2 where hr = 1;
+
+insert overwrite table alter_varchar2 partition (hr=2)
+  select key from src limit 1;
+
+select hr, c1, length(c1) from alter_varchar2 where hr = 1;
+select hr, c1, length(c1) from alter_varchar2 where hr = 2;

Added: hive/branches/branch-0.12/ql/src/test/results/clientpositive/alter_varchar2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.12/ql/src/test/results/clientpositive/alter_varchar2.q.out?rev=1529056&view=auto
==============================================================================
--- hive/branches/branch-0.12/ql/src/test/results/clientpositive/alter_varchar2.q.out (added)
+++ hive/branches/branch-0.12/ql/src/test/results/clientpositive/alter_varchar2.q.out Fri
Oct  4 01:16:37 2013
@@ -0,0 +1,97 @@
+PREHOOK: query: -- alter column type, with partitioned table
+drop table if exists alter_varchar2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: -- alter column type, with partitioned table
+drop table if exists alter_varchar2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table alter_varchar2 (
+  c1 varchar(255)
+) partitioned by (hr int)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table alter_varchar2 (
+  c1 varchar(255)
+) partitioned by (hr int)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@alter_varchar2
+PREHOOK: query: insert overwrite table alter_varchar2 partition (hr=1)
+  select value from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@alter_varchar2@hr=1
+POSTHOOK: query: insert overwrite table alter_varchar2 partition (hr=1)
+  select value from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@alter_varchar2@hr=1
+POSTHOOK: Lineage: alter_varchar2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value,
type:string, comment:default), ]
+PREHOOK: query: select c1, length(c1) from alter_varchar2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_varchar2
+PREHOOK: Input: default@alter_varchar2@hr=1
+#### A masked pattern was here ####
+POSTHOOK: query: select c1, length(c1) from alter_varchar2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_varchar2
+POSTHOOK: Input: default@alter_varchar2@hr=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_varchar2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value,
type:string, comment:default), ]
+val_238	7
+PREHOOK: query: alter table alter_varchar2 change column c1 c1 varchar(10)
+PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@alter_varchar2
+PREHOOK: Output: default@alter_varchar2
+POSTHOOK: query: alter table alter_varchar2 change column c1 c1 varchar(10)
+POSTHOOK: type: ALTERTABLE_RENAMECOL
+POSTHOOK: Input: default@alter_varchar2
+POSTHOOK: Output: default@alter_varchar2
+POSTHOOK: Lineage: alter_varchar2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value,
type:string, comment:default), ]
+PREHOOK: query: select hr, c1, length(c1) from alter_varchar2 where hr = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_varchar2
+PREHOOK: Input: default@alter_varchar2@hr=1
+#### A masked pattern was here ####
+POSTHOOK: query: select hr, c1, length(c1) from alter_varchar2 where hr = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_varchar2
+POSTHOOK: Input: default@alter_varchar2@hr=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_varchar2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value,
type:string, comment:default), ]
+1	val_238	7
+PREHOOK: query: insert overwrite table alter_varchar2 partition (hr=2)
+  select key from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@alter_varchar2@hr=2
+POSTHOOK: query: insert overwrite table alter_varchar2 partition (hr=2)
+  select key from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@alter_varchar2@hr=2
+POSTHOOK: Lineage: alter_varchar2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value,
type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar2 PARTITION(hr=2).c1 EXPRESSION [(src)src.FieldSchema(name:key,
type:string, comment:default), ]
+PREHOOK: query: select hr, c1, length(c1) from alter_varchar2 where hr = 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_varchar2
+PREHOOK: Input: default@alter_varchar2@hr=1
+#### A masked pattern was here ####
+POSTHOOK: query: select hr, c1, length(c1) from alter_varchar2 where hr = 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_varchar2
+POSTHOOK: Input: default@alter_varchar2@hr=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_varchar2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value,
type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar2 PARTITION(hr=2).c1 EXPRESSION [(src)src.FieldSchema(name:key,
type:string, comment:default), ]
+1	val_238	7
+PREHOOK: query: select hr, c1, length(c1) from alter_varchar2 where hr = 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alter_varchar2
+PREHOOK: Input: default@alter_varchar2@hr=2
+#### A masked pattern was here ####
+POSTHOOK: query: select hr, c1, length(c1) from alter_varchar2 where hr = 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alter_varchar2
+POSTHOOK: Input: default@alter_varchar2@hr=2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: alter_varchar2 PARTITION(hr=1).c1 EXPRESSION [(src)src.FieldSchema(name:value,
type:string, comment:default), ]
+POSTHOOK: Lineage: alter_varchar2 PARTITION(hr=2).c1 EXPRESSION [(src)src.FieldSchema(name:key,
type:string, comment:default), ]
+2	238	3



Mime
View raw message