Re: Adding a new column to a table and updating it

2015-12-11 Thread Eugene Koifman
rg>> Date: Friday, December 11, 2015 at 3:07 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: RE: Adding a new column to a table and updating it Thanks Eugene So basically as I understand when a column can be added to an

RE: Adding a new column to a table and updating it

2015-12-11 Thread Mich Talebzadeh
er@hive.apache.org <mailto:user@hive.apache.org> " mailto:user@hive.apache.org> > Date: Friday, December 11, 2015 at 12:56 AM To: "user@hive.apache.org <mailto:user@hive.apache.org> " mailto:user@hive.apache.org> > Subject: Adding a new column to a table and updat

Re: Adding a new column to a table and updating it

2015-12-11 Thread Eugene Koifman
> Date: Friday, December 11, 2015 at 12:56 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: Adding a new column to a table and updating it I can use Hive to add a new column to an existing table (it is an ORC transactional tab

Adding a new column to a table and updating it

2015-12-11 Thread Mich Talebzadeh
I can use Hive to add a new column to an existing table (it is an ORC transactional table) with data in it. Example: hive> alter table t add columns (new_col varchar(30)); OK Now that column is created with NULL value. The operation is fast as the DDL in metadata is altered. Howeve