BigData – Hadoop, SQOOP

Load data from sql server to hadoop using sqoop …

./sqoop-import –connect ‘jdbc:sqlserver://<db server IP>;databaseName=<db name>;username=<uid>;password=<pwd>;’ –table <table/view name> –hive-import

http://download.1105media.com/tdwi/Webinar/Hadoop-Best-Practices-for-Data-Warehousing-and-Analytics.wmv