arrow_back Apache Hive 3.0.0 Installation on Windows 10 Step by Step Guide
Did you get Hadoop installation successfully first?
This is a HDFS CLI issue and is not related to Hive installation.
person Swati Agarwal access_time 5 years ago
Hi Team,
At step, Set up Hive HDFS folders while creating dir using hadoop fs -mkdir /tmp at cmd, the system is throwing an error.
mkdir: Your endpoint configuration is wrong
Please suggest how to resolve this.
Regards,
Swati
Hi Team,
At step, Set up Hive HDFS folders while creating dir using hadoop fs -mkdir /tmp at cmd, the system is throwing an error.
mkdir: Your endpoint configuration is wrong
Please suggest how to resolve this.
Regards,
Swati
You mentioned $HIVE_PATH in one of the previous comments while it should be $HIVE_HOME. Can you please double check that?
Based on what you have described and also if I understand correctly:
Your issue is that you cannot run the following command successfully:
$HIVE_HOME/bin/schematool -dbType derby -initSchema
And you got error: no such file or directory exist.
Usually this issue will happen if:
- No x permission (execute) for your account on schematool file, which is why I recommended to check that permission and add it if missing.
- Or as the error message self-described, the path doesn't exist. For example, it may be because your $HIVE_HOME environment variable is not setup correctly. I would recommend to follow the steps below to add it into your .bashrc file and then re-run the schema initialisation command:
1) Edit file ~/.bashrc by running the following command
vi ~/.bashrc
2) Add the following line at the end of the file:
export HIVE_HOME={your hive home folder path}
3) Source the settings
source ~/.bashrc
And then run the command:
$HIVE_HOME/bin/schematool -dbType derby -initSchema
If the above suggestions don't work still, I'm not sure whether I can help more unless you provide screenshots about your Cygwin window, hive folder, and detailed error messages here.
You can upload images in the comment section directly. Or alternatively, write me an email at enquiry[at]kontext.tech
person Ba*** access_time 5 years ago
So, $HIVE_HOME/bin was in the path. So, I just ran schematool -dbType mysql -initSchema. Also, before that I did hive -service metastore.
So, $HIVE_HOME/bin was in the path. So, I just ran schematool -dbType mysql -initSchema. Also, before that I did hive -service metastore.
Can you run the following command in Cygwin to see if the script file is executable?
ls -alt $HIVE_HOME/bin
-rwxr-xr-x+ 1 fahao fahao 832 May 16 2018 metatool
-rwxr-xr-x+ 1 fahao fahao 884 May 16 2018 schematool
The output should look like the above one. 'x' means execution permission. You will need that permission before you can execute the scripts.
If no permission, please try the following command to add it:
chmod +x $HIVE_HOME/bin/schematool
person Ba*** access_time 5 years ago
Yes, I did. When I go the path from cygwin, and do a ls, I see schematool there. Also when I print $HIVE_PATH and $HADOOP_PATH I get the correct location.
Yes, I did. When I go the path from cygwin, and do a ls, I see schematool there. Also when I print $HIVE_PATH and $HADOOP_PATH I get the correct location.
person Bali access_time 5 years ago
When I try to run $HIVE_HOME/bin/schematool -dbType derby -initSchema I get no such file or directory exist. But when I go to the exact location with cd and run ls, I see the file there. Also, when I echo HIVE_HOME it return me the exact path.
When I try to run $HIVE_HOME/bin/schematool -dbType derby -initSchema I get no such file or directory exist. But when I go to the exact location with cd and run ls, I see the file there. Also, when I echo HIVE_HOME it return me the exact path.
Hi Team,
Yes it was installation issue. Thanks for the help.
I am new to Hadoop 3, and would seek your guidance.
For installing and working in Hadoop 3, we have to follow:
1) Hadoop 3 installation process
https://kontext.tech/docs/DataAndBusinessIntelligence/p/install-hadoop-300-in-windows-single-node
2) Hive process
https://kontext.tech/docs/DataAndBusinessIntelligence/p/apache-hive-300-installation-on-windows-10-step-by-step-guide
Please correct me if I am wrong.
Is there anything else that is required to be installed or set up? Please suggest and guide me.
Also can we connect over linkedin? If I get stuck somewhere I would need your expert advice.
My linkedin id is : https://www.linkedin.com/in/swati0303/
It will be really really helpful.
Regards,
Swati