Look like this is a bug. A JIRA SQOOP-364 is opened for this. Before it's fixed, you may take a look at "--incremental append" option to see if it can be a workaround for you. That option is enhanced to support date/time in SQOOP-321.
On Wed, Oct 12, 2011 at 4:11 PM, Mark Roddy <markro...@gmail.com> wrote: > 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? >
