New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

Cannot issue data manipulation statements with executeQuery()

UserBird
Dataiker
Dataiker
Cannot issue data manipulation statements with executeQuery()
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()
0 Kudos
1 Reply
Clément_Stenac
Dataiker
Dataiker
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
0 Kudos
Labels (3)
A banner prompting to get Dataiku DSS