arrow_back Apache Hive 3.1.2 Installation on Windows 10

comment Comments
Raymond Raymond #354 access_time 4 years ago more_vert

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. 

format_quote

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?


A Ankit Tiwari #353 access_time 4 years ago more_vert

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?


format_quote

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. 

Raymond Raymond #352 access_time 4 years ago more_vert

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. 

format_quote

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 ?


A Ankit Tiwari #351 access_time 4 years ago more_vert

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 ?


Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts