Rajat
04/15/2025, 6:00 AMXiang Fu
Rajat
04/15/2025, 7:41 AMXiang Fu
Xiang Fu
Rajat
04/15/2025, 7:45 AMRajat
04/15/2025, 7:45 AMXiang Fu
Rajat
04/15/2025, 7:50 AM"starTreeIndexConfigs": [
{
"enableStarTreeIndex": true,
"dimensionsSplitOrder": [
"o_shipping_method",
"o_payment_method",
"s_courier",
"s_status",
"s_company_id"
],
"skipStarNodeCreationForDimensions": [],
"functionColumnPairs": [
"SUM__o_net_total_double",
"SUM__o_total_double",
"SUM__a_applied_weight_amount_double",
"SUM__a_charge_weight_amount_double",
"COUNT__*"
],
"maxLeafRecords": 10000
}
],
in offline table and I am facing performance issue in the case when the query is running on Hybrid segments. when querying on separate offline or Online segments it was running under 100 ms and with hybrid table it was taking 900-1000 ms.
the query:
SELECT o_shipping_method,
o_payment_method,
s_courier,
s_status,
s_company_id,
COUNT(*) AS shipment_count
FROM shipmentMerged_v3
GROUP BY 1,2,3,4,5
and primary key = s_idRajat
04/16/2025, 7:26 AMXiang Fu
Xiang Fu
Rajat
04/16/2025, 2:00 PMXiang Fu