join 2 tables

2014-11-12 Thread Franco Barrientos 
I have 2 tables in a hive context, and I want to select one field of each
table where id’s of each table are equal. For example,

 

val tmp2=sqlContext.sql(select a.ult_fecha,b.pri_fecha from
fecha_ult_compra_u3m as a, fecha_pri_compra_u3m as b where a.id=b.id)

 

but i get an error:

 



 

Franco Barrientos
Data Scientist

Málaga #115, Of. 1003, Las Condes.
Santiago, Chile.
(+562)-29699649
(+569)-76347893

 mailto:franco.barrien...@exalitica.com franco.barrien...@exalitica.com 

 http://www.exalitica.com/ www.exalitica.com


  http://exalitica.com/web/img/frim.png

Re: join 2 tables

2014-11-12 Thread Rishi Yadav 
please use join syntax.

On Wed, Nov 12, 2014 at 8:57 AM, Franco Barrientos 
franco.barrien...@exalitica.com wrote:

 I have 2 tables in a hive context, and I want to select one field of each
 table where id’s of each table are equal. For example,



 *val tmp2=sqlContext.sql(select a.ult_fecha,b.pri_fecha from
 fecha_ult_compra_u3m as a, fecha_pri_compra_u3m as b where a.id
 http://a.id=b.id http://b.id)*



 but i get an error:





 *Franco Barrientos*
 Data Scientist

 Málaga #115, Of. 1003, Las Condes.
 Santiago, Chile.
 (+562)-29699649
 (+569)-76347893

 franco.barrien...@exalitica.com

 www.exalitica.com

 [image: http://exalitica.com/web/img/frim.png]