Error: Invalid number of columns in query

Solved!
sdelobel
Level 2
Error: Invalid number of columns in query
Hi,

After create my connection with sucess to my postgresql database.

I've the following error when I import my table in my project :

An invalid argument has been encountered : Invalid number of columns in query (2, expected 0) SELECT * FROM "public"."ape_ref" LIMIT 10000. Please check dataset schema

Could you explain me the reason of this error ?
0 Kudos
1 Solution
sdelobel
Level 2
Author

If you create a new dataset (postgresql in my case) with just filling fields and click on CREATE button





The error "Invalid number of columns in query" appear





The reason of the problem is your dataiku schema is empty.





To correct this one, click on CHECK DATA button and RELOAD SCHEMA USING DETECTED DATA button





Now, you can use your dataset after you push CREATE button ๐Ÿ™‚

View solution in original post

0 Kudos
5 Replies
UserBird
Dataiker

Hi,



Can you try the following: go to your table, then Settings -> Schema -> Reload schema from table





Cheers,



Du Phan

0 Kudos
sdelobel
Level 2
Author
Thanks it's works now
0 Kudos
sdelobel
Level 2
Author

If you create a new dataset (postgresql in my case) with just filling fields and click on CREATE button





The error "Invalid number of columns in query" appear





The reason of the problem is your dataiku schema is empty.





To correct this one, click on CHECK DATA button and RELOAD SCHEMA USING DETECTED DATA button





Now, you can use your dataset after you push CREATE button ๐Ÿ™‚

0 Kudos
alankritasinha
Level 1

Thanks, this was of great help

Herve
Level 4

I have the same issue using Dataiku DSS Version 8.0.5

But I don't see a CHECK DATA nor a RELOAD SCHEMA USING DETECTED DATA buttons in the Schema tab of my Postgre dataset (Settings)

Any help please ?

0 Kudos