Home Forums Hive / HCatalog Pig to load HCatalog table with ORC File storage

Tagged: , , ,

This topic contains 2 replies, has 2 voices, and was last updated by  Eugene Koifman 4 months ago.

  • Creator
    Topic
  • #54089

    Hi,
    I am trying to figure out a way to load Hive tables using Pig. I have the below questions:
    1. Do I need to create a HCatalog table for PIG to be able to load data or can it load directly to a Hive table
    2. How to create a Hcatalog table with ORC storage. I checked the documentation and HDP1.3 mentions HCatalog can support future Hive storage formats like ORC but i am not able to find references from HDP 2.1

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #54121

    Eugene Koifman
    Participant

    Just create a Hive table and specify storage, then use HCatStorer to have Pig write it it.

    Collapse
    #54094

    I have found a link which mentions that HCatalog works with ORC files but no confirmation anywhere else.

    https://issues.apache.org/jira/browse/HCATALOG-632

    Collapse
Viewing 2 replies - 1 through 2 (of 2 total)