Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> ALTER TABLE CHANGE COLUMN issue

Copy link to this message

I am running into an issue where ALTER TABLE CHANGE COLUMN does not seem to be working.

I have a table with a column data type looking like array<struct<a:int, b:int>> and I am trying to it change to array<struct<a:int, b:int, c:string>> based
on the underlying data schema change.
The alter command succeeds and subsequent describe call shows me the updated table structure. But when tried querying the table,
it returns null for the newly added field.

This does not happen when a new table with updated column data type is created.

Is this a known bug?


PS:- My alter command: ALTER TABLE hardiktest CHANGE COLUMN col1 col2 array<struct<a:int, b:int, c:string>>.
Nitin Pawar 2013-01-30, 08:17
Dean Wampler 2013-01-30, 13:51
hardik doshi 2013-01-30, 19:12
Mark Grover 2013-01-30, 19:32
Nitin Pawar 2013-01-30, 19:37