Support Questions

Find answers, ask questions, and share your expertise

list Phoenix tables in hbase shell or sqlline

avatar
Explorer

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

 

1 REPLY 1

avatar
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.