question Re: hive import from sql server? in Support Questions

hive import from sql server?

omkarmotoe — Fri, 16 Sep 2022 10:15:07 GMT

Re: hive import from sql server?

mgaido — Thu, 21 Apr 2016 21:02:20 GMT

You can simply use sqoop

Re: hive import from sql server?

isoardi — Thu, 21 Apr 2016 21:05:52 GMT

https://community.hortonworks.com/questions/28395/how-to-load-the-data-from-sql-server-to-hdfs-using.html#comment-28450

Re: hive import from sql server?

aubaldi — Thu, 21 Apr 2016 21:29:40 GMT

You need use sqoop for direct import on hive form sql.

First download sql jdbc https://www.microsoft.com/en-us/download/details.aspx?id=11774

place jar on sqoop master server: /usr/hdp/current/sqoop-server/lib

use this command for import:

import --connect jdbc:sqlserver://[SQL_SERVER_NAME]:[SQL_PORT]/[DB-NAME] --username "[SQL_USERNAME]" --password "[PASSWORD]" --query '[INSERT QUERY HERE] WHERE $CONDITIONS' -m 1 --hive-import --hive-database [DB_HIVE] --create-hive-table --hive-table [HIVE_TABLE]

if use --query you must have WHERE $CONDITIONS on query.