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

Load Data in Hive Table using .Net SDK

Load Data in Hive Table using .Net SDK

Explorer

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:

hivejob.txt

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.

Thank you.

Don't have an account?