Table Creation – And Data Load

to create new topics or reply. | New User Registration

Tagged: , ,

This topic contains 1 reply, has 2 voices, and was last updated by  Yi Zhang 1 year, 5 months ago.

  • Creator
    Topic
  • #48731

    Kumar Mayuresh
    Participant

    Hello Community,

    I am facing a problem while data load using HIVE. I am using a Json file to load data using hive, when the data is loaded all the fields from the file gets loaded into single field in the table.

    For eg: Suppose the json file is having Field 1 and Field 2 with data in Field 1 = A and Field 2 = B, instead of getting loaded in their respective fields in table the data gets loaded in FIELD 1 only.

    Please suggest the possible way of correcting the same.

    Awaiting response.

    Regards
    Kumar Mayuresh.

Viewing 1 replies (of 1 total)

You must be to reply to this topic. | Create Account

  • Author
    Replies
  • #49027

    Yi Zhang
    Moderator

    Hi Kumar,

    Can you check if the serde defined for the table an parse the json data properly?

    Thanks,
    Yi

    Collapse
Viewing 1 replies (of 1 total)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.