Created 02-03-2017 06:54 AM
Created 02-03-2017 04:13 PM
@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
Created 03-20-2017 07:28 PM
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.