My Oracle Support Banner

Frequently Asked Question for Hive Server2 / Beeline In Oracle Big Data Appliance V3.*/V4 and CDH5 (Doc ID 1931819.1)

Last updated on JANUARY 30, 2020

Applies to:

Big Data Appliance Integrated Software - Version 3.0.1 and later
Linux x86-64


 To provide answers to frequently asked questions about Hive Server2 / Beeline In BDA V3.*/V4 and CDH5.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 When starting beeline command line, seeing "No such file or directory" messages. Are the messages expected? What changes need to be done to change that behavior?
 Getting "Error: Error while processing statement: FAILED: Execution Error, return code 1 from (state=08S01,code=1)" without having the username specified. It runs fine when I run the same command adding username and password. Does the username and password need to be hard coded in order to run in batch mode (beeline -f)?
 Does Insert into table2 select from table1 statement put an exclusive lock on table 2 while loading the data? I was getting "concurrency lock error" when I tried to select from table 2.
 What happens if I execute unlock table table2 statement while the above insert statement is running? Will it unlock the table just for me? for everyone? Any impacts on the insert statement?
 Who can unlock a table? Table owner only? The user executing the INSERT statement? Or any user?
 Can I use beeline with Impala?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.