如何将SQL数据加载到Hortonworks中？ [英] How to load SQL data into the Hortonworks?

问题描述

我在我的电脑中安装了Hortonworks SandBox。也尝试了一个CSV文件，并且以表格结构的方式获取它的OK（Hive + Hadoop），如果我想将我当前的SQL Databse迁移到沙盒（MS SQL 2008 r2）中，我将如何执行此操作？还想连接到我的项目（VS 2010 C＃）。

是否可以通过ODBC连接？

我听说sqoop用于将数据从SQL传输到Hadoop，所以我如何使用sqoop执行此迁移？ 您可以编写你自己的工作来迁移数据。但Sqoop会更方便。要做到这一点，你必须下载 Sqoop和适当的连接器，用于Apache Hadoop的Microsoft SQL Server连接器。您可以从此处下载它。请通过 Sqoop用户指南。它包含所有信息的细节。

和Hive支持ODBC。您可以在页面上找到更多相关信息。

I have Installed Hortonworks SandBox in my pc. also tried with a CSV file and its getting in a table structerd manner its OK (Hive + Hadoop), nw I want to migrate my current SQL Databse into Sandbox (MS SQL 2008 r2).How I will do this? Also want to connect to my project (VS 2010 C#).

Is it possible to connect through ODBC?

I Heard sqoop is using for transferring data from SQL to Hadoop so how I can do this migration with sqoop?

解决方案

You could write your own job to migrate the data. But Sqoop would be more convenient. To do that you have to download Sqoop and the appropriate connector, Microsoft SQL Server Connector for Apache Hadoop in your case. You can download it from here.Please go through the Sqoop user guide. It contains all the information in proper detail.

And Hive does support ODBC. You can find more on this at this page.

这篇关于如何将SQL数据加载到Hortonworks中？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！