I am using Azure HDInsight. For submitting Hive Job, I use .Net SDK. I have a csv file in HDFS(Blob Storage) that I want to load in Hive table. The csv file is at "/HiveStoreOP/2007_10" location of HDFS. And Hive table is of name "flights12" and storing O/P in "HiveStoreOP/output123". I am using code that given Attached file:
I have tried to load file in Hive table using different location, like in creating new database and currently using default database of Hive.
LOAD DATA INPATH '/HiveStoreOP/2007_10' INTO TABLE default.flights12;
LOAD DATA INPATH 'wasb:///HiveStoreOP/2007_10' INTO TABLE default.flights12;
LOAD DATA INPATH 'wasbs:///HiveStoreOP/2007_10' INTO TABLE default.flights12;
LOAD DATA INPATH 'https://hdpstoragesa.blob.core.windows.net/container-hdpcluster/HiveStoreOP/2007_10.csv' INTO TABLE default.flights12;
hdpstoragesa is a storage account name and container-hdpcluster is a container created in azure.
but still it didn't work.
Please suggest Solution.