Member since
04-12-2022
1
Post
0
Kudos Received
0
Solutions
04-12-2022
10:30 AM
Hi all, I would like to execute "INSERT OVERWRITE" from managed table to Hive Transaction Table which is EMRFS. What I tried was to first create managed table with s3 location (CSV), and executed the following: INSERT OVERWRITE TABLE tobe_tbl SELECT * FROM asis_tbl LIMIT 10; but I got error as below: ... Total jobs = 1 Launching Job 1 out of 1 FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask ... I noticed that there was an error saying it is writing in Avro not ORC. What commands or configurations could I make to properly INSERT OVERWRITE to Hive Transaction Table?
... View more
Labels:
- Labels:
-
Apache Hive