close
Warning:
Can't synchronize with repository "(default)" (Unsupported version control system "svn": /usr/lib/python2.7/dist-packages/libsvn/_core.so: failed to map segment from shared object: Cannot allocate memory). Look in the Trac log for more information.
- Timestamp:
-
Dec 1, 2013, 6:03:32 PM (12 years ago)
- Author:
-
jazz
- Comment:
-
--
Legend:
- Unmodified
- Added
- Removed
- Modified
-
|
v3
|
v4
|
|
| 3 | 3 | == import data from MS SQL Server using Sqoop == |
| 4 | 4 | |
| 5 | | * [https://www.facebook.com/notes/james-chang/using-sqoop-to-improt-data-from-microsoft-sql-server-under-cloudera-cdh-440/730480376969050 Using sqoop to improt data from Microsoft SQL Server under Cloudera CDH 4.4.0] |
| 6 | | * [http://www.microsoft.com/zh-tw/download/details.aspx?displaylang=en&id=11774 Microsoft JDBC Driver 4.0 for SQL Server] |
| | 5 | * <參考> [https://www.facebook.com/notes/james-chang/using-sqoop-to-improt-data-from-microsoft-sql-server-under-cloudera-cdh-440/730480376969050 Using sqoop to improt data from Microsoft SQL Server under Cloudera CDH 4.4.0] |
| | 6 | * Step 1 : download Microsoft JDBC Driver 4.0 for SQL Server |
| | 7 | * <來源> [http://www.microsoft.com/zh-tw/download/details.aspx?displaylang=en&id=11774 Microsoft JDBC Driver 4.0 for SQL Server] |
| 7 | 8 | {{{ |
| 8 | 9 | wget http://download.microsoft.com/download/0/9/E/09E1D1A1-79F6-4BC2-969B-406EC77C7277/sqljdbc_4.0.2206.100_cht.tar.gz |
| | 10 | }}} |
| | 11 | * Step 2 : extract the archive file and copy jar files into /usr/lib/sqoop |
| | 12 | {{{ |
| 9 | 13 | unzip sqljdbc*.tar.gz |
| 10 | | }}} |
| 11 | | {{{ |
| 12 | 14 | sudo cp sqljdbc_4.0/cht/*.jar /usr/lib/sqoop/ |
| 13 | 15 | }}} |