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
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
LOAD DATA INPATH './000032_0' INTO TABLE hive_ORC.test_Orc;
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