spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Franco Barrientos" <franco.barrien...@exalitica.com>
Subject join 2 tables
Date Wed, 12 Nov 2014 16:57:59 GMT
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.barrientos@exalitica.com> franco.barrientos@exalitica.com 

 <http://www.exalitica.com/> www.exalitica.com


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

 


Mime
View raw message