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 Talebzadeh
LinkedIn
/https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw/
http://talebzadehmich.wordpress.com <http://talebzadehmich.wordpress.com/>
On 17 May 2016 at 21:20, mahender bigdata
<mahender.bigd...@outlook.com <mailto:mahender.bigd...@outlook.com>>
wrote:
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, at 15:00, Mich Talebzadeh
<mich.talebza...@gmail.com <mailto:mich.talebza...@gmail.com>> wrote:
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 *, <value_for_new_column) from old_table
ALTER old_table RENAME to old_table_KEEP
RENAME new_table TO ol_table
That should work. Check the syntax.
HTH
Dr Mich Talebzadeh
LinkedIn
/https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw/
http://talebzadehmich.wordpress.com
On 16 May 2016 at 23:53, mahender bigdata
<mahender.bigd...@outlook.com
<mailto:mahender.bigd...@outlook.com>> wrote:
I'm on Hive 1.2
On 5/16/2016 12:02 PM, Matthew McCline wrote:
What version of Hive are you on?
------------------------------------------------------------------------
*From:* Mahender Sarangam <mahender.bigd...@outlook.com>
<mailto:mahender.bigd...@outlook.com>
*Sent:* Saturday, May 14, 2016 3:29 PM
*To:* user@hive.apache.org <mailto:user@hive.apache.org>
*Subject:* Query Failing while querying on ORC Format
Hi,
We are dumping our data into ORC Partition Bucketed table.
We have loaded almost 6 months data and here month is
Partition by column. Now we have modified ORC partition
bucketed table schema. We have added 2 more columns to
the ORC table. Now whenever we are running select statement
for older month which has no columns( even though these
columns are not part in select clause, (projection
column) ), it is throwing exception.
There is JIRA bug for this kind of requirement has already
been raised.
https://issues.apache.org/jira/browse/HIVE-11981
Can any one please tell me know alternative workaround for
reading old previous columns of ORC partition table.
Thanks
