Stack Overflow
Stack Overflow

Questions tagged [hivecli]

Hive CLI is a Hive command-line shell.

Hive CLI will soon be deprecated in favor of Beeline, which works on HiveServer2

12 questions
14
votes
2 answers

What is the hive command to see the value of hive.exec.dynamic.partition

We know that set command is used to set some values for properties hive> SET hive.exec.dynamic.partition=true; hive> SET hive.exec.dynamic.partition.mode=non-strict; But how do we read the current value of above property I tried the below…
Surender Raja
  • 3,553
  • 8
  • 44
  • 80
7
votes
3 answers

Kill hive queries without exiting from hive shell

Is there any way we can kill hive query without exiting from hive shell ?. For Example, I wrongly ran the select statement from some table which has million rows of data, i just wanted to stop it, but not exiting from the shell. If I pressed CTRL+Z,…
Padmanabhan Vijendran
  • 306
  • 1
  • 6
  • 18
6
votes
1 answer

How to run hive script from hive cli

I have hive script custsales.hql now I want to run it from hive cli as hive (pract5)> run /user/training/hdfs_location/custsales.hql but it does not execute. Please guide. I know we can run it from command line with $ hive -f…
user8167344
  • 353
  • 2
  • 6
  • 17
5
votes
0 answers

Lots of warning messages in hive cli after removing jndiLookup Class

After removing JndiLookupClass from the classpath under $HIVE_HOME/lib/log4j-core-2.6.2.jar we are getting multiple warnings when we open hive cli and also while running the queries. PFA error lines. 2021-12-17 18:47:32,880 main WARN JNDI lookup…
Densing Moses
  • 51
  • 1
4
votes
2 answers

Difference between hive, impala and beeline

I am new to Hadoop eco-system tools. Can anyone help me with understand the difference between hive, beeline and hive. Thanks in advance!
Ramkrushna26
  • 125
  • 1
  • 7
1
vote
1 answer

Hive SQL file execution

I am using Cloudera Quickview VM 5.10 The following is my implementation which is not working. Created a new file (sample.sql) in "user/hive/warehouse" using Hue. The extension is sql. In Edit mode, I wrote some SQL code (use testdb; select * from…
Onlydocs
  • 79
  • 7
1
vote
0 answers

How to pass variable values of a hive script, to a shell script within it

I have a hive script which takes parameters in the form of --hivevar var_name="value" from beeline and the substitution works well within hive queries. Within this hive script, I wanted to run a shell script with a variable passed as a parameter. I…
Kevin Bobby
  • 21
  • 7
1
vote
1 answer

How to use hive variable substitution rightly

When I'm using variable substitution in hive, I meet some errors, but I need your help. My code: set hievar:b='on t1.id=t2.id where t2.id is null'; select * from t_old as t1 full outer join t_new as t2 ${b}; when I run this code in hive shell, it…
BlackMamba
  • 10,054
  • 7
  • 44
  • 67
0
votes
0 answers

How to set hadoop class parameters in Hive Similar to Pig shown here?

I want Hive to automatically acquire kerberos ticket whenever hive(More specifically hive-shell not hive-server) is executed and also renew it automatically in between if job run more then timeout of ticket. I found similar functionality in Pig. See…
Uddhav Savani
  • 31
  • 6
0
votes
1 answer

How to configure Hive Cli to automatically get the kerberos ticket and renew/request new if expires by it own

Hi I am new to Hive and kerberos. I have some hive jobs which run more then life time of ticket. how can I configure hive so that when I start hive shell if ticket is not cached it automatically request for ticket. After acquiring ticket lets…
Uddhav Savani
  • 31
  • 6
0
votes
1 answer

Using Beeline as an example (vs hive cli)?

I have a sqoop job ran via oozie coordinator. After a major upgrade we can no longer use hive cli and were told to use beeline. I'm not sure how to do this? Here is the current process: I have a hive file: hive_ddl.hql use schema_name; SET…
user3486773
  • 1,174
  • 3
  • 25
  • 50
-2
votes
1 answer

is it possible to use output of inner query to input of outer query where caluse?

like select ho from (select sourceaddress,count(sourceaddress) as src,hour(eventtime) as ho from default.fullandfinal where sourceaddress='0.0.0.0' and eventtime between '2019-05-11 00:00:00' and '2019-05-11 19:59:59' group by…
vishwajeet
  • 83
  • 1
  • 9