hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mahender Sarangam <Mahender.BigD...@outlook.com>
Subject Re: ORC does not support type conversion from INT to STRING.
Date Tue, 14 Jun 2016 18:42:08 GMT
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



<http://talebzadehmich.wordpress.com/>http://talebzadehmich.wordpress.com



On 14 June 2016 at 19:04, Mahender Sarangam <Mahender.BigData@outlook.com<mailto: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