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 2021/04/21 07:33:58 UTC
[GitHub] [superset] ljclour opened a new issue #14263: There is no option in TIME GRAIN
ljclour opened a new issue #14263:
URL: https://github.com/apache/superset/issues/14263
I haved successful connect **DB2** and added a database yet. When i use a dataset to create a line chart,there is no option in **TIME GRAIN**.Is anything wrong?
--
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] [superset] junlincc commented on issue #14263: There is no option in TIME GRAIN
Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #14263:
URL: https://github.com/apache/superset/issues/14263#issuecomment-823860108
Hi @ljclour We may not support Time grain in DB2 yet, I'm not sure. Contribution from the community is welcome! :)
cc @cabo40
--
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] [superset] cabo40 commented on issue #14263: There is no option in TIME GRAIN
Posted by GitBox <gi...@apache.org>.
cabo40 commented on issue #14263:
URL: https://github.com/apache/superset/issues/14263#issuecomment-824268131
@junlincc , thanks.
Hi, I will go with what @villebro said, there are two aliases for DB2 connections https://superset.apache.org/docs/databases/ibm-db2 and they handle datetimes and limits in a different manner.
@ljclour , does the sql lab allows you to do raw queries or fails with the limit? Also, can you try any of this?
```sql
SELECT current date FROM sysibm.sysdummy1
SELECT current time FROM sysibm.sysdummy1
SELECT current timestamp FROM sysibm.sysdummy1
```
--
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] [superset] ljclour commented on issue #14263: There is no option in TIME GRAIN
Posted by GitBox <gi...@apache.org>.
ljclour commented on issue #14263:
URL: https://github.com/apache/superset/issues/14263#issuecomment-823919757
> Hi @ljclour We may not support Time grain in DB2 yet, I'm not sure. Contribution from the community is welcome! :)
>
> cc @cabo40
Thanks for the reply!If it does not support DB2,i haved to choose another way to fit it.
--
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] [superset] villebro closed issue #14263: There is no option in TIME GRAIN
Posted by GitBox <gi...@apache.org>.
villebro closed issue #14263:
URL: https://github.com/apache/superset/issues/14263
--
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] [superset] srinify commented on issue #14263: There is no option in TIME GRAIN
Posted by GitBox <gi...@apache.org>.
srinify commented on issue #14263:
URL: https://github.com/apache/superset/issues/14263#issuecomment-824036581
@junlincc it looks like we actually *do* support time grains for db2. You can tell by the presence of `_time_grain_expressions` dictionary in `db2.py` but no idea if they actually work!
https://github.com/apache/superset/blob/master/superset/db_engine_specs/db2.py
But just for future reference :D
--
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] [superset] villebro commented on issue #14263: There is no option in TIME GRAIN
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #14263:
URL: https://github.com/apache/superset/issues/14263#issuecomment-823985925
@ljclour what does your connection string look like, specifically the part before `://`?
--
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] [superset] villebro commented on issue #14263: There is no option in TIME GRAIN
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #14263:
URL: https://github.com/apache/superset/issues/14263#issuecomment-824517169
@ljclour I opened a PR #14295 to add support for both `db2` and `ibm_db_sa` engine names, let me know if this works for you.
--
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] [superset] villebro commented on issue #14263: There is no option in TIME GRAIN
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #14263:
URL: https://github.com/apache/superset/issues/14263#issuecomment-824039362
I seem to recall that the DB2 SQLA connector has a few aliases for the dialect, and we may need to add those to the `engine_aliases` property. See how Postgres does it: https://github.com/apache/superset/blob/852e840575cf5ec6e1ad2780c986972619c8666f/superset/db_engine_specs/postgres.py#L148
--
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] [superset] ljclour commented on issue #14263: There is no option in TIME GRAIN
Posted by GitBox <gi...@apache.org>.
ljclour commented on issue #14263:
URL: https://github.com/apache/superset/issues/14263#issuecomment-824499222
> @ljclour what does your connection string look like, specifically the part before `://`?
Thanks!It does work when i choose another connection, like `ibm_db_sa`. @cabo40
--
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