- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How can I upload ORC files to Hive tables?
- Labels:
-
Apache Hive
Created ‎06-07-2017 09:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
Created ‎06-08-2017 02:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎06-08-2017 02:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
