Stack Overflow
Stack Overflow

Questions tagged [hiveserver2]

23 questions
2
votes
0 answers

Hiveserver2 started but 10000 port not coming up

I am able to start hiveserver2 service on Centos8.5 and attached below logs when starting hiveserver2. hiveserver2 logs Also hive metastore service is up and running. Logs are attached below. hive metastore logs I am able to access hive shell by…
Faizan
  • 21
  • 5
2
votes
1 answer

Join a small in-memory spark table with huge hive table without bringing all records from hive to spark

Usecase : I have a small table(~1000 rows) available in spark, and a huge hive table(20 billion records). Let's call the small table as base and the huge table as main. Now, the base table has a column 'id' and I need to fetch all records from main…
Anshul
  • 448
  • 2
  • 11
1
vote
0 answers

hive issue when activating yarn FairScheduler

After activating yarn FairScheduler, i am note able to run beeline hive, i have this error on hiveserver2 :java.lang.NoSuchMethodError: org.apache.hadoop.yarn.server.resourcemanager.scheduler.fair.AllocationFileLoaderService: method ()V not…
Heni BOUHAMED
  • 11
  • 1
1
vote
0 answers

Getting error "UnicodeError: label too long" while trying to connect Hive from python

I am trying to connect Hive DB using below host and user creds. Getting error "UnicodeError: label too long". Is there a way I can overcome this issue? I tried below script: from pyhive import hive import re, os, time import pandas as pd import…
Dilip
  • 55
  • 1
  • 1
  • 8
1
vote
1 answer

How to print output file size when use hive export data with command "insert overwrite directory"

I am using beeline to export data to hdfs with command: INSERT OVERWRITE DIRECTORY $export_tmp ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' select * from xxx_table_name; I want to set echo output file size such…
rilweic
  • 51
  • 1
  • 5
0
votes
0 answers

Spark Thrift Server fails to start

I am trying to use logback with spark-thrift-server to log the application logs in elasticsearch and for that i am using log4j-over-slf4j along with logback-classic and logback-core. Service fails to start with this Exception:- Exception in thread…
Surya
  • 3
  • 4
0
votes
0 answers

ClassNotFoundException: org.apache.hive.org.apache.commons.cli.ParseException - While starting hiveserver2 in Windows

I installed hive and hadoop in windows as per the link. I can able to create tables and load data in hive but when I tried to start the hiveserver2 using command hive --service hiveserver2 Facing the below exception. Metastore is also up and…
Dinesh Babu M
  • 3
  • 4
0
votes
0 answers

Ranger Hive-Plugin don't appear in Web UI

I have two virtual machines, first one with the Apache Ranger and LDAP running, second one with Apache Spark running. I want to use Ranger Policies to control the user's querys in Beeline, for example. The procedure I'm doing now is running…
Eduardo Carlos
  • 1
0
votes
0 answers

Unable to Connect to Hive using jdbc with CDP version

Driver: com.cloudera.hive.jdbc41.HS2Driver jdbc url:  jdbcUrl=jdbc:hive2://EXAMPLE.NET:10010/;AuthMech=1;KrbHostFQDN=EXAMPLE.NET/;KrbServiceName=hive;krbRealm=REALM;SSL=1;SSLTrustStore=FILE;SSLTrustStorePwd=PASS Facing below…
user10309853
  • 1
0
votes
0 answers

How do I connect laravel 8 to hiveserver2? Is there any odbc connector package for laravel to do so?

I want to connect to hadoop hive database from laravel 8, currently I am getting packages which might work with laravel 5 and 6, I have not tested yet, but need help in establishing the connection between laravel and hive. Any help from you guys is…
Saurav Sen Sarma
  • 19
  • 5
0
votes
0 answers

Unable to access HiveServer2 from LAN on port 10000. Able to access it from localhost. Tested this using beeline

Unable to access HiveServer2 from LAN on port 10000 but able to access it from locahost. Tested this using beeline. hive.server2.thrift.bind.host is set to 0.0.0.0 hive.server2.webui.host is set to 0.0.0.0 I am able to access 10002 from LAN but not…
Vatsal
  • 33
  • 3
0
votes
0 answers

Hive Mapreduce Query runs only once after running HIVESERVER

hive mapreduce query runs only once successfully after running hiveserver once afterwards it gives error eventhough the same query hiveserver info:- Connecting to jdbc:hive2://localhost:10000 to: Apache Hive (version 4.0.0-alpha-2) Driver: Hive JDBC…
Nishchal v gowda
  • 1
  • 1
0
votes
0 answers

datagrip connects to hive through hiveserver2 and displays a message indicating that the current user is not an admin role

I can use datagrip successfully connects to hive through hiveserver2,however,When I was performing an sql calculation, I began to receive an error message indicating that the current user was not admin role I tried a number of methods and looked at…
songyj
  • 1
  • 1
0
votes
1 answer

How to pass command to beeline without using interactive mode?

Using beeline, you can give specific hive commands (not HQL queries !) for hive configuration such as: add jar myjar.jar However, I do not understand how you can provide these commands to beeline without being in interactive mode as the…
Itération 122442
  • 2,644
  • 2
  • 27
  • 73
0
votes
0 answers

Direct Hive Queries Doesn't appear in HiveServer2 WebUI

I need to know, why Direct Hive Queries Doesn't appear in HiveServer2 WebUI? Follow a GIF to explain my doubt.
Paulo Ferrari
  • 1
  • 1
1
2