just quick question: does pinot support other partition logics other than time based partition?

yes, https://docs.pinot.apache.org/operators/operating-pinot/tuning/routing

thanks .