In Hive 0.13 when I do a tablesample query on an ORC table, such as
select x from orc_table tablesample (bucket 32 out of 64) where date=1106;
I'll get the following error saying I'm trying to run with EXECUTE access
but the files have only READ access for non owner. Why would a simple
select que
all
> rank() over (partition ..order..).
>
> AFAIK, in hive rank over() syntax uses (partition ..order..) only.
>
> Thanks
> Rekha
>
> From: Eric Chu
> Reply-To: "user@hive.apache.org"
> Date: Friday, July 11, 2014 at 1:38 PM
> To: "hive-u...@hadoo
Does anyone know what
*rank() over(distribute by p_mfgr sort by p_name) *
does exactly and how it's different from
*rank() over(partition by p_mfgr order by p_name)*?
Thanks,
Eric
as expected.
Thanks,
Eric
On Thu, Nov 21, 2013 at 10:55 AM, Tim wrote:
> Or setting reducers to 1 and doing a GROUP BY all columns forces a single
> file too.
>
>
> Tim,
> Sent from my iPhone (which makes terrible auto-correct spelling mistakes)
>
> On 21 Nov 2013, at
Hi,
We often have map-only queries that result in a large number of small
output files (in the thousands). Although this doesn't affect CLI, when
users try to view/download the query result in Hue, Hue would time out in
trying to read all these small files. We tried to set the following
properties
Hi,
We're trying to convert our fact tables partitioned by date from RCFile to
ORCFile. Since they are really big in size and we retain the last N days
(partitions) of data, we don't want to re-process existing partitions.
There are two approaches using Hive ALTER and INSERT commands that I'm
comp
I found out what I missed - I needed to set JAVA_HOME. It'd be good if we
could add that to the unit test documentation. It's not intuitive to me b/c
some tests did run w/out that. After setting that, the unit tests seem to
run fine.
Thanks,
Eric
On Fri, Sep 6, 2013 at 2:27 AM, Eric
ls datanu*". To avoid that,
> you need to do "ant very-clean" before building hive.
>
> --Xuefu
>
>
> On Tue, Aug 6, 2013 at 4:39 PM, Eric Chu wrote:
>
> > Hi,
> >
> > I'm a bit confused about what DataNucleus patches we should get fo
Hi,
I'm a bit confused about what DataNucleus patches we should get for *Hive
0.11 with JDK 6*. It'd be great if people working on that could shed some
light on the subject. Thanks in advance!
After installing Hive 0.11 and applying the patch for HIVE-4619 (or else MR
queries will result in error
Hi,
After upgrading Hive to 0.10 we often observe the following build error. We
notice that when we run our dumpcache job (which includes deleting the ivy
cache), the problem is *sometimes, but not always,* resolved. Does anyone
know the cause of this problem or know of a better solution?
Thanks
Hi,
I'm running Hive 0.10 and I want to support HWI (besides CLI and HUE). When
I started HWI I didn't get any error. However, when I went to :/hwi on my browser I saw the error below complaining about "No
Java compiler available". My JAVA_HOME is set to
/usr/lib/jvm/java-1.6.0-sun-1.6.0.16.
(+hue-user since this issue prevents me from successfully installing Hue
from source)
Hi,
I recently did the following with both the Hive-0.10 and Hive-0.9, and had
a problem with 0.10 that I didn't see with 0.9
- Checked out the respective branch from github
- Did an "ant package"
- Co
pache could
review/update the "build from source" instruction or the release notes.
Eric
On Tue, Feb 26, 2013 at 11:38 AM, Eric Chu wrote:
> Hi,
>
> I tried to build Hive0.10.0 from source by doing the following:
>
>
> svn co http://svn.apache.org/repos/asf/hive/trun
Hi,
I tried to build Hive0.10.0 from source by doing the following:
svn co http://svn.apache.org/repos/asf/hive/trunk hive
sudo ant package
It built fine and I got the dist folder as expected, but inside that folder
the RELEASE_NOTES.txt says the version is 0.8.0.
How do I get 0.10.0 source?
14 matches
Mail list logo
