You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "xavier-GitHub76 (via GitHub)" <gi...@apache.org> on 2023/10/18 12:07:01 UTC

[I] Error message: data type 'integer' not understood [superset]

xavier-GitHub76 opened a new issue, #25690:
URL: https://github.com/apache/superset/issues/25690

   With supserset v3.0.0, I want to upload csv file with Column Data Types setted (on "COM" column)
   
   On the screen, the help message is : 
   A dictionary with column names and their data types if you need to change the defaults. Example: {"user_id":"integer"}
   
   but with {"COM":"integer"}, I have the error message "data type 'integer' not understood"
   ![image](https://github.com/apache/superset/assets/82046143/62ee2abc-27f3-4c19-9e68-4f08908a524c)
   
   The import succeded with  {"COM":"int"}
   ![image](https://github.com/apache/superset/assets/82046143/31688adf-f525-4fb2-a8ff-56aedeff3105)
   
   I don't find documentation about the format keywords for types
   I test with : 
   - {"COM":"str"}  ✔ 
   - {"COM":"string"} ✔  
   - {"COM":"int"} ✔  
   - {"COM":"integer"}  ❌
   
   ![image](https://github.com/apache/superset/assets/82046143/731df5c4-4d50-4e35-9265-588a760f2573)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] fix: Error message: data type 'integer' not understood [superset]

Posted by "xavier-GitHub76 (via GitHub)" <gi...@apache.org>.
xavier-GitHub76 commented on issue #25690:
URL: https://github.com/apache/superset/issues/25690#issuecomment-1970916578

   Not seeing how to reopen this anomaly, I declared a new one
   https://github.com/apache/superset/issues/27305
   I hope this is good practice


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] fix: Error message: data type 'integer' not understood [superset]

Posted by "xavier-GitHub76 (via GitHub)" <gi...@apache.org>.
xavier-GitHub76 commented on issue #25690:
URL: https://github.com/apache/superset/issues/25690#issuecomment-1970900941

   Hello,
   Thanks for precision and link to Pandas dtypes.
   The example displayed on the import screen is therefore misleading.
   It should be: Example: {"user_id":"int"}
   Best regards


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] fix: Error message: data type 'integer' not understood [superset]

Posted by "xavier-GitHub76 (via GitHub)" <gi...@apache.org>.
xavier-GitHub76 commented on issue #25690:
URL: https://github.com/apache/superset/issues/25690#issuecomment-1790970008

   Thanks for your action


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] fix: Error message: data type 'integer' not understood [superset]

Posted by "DarkCoffeeLake (via GitHub)" <gi...@apache.org>.
DarkCoffeeLake commented on issue #25690:
URL: https://github.com/apache/superset/issues/25690#issuecomment-2019930656

   > The supported data types come from [Pandas dtypes](https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.dtypes.html) and not from the database. That's why you can't import using `integer` but can with `int` 😉
   
   As you mentioned I used the data type 'datetime' as referenced in Pandas dtypes but i still got the same error (I need both date and timestamp data type).
   `apache superset error message: data type 'datetime' not understood`
   
   I still can't fathom how the data types work and it should be mentioned in the documentation the different supported data types.
   @michael-s-molina 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] fix: Error message: data type 'integer' not understood [superset]

Posted by "michael-s-molina (via GitHub)" <gi...@apache.org>.
michael-s-molina closed issue #25690: fix: Error message: data type 'integer' not understood
URL: https://github.com/apache/superset/issues/25690


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] fix: Error message: data type 'integer' not understood [superset]

Posted by "michael-s-molina (via GitHub)" <gi...@apache.org>.
michael-s-molina commented on issue #25690:
URL: https://github.com/apache/superset/issues/25690#issuecomment-1872314954

   The supported data types come from [Pandas dtypes](https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.dtypes.html) and not from the database. That's why you can't import using `integer` but can with `int` 😉 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org