The Hortonworks Community Connection is now live. A completely rebuilt Q&A forum, Knowledge Base, Code Hub and more, backed by the experts in the industry.

You will be redirected here in 10 seconds. If your are not redirected, click here to visit the new site.

The legacy Hortonworks Forum is now closed. You can view a read-only version of the former site by clicking here. The site will be taken offline on January 31,2016

Hive / HCatalog Forum

Load Pig File with Hive

  • #57705

    Hello community,

    I stored the results of a pig job in the file browser as a part-m-0000 file. Then I would like to import this file in a hive table. When I click in the tables tab of hive on “create new table from file” everything goes very easy and straightforward. Then I am able to acces this table in Hive for my Querries. Works perfectly fine. Now i thought this should work with code as well like the following commands:

    CREATE TABLE Source (col1 string, col2 int, col3 int, col4 int)
    LOAD DATA INPATH ‘user/hue/pigresult/part-m-00000’ OVERWRITE INTO TABLE Source;

    Unfortunately it didn’t. The only hint I got is the log file

    Any help would be very welcome.


The forum ‘Hive / HCatalog’ is closed to new topics and replies.

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

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.