Invalid number of columns in query while writing to a dataset
jvijayakumar2
Partner, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 30 Partner
I get the following error while trying to run a recipe that writes to a newly created dataset. Please help!
Answers
-
Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 Dataiker
Quite often, prepare recipes change dataset schema (adding/removing columns). In all such cases when you run the recipe, DSS will ask you if you want to accept schema changes. When you do this, the output dataset will have the correct number and types of columns. If you do not do this, you will get an error like you shown on the screenshot.
You can try navigating to the output dataset->Settings->Schema and hit "Check now". You should see a message to accept new schema.
-
jvijayakumar2 Partner, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 30 Partner
Thanks for your reply! The schema seems to be good but the error wouldn't go away.