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 2020/06/30 10:56:40 UTC
[GitHub] [incubator-superset] rbk-paul opened a new issue #10199: Time Grain Not Available
rbk-paul opened a new issue #10199:
URL: https://github.com/apache/incubator-superset/issues/10199
A clear and concise description of what the bug is.
The "Time Grain" filter does not have any options available (shows "0 Options"), despite detecting correct the various "Time Columns".
This problem exists for all Visualization Types.
Found a similar issue reported but was closed and marked stale:
https://github.com/apache/incubator-superset/issues/8009
Data Source is from Azure Databricks.
### Expected results
Time Grain filter shows different options like Year, Month, Day...
### Actual results
Shows "0 Options"
#### Screenshots
<img width="424" alt="Screenshot 2020-06-30 at 5 55 45 PM" src="https://user-images.githubusercontent.com/26905569/86118452-6448a580-bb03-11ea-966f-ae4cd70b517b.png">
#### How to reproduce the bug
1. Create any Visualization Type connecting to any tables from a Azure Databricks data source
2. "Time Grain" does not show options
### Environment
(please complete the following information):
- superset version: 0.36.0
- python version: 3.7.7
- node.js version: v13.11.0
- npm version: 6.13.7
### Checklist
Make sure these boxes are checked 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.
### Additional context
Add any other context about the problem here.
----------------------------------------------------------------
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.
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] [incubator-superset] issue-label-bot[bot] commented on issue #10199: Time Grain Not Available
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10199:
URL: https://github.com/apache/incubator-superset/issues/10199#issuecomment-651720113
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.73. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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.
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] [incubator-superset] villebro commented on issue #10199: Time Grain Not Available
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #10199:
URL: https://github.com/apache/incubator-superset/issues/10199#issuecomment-670320598
@rbk-paul are you connecting using this connector? https://pypi.org/project/databricks-dbapi/
----------------------------------------------------------------
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.
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] [incubator-superset] MApeldoorn commented on issue #10199: Time Grain Not Available
Posted by GitBox <gi...@apache.org>.
MApeldoorn commented on issue #10199:
URL: https://github.com/apache/incubator-superset/issues/10199#issuecomment-669973163
Hi,
I am having the same issue. Running SuperSet 0.36, but had the same problem in 0.29.
Connection to a sqlalchemy_sqlany backend. DATETIME_ID (type TIMESTAMP) and DAET_ID (type DATE) are giving 0 Time Grain option(s).
I have tried multiple datetime-translation, but no success.
With kind regards,
Mark
----------------------------------------------------------------
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.
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] [incubator-superset] stale[bot] commented on issue #10199: Time Grain Not Available
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10199:
URL: https://github.com/apache/incubator-superset/issues/10199#issuecomment-706542876
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the 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.
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] [incubator-superset] MApeldoorn commented on issue #10199: Time Grain Not Available
Posted by GitBox <gi...@apache.org>.
MApeldoorn commented on issue #10199:
URL: https://github.com/apache/incubator-superset/issues/10199#issuecomment-671249007
@mistercrunch : sqlalchemy_sqlany://...
----------------------------------------------------------------
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.
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] [incubator-superset] rbk-paul commented on issue #10199: Time Grain Not Available
Posted by GitBox <gi...@apache.org>.
rbk-paul commented on issue #10199:
URL: https://github.com/apache/incubator-superset/issues/10199#issuecomment-670420634
@villebro. yes, using the connector you specified.
@mistercrunch, connection string looks like this:
databricks+pyhive://token:<databrick_access_token>@<databrick_host>:<port>/<database_name>
----------------------------------------------------------------
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.
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] [incubator-superset] mistercrunch commented on issue #10199: Time Grain Not Available
Posted by GitBox <gi...@apache.org>.
mistercrunch commented on issue #10199:
URL: https://github.com/apache/incubator-superset/issues/10199#issuecomment-670318421
What does your connection string look like? What SQL dialect is this most like? Hive?
You probably want to add a new module here:
https://github.com/apache/incubator-superset/tree/master/superset/db_engine_specs
----------------------------------------------------------------
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.
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] [incubator-superset] MApeldoorn commented on issue #10199: Time Grain Not Available
Posted by GitBox <gi...@apache.org>.
MApeldoorn commented on issue #10199:
URL: https://github.com/apache/incubator-superset/issues/10199#issuecomment-671887268
> What does your connection string look like? What SQL dialect is this most like? Hive?
> You probably want to add a new module here:
> https://github.com/apache/incubator-superset/tree/master/superset/db_engine_specs
It worked for me. I copied the mssql.py db_engine_specs, renamed it to sqlalchemy_sqlany. Only thing I had to fix after that was replace the "0" within DATEADD and DATEDIFF. The results these functions get comparing to todays datetime is giving an error (probably too high value). Replacing "0" by e.g. '2020-01-01' did the trick.
----------------------------------------------------------------
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.
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] [incubator-superset] MApeldoorn edited a comment on issue #10199: Time Grain Not Available
Posted by GitBox <gi...@apache.org>.
MApeldoorn edited a comment on issue #10199:
URL: https://github.com/apache/incubator-superset/issues/10199#issuecomment-671249007
@mistercrunch : In my case: sqlalchemy_sqlany://..., connecting to Sybase
----------------------------------------------------------------
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.
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