Sweety1234
04/01/2025, 10:00 PM"segmentPartitionConfig":{
"columnPartitionMap": {
"itemId": {
"functionName": "Murmur",
"numPartitions": 32
}
}
}
But I dont see the partition created on the column when explain plan is run -
EXPLAIN PLAN FOR
SELECT * FROM pricing_stage_test_OFFLINE
WHERE itemId = 1012797282;
BROKER_REDUCE(limit:10) 1 0
COMBINE_SELECT 2 1
PLAN_START(numSegmentsForThisPlan:41) -1 -1
SELECT(selectList:__header$changedAttributes, created_at, currentPriceCurrencyAmount, currentPriceCurrencyCurrencyUnit, externalPartnerId, itemId, modified_at, offerId, sellerId, ts) 3 2
PROJECT(__header$changedAttributes, itemId, currentPriceCurrencyAmount, sellerId, externalPartnerId, currentPriceCurrencyCurrencyUnit, created_at, offerId, modified_at, ts) 4 3
DOC_ID_SET 5 4
FILTER_FULL_SCAN(operator:EQ,predicate:itemId = '1012797282')
Below is the kind of data for which partition is not created for itemId column. Can you please suggest why the partition is not created on the itemId column?raghav
04/02/2025, 7:08 AM"segment.partition.metadata": "{\"columnPartitionMap\":{\"metric_id\":{\"numPartitions\":24,\"functionName\":\"Murmur\",\"partitions\":[11],\"functionConfig\":null}}}",Sweety1234
04/03/2025, 9:55 PM