When I altered the table and added int type column...
# troubleshootings
Sadim Nadeem
10/29/2021, 3:20 PMWhen I altered the table and added int type column in real-time table..
Now all old/past ingested rows for that particular newly added column's value in the table got initialized to default value ie integer minimum which was expected
But new values for that column that I am ingesting through kafka for published and recently ingested rows after alter table is done also have that newly added column initialized as default value even when json published have value as 0 or 1 but initialized to integer minimum value
x
Xiang Fu
10/29/2021, 9:11 PM
did you restart pinot server or reset the table consuming segment ?
Xiang Fu
10/29/2021, 9:12 PM
if you altered schema and segment is still consuming, then pinot will wait until current consuming segment is persisted then next consuming segment will pickup the new schema and field
✅ 1
s
Sadim Nadeem
10/30/2021, 3:42 PMI did reload all segmenta
Sadim Nadeem
10/30/2021, 3:43 PMStill the newly ingestes rows new column holds default value
Sadim Nadeem
10/30/2021, 3:44 PMDo you mean all the data jn current segment will hold default value until current segment which was getting newly ingested data while alter table is flushed
Sadim Nadeem
10/31/2021, 3:18 AMthanks @Xiang Fu now it is ingesting records with the provided value since the old segment is flushed
x
Xiang Fu
10/31/2021, 3:59 AM
Yes
Xiang Fu
10/31/2021, 3:59 AM
2 Views