join datasets failure

laura
laura Registered Posts: 2 ✭✭✭✭
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)

Answers

Setup Info
    Tags
      Help me…