Search code examples
hadoophive

Install Hive on windows: 'hive' is not recognized as an internal or external command, operable program or batch file

I have installed Hadoop 2.7.3 on Windows and I am able to start the cluster. Now I would like to have hive and went through the steps below: 1. Downloaded db-derby-10.12.1.1-bin.zip, unpacked it and started the startNetworkServer -h 0.0.0.0.
2. Downloaded apache-hive-1.1.1-bin.tar.gz from mirror site and unpacked it. Created hive-site.xml to have below properties:

javax.jdo.option.ConnectionURL
javax.jdo.option.ConnectionDriverName
hive.server2.enable.impersonation
hive.server2.authentication
datanucleus.autoCreateTables
hive.metastore.schema.verification

I have also setup HIVE_HOME and updated path. Also set HIVE_LIB and HIVE_BIN_PATH.

When I run hive from bin I get 'hive' is not recognized as an internal or external command, operable program or batch file.

The bin/hive appears as filetype File. Please suggest. Not sure if the hive version is correct one.

Thank you.

Solution

  • i also run into this problem. to get necessary file to run hive on windows i have downloaded hive-2.3.9 and hive-3.1.2 but none of them have this files.so, we have two option:

    Option 1: install hive-2.1.0 and set it up as i have tried,

    Hadoop 2.8.0
    derby 10.12.1.1
    hive 2.1.0

    Option 2: download whole bin directory and replace with yours hive bin directory. for downloading bin we need wget utility for windows. after that run this command(to understand how it works):

    wget -r -np -nH --cut-dirs=3 -R index.html https://svn.apache.org/repos/asf/hive/trunk/bin/

    your downloaded bin looks like: Downloaded bin directory image

    after replacing it you are ready to go. so now my configurations are as below:

    Hadoop 3.3.1
    derby 10.13.1.1
    hive 2.3.9