- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
list Phoenix tables in hbase shell or sqlline
- Labels:
-
Apache Phoenix
Created ‎08-20-2020 05:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
