hue_安装

依赖

yum install -y asciidoc cyrus-sasl-devel cyrus-sasl-gssapi cyrus-sasl-plain gcc gcc-c++ krb5-devel libxml2-devel libxslt-devel openldap-devel python-devel openssl-devel sqlite-devel mysql-devel gmp-devel

yum install -y ant asciidoc cyrus-sasl-devel cyrus-sasl-gssapi gcc gcc-c++ krb5-devel libtidy libxml2-devel libxslt-devel openldap-devel python-devel sqlite-devel openssl-devel mysql-devel gmp-devel

初始化配置

[desktop]
  secret_key=woyaobianqiang

  http_host=10.10.10.90
  http_port=8888

  is_hue_4=true

  time_zone=Asia/Shanghai

  server_user=hadoop
  server_group=hadoop
  default_user=hadoop
  default_hdfs_superuser=hadoop

[[database]]
    engine=mysql
    host=10.10.10.90
    port=3306
    user=root
    password=z123

    name=hue

创建数据库

create database `hue` default character set utf8mb4 default collate utf8mb4_general_ci;

初始化数据库

/opt/hue/build/env/bin/hue syncdb
/opt/hue/build/env/bin/hue migrate

配置oracle_client

instantclient-basic;instantclient-sqlplus;instantclient-sdk;
export ORACLE_HOME=/opt/instantclient_11_2
yum install -y epel-release
yum install -y python-pip
pip -V
pip install cx_cx_Oracle

启动服务

/opt/hue/build/env/bin/supervisor

修改配置

• hue.ini

  # hdfs
  [[hdfs_clusters]]
      fs_defaultfs=hdfs://10.10.10.90:9000
      webhdfs_url=http://10.10.10.90:50070/webhdfs/v1
  
      hadoop_hdfs_home=/opt/hadoop3.2
      hadoop_bin=/opt/hadoop3.2/bin
      hadoop_conf_dir=/opt/hadoop3.2/etc/hadoop

  # yarn
  [[yarn_clusters]]
      resourcemanager_host=10.10.10.90

      resourcemanager_port=8032

      submit_to=True

      resourcemanager_api_url=http://10.10.10.90:8088

      history_server_api_url=http://10.10.10.90:19888 

  # 集成hive
  [beeswax]
      hive_server_host=10.10.10.90
      hive_server_port=10000
      hive_conf_dir=/opt/hive3.2.1/conf
      server_conn_timeout=120
      auth_username=hadoop
      auth_password=z123

• yarn-site.xml

  <!-- 启动聚合操作日志 -->
  <property>
      <name>yarn.log-aggregation-enable</name>
      <value>true</value>
  </property>

  <!-- 日志保留时间，秒 -->
  <property>
      <name>yarn.log-aggregation.retain-seconds</name>
      <value>106800</value>
  </property>

重启

• hadoop

start-dfs.sh
start-yarn.sh

nohup hive --service metastore &
nohup hive --service hiveserver2 &

• hue

CTRL+C
/opt/hue/build/env/bin/supervisor

浏览UI

http://10.10.10.90:8888/