Padma Malladi
04/12/2022, 2:55 PMRichard Startin
04/12/2022, 3:00 PMRichard Startin
04/12/2022, 3:00 PMRichard Startin
04/12/2022, 3:02 PMRichard Startin
04/12/2022, 3:02 PMPadma Malladi
04/12/2022, 4:26 PMPadma Malladi
04/12/2022, 4:28 PMRichard Startin
04/12/2022, 4:35 PMRichard Startin
04/12/2022, 4:35 PMRichard Startin
04/12/2022, 4:36 PMPadma Malladi
04/12/2022, 4:37 PMPadma Malladi
04/12/2022, 4:53 PMPadma Malladi
04/12/2022, 4:54 PM"dateTimeFieldSpecs": [
{
"name": "timestamp_ms",
"dataType": "LONG",
"format": "1:MILLISECONDS:EPOCH",
"granularity": "1:HOURS"
}
Padma Malladi
04/12/2022, 4:55 PMMayank
Mohemmad Zaid Khan
04/13/2022, 2:39 AMtime > 'value' and time < 'value'
then you can configure your table to have -
"routing": {
"segmentPrunerTypes": ["time"]
}
Broker will only query the relevant segments.Padma Malladi
04/13/2022, 5:29 PMPadma Malladi
04/13/2022, 5:30 PMPadma Malladi
04/13/2022, 5:46 PMMohemmad Zaid Khan
04/21/2022, 5:40 AMtime
keyword. Yes, this is part of table config.Sudharsan Kannan
08/02/2022, 6:57 AM"routing": {
"segmentPrunerTypes": ["time"]
}
This configuration is supposed to create 'n' segments based on the "dateTimeFieldSpecs"
right ?
Use case : I have a dataset of 76K records with { "name":"PDate",
"dataType": "STRING",
format": "1:DAYS:SIMPLE_DATE_FORMAT:yyyy-MM-dd",
"granularity": "1:DAYS" }
Sudharsan Kannan
08/02/2022, 7:04 AM"routing": {
"segmentPrunerTypes": ["time"]
}
This configuration is supposed to create 'n' segments based on the "dateTimeFieldSpecs"
right ?
Test Case : I have a dataset of 76K records where I'm trying this routing configuration. I have the following configuration in the table-schema for a Real Time Table configured to consume from a single kafka topic-partition
{
"name": "PDate",
"dataType": "STRING",
"format": "1:DAYS:SIMPLE_DATE_FORMAT:yyyy-MM-dd",
"granularity": "1:DAYS"
}
The PDate column contains 3600 odd unique values. When I inspect, I could see only two segments created for the table. Shouldn't there be more segments created based on the values ? Or am I missing something ??Mohemmad Zaid Khan
08/02/2022, 7:23 AM“segmentPrunerTypes”: [“time”]
This setting is not for partitioning segments. It is just used to determine the whether to prune the segments or not, based on segment’ startTime and endTime