How to move data from Azure SQL Database To Hive tables?

[Anmolgan81]

Is there any way I can move files from Azure SQL Databases to Hive tables, I know I cannot use ADF here becasue hive is only supported as a source and not sink, any other examples?

---

Detalji dokumenta

⚠ Ne uređujte ovu sekciju. Ona je neophodna za povezivanje problema slijedom docs.microsoft.com ➟ GitHub.

• ID: e90d6fae-e788-1cca-0e11-b7674d34ed2d
• Version Independent ID: cb4d5cde-80f3-2965-6b70-5b1057454cd2
• Content: Extract, transform, and load (ETL) at Scale - Azure HDInsight
• Content Source: articles/hdinsight/hadoop/apache-hadoop-etl-at-scale.md
• Service: hdinsight
• GitHub Login: @ashishthaps
• Microsoft Alias: ashishth

[ChiragMishra-MSFT]

@Anmolgan81 Thanks for reaching out. We are investigating into your query and will respond shortly.

[ChiragMishra-MSFT]

@Anmolgan81 Since the issue is not a feedback on the doc in reference, I would recommend you to create a thread on the forums - MSDN or stack overflow.

Once you post your issue on forums, it will have visibility across the community which is a better suited audience for such types of issues.

Please create a Forum thread and post it's link here and tag me so that we can track that thread. We would love to work with you on the issue on the forums.

I will now proceed to close this issue. Feel free to comment if you have any other queries.

PS - I found a couple of resources that I would like to share to get you unblocked for now :

• You can use ADF to copy data from Azure SQL to Azure blob and then have a hive activity to copy the data into hive tables :

https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/move-hive-tables#load-data

• You can use services like sqoop (https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.3.0/bk_dataintegration/content/using_sqoop_to_move_data_into_hive.html) to directly copy data from a SQL source to Hive tables.