0 votes
Joining datasets is failing with an error log to say 'Copy thread failed'. My datasets are in postgres and I can see the joined table schema created there (but no data). I tried both visual SQL join and a python join. Both cases are throwing the error below. Does anyone have any suggestions? Thanks.

org.postgresql.util.PSQLException: ERROR: unterminated quoted string at or near "'\'"
  Position: 60
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processCopyResults(QueryExecutorImpl.java:964)
        at org.postgresql.core.v3.QueryExecutorImpl.startCopy(QueryExecutorImpl.java:726)
        at org.postgresql.copy.CopyManager.copyIn(CopyManager.java:54)
        at org.postgresql.copy.CopyManager.copyIn(CopyManager.java:178)
        at org.postgresql.copy.CopyManager.copyIn(CopyManager.java:163)
by

1 Answer

0 votes
Hi Laura,

Is this PostgreSQL 8.X ? DSS only supports PostgreSQL 9.X

Regards,
by
Hi Clément,

It's postgres 9.3.10

Regards,
Laura
1,258 questions
1,287 answers
1,462 comments
11,809 users

©Dataiku 2012-2018 - Privacy Policy