Hi team :wink: Really quick question about Derived...
# troubleshooting
f
Hi team 😉 Really quick question about Derived Column and performances. I’ve got a few Derived Column in my table and I’m planning to add many other more using JSONEXTRACTSCALAR. My main concern is about performances on a REALTIME with allready existing segments. Does the reload needed to have this new column avalaible calculate it for each row of all segments ? Or is it calculated on flight at query time (I just hope it’s not the case)
m
Yes need to reload
f
Yes I kown It but this new col is calculated on flight at query time for old segments or its calculated during the reload ?
m
Not sure if I follow. The whole purpose of reload is to create the new column
f
Yes and will it populate the column with calculated value instead of default a this time during the reload ?
m
Yes
f
many thanks for you rapid feedback 😉
🙏 1
m
Always happy to help