Questions tagged [apache-hive]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
824 views

how to set the value of Hive Metastore heap size

we have hadoop cluster ( based on ambari platform ) , when hive metastore installed on two machines Sometime during job running ( we runs the queries from presto ) we saw job failure due to heap size. ...
yael's user avatar
  • 13.1k
0 votes
1 answer
2k views

hive + what is the meaning of nofile and nproc

regarding to hive in hadoop cluster what is the meaning of the following hive - nofile 30000 hive - nproc 18000 the file: more /etc/security/limits.d/hive.conf # Licensed to the Apache ...
yael's user avatar
  • 13.1k
1 vote
1 answer
4k views

How to verify, that a DB hive already exists?

We create a hive database using expect script and with some other commands. In the case if we run the expect script again on the machine that hive already created, we get this: ERROR hive already ...
yael's user avatar
  • 13.1k
1 vote
1 answer
2k views

How to change Hive Server Timezone

I am using Apache Hive on RedHat. Hive version is 1.2.1. The current Timezone in Hive is EST and I want to convert it to GMT. PS: I want to change the Hive Server Timezone and I am not asking about ...
Raman's user avatar
  • 113
1 vote
0 answers
24 views

Shell Script Execution with Bash and without bash on command line [duplicate]

I have a shell script that reads data from a file and stores it into an array. When i execute the script like bash scriptname.sh i dont get any errors but when i execute it using sh scriptname.sh i ...
vaibhav kumar's user avatar
3 votes
1 answer
11k views

Change column datatypes in Hive database

Can I change the datatype in Hive database? Below is a complete information about the same. I have a database named "test". It has a table "name". Below is a query I had used while creating a column ...
Nitesh B.'s user avatar
  • 563
1 vote
1 answer
601 views

Escaping bash variables before storing them in an apache hive database

I'm running a script file sqoop_import_ATM.sh and would like to store the logs in a SQL database. First thing I did was to direct the logs into my own variable: OUTPUT="$(/home/me/...
Greg Peckory's user avatar
3 votes
3 answers
671 views

Why does using pipe '|' terminate the second process, is there a way to prevent it?

Just to give some context, I'm trying to run this command echo "set hive.execution.engine=tez;" | hive hive terminates as soon as "set hive.execution.engine..." has been entered into the hive ...
Fil's user avatar
  • 33