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
1 answer

query works in Hive 1.x but not in beeline

With Hive 1.x, my query similar to this: select ... from Table group by column; works fine. However with beeline like so alias beeline='beeline -u jdbc:hive2://localhost:10000 -u hadoop -p pass --hiveconf …
Chris
  • 1,219
  • 2
  • 11
  • 21
0
votes
2 answers

Unable to start beeline client

I installed spark-1.5.1-bin-without-hadoop and trying to start beeline using the following command from spark install directory. ./bin/beeline I get "Error: Could not find or load main class org.apache.hive.beeline.BeeLine".
Ramakishore Yelamanchilli
  • 11
  • 2
  • 6
0
votes
1 answer

Hive - Beeline - how to pass exceptions from fileinputformat to beeline

My FileInputFormat throws exception sometimes, and I'd like the user to see the message from the exception. Is there a way to inform beeline of the exception. It just shows Error while processing statement: FAILED: Execution Error, return code 1…
hba
  • 7,406
  • 10
  • 63
  • 105
-1
votes
1 answer

FAILED: ParseException line 3:0 cannot recognize input near 'row' 'format' 'demilited' in table row format specification (state=42000,code=40000)

CREATE EXTERNAL TABLE CLIENTES ( 'idcliente int, cnh string, cpf string, validacnh date, nome string, datacadastro date, datanascimento date, telefone string, status string' ) row format demilited fields…
PythonPy
  • 1
-1
votes
1 answer

How to remove extra tab from a row in Hive export csv after decryption

Facing issue while exporting data from hive : Hive version : 2.6.5 Quality check in big query output error : Error message: Too many values in row starting at position: 2121402186. Found 22 column(s) while expected 21 Step 1 : exported the data…
SweetyP
  • 23
  • 6
-1
votes
1 answer

Is it possible to execute multiple beeline commands from python using subprocess and capture the output of each query

How can I execute multiple beeline commands from python using subprocess and capture the output of each query? I am able to execute the below code in sequence but it is not running in parallel. Also, if the first command fails for some reason the…
Shine
  • 83
  • 10
-1
votes
1 answer

How to run hive commands from shell?

I have to repair tables in hive from my shell script after successful completion of my spark application. msck repair table .; Please suggest me a suitable approach for this which also works for large tables with…
Sambhav Kumar
  • 368
  • 3
  • 19
-1
votes
1 answer

How to handle errors in beeline shell

I had created a shell script to invoke beeline shell. But, how can I handle errors in the beeline shell with the below two scenarios. If suppose there are any connection errors in the beeline shell, it should print the error message in the log…
dev333
  • 713
  • 2
  • 17
  • 38
-1
votes
1 answer

Not able to grant a role to the group in beeline

I am trying to grant a role to the AD group in beeline. I am facing the below error. If anyone has encountered the same issue, Please suggest me the steps to resolve. GRANT ROLE role_test1 TO GROUP test1; Error: Error while processing statement:…
Mintu
  • 21
  • 5
-2
votes
2 answers

'beeline' is not recognized as an internal or external command

I am trying to connect to hive server using below code but getting error when trying to run from my LOCAL Machine: 'beeline' is not recognized as an internal or external command. Same code is working fine from Hive Server. ''' Import…
Rohit
  • 97
  • 1
  • 2
  • 9
1 2 3
…
18
19