arrow_back Apache Hive 3.1.2 Installation on Windows 10
person Ankit access_time 4 years ago
Hi Raymond,
I faced issues during Hive installation, so did the complete process again and found that Schematool step has some issues.
Please see the below screen-shot. It says that "Found configuration file null" conf.Hiveconf.
I guess that's why my metastore step has issues.
There are a lot of blank lines in the schematool log.
If you know what can be done to fix this, could you please help me?
Hi Raymond,
I faced issues during Hive installation, so did the complete process again and found that Schematool step has some issues.
Please see the below screen-shot. It says that "Found configuration file null" conf.Hiveconf.
I guess that's why my metastore step has issues.
There are a lot of blank lines in the schematool log.
If you know what can be done to fix this, could you please help me?
person Raymond access_time 4 years ago
Hi Ankit,
If you are using default derby as metastore, you cannot open multiple sessions. When you run the command yes you can still see logs but you can press enter so that you can input commands without starting a new session.
If you prefer to allow multiple sessions, please follow the link to use a remote metastore like SQL Server.
Hi Ankit,
If you are using default derby as metastore, you cannot open multiple sessions. When you run the command yes you can still see logs but you can press enter so that you can input commands without starting a new session.
If you prefer to allow multiple sessions, please follow the link to use a remote metastore like SQL Server.
person Ankit access_time 4 years ago
Hi Raymond,
Thanks for sharing the links for installation of additional Hadoop softwares.
I started with installing Hive.
When I run the command $HIVE_HOME/bin/hive --service metastore &
the command keeps running and I do not get the command prompt back.
So I opened another Cygwin terminal to run the below command.
$HIVE_HOME/bin/hive --service hiveserver2 start &
Then I opened a 3rd Cygwin terminal to run the commands
$HIVE_HOME/bin/beeline -u jdbc:hive2://localhost:10000
$HIVE_HOME/bin/hive
and got the below message.
Could you please guide me if I need to change it ?
Hi Raymond,
Thanks for sharing the links for installation of additional Hadoop softwares.
I started with installing Hive.
When I run the command $HIVE_HOME/bin/hive --service metastore &
the command keeps running and I do not get the command prompt back.
So I opened another Cygwin terminal to run the below command.
$HIVE_HOME/bin/hive --service hiveserver2 start &
Then I opened a 3rd Cygwin terminal to run the commands
$HIVE_HOME/bin/beeline -u jdbc:hive2://localhost:10000
$HIVE_HOME/bin/hive
and got the below message.
Could you please guide me if I need to change it ?
For some of my previous configurations, the logs were not printed out either.
Can you please check whether there is a folder named metastore_db created? It should be ok if the folder exists and have content.
To make everything easy, I would suggest to install SQL Server express or Developer edition and then configure your Hive metastore to use SQL Server:
https://kontext.tech/column/hadoop/302/configure-a-sql-server-database-as-remote-hive-metastore
If it still doesn't work, please send an email to enquiry[at]kontext.tech and I can arrange a Teams meeting with you to debug.