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.bigd...@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 > > > > >
