How can I upload ORC files to Hive tables?

[#1]

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;

[#2 · Accepted solution]

Hi @Ali Mahinpoor

See this post that might help: https://community.hortonworks.com/questions/47594/how-can-i-upload-ocr-files-to-hive.html

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