Support Questions

Find answers, ask questions, and share your expertise

How can I upload ORC files to Hive tables?

avatar
New Contributor

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;

1 ACCEPTED SOLUTION

avatar
Guru

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.

View solution in original post

1 REPLY 1

avatar
Guru

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.