升级hue后，hive查询窗口中，query中有中文时报字符集错误

hue中hive 查询窗口报 'ascii' codec can't decode byte 0xe5 in position 36: ordinal not

hue 的error log

  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/desktop/libs/notebook/src/notebook/decorators.py", line 114, in wrapper
    return f(*args, **kwargs)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 222, in execute
    response = _execute_notebook(request, notebook, snippet)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 153, in _execute_notebook
    response['handle'] = interpreter.execute(notebook, snippet)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 98, in decorator
    return func(*args, **kwargs)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 302, in execute
    handle = db.client.query(query, session=_session)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 1286, in query
    return self._client.execute_async_query(query, statement, session=session)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 968, in execute_async_query
    return self.execute_async_statement(statement=query_statement, confOverlay=configuration, session=session)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 995, in execute_async_statement
    (res, session) = self.call_return_result_and_session(self._client.ExecuteStatement, req, session=session)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 731, in call_return_result_and_session
    return self._call_return_result_and_session(fn, req, status=status, session=session)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 763, in _call_return_result_and_session
    res = fn(req)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/desktop/core/src/desktop/lib/thrift_util.py", line 416, in wrapper
    return attr(*args, **kwargs)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/desktop/core/src/desktop/lib/thrift_util.py", line 485, in wrapper
    ret = res(*args, **kwargs)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/apps/beeswax/gen-py/TCLIService/TCLIService.py", line 324, in ExecuteStatement
    self.send_ExecuteStatement(req)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/apps/beeswax/gen-py/TCLIService/TCLIService.py", line 331, in send_ExecuteStatement
    args.write(self._oprot)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/apps/beeswax/gen-py/TCLIService/TCLIService.py", line 2009, in write
    self.req.write(oprot)
  File "/opt/cloudera/parcels/CDH-6.3.0-1.cdh6.3.0.p0.1279813/lib/hue/apps/beeswax/gen-py/TCLIService/ttypes.py", line 3967, in write
    if self.statement is not None:
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe5 in position 36: ordinal not in range(128)

 

把错误涉及的代码文件中加入以下文件的编码方式 ，问题解决

import sys

reload(sys) 

sys.setdefaultencoding('utf-8')