RE: Hive Alter Partition Location Issue

Hi Harsha, Have you updated stats on table1 after partition adding? In other words it is possible that the optimiser is not aware of that partition yet? analyze table table1 partition (dt=201501) compute statistics; HTH Mich Talebzadeh http://talebzadehmich.wordpress.com

Re: Too many connections from hive to zookeeper

I have had the same problem and bouncing the Hive server temporarily alleviates this. Abe On Thu, Apr 30, 2015 at 2:20 AM, Shady Xu shad...@gmail.com wrote: I found the patch here https://issues.apache.org/jira/browse/HIVE-9119. But upgrading is the last thing we want to do. Also, I found

Re: Too many connections from hive to zookeeper

It looks to me using Hive's Table Lock Manager with ZK with Cloudera's CDH5.3.3 distribution (Hive 0.13.1) is a bad thing. The ticket indicates the problem is fixed in version 1.1.0 only. I asked earlier in a different email (Subject: Table Lock Manager: ZooKeeper cluster) about using the same ZK

map side join

Hi, I am doing a few map side joins in one query to load an user facing ORC table in order to denormalize. Two of the tables I am joining too are pretty large. I am setting hive.auto.convert.join.noconditionaltask.size pretty high. However, the join it self filters on those two tables, but it

Re: map side join

Great info, thanks. Makes sense on the partition since those files can be shipped by themselves. These are reference tables, but one happens to be pretty long. Thanks, Abe On Thu, Apr 30, 2015 at 12:54 PM, Gopal Vijayaraghavan gop...@apache.org wrote: Hi, Using CDH 5.3 - Hive 0.13. Does

Re: PL/HQL - Procedural SQL-on-Hadoop

Hi everyone, PL/HQL 0.3.1 released today. There are some features I hope you find interesting: 1) Stored procedures and SQL user-defined functions CREATE PROCEDURE and CREATE FUNCTION statements are supported so you can define procedures and functions in your scripts, and when added to .plhqlrc

Re: Edit access to hive wiki to update hive-hbase integration docs

Done. Welcome to the Hive wiki team, Andrew. -- Lefty On Thu, Apr 30, 2015 at 7:20 PM, Andrew Mains andrew.ma...@kontagent.com wrote: Doh, can't believe I forgot that, sorry! Username: amains12 Thanks again. On 4/30/15 4:11 PM, Lefty Leverenz wrote: Great! Just give us a Confluence

Re: Edit access to hive wiki to update hive-hbase integration docs

Great! Just give us a Confluence username (see About This Wiki -- How to get permission to edit https://cwiki.apache.org/confluence/display/Hive/AboutThisWiki#AboutThisWiki-Howtogetpermissiontoedit ). -- Lefty On Thu, Apr 30, 2015 at 7:07 PM, Andrew Mains andrew.ma...@kontagent.com wrote: Hi

Edit access to hive wiki to update hive-hbase integration docs

Hi all, Could I get edit access to the hive wiki in order to update the hive/hbase integration docs (https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration). Specifically I'd like to: 1. Add documentation about compound key support (the only statement on the wiki right now is

Re: Edit access to hive wiki to update hive-hbase integration docs

Doh, can't believe I forgot that, sorry! Username: amains12 Thanks again. On 4/30/15 4:11 PM, Lefty Leverenz wrote: Great! Just give us a Confluence username (see About This Wiki -- How to get permission to edit