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.
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 query and limit
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
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 darren@gmail.com wrote:
I also just realized that partitioned
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
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: