Support Questions
Find answers, ask questions, and share your expertise

I am facing this problem. Insert into table by load data inpath 'Hdfs://abc/*.csv'. java.lang.Exception: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

Highlighted

I am facing this problem. Insert into table by load data inpath 'Hdfs://abc/*.csv'. java.lang.Exception: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

Explorer
 
2 REPLIES 2
Highlighted

Re: I am facing this problem. Insert into table by load data inpath 'Hdfs://abc/*.csv'. java.lang.Exception: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

Mentor

@anum zareef does this directory have subdirectories? Try without a wildcard also.

load data inpath 'hdfs://abc/'

If you insist on using wildcard, try on the filename part instead on the extension. https://cwiki.apache.org/confluence/display/Hive/Tutorial#Tutorial-LoadingData

Highlighted

Re: I am facing this problem. Insert into table by load data inpath 'Hdfs://abc/*.csv'. java.lang.Exception: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

Hi anum zareef I believe that you are trying to ingest all the files with extension as csv into a hive table in one single which is not possible in hive(atleast as of now). So capture all the file names in a file and read one file name at a time and pass the parameter to hive as file name. I will solve your problem. But hive cannot load multiple files in one single shot using wildcards. But if the folder contains one file it should work fine.

Don't have an account?