Hue的那些坑。。

1、hue的报错信息为

Error: 1366: Incorrect string value

解决办法：

在元数据库执行以下语句：

alter database hue character set latin1;
alter table beeswax_queryhistory modify `query` longtext CHARACTER SET utf8 COLLATE utf8_general_ci  NOT NULL;
           

2、hue报错信息为

ProgrammingError at /

(1146, “Table ‘hue.django_session’ doesn’t exist”)

Request Method: GET

Request URL: http://10.0.153.236:8000/

Django Version: 1.11.20

Exception Type: ProgrammingError

Exception Value:

(1146, “Table ‘hue.django_session’ doesn’t exist”)

Exception Location: /apps/hue/build/env/lib/python2.7/site-packages/Django-1.11.20-py2.7.egg/django/db/models/sql/compiler.py in execute_sql, line 899

Python Executable: /apps/hue/build/env/bin/python2.7

解决方法，初始化hue元数据

bin/hue syncdb
bin/hue migrate