Hi Phil,
It works. Thanks a lot.
Best wishes,
Lin
On Tue, Aug 21, 2012 at 11:49 PM, Philip Tromans wrote:
> There's a case bug in hive. Put all the names into lower case. I've got a
> JIRA open about it somewhere.
>
> Phil.
> On Aug 22, 2012 4:39 AM, "Lin" wrote:
>
>> Hi,
>>
>> I build a com
There's a case bug in hive. Put all the names into lower case. I've got a
JIRA open about it somewhere.
Phil.
On Aug 22, 2012 4:39 AM, "Lin" wrote:
> Hi,
>
> I build a compact index IX for table A as follows,
>
> create index IX on table A(a, b) as 'COMPACT'
> with deferred rebuild
> in table A_
Hi,
I build a compact index IX for table A as follows,
create index IX on table A(a, b) as 'COMPACT'
with deferred rebuild
in table A_IX.
When I run the following query,
select c, d from A
where a='a_v' and b ='b_v';
I got the following error:
FAILED: Error in semantic analysis: No partition pr
Hi,
When I try to use Hive Indexing, I have the following questions.
1. Does Indexing have the same performance on both the partitioned and
non-partitioned tables? How about bucketed and un-bucked tables?
2. Is it possible for us to build index of function of indexed columns,
like
create
