FAQ
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.

Search Discussions

  • Prasad Chakka at Sep 16, 2009 at 6:06 pm
    Yes, it should.


    ________________________________
    From: Abhijit Pol <apol@rocketfuelinc.com>
    Reply-To: <hive-user@hadoop.apache.org>
    Date: Wed, 16 Sep 2009 11:04:24 -0700
    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.
  • Namit Jain at Sep 16, 2009 at 6:13 pm
    Yes, that should be fine


    From: Abhijit Pol
    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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedSep 16, '09 at 6:04p
activeSep 16, '09 at 6:13p
posts3
users3
websitehive.apache.org

People

Translate

site design / logo © 2021 Grokbase