You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Abhijit Pol <ap...@rocketfuelinc.com> on 2009/09/16 20:04:24 UTC

hive queries over tables in different formats

does hive support queries over multiple tables stored in different formats?
for example tableA is stroed as TEXTFILE and table B is stored as
SEQUENCEFILE and query has tableA join tableB.

RE: hive queries over tables in different formats

Posted by Namit Jain <nj...@facebook.com>.

Yes, that should be fine

From: Abhijit Pol [mailto:apol@rocketfuelinc.com]
Sent: Wednesday, September 16, 2009 11:04 AM
To: hive-user@hadoop.apache.org
Subject: hive queries over tables in different formats

does hive support queries over multiple tables stored in different formats? for example tableA is stroed as TEXTFILE and table B is stored as SEQUENCEFILE and query has tableA join tableB.

Re: hive queries over tables in different formats

Posted by Prasad Chakka <pc...@facebook.com>.

Yes, it should.

________________________________
From: Abhijit Pol <ap...@rocketfuelinc.com>
Reply-To: <hi...@hadoop.apache.org>
Date: Wed, 16 Sep 2009 11:04:24 -0700
To: <hi...@hadoop.apache.org>
Subject: hive queries over tables in different formats

does hive support queries over multiple tables stored in different formats? for example tableA is stroed as TEXTFILE and table B is stored as SEQUENCEFILE and query has tableA join tableB.