Hi team, I have created partition for an offline ...
# troubleshooting
s
Hi team, I have created partition for an offline table using the below config
Copy code
"segmentPartitionConfig":{
      "columnPartitionMap": {
        "itemId": {
          "functionName": "Murmur",
          "numPartitions": 32
      }
    }
    }
But I dont see the partition created on the column when explain plan is run -
Copy code
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?
r
Afaik the partition information is not visible in explain plan query. You should go to segment details page and there metadata like below should be present.
Copy code
"segment.partition.metadata": "{\"columnPartitionMap\":{\"metric_id\":{\"numPartitions\":24,\"functionName\":\"Murmur\",\"partitions\":[11],\"functionConfig\":null}}}",
s
Let me validate on that, thank you