Hi,
Hive query running on Tez to insert from one table to another is failing with
the below error. Both the tables have file format as ORC and all the columns in
both the tables are string. Can anyone help on how it can be fixed.
Hive version: 1.2.1.2.4
Error message:
Vertex failed, vertexName
Hi,
I have the below query which is gives the city_code for all the cities in the
particular region and country.
SELECT CITY_CODE
FROM COUNTRY
WHERE REGION_CODE = 'MEX_EAST'
AND COUNTRY='MEXICO'
Is there a way I can get the output in a single row and comma separated?
Example - GUAD,MONT,DF,CAN
Hi,
I am trying to understand how hive is reading the configuration from
hive-site.xml. Where we define the structure of the xml file and code used to
read the hite-site.xml.
Thanks
Amit
Legal Disclaimer:
The information contained in this message may be privileged and confidential.
It is inte
e.printStackTrace();
}
From: Markovitz, Dudu [mailto:dmarkov...@paypal.com]
Sent: Friday, August 05, 2016 3:04 PM
To: user@hive.apache.org
Subject: RE: Error running SQL query through Hive JDBC
Can you please share the query?
From: Amit Bajpai [mai
Hi,
I am getting the below error when running the SQL query through Hive JDBC. Can
suggestion how to fix it.
org.apache.hive.service.cli.HiveSQLException: Error while compiling statement:
FAILED: SemanticException UDF = is not allowed
at org.apache.hive.jdbc.Utils.verifySuccess(
You need to increase the value for the below hive property value in Ambari
hive.server2.tez.sessions.per.default.queue
If this does not fix the issue then you need to update the capacity scheduler
property values.
From: Raj hadoop [mailto:raj.had...@gmail.com]
Sent: Wednesday, August 03, 2016 8
ySQL's "SHOW PROCESSLIST"
(and equivalent commands in most other databases).
From: Amit Bajpai [mailto:amit.baj...@flextronics.com]
Sent: Thursday, July 14, 2016 10:22 PM
To: user@hive.apache.org<mailto:user@hive.apache.org>
Subject: Yarn Application ID for Hive query
Hi,
Hi,
I am using the below python program to run a hive query. How can I get the Yarn
application ID using the python program for the hive query execution.
import pyhs2
with pyhs2.connect(host='abc.sac.com',
port=1,
authMechanism="PLAIN",
user='ami
