hive import from sql server?

[#1]

You can simply use sqoop

[#2]

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

[#3 · Accepted solution]

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.