Re: Query Failing while querying on ORC Format

gd...@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 load

Re: Query Failing while querying on ORC Format

m > > > > On 16 May 2016 at 23:53, mahender bigdata > wrote: > >> I'm on Hive 1.2 >> >> On 5/16/2016 12:02 PM, Matthew McCline wrote: >> >> ​ >> >> What version of Hive are you on? >> >> >> -- &

Re: Query Failing while querying on ORC Format

om> *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 i

Re: Query Failing while querying on ORC Format

f Hive are you on? *From:* Mahender Sarangam <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

Re: Query Failing while querying on ORC Format

r bigdata >> 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 >>> Sent: Saturday, May 14, 2016 3:29 PM >>>

Re: Query Failing while querying on ORC Format

atthew McCline wrote: > > ​ > > What version of Hive are you on? > > > -- > *From:* Mahender Sarangam > > *Sent:* Saturday, May 14, 2016 3:29 PM > *To:* user@hive.apache.org > *Subject:* Query Failing while querying on ORC Format > > Hi, &

Re: Query Failing while querying on ORC Format

iling 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 ru

Re: Query Failing while querying on ORC Format

http://talebzadehmich.wordpress.com On 16 May 2016 at 20:02, Matthew McCline wrote: > ​ > > What version of Hive are you on? > > > -- > *From:* Mahender Sarangam > *Sent:* Saturday, May 14, 2016 3:29 PM > *To:* user@hive.apache.org > *Subjec

Re: Query Failing while querying on ORC Format

? What version of Hive are you on? From: Mahender Sarangam Sent: Saturday, May 14, 2016 3:29 PM To: 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

Re: Query Failing while querying on ORC Format

Hi Mich, sorry. Link is not pointing to right location. On 5/15/2016 1:25 PM, Mich Talebzadeh wrote: Hi Mahender, Please check this thread https://mail.google.com/mail/#search/alter+table+add+columns+aternatives+or+hive+refresh/153fe59e7c2970b2 HTH Dr Mich Talebzadeh LinkedIn /https://w

Re: Query Failing while querying on ORC Format

For Temporary, I'm disabling vectorization on ORC table. then it is working. On 5/15/2016 3:38 PM, mahender bigdata wrote: here is the error message https://issues.apache.org/jira/browse/HIVE-10598 Error: java.lang.RuntimeException: Error creating a batch at org.apache.hadoop.hive.ql.io.or

Re: Query Failing while querying on ORC Format

here is the error message https://issues.apache.org/jira/browse/HIVE-10598 Error: java.lang.RuntimeException: Error creating a batch at org.apache.hadoop.hive.ql.io.orc.VectorizedOrcInputFormat$VectorizedOrcRecordReader.createValue(VectorizedOrcInputFormat.java:114) at org.apache.hadoop.hive.

Re: Query Failing while querying on ORC Format

here is the error message Error: java.lang.RuntimeException: Error creating a batch at org.apache.hadoop.hive.ql.io.orc.VectorizedOrcInputFormat$VectorizedOrcRecordReader.createValue(VectorizedOrcInputFormat.java:114) at org.apache.hadoop.hive.ql.io.orc.VectorizedOrcInputFormat$VectorizedOrcR

Re: Query Failing while querying on ORC Format

Hi Mahender, Please check this thread https://mail.google.com/mail/#search/alter+table+add+columns+aternatives+or+hive+refresh/153fe59e7c2970b2 HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Re: Query Failing while querying on ORC Format

Hi Mich, Is there any link missing ?. We have already added column. Some how the old partition data with new column is not failing to retrieving. /mahens On 5/14/2016 4:15 PM, Mich Talebzadeh wrote: that night help

Re: Query Failing while querying on ORC Format

check this thread. alter table add columns aternatives or hive refresh that night help HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * ht

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 olde