Support Questions

Find answers, ask questions, and share your expertise

list Phoenix tables in hbase shell or sqlline


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



Cloudera Employee

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.