Hello

System: pgsql-9.6 and HDP 2.4
Error on MapReduce:

 *Exception running child : java.lang.RuntimeException: Unexpected
return value from pg_bulkload: 2*

I saw on code: * PostgreSQL connection error *
(https://github.com/ossc-db/pg_bulkload/blob/6f7240eb1438b8dcc58b68667639abc32ed69b03/bin/pgut/pgut.h#L96)

But in a previous Step do "INFO manager.SqlManager: Executing SQL
statement" and its sucessful

 sqoop export \
    -Dmapred.reduce.tasks=1 \
    -Dpgbulkload.bin="/usr/pgsql-9.6/bin/pg_bulkload" \
    -Dpgbulkload.input.field.delim=$'\t' \
    -Dpgbulkload.check.constraints="NO" \
    -Dpgbulkload.parse.errors="INFINITE" \
    -Dpgbulkload.duplicate.errors="INFINITE" \
    --connect jdbc:postgresql://X.X.X.X:5432/postgis_performancetest \
    --connection-manager org.apache.sqoop.manager.PGBulkloadManager \
    --table test \
    --username postgres --password 1234 --export-dir=/user/hdfs/data -m 1\

I tried to launch as root and HDFS user

Reply via email to