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]
>
>
>
