You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "TomBurdge (via GitHub)" <gi...@apache.org> on 2023/09/20 13:17:07 UTC
[GitHub] [superset] TomBurdge opened a new issue, #25347: Datetime column not provided error when implementing an Annotation Layer
TomBurdge opened a new issue, #25347:
URL: https://github.com/apache/superset/issues/25347
When embedding a table as an interval annotation layer in a line chart, there is an error.
This is in 3.0.0 - we updated to this (somewhat unexpectedly, by restarting and using the latest image) yesterday.
This release appears to have introduced the bug.
#### How to reproduce the bug
1. Create a dataset, with a BigQuery db connection, as:
SELECT
"Latest periods" AS latest_periods,
LAST_DAY(CURRENT_DATE(), MONTH) AS end_of_current_month,
LAST_DAY(DATE_ADD(CURRENT_DATE(),INTERVAL -1 MONTH), MONTH) AS end_of_previous_month;
2. Try to embed this chart in a line chart.
### Expected results
As with previous superset versions, I would expect an annotation layer to embed (either as an interval or event - both cause an error).
### Actual results
Receives an error as in the image.
"ERROR: Error: Datetime column not provided as part table configuration and is required by this type of chart"
#### Screenshots
Image attached.
This does not seem to be limited to my specific table.

### Environment
- browser type and version: Google Chrome - latest
- superset version: 3.0.0
- python version: 3.9.18
- node.js version: not using plugins
- any feature flags active:
{
"ALERT_REPORTS": False,
"ENABLE_TEMPLATE_PROCESSING": True,
'DASHBOARD_CROSS_FILTERS': True,
'DASHBOARD_RBAC': True,
'ESCAPE_MARKDOWN_HTML': True,
'LISTVIEWS_DEFAULT_CARD_VIEW': True,
'SCHEDULED_QUERIES': True,
'THUMBNAILS': False,
'DASHBOARD_NATIVE_FILTERS': True,
'ENABLE_JAVASCRIPT_CONTROLS': True,
'FEATURE_GENERIC_CHART_AXES': True,
'EMBEDDED_SUPERSET': True,
'HORIZONTAL_FILTER_BAR': True,
'DRILL_BY': True,
'DRILL_TO_DETAIL': True
}
and
DEFAULT_FEATURE_FLAGS = {
# Experimental feature introducing a client (browser) cache
"CLIENT_CACHE": True
} (just noticed this is deprecated in the latest release notes.)
### 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.
### 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.
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
Re: [I] Datetime column not provided error when implementing an Annotation Layer [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #25347:
URL: https://github.com/apache/superset/issues/25347#issuecomment-2218454157
Closing this because:
1) It's gone stale
2) The last clarifying question wasn't responded to
3) We support Superset 3.1 / 4.x at the moment.
Happy to re-open this if we can gain any updated context :)
--
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
Re: [I] Datetime column not provided error when implementing an Annotation Layer [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #25347: Datetime column not provided error when implementing an Annotation Layer
URL: https://github.com/apache/superset/issues/25347
--
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
Re: [I] Datetime column not provided error when implementing an Annotation Layer [superset]
Posted by "rtexelm (via GitHub)" <gi...@apache.org>.
rtexelm commented on issue #25347:
URL: https://github.com/apache/superset/issues/25347#issuecomment-1961795506
I came across a similar problem recently but it seemed to be caused by my choice of dataset. Curious if you have had any new experience with this one?
--
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