Hive Insert query is failing

2017-01-07 Thread Amit Bajpai
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,

Reading hive-site.xml

2016-09-18 Thread Amit Bajpai
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

RE: Error running SQL query through Hive JDBC

2016-08-05 Thread Amit Bajpai
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 [mailto:amit.baj...@flex

Error running SQL query through Hive JDBC

2016-08-05 Thread Amit Bajpai
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

RE: hive concurrency not working

2016-08-03 Thread Amit Bajpai
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

RE: Yarn Application ID for Hive query

2016-07-18 Thread Amit Bajpai
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, I am usin

Yarn Application ID for Hive query

2016-07-14 Thread Amit Bajpai
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",