Community Conundrums are live! Learn more

join datasets failure

Level 1
join datasets failure
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)
0 Kudos
2 Replies
Dataiker
Dataiker
Hi Laura,

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

Regards,
0 Kudos
Level 1
Author
Hi Clément,

It's postgres 9.3.10

Regards,
Laura
0 Kudos
Labels (3)