Problems joining tables
larispardo
Registered Posts: 28 ✭✭✭✭✭
Hi, while doing a normal join on one table I run into this error "in act.compute_Base_Modelos_1_1_1_NP: Column name can not contain comma, quotation mark, leading or trailing white spaces with DSS engine (when using H2)." the problem is, even when I just use non coma, qm, and space columns to get the output I get the same error. Also this two tables come from other joins which is weird for me to be receiving this error until now. Is there an easy way to resolve this?
Tagged:
Answers
-
Was this ever resolved? I am having the same issue.
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,399 Dataiker@cullimk
Could please open a support ticket with the job diagnostics from this and submit a support ticket?
https://doc.dataiku.com/dss/latest/troubleshooting/problems/job-fails.html#getting-a-job-diagnosis
If you have the option to use another engine .eg Spark you can try that well to see if the join works.
Thanks -
Some experimentation reveals that the problem I had is a result of having columns that are arrays on the input datasets (even changing the storage or meaning did not help), even if you do not include them in the join output. Once eliminated and/or transformed the arrays in a prep step prior to the join, the join worked. Thanks for the speedy reply!
