Sqoop Forum

sqoop with postgres

  • #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,

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #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

    #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

    #26435
    Larry Liu
    Moderator

    Hi, Gnanesh

    Can you please provide the full error log?

    Larry

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

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

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.