Home Forums Hive / HCatalog Hive External Table

This topic contains 2 replies, has 2 voices, and was last updated by  richa sharma 10 months, 3 weeks ago.

  • Creator
    Topic
  • #26949

    richa sharma
    Member

    I want to load data from table A into an external table B in Hive. Once loaded I want to refer data in table B using Pig for row wise operations.

    Currently once the data is loaded into external table – the actual data file has a name like 00000_0. is there a way I can specify what file name to use so that i could refer that in my Pig code ?

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

You must be logged in to reply to this topic.

  • Author
    Replies
  • #26988

    richa sharma
    Member

    Thanks Ted

    Yes, this is quite helpful. I think I’ll go with sqoop to get the data from Hive.. understood why it doesn’t let us control the file names.

    Thanks again

    Richa

    Collapse
    #26964

    tedr
    Moderator

    Hi Richa,

    Does the information at this post help http://stackoverflow.com/questions/8536066/hive-create-table-filename-000000-0
    ?

    Thanks,
    Ted.

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