All geek questions in one place

Hive-site.xml path in hive0.13.1

I'm new at this. I would like to know the location of the hive-site.xml and hive-default.xml files in hive-site.xml version.

I downloaded the hive0.13.1-bin version from the location below. http://apache.mirrors.pair.com/hive/hive-0.13.1/

Extracted and configured hive environment variables.
I can run the commands (create table, show, load data, query table..) .

But in the conf(/hive/hive-0.13-1/conf) directory conf(/hive/hive-0.13-1/conf) I do not see the hive-site.xml and hive-default.xml files.

Where are these files located in hive-0.13.1 ?

+5
source share
2 answers

follow the steps

1) Extract folder

2) go to / apache -hive-0.13.1-bin / conf and create a copy of the hive-default.xml.template file, this is similar to hive-default.xml (copy) .template.

3) Rename hive-default.xml (copy) .template to hive-site.xml.

4) Make a copy of the hive-env.sh.template file for hive-env.sh.

add to hive-env.sh

 export HADOOP_HEAPSIZE=1024 # Set HADOOP_HOME to point to a specific hadoop install directory export HADOOP_HOME=/home/user17/BigData/hadoop #hive export HIVE_HOME=/home/user17/BigData/hive # Hive Configuration Directory can be controlled by: export HIVE_CONF_DIR=$HIVE_HOME/conf

5) export the hadoop and hive path to a .bashrc file

 export HADOOP_HOME=/home/user17/BigData/hadoop export PATH=$PATH:$HADOOP_HOME/bin export HIVE_HOME=/home/user17/BigData/hive export PATH=$PATH:$HIVE_HOME/bin

run your haop

 start-all.sh

enjoy your hive. Give the way how and hive in the export team to suit your system. I know if it doesn't work.

+7
source

You cannot find the hive-site.xml in the conf directory. You have to do it. And hive-site.xml looks like this:

 <?xml version="1.0"?> <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> <!-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. --> <configuration> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true</value> <description>the URL of the MySQL database</description> </property> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> </property> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>root</value> </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>root</value> </property> <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.12.0.war</value> </property> <!-- <property> <name>hive.metastore.local</name> <value>true</value> </property> --> </configuration>

And find some concepts about beehive metadata in mysql.

+5
source

Source: https://habr.com/ru/post/1208093/

More articles:


All Articles