jgbolger commented on issue #3464: Issue using Oracle DB as superset database - 
Error running a migration script
URL: 
https://github.com/apache/incubator-superset/issues/3464#issuecomment-329906212
 
 
   I'm not sure Oracle can be used without code changes - I think you need to 
tell SQLAlchemy to use sequences for id generation, otherwise it expects there 
to be auto increment behaviour. I am not that familiar with it (coming from a 
Java background) so I can't say I'm 100% confident of that.
   
   Apart from the sequence issue, to make Oracle work you also need to:
   
   1. Set transactional_ddl = true
   2. Update dialect to includes "rows" as a reserved word.
   
   Regarding support of Oracle - I understand that you cannot expect to support 
all databases and it would lead to a high overhead for you. Can I therefore 
suggest that you call out the list of supported / tested databases in the 
documentation for installation & configuration? 
   
   Thanks,
   John
 
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

Reply via email to