Hi, I am trying to create multiple realtime tables...
# general
r
Hi, I am trying to create multiple realtime tables from same schema.. Need to have different filter strategy in them... but since the tableName has to be the same as schema name I can only create 1 realtime table from 1 schema... But I read that since schema is in it's own file we can create multiple tables from it... Is there something that is wrong in my setup???
r
Are you getting the
Schema name  does not match table name:
error when trying to create these new tables. By the way, are we consuming from a single real-time ingestion source for all these tables? If yes, having multiple tables use more disk than expected? There might be a way to have a single table with multiple derived columns to support different filter strategies. Will that work for you?
r
No when I type in the table name it says schema not found... My usecase is the I want to split a json field into columns but also keep that field as well... I wasn't able to achieve this so I was trying to create multiple tables... Is there any other way to do this??
r
How are you creating the table? Via the REST API? We can create the original JSON Field as it is and create new derived columns. Refer to this.
ack 1
r
No via UI... not swagger
r
It shouldn’t matter but can you try the REST API as well and let me know the exact error you are getting
r
Sure will do that and let you know
👍 1