clarahong opened a new issue, #14660:
URL: https://github.com/apache/pinot/issues/14660

   
   When setting table index configs, Pinot documentation recommends deprecating 
usage of single-column index configurations in favor of the Field Config List. 
   
   However, when attempting to migrate an existing table from the deprecated 
format, these settings are not respected. For example, using an old table 
config, dictionary indexes are disabled: 
   ```
   {
     ...
       "tableIndexConfig": {
         "noDictionaryColumns": [
           "col1",
           “range1”,
         ],
         ...
         "optimizeDictionaryForMetrics": true,
         "optimizeDictionary": false,
         "noDictionarySizeRatioThreshold": 0.85
       },
     }
   ```
   Updating to a new definition: 
   ```
   {
   ...
     "fieldConfigList": [
       {
         "name": "range1",
         "indexes": {
           "dictionary": {
             "disabled": true
           },
           "range": {}
         }
       },
       {
         "name": "col1",
         "indexes": {
           "dictionary": {
             "disabled": true
           },
           "json": {
             "maxLevels": 1,
             "excludeArray": true,
             "disableCrossArrayUnnest": true
           }
         }
       }
     ]
   }
   ```
   Making the table config change and triggering a table reload creates new 
dictionary indexes even though they are specified as disabled. Adding the 
property "encodingType": "RAW" also does not resolve this issue. 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to