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
