Cannot use _tp_time in tumble window for external stream

[jovezhong]

Describe what's wrong

I created an external stream with Redpanda in docker-compose

CREATE EXTERNAL STREAM frontend_events(raw string)
SETTINGS type='kafka', 
         brokers='redpanda:9092',
         topic='owlshop-frontend-events'

I cannot run

select window_start, raw:method, count() from tumble(frontend_events,1s)
group by window_start, raw:method

Error

Code: 43. DB::Exception: Received from localhost:8463. DB::Exception: Illegal column _tp_time argument of function TUMBLE. Must be datetime or datetime64. (ILLEGAL_TYPE_OF_ARGUMENT)

Have to use now() to avoid the default _tp_time.

select window_start, raw:method, count() from tumble(frontend_events,now(),1s)
group by window_start, raw:method

How to reproduce

1.3.9 proton. With docker-compose file at https://github.com/timeplus-io/proton/blob/feature/issue-14-refine-oss-docs/docker-compose.yml

Error message and/or stacktrace

Additional context

[jovezhong]

(Jove Github Bot) assuming it is not done, deferred this ticket to the next sprint.

[jovezhong]

(Jove Github Bot) assuming it is not done, deferred this ticket to the next sprint.

[jovezhong]

(Jove Github Bot) assuming it is not done, deferred this ticket to the next sprint.

[jovezhong]

(Jove Github Bot) assuming it is not done, deferred this ticket to the next sprint.

[jovezhong]

(Jove Github Bot) assuming it is not done, deferred this ticket to the next sprint.

[jovezhong]

(Jove Github Bot) assuming it is not done, deferred this ticket to the next sprint.

[jovezhong]

(Jove Github Bot) assuming it is not done, deferred this ticket to the next sprint.

[jovezhong]

(Jove Github Bot) moved this ticket out of the GitHub project(up to 1200 tickets for one project).