You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "enzo-dechaene (via GitHub)" <gi...@apache.org> on 2023/02/01 14:57:13 UTC
[GitHub] [pinot] enzo-dechaene opened a new issue, #10213: Impossible to use the virtual column generated by the timestamp index ($ts$DAY) in the startree index
enzo-dechaene opened a new issue, #10213:
URL: https://github.com/apache/pinot/issues/10213
When I try to create my realtime table with a timestamp and a startree index, I get this error :
`Invalid table config: my-table-name_REALTIME. Column Name $ts$DAY defined in StarTreeIndex Config must be a valid column defined in the schema`
Currently the table config validation requires all the star-tree index to be explicitly configured within the schema.
--
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: commits-unsubscribe@pinot.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] Jackie-Jiang commented on issue #10213: Impossible to use the virtual column generated by the timestamp index ($ts$DAY) in the startree index
Posted by "Jackie-Jiang (via GitHub)" <gi...@apache.org>.
Jackie-Jiang commented on issue #10213:
URL: https://github.com/apache/pinot/issues/10213#issuecomment-1631653458
We have plans to re-design the timestamp index because currently it is more or less just the syntactic sugar for derived column + expression override. In regular case, derived column should be defined within the schema so that it can be used within the star-tree, but it is not the case for timestamp index as of now.
Add @gortiz to share more ideas
--
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: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] s0nskar commented on issue #10213: Impossible to use the virtual column generated by the timestamp index ($ts$DAY) in the startree index
Posted by "s0nskar (via GitHub)" <gi...@apache.org>.
s0nskar commented on issue #10213:
URL: https://github.com/apache/pinot/issues/10213#issuecomment-1626703395
@Jackie-Jiang I would like to work on this but I will need some guidance for this.
Should we even allow creating indexes on top of generated columns?
--
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: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org