How to resolve hue configuration

[#1]

Hi all,

 im getting configuration issues

recently changed thrift server timeout and limit beewax to 10000

[#2]

@syedshakir 

Hue database requires UTF8 character set. Please refer below document

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/hue_dbs_mysql.html#concept_vjx_lrl_w...

Regarding the alerts with hive and impala, please check below points:

1. Hive and Impala service should be enabled with Hue under Hue -> Configuration -> Hive/Impala Service

2. Add the respective hive server and Impala ports uder the below Hue configuration on Cloudera Manager.

Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini

[impala]
server_port=<portnumber>
[beeswax]
hive_server_port=<portnumber>

3. Restart the Hue service post the changes.

Hope this helps,

Paras

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

[#3]

Hi Paras,

i have existing database but in article it s for new database . my question how to apply utf8 to existing database

Thanks, Syed

[#4]

@syedshakir 

For existing DB, stop the hue service and alter the DB using below query:

ALTER DATABASE hue CHARACTER SET utf8 ;

ALTER DATABASE hue COLLATE = 'utf8_general_ci';

Start the hue service.

Hope this helps,

Paras

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.