apache / apache/pinot

Impossible to use the virtual column generated by the timestamp index ($ts$DAY) in the startree index

Open
#10,213 2 comments 0 reactions 0 assignees View on GitHub
bug help wanted
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
2d 55m
Merged PRs (30d)
182

Description

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.

Contributor guide

Open the contributing guide

Research direction

Start by reproducing realtime table creation with a timestamp column and a StarTree index using the virtual $ts$DAY column. Read the table config validation and StarTreeIndex configuration handling; done means the configuration is accepted without requiring $ts$DAY to be explicitly declared in the schema.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.