you must excuse my ignorance can you please elaborate on this as there seems something has gone wrong somewhere?
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:42, Mahender Sarangam <mahender.bigd...@outlook.com> wrote: > 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 > <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.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 >> >> >> >> >> > >
