Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

104 lines (69 sloc) 3.962 kb
Requierment:
Linux or FreeBSD with Java, Hive and Hadoop on it.
Nginx && php 5.3+
To start Hive Thrift Server:
`$HIVE_HOME/bin/hive --service hiveserver 10000 &`
Installation:
1: run git clone git://github.com/xianglei/phpHiveAdmin.git
2: run install shell script to set environment and open config.inc.php
chmod +x install.sh
./install.sh
enter path of hadoop, hive and java
and then open config.inc.php
find and set define('HOST','127.0.0.1'); and define('PORT','10000'); #To your hive thrift server address and port.
find and set define('METADB','127.0.0.1'); and define('METAPORT', '3306'); #To your hive mysql metastore ip and port
find variables below in config.inc.php, change to your own path,and chmod etl,output_path,logs_path to 777 or 755
$env['lang_set'] = 'zh_CN.UTF-8'; #operation system language set
#$env['lang_set'] = 'en_US.UTF-8'; #if you are using with english uncomment this and comment zhCN
$env['udf'] = ' -i '.$env['hive_home'].'/BfUDF/hive_init.q'; #command to run your udf functions, it maybe a jar or other initialized script. if there is no udf, leave it empty .
$env['seperator'] = "\t";#seperator(delimiter) set for hive external table
Then?
No then, surfing in the data.
IMPORTANT:
for localized language using,modify /config.inc.php
in this files, change "langs/lang_xx.php" to your language set.
accesslist intro:
[0]
;userset order above
username=yourname
password=yourpass
privdb=all #the database that this user can see
mrslots=map slots,reduce slots #(not used in recent version, but future will be)
role=superadmin( dbadmin, user ) #superadmin means can read all databases and admin them, dbadmin means can read privdb setted dbs and admin them, user means can only read from privdb setted dbs
if you want to show all db, put "all" on "onlydb" area, else onlydb(s) use comma to seperate.
-------------------Chinese中文安装说明-----------------------------
系统要求:
包含Java, Hive 和 Hadoop 的 Linux 或 FreeBSD服务器.
Nginx 与 php 5.3+
启动Hive thrift服务:
`$HIVE_HOME/bin/hive --service hiveserver &`
安装步骤:
1: 运行 git clone git://github.com/xianglei/phpHiveAdmin.git
2: 运行install.sh 并打开 config.inc.php
chmod+x install.sh
./install.sh
填写正确的HADOOP HIVE JAVA的HOME路径
找到 define('HOST','192.168.1.49'); and define('PORT','10000'); 并设置为你自己的hive thrift server地址.
找到 define('METADB','127.0.0.1'); and define('METAPORT', '3306'); #设置为你的hive元数据mysql地址和端口
在config.inc.php中找到以下变量,并修改为你自己的路径,请赋予etl,output_path,logs_path 777权限或755
$env['hadoop_home'] = '/opt/modules/hadoop/hadoop-0.20.203.0'; #hadoop安装的目录
$env['hive_home'] = '/opt/modules/hive/hive-0.7.1'; #hive安装的目录
$env['java_home'] = '/usr/java/jdk1.6.0_21'; #java安装目录
$env['lang_set'] = 'zh_CN.UTF-8'; #操作系统的语言设置
#$env['lang_set'] = 'en_US.UTF-8'; #如使用英文,则取消前面的注释,并注释掉中文设置
$env['udf'] = ' -i '.$env['hive_home'].'/BfUDF/hive_init.q'; #调用UDF的命令, 可能为jar文件或初始化脚本. 如果没有udf, 则设置为空
$env['seperator'] = "\t"; #hive中外部表数据的分隔符
然后?
就没有然后了,在数据里冲浪吧.
重要:
为本地化使用,修改config.inc.php中的如下部分
将"langs/lang_xx.php" 修改成你自己的语言设置.
验证部分accesslist.ini设置.
[0]
;userset order above
username=用户名
password=密码
privdb=该用户可见的数据库
mrslots=map slots,reduce slots(最近版本不会使用,但是未来会开放)
onlydb写all为全部访问,写数据库名则访问单独的数据库,库名可写多个,以英文逗号分隔。
role=superadmin( dbadmin, user ) #superadmin 可读取全部数据库并管理, dbadmin 可读取privdb设置的dbs并管理, user 仅可读取privdb设置的数据库,不能管理
Jump to Line
Something went wrong with that request. Please try again.