How can I upload ORC files to Hive tables?

faryad_el9 — Thu, 08 Jun 2017 04:28:20 GMT

Hello,

I am trying to upload an ORC file into a hive table in Visual Studio. However, I keep getting the following error:

"Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask"

Is there a way to actually upload an ORC file using the following SQL?

create database if not exists HIVE_ORC;

CREATE TABLE IF NOT EXISTS HIVE_ORC.test_internal_ORC ( t1 string, t2 string, t3 string, t4 string, t5 string, t6 string, t7 string )

ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'

LOCATION 'wasb:///hadooplinuxcluster-2017-05-31t23-42-02-589z/ORC_Test';

LOAD DATA INPATH './000032_0' INTO TABLE hive_ORC.test_Orc;

Re: How can I upload ORC files to Hive tables?

ssahi — Thu, 08 Jun 2017 09:53:50 GMT

As always if you find this post useful, please "Accept" the answer.