Sqoop: 1.3.0-cdh3u1
Postgres Server: 8.4.7
Command I'm running:
sqoop import --connect "jdbc:postgresql://..." --num-mappers 4 --table
listings --target-dir listings --columns some,set,of,columns
--incremental lastmodified --check-column last_modified_tsz
--last-value '2011-10-11 00:00:00.000000+00'
Error:
11/10/12 23:09:14 WARN manager.SqlManager: SQL exception accessing
current timestamp: org.postgresql.util.PSQLException: ERROR: syntax
error at or near ")"
11/10/12 23:09:14 ERROR tool.ImportTool: Encountered IOException
running import job: java.io.IOException: Could not get current time
from database
at
com.cloudera.sqoop.tool.ImportTool.initIncrementalConstraints(ImportTool.java:241)
at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:345)
at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)
Has anyone run into this before?
