Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-11091

Unable to load data into hive table using "Load data local inapth" command from unix named pipe

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • 0.14.0
    • None
    • Hive
    • None
    • Unix,MacOS

    Description

      Unable to load data into hive table from unix named pipe in Hive 0.14.0

      Please find below the execution details in env ( Hadoop2.6.0 + Hive 0.14.0):
      ----------------------------------------------------------------------------------------------------
      $ mkfifo /tmp/test.txt
      $ hive
      hive> create table test(id bigint,name string);
      OK
      Time taken: 1.018 seconds
      hive> LOAD DATA LOCAL INPATH '/tmp/test.txt' OVERWRITE INTO TABLE test;
      Loading data to table default.test
      Failed with exception addFiles: filesystem error in check phase
      FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

      But in Hadoop 1.3 and hive 0.11.0 it works fine:
      hive> LOAD DATA LOCAL INPATH '/tmp/test.txt' OVERWRITE INTO TABLE test;
      Copying data from file:/tmp/test.txt
      Copying file: file:/tmp/test.txt

      Attachments

        Activity

          People

            Delios Alexandros
            manoranjan Manoranjan Sahoo
            Votes:
            2 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated: