Re: ORC does not support type conversion from INT to STRING.

2016-07-19 Thread Mich Talebzadeh
22:31, Matthew McCline >> wrote: >> >>> >>> Hi Mahender, >>> >>> >>> Schema Evolution is available on the latest recent version of Hive. >>> >>> >>> For example, if you set >>> hive.metastore.disallow.inc

Re: ORC does not support type conversion from INT to STRING.

2016-07-19 Thread Mahender Sarangam
older version, then you are out of luck. Thanks, Matt From: Mahender Sarangam mailto:mahender.bigd...@outlook.com>> Sent: Monday, July 18, 2016 1:59 PM To: user@hive.apache.org<mailto:user@hive.apache.org> Subject: Re: ORC does not support type conversion from

Re: ORC does not support type conversion from INT to STRING.

2016-07-19 Thread Mich Talebzadeh
NG conversion. >> >> >> If you need to remain on an older version, then you are out of luck. >> >> >> Thanks, >> >> Matt >> >> >> -- >> *From:* Mahender Sarangam >> *Sent:* Monday, July 18, 20

Re: ORC does not support type conversion from INT to STRING.

2016-07-19 Thread Mahender Sarangam
July 18, 2016 1:59 PM To: user@hive.apache.org<mailto:user@hive.apache.org> Subject: Re: ORC does not support type conversion from INT to STRING. Hi Mich, Sorry for delay in responding. here is the scenario, We have created new cluster and we have moved all ORC File data into new clust

Re: ORC does not support type conversion from INT to STRING.

2016-07-18 Thread Mich Talebzadeh
rsion, then you are out of luck. > > > Thanks, > > Matt > > > -- > *From:* Mahender Sarangam > *Sent:* Monday, July 18, 2016 1:59 PM > *To:* user@hive.apache.org > *Subject:* Re: ORC does not support type conversion from INT to STRING. >

Re: ORC does not support type conversion from INT to STRING.

2016-07-18 Thread Matthew McCline
out of luck. Thanks, Matt From: Mahender Sarangam Sent: Monday, July 18, 2016 1:59 PM To: user@hive.apache.org Subject: Re: ORC does not support type conversion from INT to STRING. Hi Mich, Sorry for delay in responding. here is the scenario, We have created

Re: ORC does not support type conversion from INT to STRING.

2016-07-18 Thread Mahender Sarangam
Hi Mich, Sorry for delay in responding. here is the scenario, We have created new cluster and we have moved all ORC File data into new cluster. We have re-created table pointing to ORC location. We have modified data type of ORC table from INT to String. From then onward, we were unable to fi

Re: ORC does not support type conversion from INT to STRING.

2016-06-14 Thread Mich Talebzadeh
you must excuse my ignorance can you please elaborate on this as there seems something has gone wrong somewhere? Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Re: ORC does not support type conversion from INT to STRING.

2016-06-14 Thread Mahender Sarangam
Yes Mich. We have restored cluster from metastore. On 6/14/2016 11:35 AM, Mich Talebzadeh wrote: Hi Mahendar, Did you load the meta-data DB/schema from backup and now seeing this error Dr Mich Talebzadeh LinkedIn https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOAB

Re: ORC does not support type conversion from INT to STRING.

2016-06-14 Thread Mich Talebzadeh
Hi Mahendar, Did you load the meta-data DB/schema from backup and now seeing this error Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http

Re: ORC does not support type conversion from INT to STRING.

2016-06-14 Thread Mahender Sarangam
ping. On 6/13/2016 1:19 PM, Mahender Sarangam wrote: Hi, We are facing issue while reading data from ORC table. We have created ORC table and dumped data into it. We have deleted cluster due to some reason. When we recreated cluster (using Metastore) and table pointing to same location. When