Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB