Soop import Mssql Incremental

to create new topics or reply. | New User Registration

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

  • Creator
  • #53904

    MEJANE Nicolas


    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: convert char to datetime error.
    Can I specified to sqoop a datetime format ?

    Here is my command :

    sqoop import –connect ‘jdbc:sqlserver://;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

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

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

  • Author
  • #54701

    Please refer:

    Which talks about the incremental imports.



    Amudhan K

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

Viewing 2 replies - 1 through 2 (of 2 total)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.