Hi everyone, I am new to the Starrocks, and am trying to do a POC for my team. I am doing some research on how to use Starrocks share-data architecture as a OLAP database for realtime queries scenario. I am using Routine Load with Hash Bucketing on the timestamp column of my data. The timestamp is microsecond format and I try to apply Hash Bucketing on hour, e.g. DISTRIBUTED BY (date_trunc('hour', _time)). However, bucketing is not allowed to use functions, although PARTITION is. Could anyone help me with this? Thanks

It's not possible to just load into certain buckets. Your table is divided into partitions, and each partition consists of buckets - so this buckets are unnamed. It does not make sense to choose only specific bucket that you want to load to. My suggestion is when you create the table use partition on your timestamp (

date_trunc(...)

)column and hash it (bucketing) using some high cardinality column like id, etc.