Stack Overflow
Stack Overflow

Questions tagged [beeline]

Beeline is a Hive command-line shell that works with HiveServer2

Beeline replaces Hive CLI for Hiveserver. Documentation is available here.

The Beeline shell works in both embedded mode as well as remote mode. In the embedded mode, it runs an embedded Hive (similar to Hive CLI) whereas remote mode is for connecting to a separate HiveServer2 process over Thrift. Starting in Hive 0.14, when Beeline is used with HiveServer2, it also prints the log messages from HiveServer2 for queries it executes to STDERR. Remote HiveServer2 mode is recommended for production use, as it is more secure and doesn't require direct HDFS/metastore access to be granted for users.

There’s detailed documentation of SQLLine which is applicable to Beeline as well.

281 questions
0
votes
2 answers

Config hive with sentry: NullPointerException privilegeObj is null for

I've followed the guide step by step. But error occured when I tried to grant privilege to the role: 0: jdbc:hive2://localhost:10000/> GRANT ALL ON SERVER server1 TO ROLE admin_role; Error: Error while compiling statement: FAILED:…
kiwi
  • 487
  • 1
  • 4
  • 16
0
votes
0 answers

What are the advantages of beeline than hive CLI?

Could someone please explain what are the advantages of beeline than HIVE CLI? I explored on this and found that Beeline have the benefit to use LDAP/Kerberos authentication But I couldn't get more insight on this. And with respect to OOZIE…
user2531569
  • 609
  • 4
  • 18
  • 36
0
votes
1 answer

Unable to load hive (beeline table) |StringLiteral near 'inpath' in load statement

I am trying to load table from HDFS file using beeline. I have written shell script for it which takes StagingSchema.hql file as input and loads table. load data inpath ${hivevar:dataLocation} into table ${hivevar:sourceTable}; Inside Shell…
Shashi
  • 2,686
  • 7
  • 35
  • 67
0
votes
0 answers

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.apache.hadoop.hive.serde2.OpenCSVSerde

I am trying to create table in hive, but I am getting the following errorFAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde:org.apache.hadoop.hive.serde2.OpenCSVSerde please help me on the same.
user2572432
  • 7
  • 1
  • 6
0
votes
1 answer

Hive job running forever on reduce phase

I am running a query on 60 GB dataset in Hive. When i fire a query 270 mappers will finish within 15 Mins, but when it comes to reducer state to complete 0.01% , its taking minimum 45 mins to 1hr. So the job is running like forever. Is there any way…
BruceWayne
  • 3,286
  • 4
  • 25
  • 35
0
votes
1 answer

Hive query cli works, same via hue fails

I have a weird issue with hue (version 3.10). I have a very simple hive query: drop table if exists csv_dump; create table csv_dump row format delimited fields terminated by ',' lines terminated by '\n' location '/user/oozie/export' as select * from…
Guillaume
  • 2,325
  • 2
  • 22
  • 40
0
votes
2 answers

Adding Hive Partition using Oozie

I'm using HPD-2.4.2 and try to add partitions to an external Hive table using an Oozie coordinator job. I created a coordinator that daily tiggers the following workflow:
Miguel San
  • 1
  • 4
0
votes
2 answers

Hive/Beeline, how can I set the job .staging directory?

On the cluster I'm working on every user is given 60GB of Hadoop quota. Historically the project I'm working on generates a lot of Hive queries. In order for things to work faster I'm trying to parallel these queries (which are unrelated) but as a…
user1942586
  • 153
  • 1
  • 3
  • 16
0
votes
2 answers

Beeline error connecting to Hive2

This is my command on beeline !connect jdbc:hive2://localhost:10000 I got this error Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: null (state=08S01,code=0) How to solve it?
samydoyle
  • 27
  • 1
  • 7
0
votes
2 answers

Hive Server 2 / Beeline returns no rows with an INNER JOIN on a Hive on HBase table

TL;DR I can execute a Hive query using an INNER JOIN on a HBase table in the Hive (Hive Server 1) command line and return the correct rows. However, the same query on the Beeline (Hive Server 2) command line returns no rows. I can do an INNER JOIN…
Matthew Moisen
  • 16,701
  • 27
  • 128
  • 231
0
votes
1 answer

HIVE : NoSuchMethodError: org.fusesource.jansi.internal.Kernel32.GetConsoleOutputCP()I

I have been trying to install hive on windows. I have 64 bit windows 8 on which HADOOP and SPARK are running. I have 1.HADOOP_HOME 2.HIVE_HOME 3.SPARK_HOME 4.Platform 5.PATH all these variables set up on my system. Also, I was getting these error…
Rebecca
  • 159
  • 1
  • 4
  • 13
0
votes
1 answer

how to query from Beeline without authentication

I am writing an automation batch script that will check beeline status in a scheduled interval of time. I have written the code below to do this, but the problem is that, it seems the edge nodes of my cluster requires password to run the beeline…
aiman
  • 1,049
  • 19
  • 57
0
votes
2 answers

sql query to spark-cassandra cluster thriftserver does not return

I have a spark-cassandra cluster set up. cqlsh works just fine. I started the thriftserver and use beeline command line to connect to it. I can do use schemaname show schemas show tables but a simple select * from tablename gets stuck. I tried…
bhomass
  • 3,414
  • 8
  • 45
  • 75
0
votes
2 answers

spark-cassandra thrift server on ec2 throws SparkException on query from beeline

I installed cassandra spark-hadoop cluster on 3 ec2 nodes. Yesterday, I was able to start the spark thrift server on node0, and actually executed a simple sql statement in beeline. Today, after a schema change, I restarted the thrift server, now I…
bhomass
  • 3,414
  • 8
  • 45
  • 75
0
votes
1 answer

what is the ip of hiveserver2 in CDH quickstart vm?

How to establish a connection with the hiveserver2 using jdbc connectivity with Beeline? What ip address should be used to connect?
Alex Raj Kaliamoorthy
  • 2,035
  • 3
  • 29
  • 46
1 2 3
…
18
19