[
https://issues.apache.org/jira/browse/SQOOP-1244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13833921#comment-13833921
]
Mohammed Attia commented on SQOOP-1244:
---------------------------------------
i have these unix CMD's only and it does not work correctly in the last command
>su – root --pw:- hadoop
> cd /usr/lib/sqoop
> wget
> http://download.microsoft.com/download/0/2/A/02AAE597-3865-456C-AE7F-613F99F850A8/sqljdbc_4.0.2206.100_enu.tar.gz
> gunzip sqljdbc_4.0.2206.100_enu.tar.gz
> tar –xvf sqljdbc_4.0.2206.100_enu.tar
> cp sqljdbc_4.0/enu/*.jar /usr/lib/sqoop/lib
> sqoop import –connect
> “jdbc:sqlserver://192.168.25.1:1433;databasename=mssqldatabase;” –table
> mytable –username sqluseraccount –password mypwd –hive-import
> how to import SQL server Database tables into hadoop sqoop?
> -----------------------------------------------------------
>
> Key: SQOOP-1244
> URL: https://issues.apache.org/jira/browse/SQOOP-1244
> Project: Sqoop
> Issue Type: Task
> Components: connectors/sqlserver, docs
> Affects Versions: 1.3.0, 2.0.0
> Environment: Hortonworks sandbox hadoop 2.0 and MS SQL server 2008
> Reporter: Mohammed Attia
> Priority: Critical
> Labels: AttiaImport
> Fix For: 1.3.0, 2.0.0
>
> Original Estimate: 1h
> Remaining Estimate: 1h
>
> how to import SQL server Database tables into hadoop sqoop?
> Hortonworks sandbox hadoop 2.0 and MS SQL server 2008
--
This message was sent by Atlassian JIRA
(v6.1#6144)
