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

[#1]

@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

[#2]

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.