Created 08-20-2020 05:59 AM
Phoenix parcel need to be removed from my cluster, but I've no idea if someone actually created a phoenix table using sqlline
The Cloudera documentation just says:
Before you uninstall the Phoenix parcel, you must disable all your Phoenix system tables, and tables created using Phoenix.
How can I find all tables created using Phoenix?
Either using hbase shell or sqlline
Created 10-12-2020 09:53 AM
Hi @jeroenr Once you have connected to sqlline you can use # !tables to list the tables created by phoenix. By default SYSTEM.CATALOG", "SYSTEM.FUNCTION", "SYSTEM.LOG", "SYSTEM.MUTEX", "SYSTEM.SEQUENCE", "SYSTEM.STATS" are created.