Hue does not list the tables post 5000 in number.

The limitation of display of 5000 tables is due to dbms.py script under Hue, below is the snippet of the script:

def get_tables(self, database='default', table_names='*'):
hql = "SHOW TABLES IN %s '%s'" % (database, table_names) # self.client.get_tables(database, table_names) is too slow
query = hql_query(hql)
handle = self.execute_and_wait(query, timeout_sec=15.0)

if handle:
result = self.fetch(handle, rows=5000)
self.close(handle)
return [name for table in result.rows() for name in table]
else:
return []


To increase the number of the tables displayed in Hue. Please do the following:

1. cp /usr/lib/hue/apps/beeswax/src/beeswax/server/dbms.py /tmp

2. Stop Hue service as 'service hue stop'.

3. Edit /usr/lib/hue/apps/beeswax/src/beeswax/server/dbms.py to change the rows value to 8000.

if handle:
result = self.fetch(handle, rows=8000) --> This value needs to be changed.
self.close(handle)
return [name for table in result.rows() for name in table]
else:
return []