Hive Management of ( Two )

Hive Management of ( Two )

Web Interface mode

  • Port number 9999
  • Starting mode :hive --service hwi
  • Access... Through a browser :http://<IP Address >:9999/hwi/

web Manager compilation and configuration

For the first time to perform hive --service hwi There may be a mistake

ls:cannot access /root.training.apache-hive-0.13.0-bin/lib/hive-hwi-*.war:No such file or directory

Usually a web The program is a war package , And in the present hive0.13 This is not included in the version web Management tools , So we're going to compile

from apache You can put it on the website apache-hive-0.13.0-src.tar.gz Download the source code

After downloading , Unzip this file

tar -zxvf apache-hive-0.13.0-src.tar.gz

Go to the source code folder ,ls Take a look. There's a hwi The catalog of , Go to this directory , I found that there was a web Catalog , Package all the files in this directory into one war package

cd apache-hive-0.13.0-src
pwd
ls
cd hwi/
ls
jar cvfM0 hive-hwi-0.13.0.war -C web/ .

hold war After the package is successfully packed , take war Package copy to hive Of lib Under the table of contents

cp hive-hwi-0.13.0.war ~/training/apache-hive-0.13.0-bin/lib/

After copying the past , It needs to be changed hive The configuration file

cd ~/training/apache-hive-0.13.0-bin/conf/
vi hive-site.xml

Go to the official website to see the relevant configuration parameters , Then add it to the configuration file

<property>
<name>hive.hwi.listen.host</name>
<value>0.0.0.0</value>
</property>
<property>
<name>hive.hwi.listen.port</name>
<value>9999</value>
</property>
<property>
<name>hive.hwi.war.file</name>
<value>lib/hive-hwi-0.13.0.war</value> </property>

After saving and exiting , use hive --service hwi Restart

INFO hwi.HWIServer: HWI is starting up

web Management tool started successfully

Now open the browser , Get into web Management interface

http://<IP Address >:9999/hwi/

There will be mistakes at this time HTTP ERROR 500

This mistake is because we need to put jdk Inside jar Package copy to hive Go to , Only in this way can we successfully visit web Manager

cp ~/training/jdk1.7.0_75/lib/tools.jar ~/training/apache-hive-0.13.0-bin/lib/

web Manager query operations

And then restart web Manager hive --service hwi

Refresh the page ,



Here we can query ( Be careful : stay web Under the manager, we can only query )

  • Browse Schema View the existing database
  • Create Session Create a session, Click on submit Submit and then perform a query operation



    Create a query ,silent mode silent mode on,start query Execute the query yes, Then click Submit

    appear Session is in QUERY_RUNNING state. Changes are not possible! The query cannot be changed in the execution state , This time you can click View File To see the results

hadoop Note it Hive Management of (web Interface mode ) More articles about

  1. hadoop Note it Hive Management of ( Remote login mode )

    Hive Management of ( 3、 ... and ) Hive Management of ( 3、 ... and ) Hive Remote services for Remote service startup mode Port number 10000 Starting mode :hive --service hiveserver ( Be careful : With JDBC or ODBC Program login ...

  2. hadoop Note it Hive Management of (CLI The way )

    Hive Management of ( One ) Hive Management of ( One ) Hive Mode of starting CLI( Command line ) The way Web Interface mode Remote service startup mode CLI The way 1. Enter command line mode Direct input <HIVE_HOME>/b ...

  3. HADOOP docker( 7、 ... and ):hive Rights management

    1. hive About permissions 1.1 hive Users and groups in 1.2 Use scenarios 1.3 The permissions model 1.3 hive Super users of 2. Authorization management 2.1 Turn on permission management 2.2 Achieve super users 2.3 Realization hiveserver2 user ...

  4. hadoop Note it Hive Data storage ( Internal table )

    Hive Data storage ( Internal table ) Hive Data storage ( Internal table ) be based on HDFS You can use hadoop For us web Manage tools to view data . Open management tools localhost:9000–>Utilities Under the ...

  5. tomcat management web Interface

    stay /usr/tomcat/apache-tomcat-7.0.47/conf/tomcat-users.xml in <?xml version='1.0' encoding='utf-8'?> ...

  6. hadoop Note it Hive introduction ( What is? Hive)

    Hive introduction ( One ) Hive introduction ( One ) What is? Hive? Hive It's a data warehouse , A data warehouse is a database , But it is different from the general database actually ,Hive Is built on hadoop HDFS A data warehouse on . ...

  7. hadoop Note it Hive introduction (Hive Architecture of )

    Hive introduction ( Two ) Hive introduction ( Two ) Hive Architecture of ○ Hive Metadata Hive Store metadata in a database (metastore), Support mysql.derby.oracle Such as the database ,Hive The default is ...

  8. hadoop note (hive)

    //**********************************// Installation configuration 1. Modify the configuration file 1.1 stay conf Under the folder touch hive-site.xml <configurat ...

  9. hadoop Note it Hive Data storage ( View )

    Hive Data storage ( View ) Hive Data storage ( View ) View (view) A view is a virtual table , It 's a logical concept : It can span multiple tables Since a view is a virtual table , That is to say, views can also be operated in the way of operation table But the view is built on ...

Random recommendation

  1. The Chinese Academy of Sciences Oracle 10G Database system training video tutorial (828MB )

    The Chinese Academy of Sciences Oracle 10G Database system training video tutorial (828MB  ) Chapter one . Installation and Architecture Overview Oracle Basic knowledge of database Chapter 2 .SQL*PLUS Basics . Instance creation, startup and shutdown Chapter 3 .SQL Language foundation four ...

  2. Linux Daemon (init.d and xinetd)

    http://www.cnblogs.com/itech/archive/2010/12/27/1914846.html

  3. Python+Django+SAE Series of tutorials 17-----authauth ( Certification and authorization ) System 1

    adopt session, We can keep data in multiple browser requests , The next part is to use session To handle user login . Of course , You can't just rely on the user's words , We believe in , So we need certification . Yes, of course ,Django Also provided ...

  4. JS frame ~Angularjs

    Come across anytao Project , The workbench , Used Angularjs frame , I feel that the user experience is quite good in front-end performance , So I took a brief look , It's easy to use , Or say , People package the code very well , It's so easy for developers to call , ha-ha ...

  5. L Type code structure case :Link Access right ( On )

    This is the first step in loose pair programming 20 piece ( Column catalog ). In this paper Link The best way to implement access rights , Strive for clean appearance and good packaging . These codes will be located in L Type code structure ( See loose pair programming series for definitions ) The lower level , The caller does not need to understand the principle . By the way ...

  6. UML And pattern

    UML And pattern application learning notes -2( Iterative and evolutionary development )   One : What is iterative and evolutionary development 1: Iterative and evolutionary development : It's common to assume that development begins without having defined all the requirements in detail , At the same time, feedback is used to clarify and improve the evolving specifications : ...

  7. delphi odbc Remote connection sqlserver

    ip Format xx.xx.xx.xx,port ip And the port number is a comma

  8. translate :select into outfile( Submitted to MariaDB The official manual )

    This paper is about mariadb The official manual :SELECT INTO OUTFILE Translation of . original text :https://mariadb.com/kb/en/select-into-outfile/ I submit to MariaDB ...

  9. BEM A thorough understanding of thought BEM grammar

    BEM It means block (block). Elements (element). Modifier (modifier), By Yandex A front-end naming methodology proposed by the team . This clever way of naming makes your CSS Classes are more transparent and meaningful to other developers ...

  10. iPhone8 After the release of those funny Geek A collection of jokes # Selected funny GEEK Duan Zi

    These jokes can make people laugh like pigs, ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha ha high energy alert ! Please put on your helmet and watch the performance of the storytellers   I can only help you here With half a bang , It's like cooperating with tmall ? Durex's hot pursuit is also timely ! Ten years is like a day ...