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:35:19 GMT
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



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