Hi,
I have Apache Hive and Apache Hadoop on Amazon EC2 machines. If anyone can
tell me that can HUE be used with this setup instead of CHD Hadoop cluster.
If not, then is there any alternate UI similar to HUE.
Please help.
Thanks,
Chunky.
Souvik,
In your new example, you need a RIGHT OUTER JOIN between table1 and table2
(order matters - table1 on left, table2 on right) on the ID1 column.
Something like this (untested by me):
SELECT
table1.*,
table2.*
FROM
table1
RIGHT OUTER JOIN table2
ON (table1.id=table2.id_1);
Mar
