Re: hiveserver2 Thrift Interface With Perl

Hi guys, I had already used the NOSASL setting to turn off that authentication, so was able to connect to the cluster fine. My issue is with how to use the new API to execute a query and get the response. -- Best wishes, Dave Cardwell. http://davecardwell.co.uk/ On 15 May 2013 00:05, Carl S

How to do a calculation among 2 rows?

Hi all, Can someone please give an idea for this? I'm totally stuck. http://stackoverflow.com/questions/16558438/in-hive-how-to-do-a-calculation-among-2-rows Thanks. --Bhathiya

Filtering

Hi, I'm using Hive 0.10.0 and Hadoop 1.0.4. I would like to create a normal table but have some of my code run so that I can remove filtering parts of the query and limit the output in the splits of the InputFormat. I believe that this is "Filtering Pushdown" as described in https://cwiki.apac

Re: How to do a calculation among 2 rows?

Hi Bhathiya, what about cartesian product ? the idea would be something like that : select a, b, c from t1 join t1 as t2 on t2.a = t1.a where t2.b > t1.b it's not very "elegant", but should work ;-) Paul 2013/5/15 Bhathiya Jayasekara > Hi all, > > Can someone please give an idea for this? I

Re: How to do a calculation among 2 rows?

There's a new release candidate version of Hive that includes windowing functions that address this. RC1 is available at http://people.apache.org/~hashutosh/hive-0.11.0-rc1/. Also see https://issues.apache.org/jira/browse/HIVE-896 Without 0.11 the approach from Paul will work, but will be slow.

Re: Filtering

On Wed, May 15, 2013 at 3:38 AM, Peter Marron < peter.mar...@trilliumsoftware.com> wrote: > Hi, > > ** ** > > I’m using Hive 0.10.0 and Hadoop 1.0.4. > > ** ** > > I would like to create a normal table but have some of my code run so that > I can remove filtering > > parts of the quer

Re: adding "create or replace view" documentation to the wiki

I also just realized that partitioned views have also been in Hive since 0.8 but it seems the only place they're mentioned on the main LanguageManual DDL page is in another offhand remark in the docs for ALTER VIEW AS SELECT. I was at least able to find a design doc

Re: adding "create or replace view" documentation to the wiki

Glad to see someone paying attention to the docs. I can't tackle these tasks right now, so I'm adding d...@hive.apache.org to the mailing list. Hope springs eternal – Lefty On Wed, May 15, 2013 at 11:50 AM, Darren Yin wrote: > I also just realized that partitioned views have also been i

Re: adding "create or replace view" documentation to the wiki

Your best bet is to find the relevant .q files inside the hive source code and "figure out" what actually works. On Wed, May 15, 2013 at 2:50 PM, Darren Yin wrote: > I also just realized that partitioned views have also been in Hive since > 0.8 but it seems the only place they're mentioned on t

Re: How to Disable Hive CLI interactive mode

not sure i understand. you're asking how to disable "hive" (with no args) [interactive mode] yet still permit "hive -e" [batch mode]? if that's the case my proposal would be to have a wrapper around the hive executable and check if stdin is a tty. then again if i've completely misunderstood t

Re: How to Disable Hive CLI interactive mode

Hi To clarify what I need is as follows - User types hive - Message is displayed "Cannot use hive without -e or -f options" From: Stephen Sprague mailto:sprag...@gmail.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Wednesday, May 15, 201

Re: How to Disable Hive CLI interactive mode

ok. so there you go. IMO, you're going to have to create a custom wrapper around hive so that your users find your wrapper (via PATH) before they find the real hive executable. Your wrapper checks for whatever you deem acceptable and if so calls the real hive else errors out with your message.

Re: How to Disable Hive CLI interactive mode

I think this will work….with some tweaks thanks a ton sanjay From: Stephen Sprague mailto:sprag...@gmail.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Wednesday, May 15, 2013 6:17 PM To: "user@hive.apache.org"

Partitioning an external hbase table

Is it possible to define partitions for a external table backed by Hbase? If so what is the proper syntax? I already have an external table backed by base and I'm finding that for even simple SELECT queries the load isn't getting evenly distributed a across the map tasks. Some tasks see as fe

Hive Web Interface

I have installed Hive locally & I am able to run Hive queries etc. Now I would like to try out Hive Web Interface, but when I try to start the webserver I run into this: ./hive --service hwi 13/05/15 22:18:33 INFO hwi.HWIServer: HWI is starting up 13/05/15 22:18:33 WARN conf.HiveConf: hive-site.x