Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> joining 2 tables


Copy link to this message
-
joining 2 tables
Hi all ,

I want to join two tables
**

I have table_A:

id1 var1 var2
1   a    b
2   c    d

Table_B:

id2 var3 var4
3   e    f
4   g    h

Expected Output is :

id1 var1 var2 id2 var3 var4
1   a    b     3    e   f
2   c    d     4    g   h
Thanks in advance.
--
--Regards
  Sandeep Nemuri