Hello, we have a use case for an offline table but...
# troubleshootingp
Priyank Bagrecha
07/18/2022, 5:25 PMHello, we have a use case for an offline table but we don't have a time column for segment config. What is the suggested route if there is one? Thank you!
l
Luis Fernandez
07/18/2022, 6:42 PMi have the same question.. you mean what if we don’t have a time column right?
Luis Fernandez
07/18/2022, 6:42 PMwe have a use case where we don’t have a time column
p
Priyank Bagrecha
07/18/2022, 6:43 PMyes, pretty much!
Priyank Bagrecha
07/18/2022, 9:06 PM@Mayank when you get a chance could you please comment or point us to the right person.
m
Mayank
07/18/2022, 9:23 PM
Typically, these end up being refresh use cases (where you refresh entire data everyday from a snapshot). Note, without time column, retention won’t work in offline.
p
Priyank Bagrecha
07/18/2022, 9:27 PMyou are correct - the use case is of a daily refresh. how do we segment data so that queries can run faster?
m
Mayank
07/18/2022, 9:28 PM
Same way you’d when time column is present. Set the right indexing/sorting.
p
Priyank Bagrecha
07/18/2022, 11:45 PMgot it. thank you. also i found this thread interesting. sharing here for luis, and anyone else that stumbles across this thread. https://apache-pinot.slack.com/archives/CDRCA57FC/p1658128621079079
l
Luis Fernandez
07/19/2022, 4:51 PMinteresting thank you for sharing @Priyank Bagrecha
👍 1
2 Views