Questions tagged [apache-hive]
9 questions
3
votes
1 answer
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 in name table.
create table name(custID…
Nitesh B.
- 563
- 2
- 7
- 20
3
votes
3 answers
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 interactive shell,
I want to it to stay in the hive…
Fil
- 33
- 2
1
vote
0 answers
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. ( metastore heap size )
in our case It's…
yael
- 12,598
- 51
- 169
- 303
1
vote
1 answer
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 exists
How can we check if database hive already…
yael
- 12,598
- 51
- 169
- 303
1
vote
1 answer
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 using a particular function in Hive that can…
Raman
- 113
- 5
1
vote
0 answers
Shell Script Execution with Bash and without bash on command line
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 get errors like array deceleration not found some…
vaibhav kumar
- 51
- 1
- 1
- 7
1
vote
1 answer
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/sqoop_insights_extract/./sqoop_import_ATM.sh 2>&1)"
This gets both…
Greg Peckory
- 111
- 2
0
votes
0 answers
Is it possible to start hive standalone metastore with just hadoop commons?
I'm trying to launch my own hive standalone metastore v3.0.0 in a kubernetes env, and write into postgresql as the backend database.
But through my experience so far, I need to have hadoop binaries present in the image itself in order to schematool…
jake wong
- 111
- 2
-1
votes
1 answer
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 Software Foundation (ASF) under one or more
#…
yael
- 12,598
- 51
- 169
- 303