hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: ORC does not support type conversion from INT to STRING.
Date Tue, 14 Jun 2016 18:47:31 GMT
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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*



http://talebzadehmich.wordpress.com



On 14 June 2016 at 19:42, Mahender Sarangam <Mahender.BigData@outlook.com>
wrote:

> 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=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> <http://talebzadehmich.wordpress.com/>http://talebzadehmich.wordpress.com
>
>
>
> On 14 June 2016 at 19:04, Mahender Sarangam <Mahender.BigData@outlook.com>
> wrote:
>
>> 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 we perform reading from ORC table. We see below error.
>>
>> SELECT col2, Col1,
>>   reflect("java.util.UUID", "randomUUID") AS ID,
>>   Source,
>>  1     ,
>> SDate,
>> EDate
>> FROM Table ORC  JOIN Table2 _surr;
>>
>> ERROR : Vertex failed, vertexName=Map 1,
>> vertexId=vertex_1465411930667_0212_1_01, diagnostics=[Task failed,
>> taskId=task_1465411930667_0212_1_01_000000, diagnostics=[TaskAttempt 0
>> failed, info=[Error: Failure while running task:java.lang.RuntimeException:
>> java.lang.RuntimeException: java.io.IOException: java.io.IOException: ORC
>> does not support type conversion from INT to STRING.
>>
>>
>> I think issue is reflect("java.util.UUID", "randomUUID") AS ID
>>
>>
>> I know there is Bug raised while reading data from ORC table. Is there
>> any workaround apart from reloading data.
>>
>> -MS
>>
>>
>>
>>
>>
>
>

Mime
View raw message