0 votes
It's good now, I can work on Dataiku.
But when I would create a new dataset by creating the table with SQL query, it has an error:

Connection OK, but query failed: Cannot issue data manipulation statements with executeQuery()
related to an answer for: i can not do anything in dataiku
by
edited by

1 Answer

0 votes
Hi Thu,

In a "SQL Query" recipe, you should enter a SELECT query, not an INSERT. DSS will take care on its own to actually transform the SELECT to an INSERT if the output is SQL, or to stream the results if it is not.

You might want to check:
http://doc.dataiku.com/dss/latest//code_recipes/sql.html

Best regards
by
Can not issue data manipulation statements with executeQuery()
1,113 questions
1,156 answers
1,301 comments
11,006 users

©Dataiku 2012-2018 - Privacy Policy