HIVE配置啟動Hwi方法,版本0.14.0
1.下載原始碼包:
wget
2.解壓,並找到 hwi/web
3.打包 hwi/web/ 所有檔案
4.將打包好的檔案複製到 $HOME_HIVE/lib下
mv hive-hwi-0.14.0.zip ~/hive/lib/hive-hwi-0.14.0.war
5.修改 hive-site.xml 檔案
6.複製 tools.jar(jdk的lib包下面的jar包) 到 hive/lib下
7.啟動 hive hwi 服務
8.在頁面開啟
點選 schema 看下:
在命令列下檢視 下我們的資料庫:
到此,OK了。
更多測試,大家自行去測試..
wget
2.解壓,並找到 hwi/web
點選(此處)摺疊或開啟
- [zhang@namenode Downloads]$ cd apache-hive-0.14.0-src
- [zhang@namenode apache-hive-0.14.0-src]$ ls
- accumulo-handler bin common data hcatalog jdbc NOTICE pom.xml RELEASE_NOTES.txt shims
- ant checkstyle conf docs hwi LICENSE odbc ql serde testutils
- beeline cli contrib hbase-handler itests metastore packaging README.txt service
- [zhang@namenode apache-hive-0.14.0-src]$ cd hwi/web/
- [zhang@namenode web]$ ls
- authorize.jsp error_page.jsp left_navigation.jsp session_diagnostics.jsp session_list.jsp session_result.jsp show_table.jsp
- css img navbar.jsp session_history.jsp session_manage.jsp show_database.jsp view_file.jsp
- diagnostics.jsp index.jsp session_create.jsp session_kill.jsp session_remove.jsp show_databases.jsp WEB-INF
點選(此處)摺疊或開啟
- [zhang@namenode web]$ zip hive-hwi-0.14.0.zip ./*
- adding: authorize.jsp (deflated 56%)
- adding: css/ (stored 0%)
- adding: diagnostics.jsp (deflated 55%)
- adding: error_page.jsp (deflated 50%)
- adding: img/ (stored 0%)
- adding: index.jsp (deflated 48%)
- adding: left_navigation.jsp (deflated 54%)
- adding: navbar.jsp (deflated 49%)
- adding: session_create.jsp (deflated 54%)
- adding: session_diagnostics.jsp (deflated 54%)
- adding: session_history.jsp (deflated 58%)
- adding: session_kill.jsp (deflated 50%)
- adding: session_list.jsp (deflated 54%)
- adding: session_manage.jsp (deflated 67%)
- adding: session_remove.jsp (deflated 51%)
- adding: session_result.jsp (deflated 54%)
- adding: show_database.jsp (deflated 52%)
- adding: show_databases.jsp (deflated 50%)
- adding: show_table.jsp (deflated 68%)
- adding: view_file.jsp (deflated 53%)
- adding: WEB-INF/ (stored 0%)
- [zhang@namenode web]$ ls
- authorize.jsp error_page.jsp index.jsp session_create.jsp session_kill.jsp session_remove.jsp show_databases.jsp WEB-INF
- css hive-hwi-0.14.0.zip left_navigation.jsp session_diagnostics.jsp session_list.jsp session_result.jsp show_table.jsp
- diagnostics.jsp img navbar.jsp session_history.jsp session_manage.jsp show_database.jsp view_file.jsp
mv hive-hwi-0.14.0.zip ~/hive/lib/hive-hwi-0.14.0.war
5.修改 hive-site.xml 檔案
點選(此處)摺疊或開啟
-
<property>
-
<name>hive.hwi.listen.host</name>
-
<value>0.0.0.0</value>
-
<description>This is the host address the Hive Web Interface will listen on</description>
-
</property>
-
<property>
-
<name>hive.hwi.listen.port</name>
-
<value>9999</value>
-
<description>This is the port the Hive Web Interface will listen on</description>
-
</property>
-
<property>
-
<name>hive.hwi.war.file</name>
-
<value>lib/hive-hwi-0.14.0.war</value>
-
<description>This sets the path to the HWI war file, relative to ${HIVE_HOME}. </description>
-
</property>
- <property>
6.複製 tools.jar(jdk的lib包下面的jar包) 到 hive/lib下
點選(此處)摺疊或開啟
- 192.168.78.129 namenode
- [zhang@namenode lib]$ cp /usr/java/jdk1.8.0_25/lib/tools.jar ./
- [zhang@namenode lib]$ ls |grep -i tools.jar
- tools.jar
7.啟動 hive hwi 服務
點選(此處)摺疊或開啟
- [zhang@namenode bin]$ ./hive --service hwi
- 15/01/20 00:09:09 INFO hwi.HWIServer: HWI is starting up
- 15/01/20 00:09:09 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
- 15/01/20 00:09:09 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist
- SLF4J: Class path contains multiple SLF4J bindings.
- SLF4J: Found binding in [jar:file:/home/zhang/hadoop-2.5.2/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
- SLF4J: Found binding in [jar:file:/home/zhang/hive/lib/hive-jdbc-0.14.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]
- SLF4J: See for an explanation.
- SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
- 15/01/20 00:09:09 INFO mortbay.log: Logging to org.slf4j.impl.Log4jLoggerAdapter(org.mortbay.log) via org.mortbay.log.Slf4jLog
- 15/01/20 00:09:09 INFO mortbay.log: jetty-6.1.26
- 15/01/20 00:09:09 INFO mortbay.log: Extract /home/zhang/hive/lib/hive-hwi-0.14.0.war to /tmp/Jetty_0_0_0_0_9999_hive.hwi.0.14.0.war__hwi__.90h87k/webapp
- 15/01/20 00:09:10 INFO mortbay.log: Started SocketConnector@0.0.0.0:9999
8.在頁面開啟
點選 schema 看下:
在命令列下檢視 下我們的資料庫:
點選(此處)摺疊或開啟
- hive> show databases;
- OK
- default
- temp
- Time taken: 0.477 seconds, Fetched: 2 row(s)
更多測試,大家自行去測試..
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28929558/viewspace-1408291/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Hive-0.14.0版本,本地獨立模式,MySQL作為後設資料庫Hive模式MySql資料庫
- Apache Hive啟動報NoClassDefFoundError錯誤ApacheHiveError
- hive on spark配置HiveSpark
- 【Hive一】Hive安裝及配置Hive
- 基於Hadoop不同版本搭建hive叢集(附配置檔案)HadoopHive
- springboot連線hive無法啟動Spring BootHive
- HP-UX啟動停止配置sendmail服務方法UXAI
- Hive1.2.1 啟動報錯 ClassNotFoundException: org.apache.hadoop.hive.service.HiveServerHiveExceptionApacheHadoopServer
- Hive安裝配置Hive
- Hive多視窗啟動異常(已解決!)Hive
- 啟動hive不成功namenode處於安全模式Hive模式
- HIVE的安裝配置Hive
- MySQL配置與啟動MySql
- MongoDB配置與啟動MongoDB
- redis sentinel配置啟動Redis
- goland的啟動配置GoLand
- Hive原始碼分析(1)——HiveServer2啟動過程Hive原始碼Server
- Linuxfirewalld配置與systemctl開啟啟動配置(轉載)Linux
- Hive的安裝與配置Hive
- Hive metastore三種配置方式HiveAST
- Hive配置與操作實踐Hive
- Ubuntu自動啟動配置指令碼Ubuntu指令碼
- Supervisor安裝、配置、開啟啟動
- Linux配置開機自啟動執行指令碼方法有哪些?Linux指令碼
- centos7上配置MySQL5.7的開機自啟動方法CentOSMySql
- Hive遠端模式安裝配置Hive模式
- Hive 啟動異常: java.net.URISyntaxException: Relative path in absolute URI:HiveJavaException
- springboot 配置熱啟動 不需重啟自動部署Spring Boot
- oracle配置開機自啟動Oracle
- 讓oracle自動啟動方法!(轉)Oracle
- Hive動態分割槽Hive
- 4 配置Oracle資料庫自動啟動Oracle資料庫
- linux 配置oracle+asm自動啟動LinuxOracleASM
- Apollo啟動配置排查,超時時間的配置
- OpenHarmony的init程式、init配置與啟動項配置
- Zabbix Agent active主動模式配置圖文版本模式
- hive-3.0.0 版本中遇到的bug 彙總Hive
- 怎麼啟動 VIM?14 個 VIM 啟動引數和啟動方法詳解