apache hive - Hive-Login Problems - hive tutorial - hadoop hive - hadoop hive - hiveql
What is Hive Login?
- Hive uses log4j for log in
- By default logs are not emitted to the console by the CLI.
- The default log in level is WARN for Hive releases prior to 0.13.0. The default logging level is INFO.
apache hive related article tags - hive tutorial - hadoop hive - hadoop hive - hiveql - hive hadoop - learnhive - hive sql
How to login to Hive?
- In order to log in into hive, we need to register and hence we will given a username and password
- Hence the log in for hive has been executed successfully
Learn Hive Tutorials - Hive Login - Hive Example
Problems while log in to hive
- Here are some problems while logging into hive and they are explained below
- If we don’t know the username and password in order to log into the hive account and hence there is a log in problem in hive
- Hence hive cannot be login with android device but if we try to login with another devices rather than android it works
- Some of the android versions does not support hive and hence you can’t log into hive if the android version does not support the following specifications which is necessary and require to log in for hive
- If there are any problems which logging into hive, check the log files in the logs directory to see if there are any errors in it and if there is an error there will be a problem while logging into hive.
Hive Log in Format
- We have mentioned the Hive error logging format. This file format has a specific format and hence this is regularly used.
apache hive related article tags - hive tutorial - hadoop hive - hadoop hive - hiveql - hive hadoop - learnhive - hive sql
Hive Error Log in Explained
- Below we will describe how to read an entry you might encounter when examining the hive error log in file (/usr/local/apache/logs/error_log).
Code:
[Thu Nov 18 05:31:50 2010] [error] [client 83.110.135.140] Premature end of script headers: /home/username/public_html/dir/file.php
Clicking "Copy Code" button will copy the code into the clipboard - memory. Please paste(Ctrl+V) it in your destination. The code will get pasted. Happy coding from Wikitechy hive tutorial team
- Hence this line tell us the statement for hive error logging
- When the logging error is found Time stamp denoting the exact second when the log in error occurred.
- Client shows the IP address for which the log in error is generated.
- We will list a few example error log in messages with an explanation below
- File does not exist: <file path> -which identifies a missing file
- Premature end of script headers: <file path> is a problem which is given with the script which was run
- mod_rewrite: maximum number of internal redirects reached. Hence it assumes configuration error. Use 'RewriteOptions MaxRedirects' to increase the limit if it is necessary
- Most commonly error message from the Hive error log in will lead directly to the problem resolution.
apache hive related article tags - hive tutorial - hadoop hive - hadoop hive - hiveql - hive hadoop - learnhive - hive sql
Solution to Hive Problems
- Connect to the HDInsight cluster with a Secure Shell (SSH) client
- Run the following command on the HDInsight cluster where from we want to export the metastore:
Syntax:
apache
for d in `hive -e "show databases"`; do echo "create database $d; use $d;" >> alltables.sql ; for t in `hive --database $d -e "show tables"` ; do ddl=`hive --database $d -e "show create table $t"`; echo "$ddl ;" >> alltables.sql ; echo "$ddl" | grep -q "PARTITIONED\s*BY" && echo "MSCK REPAIR TABLE $t ;" >> alltables.sql ; done; done
Clicking "Copy Code" button will copy the code into the clipboard - memory. Please paste(Ctrl+V) it in your destination. The code will get pasted. Happy coding from Wikitechy hive tutorial team
- This will generate a file named alltables.sql.
- Copy the file alltables.sql to the new HDInsight cluster and run the following command:
Code:
apache
hive -f alltables.sql
Clicking "Copy Code" button will copy the code into the clipboard - memory. Please paste(Ctrl+V) it in your destination. The code will get pasted. Happy coding from Wikitechy hive tutorial team
- This code assumes that data paths on new cluster on HDFS.Hence the log in problem for hive has been solved completely using HDInsight cluster.