Hi! I’m trying to update my retentionTimeValue for...
# troubleshootingg
Grace Walkuski
06/15/2022, 4:54 PMHi! I’m trying to update my retentionTimeValue for a table, and the endpoint doesn’t seem to be working, can someone help?
The body on the left has 742 days, the call is successful, but the returned response still has 738 days…
n
Neha Pawar
06/15/2022, 7:01 PM
in PUT api, you want to only include the json from
{ "tableName":…}Neha Pawar
06/15/2022, 7:01 PM
starting this commit: https://github.com/apache/pinot/pull/8514 you should see them come up as
unrecognizablePropsg
Grace Walkuski
06/15/2022, 7:03 PMThat gives me the same behavior
l
Laxman Ch
06/15/2022, 7:11 PMIf possible, can you try updating one additional config property along with retentionTimeValue.
g
Grace Walkuski
06/15/2022, 7:21 PMtried changing
allowNullTimeValueGrace Walkuski
06/15/2022, 7:22 PMWould disabling the table, updating config and then enabling the table again work?
Grace Walkuski
06/15/2022, 7:23 PMn
Neha Pawar
06/15/2022, 7:29 PM
not really, there’s something incorrect about the config i think. can you try editing directly from Pinot UI to just see if that works?
l
Laxman Ch
06/15/2022, 7:31 PMalso, see if you get some clue from controller logs.
g
Grace Walkuski
06/15/2022, 7:33 PMI found the config in the ui but I’m unable to edit it
Grace Walkuski
06/15/2022, 7:34 PMthrough the swagger api you mean? That doesn’t work because it needs my company auth
n
Neha Pawar
06/15/2022, 7:35 PM
no i meant this UI:
g
Grace Walkuski
06/15/2022, 7:47 PMInspected the tab, copied the path, and body its using to postman and ran it there - still no change in
retentionTimeValueGrace Walkuski
06/15/2022, 7:52 PMWhen I do a diff on the body the UI generates and the one I was using before, it shows no differences
Grace Walkuski
06/15/2022, 8:03 PMI got it! In postman, the {{baseUrl}} was set to use the controller load balancer url instead of the instead of the specific controller url
k
Kishore G
06/16/2022, 7:34 AM
Hi Grace, I am deleting some of the messages since it has some internal urls.. please repost after masking them
👍 1