Home Forums Sqoop sqoop with postgres

Tagged: 

This topic contains 3 replies, has 3 voices, and was last updated by  Larry Liu 1 year, 3 months ago.

  • Creator
    Topic
  • #26084

    I am trying to import table from postgress db to HDFS and when i try to do it i am getting ERROR : prepared statement “S_1″ already exists, does anyone knows how to fix this,

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

The topic ‘sqoop with postgres’ is closed to new replies.

  • Author
    Replies
  • #26435

    Larry Liu
    Moderator

    Hi, Gnanesh

    Can you please provide the full error log?

    Larry

    Collapse
    #26101

    Yi,

    postgres version is 8.2.15, the command i am using is very simple

    sqoop import –connect xxx –username xxxx –password xxxx –table xxxx

    I checked that link but i have no idea about postgres db, this is the first time i am working on it as its part of Greennplum HD, but i see one suggestion to set below parameter to the jdbc driver

    prepareThreshold=0

    so can i pass the above parameter to the sqoop import statement ?

    Regards
    Gnanesh

    Collapse
    #26100

    Yi Zhang
    Moderator

    Hi Gnanesh,

    What version is postgres? Can you post us the sqoop command you are using?
    This post maybe helpful:

    http://stackoverflow.com/questions/7611926/postgres-error-prepared-statement-s-1-already-exists

    Thanks,
    Yi

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