In upsert table, can we update the timestamp of th...
# troubleshootingw
Weixiang Sun
03/18/2022, 8:25 PMIn upsert table, can we update the timestamp of the row?
j
Jackie
03/20/2022, 6:49 AMConceptually it is possible if you configure a different comparison column
Jackie
03/20/2022, 6:50 AMIf you use timestamp as the comparison column (default setting) then it cannot be changed
w
Weixiang Sun
03/21/2022, 4:31 AMHow to delete a row if we are using different comparison column? Any tool?
j
Jackie
03/21/2022, 5:13 PMI don't follow the ask. Do you want to delete a row already ingested? Upsert only allows you to update a row with the same primary key, but not allow deletion
w
Weixiang Sun
03/21/2022, 6:52 PMYes, I want to delete a row already ingested. It seems that answer is “NO”
j
Jackie
03/21/2022, 8:34 PMYeah, currently there is no way to do that besides replacing the segment