Home Forums Sqoop Soop import Mssql Incremental

This topic contains 2 replies, has 3 voices, and was last updated by  Mahesh Balakrishnan 4 months, 4 weeks ago.

  • Creator
    Topic
  • #53904

    MEJANE Nicolas
    Participant

    Hello,

    I get a error when I am trying to import from mssql with sqoop. I do a incremental import with lastmodified option on a datetime filed.
    I get : Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: convert char to datetime error.
    Can I specified to sqoop a datetime format ?

    Here is my command :

    sqoop import –connect ‘jdbc:sqlserver://172.16.0.40;databasename=XXX;username=XXX;password=XXX’ –table ‘tablename’ –hbase-table Table –column-family OFE –hbase-row-key CODE_ROW –incremental lastmodified –check-column DATE_COLUMN –last-value

    Thank for your help
    Nicolas

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Soop import Mssql Incremental’ is closed to new replies.

  • Author
    Replies
  • #54701

    Please refer: http://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html#_incremental_imports

    Which talks about the incremental imports.

    -Mahesh

    Collapse
    #54256

    Amudhan K
    Participant

    Hello MEJANE Nicolas,
    Change the –incremental to –incremental append. then it will work, there is no such thing in sqoop as incremental.

    Collapse
Viewing 2 replies - 1 through 2 (of 2 total)