Thank you for replying. You are right, I just have to set these guys in:
set hive.strict.checks.cartesian.product=false;
set hive.mapred.mode=nonstrict;
*From: *Furcy Pin
*Date: *Tuesday, August 7, 2018 at 2:25 AM
*To: *Sowjanya Kakarala
*Subject: *[EXT] Re: Subqueries two tables to one
Hi Everyone,
I am trying to insert data from 2tables to one table as separate columns.
Example:
Table1 as A:
Id
Data
time_stamp
1
0.1
2018-01-01
2
0.2
2018-01-01
3
0.3
2018-01-02
Table2 as B
Id
Data
time_stamp
1
1.1
2018-01-01
2
2.2
2018-01-01
3
1.3
2018-01-02
Now I
