ORC does not support type conversion from INT to STRING.

[Mahender Sarangam]

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