Added: hive/trunk/ql/src/test/results/clientpositive/alter_table_cascade.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_table_cascade.q.out?rev=1640418&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/alter_table_cascade.q.out (added) +++ hive/trunk/ql/src/test/results/clientpositive/alter_table_cascade.q.out Tue Nov 18 20:14:29 2014 @@ -0,0 +1,1387 @@ +PREHOOK: query: -- SORT_QUERY_RESULTS + +drop table if exists alter_table_src +PREHOOK: type: DROPTABLE +POSTHOOK: query: -- SORT_QUERY_RESULTS + +drop table if exists alter_table_src +POSTHOOK: type: DROPTABLE +PREHOOK: query: drop table if exists alter_table_cascade +PREHOOK: type: DROPTABLE +POSTHOOK: query: drop table if exists alter_table_cascade +POSTHOOK: type: DROPTABLE +PREHOOK: query: create table alter_table_src(c1 string, c2 string) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@alter_table_src +POSTHOOK: query: create table alter_table_src(c1 string, c2 string) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@alter_table_src +PREHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_table_src +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@alter_table_src +POSTHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_table_src +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@alter_table_src +PREHOOK: query: create table alter_table_cascade (c1 string) partitioned by (p1 string, p2 string) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@alter_table_cascade +POSTHOOK: query: create table alter_table_cascade (c1 string) partitioned by (p1 string, p2 string) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@alter_table_cascade +PREHOOK: query: insert overwrite table alter_table_cascade partition (p1, p2) + select c1, 'abc', '123' from alter_table_src + union all + select c1, null, '123' from alter_table_src +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_src +PREHOOK: Output: default@alter_table_cascade +POSTHOOK: query: insert overwrite table alter_table_cascade partition (p1, p2) + select c1, 'abc', '123' from alter_table_src + union all + select c1, null, '123' from alter_table_src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_src +POSTHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +POSTHOOK: Lineage: alter_table_cascade PARTITION(p1=__HIVE_DEFAULT_PARTITION__,p2=123).c1 EXPRESSION [(alter_table_src)alter_table_src.FieldSchema(name:c1, type:string, comment:null), (alter_table_src)alter_table_src.FieldSchema(name:c1, type:string, comment:null), ] +POSTHOOK: Lineage: alter_table_cascade PARTITION(p1=abc,p2=123).c1 EXPRESSION [(alter_table_src)alter_table_src.FieldSchema(name:c1, type:string, comment:null), (alter_table_src)alter_table_src.FieldSchema(name:c1, type:string, comment:null), ] +PREHOOK: query: show partitions alter_table_cascade +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: show partitions alter_table_cascade +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@alter_table_cascade +p1=__HIVE_DEFAULT_PARTITION__/p2=123 +p1=abc/p2=123 +PREHOOK: query: describe alter_table_cascade +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: select * from alter_table_cascade where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=abc/p2=123 +#### A masked pattern was here #### +Beck abc 123 +Beck abc 123 +Beck abc 123 +Cluck abc 123 +Mary abc 123 +Mary abc 123 +Snow abc 123 +Tom abc 123 +Tom abc 123 +Tom abc 123 +PREHOOK: query: select * from alter_table_cascade where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck __HIVE_DEFAULT_PARTITION__ 123 +Beck __HIVE_DEFAULT_PARTITION__ 123 +Beck __HIVE_DEFAULT_PARTITION__ 123 +Cluck __HIVE_DEFAULT_PARTITION__ 123 +Mary __HIVE_DEFAULT_PARTITION__ 123 +Mary __HIVE_DEFAULT_PARTITION__ 123 +Snow __HIVE_DEFAULT_PARTITION__ 123 +Tom __HIVE_DEFAULT_PARTITION__ 123 +Tom __HIVE_DEFAULT_PARTITION__ 123 +Tom __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: -- add columns c2 by replace columns (for HIVE-6131) +-- reload data to existing partition __HIVE_DEFAULT_PARTITION__ +-- load data to a new partition xyz +-- querying data (form new or existing partition) should return non-NULL values for the new column +alter table alter_table_cascade replace columns (c1 string, c2 string) cascade +PREHOOK: type: ALTERTABLE_REPLACECOLS +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Output: default@alter_table_cascade +PREHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +PREHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +POSTHOOK: query: -- add columns c2 by replace columns (for HIVE-6131) +-- reload data to existing partition __HIVE_DEFAULT_PARTITION__ +-- load data to a new partition xyz +-- querying data (form new or existing partition) should return non-NULL values for the new column +alter table alter_table_cascade replace columns (c1 string, c2 string) cascade +POSTHOOK: type: ALTERTABLE_REPLACECOLS +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +PREHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__',p2='123') +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__',p2='123') +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +PREHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_table_cascade partition (p1='xyz', p2='123') +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@alter_table_cascade +POSTHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_table_cascade partition (p1='xyz', p2='123') +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade@p1=xyz/p2=123 +PREHOOK: query: describe alter_table_cascade +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +c2 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='xyz', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='xyz', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +c2 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +c2 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +c2 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: select * from alter_table_cascade where p1='xyz' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=xyz/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='xyz' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=xyz/p2=123 +#### A masked pattern was here #### +Beck 0.0 xyz 123 +Beck 77.341 xyz 123 +Beck 79.9 xyz 123 +Cluck 5.96 xyz 123 +Mary 33.33 xyz 123 +Mary 4.329 xyz 123 +Snow 55.71 xyz 123 +Tom -12.25 xyz 123 +Tom 19.00 xyz 123 +Tom 234.79 xyz 123 +PREHOOK: query: select * from alter_table_cascade where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=abc/p2=123 +#### A masked pattern was here #### +Beck NULL abc 123 +Beck NULL abc 123 +Beck NULL abc 123 +Cluck NULL abc 123 +Mary NULL abc 123 +Mary NULL abc 123 +Snow NULL abc 123 +Tom NULL abc 123 +Tom NULL abc 123 +Tom NULL abc 123 +PREHOOK: query: select * from alter_table_cascade where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0.0 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77.341 __HIVE_DEFAULT_PARTITION__ 123 +Beck 79.9 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 5.96 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33.33 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4.329 __HIVE_DEFAULT_PARTITION__ 123 +Snow 55.71 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12.25 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19.00 __HIVE_DEFAULT_PARTITION__ 123 +Tom 234.79 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: -- Change c2 to decimal(10,0), the change should cascaded to all partitions +-- the c2 value returned should be in decimal(10,0) +alter table alter_table_cascade change c2 c2 decimal(10,0) comment "change datatype" cascade +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Output: default@alter_table_cascade +PREHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +PREHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +PREHOOK: Output: default@alter_table_cascade@p1=xyz/p2=123 +POSTHOOK: query: -- Change c2 to decimal(10,0), the change should cascaded to all partitions +-- the c2 value returned should be in decimal(10,0) +alter table alter_table_cascade change c2 c2 decimal(10,0) comment "change datatype" cascade +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +POSTHOOK: Output: default@alter_table_cascade@p1=xyz/p2=123 +PREHOOK: query: describe alter_table_cascade +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +c2 decimal(10,0) change datatype +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='xyz', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='xyz', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +c2 decimal(10,0) change datatype +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +c2 decimal(10,0) change datatype +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +c2 decimal(10,0) change datatype +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: select * from alter_table_cascade where p1='xyz' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=xyz/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='xyz' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=xyz/p2=123 +#### A masked pattern was here #### +Beck 0 xyz 123 +Beck 77 xyz 123 +Beck 80 xyz 123 +Cluck 6 xyz 123 +Mary 33 xyz 123 +Mary 4 xyz 123 +Snow 56 xyz 123 +Tom -12 xyz 123 +Tom 19 xyz 123 +Tom 235 xyz 123 +PREHOOK: query: select * from alter_table_cascade where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=abc/p2=123 +#### A masked pattern was here #### +Beck NULL abc 123 +Beck NULL abc 123 +Beck NULL abc 123 +Cluck NULL abc 123 +Mary NULL abc 123 +Mary NULL abc 123 +Snow NULL abc 123 +Tom NULL abc 123 +Tom NULL abc 123 +Tom NULL abc 123 +PREHOOK: query: select * from alter_table_cascade where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77 __HIVE_DEFAULT_PARTITION__ 123 +Beck 80 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 6 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4 __HIVE_DEFAULT_PARTITION__ 123 +Snow 56 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19 __HIVE_DEFAULT_PARTITION__ 123 +Tom 235 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: -- rename c1 to c2fromc1 and move it to after c2, the change should cascaded to all partitions +alter table alter_table_cascade change c1 c2fromc1 string comment "change position after" after c2 cascade +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Output: default@alter_table_cascade +PREHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +PREHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +PREHOOK: Output: default@alter_table_cascade@p1=xyz/p2=123 +POSTHOOK: query: -- rename c1 to c2fromc1 and move it to after c2, the change should cascaded to all partitions +alter table alter_table_cascade change c1 c2fromc1 string comment "change position after" after c2 cascade +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +POSTHOOK: Output: default@alter_table_cascade@p1=xyz/p2=123 +PREHOOK: query: describe alter_table_cascade +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c2 decimal(10,0) change datatype +c2fromc1 string change position after +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='xyz', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='xyz', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c2 decimal(10,0) change datatype +c2fromc1 string change position after +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c2 decimal(10,0) change datatype +c2fromc1 string change position after +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c2 decimal(10,0) change datatype +c2fromc1 string change position after +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: -- rename c2fromc1 back to c1 and move to first as c1, the change should cascaded to all partitions +alter table alter_table_cascade change c2fromc1 c1 string comment "change position first" first cascade +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Output: default@alter_table_cascade +PREHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +PREHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +PREHOOK: Output: default@alter_table_cascade@p1=xyz/p2=123 +POSTHOOK: query: -- rename c2fromc1 back to c1 and move to first as c1, the change should cascaded to all partitions +alter table alter_table_cascade change c2fromc1 c1 string comment "change position first" first cascade +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +POSTHOOK: Output: default@alter_table_cascade@p1=xyz/p2=123 +PREHOOK: query: describe alter_table_cascade +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string change position first +c2 decimal(10,0) change datatype +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='xyz', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='xyz', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string change position first +c2 decimal(10,0) change datatype +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string change position first +c2 decimal(10,0) change datatype +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string change position first +c2 decimal(10,0) change datatype +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: -- Try out replace columns, the change should cascaded to all partitions +alter table alter_table_cascade replace columns (c1 string) cascade +PREHOOK: type: ALTERTABLE_REPLACECOLS +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Output: default@alter_table_cascade +PREHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +PREHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +PREHOOK: Output: default@alter_table_cascade@p1=xyz/p2=123 +POSTHOOK: query: -- Try out replace columns, the change should cascaded to all partitions +alter table alter_table_cascade replace columns (c1 string) cascade +POSTHOOK: type: ALTERTABLE_REPLACECOLS +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +POSTHOOK: Output: default@alter_table_cascade@p1=xyz/p2=123 +PREHOOK: query: describe alter_table_cascade +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='xyz', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='xyz', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: select * from alter_table_cascade where p1='xyz' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=xyz/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='xyz' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=xyz/p2=123 +#### A masked pattern was here #### +Beck xyz 123 +Beck xyz 123 +Beck xyz 123 +Cluck xyz 123 +Mary xyz 123 +Mary xyz 123 +Snow xyz 123 +Tom xyz 123 +Tom xyz 123 +Tom xyz 123 +PREHOOK: query: select * from alter_table_cascade where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=abc/p2=123 +#### A masked pattern was here #### +Beck abc 123 +Beck abc 123 +Beck abc 123 +Cluck abc 123 +Mary abc 123 +Mary abc 123 +Snow abc 123 +Tom abc 123 +Tom abc 123 +Tom abc 123 +PREHOOK: query: select * from alter_table_cascade where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck __HIVE_DEFAULT_PARTITION__ 123 +Beck __HIVE_DEFAULT_PARTITION__ 123 +Beck __HIVE_DEFAULT_PARTITION__ 123 +Cluck __HIVE_DEFAULT_PARTITION__ 123 +Mary __HIVE_DEFAULT_PARTITION__ 123 +Mary __HIVE_DEFAULT_PARTITION__ 123 +Snow __HIVE_DEFAULT_PARTITION__ 123 +Tom __HIVE_DEFAULT_PARTITION__ 123 +Tom __HIVE_DEFAULT_PARTITION__ 123 +Tom __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: -- Try add columns, the change should cascaded to all partitions +alter table alter_table_cascade add columns (c2 decimal(14,4)) cascade +PREHOOK: type: ALTERTABLE_ADDCOLS +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Output: default@alter_table_cascade +PREHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +PREHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +PREHOOK: Output: default@alter_table_cascade@p1=xyz/p2=123 +POSTHOOK: query: -- Try add columns, the change should cascaded to all partitions +alter table alter_table_cascade add columns (c2 decimal(14,4)) cascade +POSTHOOK: type: ALTERTABLE_ADDCOLS +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade +POSTHOOK: Output: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Output: default@alter_table_cascade@p1=abc/p2=123 +POSTHOOK: Output: default@alter_table_cascade@p1=xyz/p2=123 +PREHOOK: query: describe alter_table_cascade +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +c2 decimal(14,4) +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='xyz', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='xyz', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +c2 decimal(14,4) +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +c2 decimal(14,4) +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_cascade +POSTHOOK: query: describe alter_table_cascade partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_cascade +c1 string +c2 decimal(14,4) +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: select * from alter_table_cascade where p1='xyz' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=xyz/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='xyz' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=xyz/p2=123 +#### A masked pattern was here #### +Beck 0 xyz 123 +Beck 77.341 xyz 123 +Beck 79.9 xyz 123 +Cluck 5.96 xyz 123 +Mary 33.33 xyz 123 +Mary 4.329 xyz 123 +Snow 55.71 xyz 123 +Tom -12.25 xyz 123 +Tom 19 xyz 123 +Tom 234.79 xyz 123 +PREHOOK: query: select * from alter_table_cascade where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=abc/p2=123 +#### A masked pattern was here #### +Beck NULL abc 123 +Beck NULL abc 123 +Beck NULL abc 123 +Cluck NULL abc 123 +Mary NULL abc 123 +Mary NULL abc 123 +Snow NULL abc 123 +Tom NULL abc 123 +Tom NULL abc 123 +Tom NULL abc 123 +PREHOOK: query: select * from alter_table_cascade where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_cascade +PREHOOK: Input: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_cascade where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_cascade +POSTHOOK: Input: default@alter_table_cascade@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77.341 __HIVE_DEFAULT_PARTITION__ 123 +Beck 79.9 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 5.96 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33.33 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4.329 __HIVE_DEFAULT_PARTITION__ 123 +Snow 55.71 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12.25 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19 __HIVE_DEFAULT_PARTITION__ 123 +Tom 234.79 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: -- + +drop table if exists alter_table_restrict +PREHOOK: type: DROPTABLE +POSTHOOK: query: -- + +drop table if exists alter_table_restrict +POSTHOOK: type: DROPTABLE +PREHOOK: query: create table alter_table_restrict (c1 string) partitioned by (p1 string, p2 string) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@alter_table_restrict +POSTHOOK: query: create table alter_table_restrict (c1 string) partitioned by (p1 string, p2 string) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@alter_table_restrict +PREHOOK: query: insert overwrite table alter_table_restrict partition (p1, p2) + select c1, 'abc', '123' from alter_table_src + union all + select c1, null, '123' from alter_table_src +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_src +PREHOOK: Output: default@alter_table_restrict +POSTHOOK: query: insert overwrite table alter_table_restrict partition (p1, p2) + select c1, 'abc', '123' from alter_table_src + union all + select c1, null, '123' from alter_table_src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_src +POSTHOOK: Output: default@alter_table_restrict@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Output: default@alter_table_restrict@p1=abc/p2=123 +POSTHOOK: Lineage: alter_table_restrict PARTITION(p1=__HIVE_DEFAULT_PARTITION__,p2=123).c1 EXPRESSION [(alter_table_src)alter_table_src.FieldSchema(name:c1, type:string, comment:null), (alter_table_src)alter_table_src.FieldSchema(name:c1, type:string, comment:null), ] +POSTHOOK: Lineage: alter_table_restrict PARTITION(p1=abc,p2=123).c1 EXPRESSION [(alter_table_src)alter_table_src.FieldSchema(name:c1, type:string, comment:null), (alter_table_src)alter_table_src.FieldSchema(name:c1, type:string, comment:null), ] +PREHOOK: query: show partitions alter_table_restrict +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: show partitions alter_table_restrict +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@alter_table_restrict +p1=__HIVE_DEFAULT_PARTITION__/p2=123 +p1=abc/p2=123 +PREHOOK: query: describe alter_table_restrict +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: select * from alter_table_restrict where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_restrict +PREHOOK: Input: default@alter_table_restrict@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_restrict where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_restrict +POSTHOOK: Input: default@alter_table_restrict@p1=abc/p2=123 +#### A masked pattern was here #### +Beck abc 123 +Beck abc 123 +Beck abc 123 +Cluck abc 123 +Mary abc 123 +Mary abc 123 +Snow abc 123 +Tom abc 123 +Tom abc 123 +Tom abc 123 +PREHOOK: query: select * from alter_table_restrict where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_restrict +PREHOOK: Input: default@alter_table_restrict@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_restrict where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_restrict +POSTHOOK: Input: default@alter_table_restrict@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck __HIVE_DEFAULT_PARTITION__ 123 +Beck __HIVE_DEFAULT_PARTITION__ 123 +Beck __HIVE_DEFAULT_PARTITION__ 123 +Cluck __HIVE_DEFAULT_PARTITION__ 123 +Mary __HIVE_DEFAULT_PARTITION__ 123 +Mary __HIVE_DEFAULT_PARTITION__ 123 +Snow __HIVE_DEFAULT_PARTITION__ 123 +Tom __HIVE_DEFAULT_PARTITION__ 123 +Tom __HIVE_DEFAULT_PARTITION__ 123 +Tom __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: -- add columns c2 by replace columns (for HIVE-6131) without cascade +-- only table column definition has changed, partitions do not +-- after replace, only new partition xyz return the value to new added columns but not existing partitions abc and __HIVE_DEFAULT_PARTITION__ +alter table alter_table_restrict replace columns (c1 string, c2 string) restrict +PREHOOK: type: ALTERTABLE_REPLACECOLS +PREHOOK: Input: default@alter_table_restrict +PREHOOK: Output: default@alter_table_restrict +POSTHOOK: query: -- add columns c2 by replace columns (for HIVE-6131) without cascade +-- only table column definition has changed, partitions do not +-- after replace, only new partition xyz return the value to new added columns but not existing partitions abc and __HIVE_DEFAULT_PARTITION__ +alter table alter_table_restrict replace columns (c1 string, c2 string) restrict +POSTHOOK: type: ALTERTABLE_REPLACECOLS +POSTHOOK: Input: default@alter_table_restrict +POSTHOOK: Output: default@alter_table_restrict +PREHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_table_restrict partition (p1='abc', p2='123') +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@alter_table_restrict@p1=abc/p2=123 +POSTHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_table_restrict partition (p1='abc', p2='123') +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@alter_table_restrict@p1=abc/p2=123 +PREHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_table_restrict partition (p1='__HIVE_DEFAULT_PARTITION__',p2='123') +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@alter_table_restrict@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_table_restrict partition (p1='__HIVE_DEFAULT_PARTITION__',p2='123') +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@alter_table_restrict@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +PREHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_table_restrict partition (p1='xyz', p2='123') +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@alter_table_restrict +POSTHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_table_restrict partition (p1='xyz', p2='123') +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@alter_table_restrict +POSTHOOK: Output: default@alter_table_restrict@p1=xyz/p2=123 +PREHOOK: query: describe alter_table_restrict +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +c2 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='xyz', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='xyz', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +c2 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: select * from alter_table_restrict where p1='xyz' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_restrict +PREHOOK: Input: default@alter_table_restrict@p1=xyz/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_restrict where p1='xyz' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_restrict +POSTHOOK: Input: default@alter_table_restrict@p1=xyz/p2=123 +#### A masked pattern was here #### +Beck 0.0 xyz 123 +Beck 77.341 xyz 123 +Beck 79.9 xyz 123 +Cluck 5.96 xyz 123 +Mary 33.33 xyz 123 +Mary 4.329 xyz 123 +Snow 55.71 xyz 123 +Tom -12.25 xyz 123 +Tom 19.00 xyz 123 +Tom 234.79 xyz 123 +PREHOOK: query: select * from alter_table_restrict where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_restrict +PREHOOK: Input: default@alter_table_restrict@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_restrict where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_restrict +POSTHOOK: Input: default@alter_table_restrict@p1=abc/p2=123 +#### A masked pattern was here #### +Beck NULL abc 123 +Beck NULL abc 123 +Beck NULL abc 123 +Cluck NULL abc 123 +Mary NULL abc 123 +Mary NULL abc 123 +Snow NULL abc 123 +Tom NULL abc 123 +Tom NULL abc 123 +Tom NULL abc 123 +PREHOOK: query: select * from alter_table_restrict where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_table_restrict +PREHOOK: Input: default@alter_table_restrict@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_table_restrict where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_table_restrict +POSTHOOK: Input: default@alter_table_restrict@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck NULL __HIVE_DEFAULT_PARTITION__ 123 +Beck NULL __HIVE_DEFAULT_PARTITION__ 123 +Beck NULL __HIVE_DEFAULT_PARTITION__ 123 +Cluck NULL __HIVE_DEFAULT_PARTITION__ 123 +Mary NULL __HIVE_DEFAULT_PARTITION__ 123 +Mary NULL __HIVE_DEFAULT_PARTITION__ 123 +Snow NULL __HIVE_DEFAULT_PARTITION__ 123 +Tom NULL __HIVE_DEFAULT_PARTITION__ 123 +Tom NULL __HIVE_DEFAULT_PARTITION__ 123 +Tom NULL __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: -- Change c2 to decimal(10,0), only limited to table and new partition +alter table alter_table_restrict change c2 c2 decimal(10,0) restrict +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@alter_table_restrict +PREHOOK: Output: default@alter_table_restrict +POSTHOOK: query: -- Change c2 to decimal(10,0), only limited to table and new partition +alter table alter_table_restrict change c2 c2 decimal(10,0) restrict +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@alter_table_restrict +POSTHOOK: Output: default@alter_table_restrict +PREHOOK: query: describe alter_table_restrict +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +c2 decimal(10,0) +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='xyz', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='xyz', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +c2 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: -- Try out replace columns, only limited to table and new partition +alter table alter_table_restrict replace columns (c1 string) +PREHOOK: type: ALTERTABLE_REPLACECOLS +PREHOOK: Input: default@alter_table_restrict +PREHOOK: Output: default@alter_table_restrict +POSTHOOK: query: -- Try out replace columns, only limited to table and new partition +alter table alter_table_restrict replace columns (c1 string) +POSTHOOK: type: ALTERTABLE_REPLACECOLS +POSTHOOK: Input: default@alter_table_restrict +POSTHOOK: Output: default@alter_table_restrict +PREHOOK: query: describe alter_table_restrict +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='xyz', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='xyz', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +c2 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: -- Try add columns, only limited to table and new partition +alter table alter_table_restrict add columns (c2 decimal(14,4)) +PREHOOK: type: ALTERTABLE_ADDCOLS +PREHOOK: Input: default@alter_table_restrict +PREHOOK: Output: default@alter_table_restrict +POSTHOOK: query: -- Try add columns, only limited to table and new partition +alter table alter_table_restrict add columns (c2 decimal(14,4)) +POSTHOOK: type: ALTERTABLE_ADDCOLS +POSTHOOK: Input: default@alter_table_restrict +POSTHOOK: Output: default@alter_table_restrict +PREHOOK: query: describe alter_table_restrict +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +c2 decimal(14,4) +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='xyz', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='xyz', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +c2 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string +PREHOOK: query: describe alter_table_restrict partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_table_restrict +POSTHOOK: query: describe alter_table_restrict partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_table_restrict +c1 string +p1 string +p2 string + +# Partition Information +# col_name data_type comment + +p1 string +p2 string
