Re: Would like to be a user

Suresh, you now have write privileges for the Hive wiki. Welcome to the docs team! -- Lefty On Tue, May 17, 2016 at 3:36 PM, Markovitz, Dudu wrote: > Thanks J > > > > *From:* Lefty Leverenz [mailto:leftylever...@gmail.com] > *Sent:* Tuesday, May 17, 2016 10:06 PM > > *To:* user@hive.apache.o

Re: Query Failing while querying on ORC Format

Thanks Mich. On 5/17/2016 1:31 PM, Mich Talebzadeh wrote: I am afraid AFAIK the old partitions cannot be modified as they are fixed in size. That is the existing partition file. I agree this is very tedious. We should come up with a more flexible design for ORC tables. HTH Dr Mich Talebza

Re: Query Failing while querying on ORC Format

I am afraid AFAIK the old partitions cannot be modified as they are fixed in size. That is the existing partition file. I agree this is very tedious. We should come up with a more flexible design for ORC tables. HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAA

Re: Query Failing while querying on ORC Format

Hi Jorn, You mean to say try to add additional columns for the old partitions where column are missing ? On 5/17/2016 7:25 AM, Jörn Franke wrote: I do not remember exactly, but I think it worked simply by adding a new partition to the old table with the additional columns. On 17 May 2016,

RE: Would like to be a user

Thanks ☺ From: Lefty Leverenz [mailto:leftylever...@gmail.com] Sent: Tuesday, May 17, 2016 10:06 PM To: user@hive.apache.org Subject: Re: Would like to be a user Done. Welcome to the Hive wiki team, Dudu! -- Lefty On Tue, May 17, 2016 at 3:04 AM, Markovitz, Dudu mailto:dmarkov...@paypal.com>

Re: Would like to be a user

Done. Welcome to the Hive wiki team, Dudu! -- Lefty On Tue, May 17, 2016 at 3:04 AM, Markovitz, Dudu wrote: > Hi Lefty > > > > Can you add me as well? > > My user is dudu.markovitz > > > > Thanks > > > > Dudu > > > > *From:* Lefty Leverenz [mailto:leftylever...@gmail.com] > *Sent:* Monday, Ma

Re: Query Failing while querying on ORC Format

Thanks Mich. Reloading will always be there. My only worry point is, we need to move 10 years of data and just looking for workaround without reloading. /Mahender On 5/17/2016 6:00 AM, Mich Talebzadeh wrote: Hi Mahendar, That version 1.2 is reasonable. One alternative is to create a new t

Re: Query Failing while querying on ORC Format

I do not remember exactly, but I think it worked simply by adding a new partition to the old table with the additional columns. > On 17 May 2016, at 15:00, Mich Talebzadeh wrote: > > Hi Mahendar, > > That version 1.2 is reasonable. > > One alternative is to create a new table (new_table) in H

Re: Query Failing while querying on ORC Format

Hi Mahendar, That version 1.2 is reasonable. One alternative is to create a new table (new_table) in Hive with columns from old_table plus the added column new_column as ORC etc Do an INSERT/SELECT from old_table to new_table INSERT INTO new_table SELECT *, https://www.linkedin.com/profile/view

RE: Would like to be a user

Hi Lefty Can you add me as well? My user is dudu.markovitz Thanks Dudu From: Lefty Leverenz [mailto:leftylever...@gmail.com] Sent: Monday, May 16, 2016 11:44 PM To: user@hive.apache.org Subject: Re: Would like to be a user Welcome Gail, I've given you write access to the Hive wiki. Thanks in