RES: RES: Join error with ORC Hive tables

2014-10-03 Thread Thiago Henrique dos Santos Bento
santh Jayachandran [mailto:pjayachand...@hortonworks.com] Enviada em: Thursday, October 2, 2014 4:53 PM Para: user@hive.apache.org Assunto: Re: RES: Join error with ORC Hive tables Caused by: java.io.IOException: Malformed ORC file hdfs://arnaldo01:8020/apps/hive/warehouse/mds.db/ds_customer_qg/p

Re: RES: Join error with ORC Hive tables

2014-10-02 Thread Prasanth Jayachandran
, t1.ID_TP_SEXO > , t1.DT_CRIACAO_CARGA > , t1.DT_LAST_CARGA > -- > FROM ds_customer_qg t1 > join ds_customer_qg t2 > on t1.COD_CLIENTE = t2.COD_CLIENTE > > > > > D

RES: Join error with ORC Hive tables

2014-10-02 Thread Thiago Henrique dos Santos Bento
on t1.COD_CLIENTE = t2.COD_CLIENTE De: Prasanth Jayachandran [mailto:pjayachand...@hortonworks.com] Enviada em: Wednesday, October 1, 2014 3:24 PM Para: user@hive.apache.org Assunto: Re: Join error with ORC Hive tables Hi Can you post the exception stacktrace from hadoop execution

Re: Join error with ORC Hive tables

2014-10-01 Thread Nagarjuna Vissarapu
Set -m flag to 1 programmatically On Oct 1, 2014 8:13 PM, "Thiago Henrique dos Santos Bento" < thiago.be...@b2wdigital.com> wrote: > Hi! > > > > I'm trying to run a simple join with two tables stored as ORC File. (the > same query runs normally without ORC File) > > I got this error while map-red

Re: Join error with ORC Hive tables

2014-10-01 Thread Prasanth Jayachandran
Hi Can you post the exception stacktrace from hadoop execution logs? What version of hive are you using? Can you provide the join query that you are using? Thanks Prasanth Jayachandran On Oct 1, 2014, at 7:41 AM, Thiago Henrique dos Santos Bento wrote: > Hi! > > I’m trying to run a simple

Join error with ORC Hive tables

2014-10-01 Thread Thiago Henrique dos Santos Bento
Hi! I'm trying to run a simple join with two tables stored as ORC File. (the same query runs normally without ORC File) I got this error while map-reduce job: Driver returned: 2. Errors: OK Query ID = hue_20141001071313_33e31d68-3b4a-49d5-acc0-30c0a42276ab Total jobs = 1 Stage-1 is selected by c