Skip to content

Support timestamp type pushdown to DT scan #1800

@zanmato1984

Description

@zanmato1984

For queries like:
select count(*) from t where timestamp_column < xxx and timestamp_column > yyy, so far the filter condition cannot be pushed down to DT scan, thus introduces extra computation consuming more CPU.

The reason why we chose not to push down timestamp expression is that we need to deal with timezone. However it is actually possible to store min/max of DT in UTC, and transform them according to the required timezone (specified in DAG request) and do the comparison.

Metadata

Metadata

Assignees

Labels

type/feature-requestCategorizes issue or PR as related to a new feature.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions