How to view Tables in Hue Database


Use following commands:

mysql> mysql -u hue -p

mysql> use hue ;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+——————————–+
| Tables_in_hue |
+——————————–+
| auth_group |
| auth_group_permissions |

 

Set Hue uses UTF8 collation and character set


mysql> CREATE DATABASE hue COLLATE = ‘utf8_general_ci’;
ERROR 1007 (HY000): Can’t create database ‘hue’; database exists
mysql> SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;
+————–+——————–+—————————-+————————+———-+
| CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH |
+————–+——————–+—————————-+————————+———-+
| NULL | information_schema | utf8 | utf8_general_ci | NULL |
| NULL | hue | utf8 | utf8_general_ci | NULL |
+————–+——————–+—————————-+————————+———-+
2 rows in set (0.00 sec)

mysql> ALTER DATABASE hue COLLATE = ‘utf8_general_ci’;
Query OK, 1 row affected (0.00 sec)