want to export hive table data to sqlserver

ishvari · ‎05-04-2017

I have created HDInsight cluster on azure. I want to export hive table to SQL Server in Azure. For this I have created job in .Net SDK. The code is as follows: I am not able to load data to the SQL Server table using this code.

ishvari · ‎05-02-2017

For submit Hive, Pig job in Azure HDInsight, I am using .Net SDK. After successfully output of Pig Job ,I used Pig output file to load into Hive table. Hive job executed successfully but Pig output is in BAG format , so its store data in Hive table like "(" , ")" characters. Means First and Last column of Hive table having these characters. I want to remove this characters from Hive table. Should I have to change the Pig output format or Is this anyway to remove above character from Hive Table ? Please give solution. Thank You.

ishvari · ‎04-26-2017

Thanks for reply. It will really help me. By mistake I wrote MapReduce Job, I should have to use HiveJob, PigJob, SqoopJob. Thanks again. I just go through Oozie. I didn't find exact Link for Oozie. If I write a Pig script and than want to transfer those data in Hive. Then using Sqoop, export this data to SQL Server. How to connect all these process using Oozie. Can you provide some reference Link?

ishvari · ‎04-26-2017

I have data in HDFS(Azure HDInsight) in csv format. I am using Pig to process this Data. After processing the Summarise data will be stored in Hive. And then Hive table is exported in RDBMS using Sqoop. Now I need to automate all this process. Is this possible that I will write particular method for all these 3 task in MapReduce, then run this MapReduce job, and all these task execute one by one. For create MapReduce job , I want to use .Net SDK. So my question is this possible, and if YES than suggest some steps and reference link for this Question. Thank You.

ishvari · ‎04-18-2017

Thanks for Reply. I was thinking like this, but confused. Now its clear. Thanks again.

ishvari · ‎04-17-2017

In Capacity Scheduler, How Resource Manage decide which Job runs on which Queue?

Online	Offline
Last Visited	‎05-05-2017 11:11 AM

Date Registered	‎03-31-2017 01:40 PM
Last Visited	‎05-05-2017 11:11 AM
Total Messages Posted	8
Total Kudos Received	1

want to export hive table data to sqlserver

Load Hive Table form Pig Output File.

Re: Automate the process of Pig, Hive, Sqoop.

Automate the process of Pig, Hive, Sqoop.

Re: Yarn Scheduling Management, Capacity Scheduler

Yarn Scheduling Management, Capacity Scheduler