error when recreating a deleted table with the same name

[flykent1990]

hi team

now I have a problem when I delete the realtime table and recreate the same name ... the segment status always says bad ... can you help me fix this?

[Jackie-Jiang]

@flykent1990 Can you please check if the deleted table has the table config and all segment metadata cleaned up? You can find these info from the Zookeeper Browser under the PROPERTYSTORE directory.

[flykent1990]

everything has been deleted ... even in zookeeper PROPERTYSTORE is not available but cannot create realtime table

[Jackie-Jiang]

@flykent1990 From the exception log, seems like you don't have the column timestamp in your schema but defined it as the time column in the table config. If that is not the case, can you please provide the full stack trace for the exception?