Pinot Version | 1.0.0 |
---|---|
Code | startreedata/pinot-recipes/time-boundary-hybrid-table |
make recipe
This command will also:
events
.events
table.events
table in Pinot.events
table in Pinot.events_REALTIME
and an events_OFFLINE
table. When you go to the query console in Pinot, you will only see one table: events
.
events_REALTIME
table. The batch loader will load 10 records into the events_OFFLINE
table for a total of 1010
records.
If you count the number of records in this table, you will only get 1000
.
query response stats
you’ll see 1000
documents scanned from 1010
totalDocs. When querying hybrid tables, the Pinot Broker must decide which records to read from the offline table and which to read from the real-time table.
If you run the SQL below, you’ll see that there are no OFFLINE segments. They are only realtime segments.
event
table’s time boundary.