https://pinot.apache.org/ logo
#general
Title
# general
v

veera vissa

03/05/2020, 6:09 PM
After updating the table config with starTreeIndexConfigs we are getting below error
n

Neha Pawar

03/05/2020, 6:10 PM
you are getting this error when updating the table or when creating the segment?
h

Harshini Elath

03/05/2020, 6:15 PM
in swagger UI
posting the table config
n

Neha Pawar

03/05/2020, 6:25 PM
ah okay i see starTreeIndexConfigs is a list `
Copy code
private List<StarTreeIndexConfig> _starTreeIndexConfigs;
let me test out before giving you the new sample
h

Harshini Elath

03/05/2020, 6:26 PM
sure
n

Neha Pawar

03/05/2020, 6:39 PM
Copy code
{
  "tableName": "iw_trans_inventory_new",
  "segmentsConfig": {
    "replication": "2",
    "schemaName": "iw_trans_inventory_new",
    "segmentAssignmentStrategy": "BalanceNumSegmentAssignmentStrategy",
    "segmentPushType": "APPEND",
    "timeColumnName": "transaction_date",
    "timeType": "DAYS"
  },
  "tenants": {
    "broker": "DefaultTenant",
    "server": "DefaultTenant"
  },
  "tableIndexConfig": {
    "starTreeIndexConfigs": [
      {
        "dimensionsSplitOrder": [
          "audit_date",
          "audit_balance",
          "psa_cd",
          "psa_name",
          "item_id",
          "item_name"
        ],
        "skipStarNodeCreationForDimensions": [
          "load_date"
        ],
        "functionColumnPairs": [
          "SUM__net_purchases",
          "SUM__cash_purchases",
          "SUM__write_off_sales",
          "SUM__transfers",
          "SUM__net_merchandise_sales",
          "SUM__audit_balance"
        ],
        "maxLeafRecords": 1
      }
    ]
  },
  "tableType": "OFFLINE",
  "metadata": {}
}
try this. only minor difference,
starTreeIndexConfigs
is an array type
will update the doc
h

Harshini Elath

03/05/2020, 7:19 PM
got it
this worked
n

Neha Pawar

03/05/2020, 7:39 PM
great!