[Hue] Hue 4.10.0 설치 가이드

HUE 다운로드

원하는 휴 선택하여 다운로드
https://github.com/cloudera/hue/tags

GitHub - cloudera/hue: Open source SQL Query Assistant service for Databases/Warehouses

 

Dependency 무한고통

mvn, database 설치후 기본적인 세팅은 완료 (hue 데이터 베이스와 유저 생성 작업까지 !)

python pip upgrade

curl https://bootstrap.pypa.io/pip/2.7/get-pip.py -o get-pip.py
python get-pip.py
pip install --upgrade pip

python package 설치

pip install psycopg2
pip install psycopg2-binary

OS Package 설치

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

SQLite 버전 업그레이드 (hue django 때문에 너무 아래버전일수록 설치 안됨)

https://kojipkgs.fedoraproject.org/packages/sqlite/

Index of /packages/sqlite

여기서 맞는 sqlite rpm, sqlite-devel rpm 다운로드

wget https://kojipkgs.fedoraproject.org/packages/sqlite/3.12.2/1.fc24/x86_64/sqlite-3.12.2-1.fc24.x86_64.rpm
wget https://kojipkgs.fedoraproject.org/packages/sqlite/3.12.2/1.fc24/x86_64/sqlite-devel-3.12.2-1.fc24.x86_64.rpm

rpm -Uvh sqlite-3.12.2-1.fc24.x86_64.rpm sqlite-devel-3.12.2-1.fc24.x86_64.rpm

HUE Build

desktop/devtools.mk 수정

DEVTOOLS += \
        ipython[7.10.0] \
        ipdb[0.13.9] \

휴 빌드

cd ${HUE_SRC}
make apps

 

HUE Start

[hue database 동기화] build/env/bin/hue migrate 
[hue server 시작] build/env/bin/hue runserver 0.0.0.0:8000
[hue login] user id/ password -admin/admin
[hdfs user 생성] hdfs dfs -mkdir /user/admin
[hdfs user dir 권한변경] hdfs dfs -chown -R admin:admin /user/admin

 

HUE Configs

vi ${HUE_SRC}/desktop/conf/pseudo-distributed.ini
  [[database]]
    engine=postgresql_psycopg2
    host=1.2.3.4
    name=hue
    port=5432
    user=hue
    password=hue


[hadoop]
  # Configuration for HDFS NameNode
  # ------------------------------------------------------------------------
  [[hdfs_clusters]]
    # HA support by using HttpFs
    [[[default]]]
      # Enter the filesystem uri
      fs_defaultfs=hdfs://1.2.3.4:8020
      webhdfs_url=http://1.2.3.4:50070/webhdfs/v1
# ------------------------------------------------------------------------     
[beeswax]
  hive_server_host=1.2.3.4
  hive_server_port=10000
  hive_server_http_port=10001
  max_number_of_sessions=3
  thrift_version=11
  use_sasl=true
  # ------------------------------------------------------------------------
[hbase]
  hbase_clusters=(Cluster|1.2.3.4:9090)
  thrift_transport=buffered
  ssl_cert_ca_verify=false