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

Explorer
 
2 REPLIES 2

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

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.