Re: delay before query starts processing

2013-01-30 Thread Ariel Marcus
>From the archives: http://mail-archives.apache.org/mod_mbox/hive-user/201110.mbox/%3CCAC9SPjuQtxOK1KtEmReD6OanNTgNM_uLkGQD+=n7krcjcal...@mail.gmail.com%3E TL;DR set hive.optimize.s3.query=true; ----- Ariel Marcus, Consultant www.openbi.com | ariel.mar...@openbi.

limit on hive partition string length

2013-01-28 Thread Ariel Marcus
ike a pretty reasonable limit to me, but just wanted to alert you (all) about it. Best, Ariel - Ariel Marcus, Consultant www.openbi.com | ariel.mar...@openbi.com 150 N Michigan Avenue, Suite 2800, Chicago, IL 60601 Cell: 314-827-4356 -- --

Re: HWI use on AWS/EMR

2013-01-18 Thread Ariel Marcus
Hey Tony, Nitin's approach would work for you as well. Amazon has very good documentation of their services. A quick google search should get you the right info. Best, Ariel - Ariel Marcus, Consultant www.openbi.com | ariel.mar...@openbi.com 150 N Michigan A

Re: HWI use on AWS/EMR

2013-01-18 Thread Ariel Marcus
This should be localhost instead of proxy: - In Connection/SSH/Tunnels I’ve added in the Source Port box, * localhost*: in the Destination box. Not sure if this is correct. Best, Aril - Ariel Marcus, Consultant www.openbi.com | ariel.mar...@openbi.com

Re: HWI use on AWS/EMR

2013-01-18 Thread Ariel Marcus
practice is to store changes from the default configuration in hive-site. Best, Ariel - Ariel Marcus, Consultant www.openbi.com | ariel.mar...@openbi.com 150 N Michigan Avenue, Suite 2800, Chicago, IL 60601 Cell: 314-827-4356 On Fri, Jan 18, 2013 at 11:26 AM, Tony

Re: HWI use on AWS/EMR

2013-01-18 Thread Ariel Marcus
worked for me. Best, Ariel - Ariel Marcus, Consultant www.openbi.com | ariel.mar...@openbi.com 150 N Michigan Avenue, Suite 2800, Chicago, IL 60601 Cell: 314-827-4356 On Fri, Jan 18, 2013 at 11:09 AM, Dean Wampler < dean.wamp...@thinkbiganalytics.com>

Re: Writing Custom Serdes for Hive

2012-10-16 Thread Ariel Marcus
hrows SerDeException Look here for an example of usage: https://github.com/rcongiu/Hive-JSON-Serde/blob/master/src/main/java/org/openx/data/jsonserde/JsonSerDe.java Hope that helps. Ariel - Ariel Marcus, Consultant www.openbi.com | ariel.mar...@openbi.com 150 N Mic