RE: ORA-8177 with Hive transactions

I have seen this one before as I use oracle database as my metastore. Two things if I recall correctly 1. Have you run the oracle sql script for concurrency against your metastore. For example hive-txn-schema-0.14.0.oracle.sql 2. You also need to run zookeeper for concurrency

Re: ORA-8177 with Hive transactions

I think ROWDEPENDENCIES on an Oracle table also covers this issue, so I don't think a separate JIRA is needed for the INITRANS change. On Fri, Sep 18, 2015 at 2:51 PM, Sergey Shelukhin wrote: > There’s HIVE-11831 and > https://issues.apache.org/

Re: ORA-8177 with Hive transactions

There’s HIVE-11831 and https://issues.apache.org/jira/browse/HIVE-11833 that try to address this. We can do a patch similar to the first one; can you file a JIRA? From: Steve Howard mailto:stevedhow...@gmail.com>> Reply-To: "user@hive.apache.org

Re: Hive Start Up Time Manifolds Greater than Execution Time

Actually, on 2nd though, even listing directories (which is necessary to launch the job) could take long. If there are any client logs, you can try to take a look to see where the time is spent. If you are running under Hive CLI, the logs would be in /tmp/$USER/hive.log by default. On 15/9/18, 11:

Re: Hive Start Up Time Manifolds Greater than Execution Time

Which version of the Hive, and file format, are you using? It could be either reading file footers for ORC - in recent version there’s way to disable that (set hive.exec.orc.split.strategy=BI); or some similar feature for other formats that I’m not immediately familiar with. It could also be slow

ORA-8177 with Hive transactions

While troubleshooting an issue with transactions shortly after enabling them, I noticed the following in an Oracle trace, which is our metastore for hive... ORA-8177: can't serialize access for this transaction These were thrown on "insert into HIVE_LOCKS..." Traditionally in Oracle, if an appli

Re: UPDATE and DELETE fail due to Error 10122 on Hive 1.2.1

use 'transactional', I.e. lower case From: , Jian-bing mailto:jian-bin@sap.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Monday, September 7, 2015 at 11:58 PM To: "user@hive.apache.org" mailto:user@hive.ap

Hive Start Up Time Manifolds Greater than Execution Time

Hi All, Something interesting fell to my notice last day when i was using hive for some queries. The time taken by hive to launch a mapreduce job was manifolds higher than the time taken by hadoop to actually execute it. This is the table details on which the query is being fired. CREATE EXTERNAL

HiveServer with LDAP

Hi all, I try to use LDAP authentication to allow users to get to HiveServer, but even though I configured some properties, it seems like it doesn't work at all, and I can't find any logs explaining why. Do anyone of you know which property to set in which log4j file to see debug logs for that fu