Error: Invalid number of columns in query
sdelobel
Registered Posts: 3 ✭✭✭✭
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 ?
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 ?
Tagged:
Best Answer
-
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 buttonNow, you can use your dataset after you push CREATE button
Answers
-
Hi,
Can you try the following: go to your table, then Settings -> Schema -> Reload schema from table
Cheers,
Du Phan
-
Thanks it's works now
-
Thanks, this was of great help
-
Herve Partner, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 58 PartnerI 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 ?
