Questions tagged [hive]

6 questions
11
votes
2 answers

How do I install the "Beeline" Hive client?

How can I install the hive client beeline without having to install all the hive/hadoop ecosystem on my laptop? I want to use it to query a remote Hive database.
lucacerone
  • 1,721
5
votes
1 answer

FAILED: HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

I'm trying to run Hive 3.1 with Hadoop 3.0. Following is my system configuration: Ubuntu 18.04.1 LTS Hadoop version 3.0.3 Hive 3.1.0 Derby 10.14.2 When I execute the show tables; query I get the following error. FAILED: HiveException…
2
votes
1 answer

Configuring JAVA HOME for Hadoop 3.0.3 when having multiple Java versions

I'm working on a Hadoop installation done by someone else. Ubuntu 18.04.1 LTS Hadoop version 3.0.3 Java open jdk 11 (auto mode) and 8 (manual mode) Currently Hadoop runs with Java 11 but I want to configure Hadoop to run with Java 8 because Hive…
1
vote
1 answer

On Hadoop installation, bash: gives an 'is a directory error'

When I run the command: $ $HADOOP_INSTALL/etc/hadoop fs -mkdir /tmp it gives me the following error: bash: /etc/hadoop-2.7.1/etc/hadoop: Is a directory These are the contents of my .bashrc file: # ~/.bashrc: executed by bash(1) for non-login…
user642283
  • 193
  • 1
  • 9
0
votes
1 answer

Sqoop import from MySQL to Hive throwing HIVE_CONF_DIR error

I am trying to load my MySQL tableLab5 to Hive using Sqoop. Sqoop ran successfully and has taken the data from mysql into hdfs. But throwing the below bolded error about HIVE_CONF_DIR not set. I have set the HIVE_CONF_DIR in ~/.bashrc and ~/.profile…
0
votes
1 answer

A JNI error has occurred, in HIVE 3.0.0

I installed Hadoop successfully and it's working fine, but when I installed Hive and ran the hive command in terminal, I got this error Error: A JNI error has occurred, please check your installation and try again Exception in thread "main"…