Airliquide76 opened a new issue, #9989:
URL: https://github.com/apache/pinot/issues/9989
Derivated column not reloaded when formula changes
Step to reproduce
1- Add a column to the schema save schema
2- Edit table to add a formula like
```
{
"columnName": "actualexpense.amountExcludingTax",
"transformFunction":
"\"actualexpense.amountIncludingTax\"-((\"actualexpense.amountIncludingTax\"/(1+(\"actualexpense.tax\"/100)))*(\"actualexpense.tax\"/100))"
},
```
3- Reload Segment
4- Edit table change a formula like
```
{
"columnName": "actualexpense.amountExcludingTax",
"transformFunction":
"\"actualexpense.amountIncludingTax\"-((\"actualexpense.amountIncludingTax\"/(1+(\"actualexpense.tax\"/100)))*(\"actualexpense.tax\"/100))-1000"
},
```
5- Reload Segment
Here come my issue my -1000 does not appear in results except in consuming
segments. Values should be backfilled as my understanding with the -1000 value
--
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]
