Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

list Phoenix tables in hbase shell or sqlline

list Phoenix tables in hbase shell or sqlline

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
Highlighted

Re: list Phoenix tables in 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.

Don't have an account?
Coming from Hortonworks? Activate your account here