How to persist tables ? It seems when logging out of sql-client all the tables are also getting destroyed, is there a way to persist these tables ?

you have two options: • use hive catalog - this will persist the table definitions across restarts. Note that this catalog will persist only the table DDLs and not the data itself. • use apache paimon catalog - this supports persisting both metadata as well as table data. Previously paimon used to be called table-store.

Thanks @Sharath Gururaj, also one common error observed with flink-sql is that the sql-client shuts down abruptly when copy pasting code, is this a known bug ?

No i haven't encountered this behaviour.. i copy paste all the time.. works fine for me.. maybe you should check the logs if any exception occurred

I followed the steps mentioned in documentation for hive catalog, installing required jars, but still getting error - Caused by: java.lang.NoClassDefFoundError: org/apache/flink/table/descriptors/CatalogDescriptorValidator