You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/02/14 14:30:21 UTC
[GitHub] [superset] mchogithub opened a new issue #18716: saved queries - schema with null value
mchogithub opened a new issue #18716:
URL: https://github.com/apache/superset/issues/18716
After saving the queries the schema is not valorized, the null value remains and it is not possible to update it in subsequent saves
#### How to reproduce the bug
1. Go to SQL Lab > SQL Editor
2. Click on Database and select one
3. Click on Schema and select one
4. Edit and run query
4. Click on Save button
5. Click on Data > Saved Queries and open the newly saved query
6. Click on Run button and the following is shown
### Expected results
the "Schema" should remain saved
### Actual results
the "Schema" always remains valued at null, even when a different value is selected from the drop-down menu
#### Screenshots
### Environment
- helm chart superset-0.5.8
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [x] I have reproduced the issue with at least the latest released version of superset.
- [x] I have checked the issue tracker for the same issue and I haven't found one similar.
--
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
[GitHub] [superset] timnick-snow edited a comment on issue #18716: saved queries - schema with null value
Posted by GitBox <gi...@apache.org>.
timnick-snow edited a comment on issue #18716:
URL: https://github.com/apache/superset/issues/18716#issuecomment-1043703530
I got the similar error.
1. go sql editor. select database and edit a sql then run
2. save to saved queries.
3. go [sql lab] -> [saved queries], edit the saved queries, will open sql edit
4. click run
MySQL error
Unable to connect to database "null".
- superset version: 1.4.1
install use Docker Compose:
Loaded your LOCAL configuration at [/app/pythonpath/superset_config.py]
Python 3.8.12
Flask 1.1.4
Werkzeug 1.0.1
--
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
[GitHub] [superset] zhaoyongjie commented on issue #18716: saved queries - schema with null value
Posted by GitBox <gi...@apache.org>.
zhaoyongjie commented on issue #18716:
URL: https://github.com/apache/superset/issues/18716#issuecomment-1041507619
@mchogithub It's weird. Do you use `docker-compose -f docker-compose-non-dev.yml up` on the 1.4.1 tag?
--
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
[GitHub] [superset] timnick-snow commented on issue #18716: saved queries - schema with null value
Posted by GitBox <gi...@apache.org>.
timnick-snow commented on issue #18716:
URL: https://github.com/apache/superset/issues/18716#issuecomment-1043703530
I got the similar error.
1. go sql editor. select database and edit a sql then run
2. save to saved queries.
3. go [sql lab] -> [saved queries], edit the saved queries, will open sql edit
4. click run
MySQL error
Unable to connect to database "null".
--
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
[GitHub] [superset] zhaoyongjie commented on issue #18716: saved queries - schema with null value
Posted by GitBox <gi...@apache.org>.
zhaoyongjie commented on issue #18716:
URL: https://github.com/apache/superset/issues/18716#issuecomment-1041147640
Hi @mchogithub, according to [MySQL Reference Manual](https://dev.mysql.com/doc/refman/8.0/en/glossary.html#glos_schema) said
> In MySQL, physically, a schema is synonymous with a database. You can substitute the keyword SCHEMA instead of DATABASE in MySQL SQL syntax, for example using CREATE SCHEMA instead of CREATE DATABASE.
`schema` and `database` is the same namespace, so `schema` put null value on MySQL driver make sense.
I try this issue on PostgreSQL 12 on my local machine. The schema can be successfully saved.
<img width="1200" alt="image" src="https://user-images.githubusercontent.com/2016594/154207478-f605290b-708e-42a7-80f3-60f36a141ed1.png">
--
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
[GitHub] [superset] mchogithub commented on issue #18716: saved queries - schema with null value
Posted by GitBox <gi...@apache.org>.
mchogithub commented on issue #18716:
URL: https://github.com/apache/superset/issues/18716#issuecomment-1041487791
Thanks @zhaoyongjie
I have tried also with the pre installed postgresql database "examples" but it still sets the schema to NULL:
Current Database settings:
Default PSQL:
MySQL:
In the currently installed version we had the same problem, but going to edit, we could set correctly the schema:
What log can I check to better verify this issue ?
--
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
[GitHub] [superset] mchogithub commented on issue #18716: saved queries - schema with null value
Posted by GitBox <gi...@apache.org>.
mchogithub commented on issue #18716:
URL: https://github.com/apache/superset/issues/18716#issuecomment-1041897295
unfortunately yes, I also tried with kubernetes via microk8s (0.5.8):
helm repo add superset https://apache.github.io/superset
helm upgrade --install superset/superset
--
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