Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Load Data in Hive Table using .Net SDK

Highlighted

Load Data in Hive Table using .Net SDK

New Contributor

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?
Coming from Hortonworks? Activate your account here