You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Mahender Sarangam <Ma...@outlook.com> on 2016/06/13 20:18:15 UTC

ORC does not support type conversion from INT to STRING.

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 know there is Bug raised while reading data from ORC table. Is there any workaround apart from reloading data.

-MS