Does pinot supports partition only for RealTime Tables? For the Offline Table all partition data written in the same segment file. segment metadata.properties

column.RELATEDID.partitionFunction = Murmur

column.RELATEDID.numPartitions = 10

column.RELATEDID.partitionValues = 0,1,2,3,4,5,6,7,8,9

Note: Running Data Ingestion using pinot-admin.sh LaunchDataIngestionJob

For offline, Pinot expects data to be already partitioned. In future we will add capability of Pinot sorting and partitioning the data during offline ingestion.

does pinot support partition for multiple columns?

No