[jira] [Commented] (SQOOP-1244) how to import SQL server Database tables into hadoop sqoop?

["Mohammed Attia (JIRA)" <ji...@apache.org>]

    [ 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)