You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "albertojarabo (via GitHub)" <gi...@apache.org> on 2023/02/06 16:54:06 UTC
[GitHub] [superset] albertojarabo opened a new issue, #23002: Time Series Graph with other non-main druid table column generates error
albertojarabo opened a new issue, #23002:
URL: https://github.com/apache/superset/issues/23002
Im trying to create a Time Series V2 Graph on Superset based on a time column that is not the main that Druid works with. So I create a Dataset based on a Select with a CAST from a VARCHAR field to TIMESTAMP. The query works well, the Graph form seems to be working but when I try to update results, it appears an error.
#### How to reproduce the bug
1. Create a druid connection
2. Create a druid dataset from a table
3. Open SQLEditor
4. Create a query that uses other field (varchar field with timestamp) and cast it to timestamp
5. Run the query and check that works.
6. Press on Create Chart when query has finished
7. Check that no time field is set on Time Column, and the CASTed field is still a Varchar field.
8. Try to cast inside the CustomSQL tab in Time Column and CAST it again.
9. See error
### Expected results
Superset should use the new Time Field for the ghrap.
### Actual results
No time field is found despite having configured it. And If you try to force the cast inside the Time Column's CustomSQL it shows an error.
#### Screenshots
### Environment
(please complete the following information):
- browser type and version: Chrome 109.0.5414.120 (Build oficial) (64 bits)
- superset version: `superset version`: 2.0.0
- python version: `python --version` 3.8.12
- druid version: 25.0.0
--
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
[GitHub] [superset] albertojarabo closed issue #23002: Time Series Graph with other non-main druid table column generates error
Posted by "albertojarabo (via GitHub)" <gi...@apache.org>.
albertojarabo closed issue #23002: Time Series Graph with other non-main druid table column generates error
URL: https://github.com/apache/superset/issues/23002
--
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] rusackas commented on issue #23002: Time Series Graph with other non-main druid table column generates error
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #23002:
URL: https://github.com/apache/superset/issues/23002#issuecomment-1419460771
Hmm... as you can see by the `abc` label next to the `__time` column, Superset is not picking this up as a Temporal column. Can you try editing the dataset (via the three dots next to the table name in the left column) and explicitly marking that `__time` column as "temporal"? That _might_ kick it into gear, but I'm not sure why it didn't pick that up automatically.
--
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] albertojarabo commented on issue #23002: Time Series Graph with other non-main druid table column generates error
Posted by "albertojarabo (via GitHub)" <gi...@apache.org>.
albertojarabo commented on issue #23002:
URL: https://github.com/apache/superset/issues/23002#issuecomment-1420487408
it worked well, thank 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.
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