Invalid number of columns in query while writing to a dataset

Options
jvijayakumar2
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!

Capture.PNGCapture.PNG

Answers

  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 Dataiker
    Options

    Hi @jvijayakumar2

    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
    jvijayakumar2 Partner, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 30 Partner
    Options

    Thanks for your reply! The schema seems to be good but the error wouldn't go away.

Setup Info
    Tags
      Help me…