You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Rakhi Khatwani <ra...@gmail.com> on 2009/06/01 13:12:09 UTC
Re: Secondary Indexes on HBase table
Hi,
yea i actually did tht... but i did it from hbase shell. when i do it
programitically, it works fine.
Regards,
Raakhi
On Sat, May 30, 2009 at 12:32 AM, Xinan Wu <wu...@gmail.com> wrote:
> don't see any obvious problems. you sure you changed conf correctly so
> you are running indexed region server? you sure you insert values into
> entry:hostname and entry:msg columns?
>
> On Fri, May 29, 2009 at 1:24 AM, Rakhi Khatwani
> <ra...@gmail.com> wrote:
> > Hi,
> >
> > I was trying to create secondary indexes on hbase table. i used the
> below
> > reference to create the table. and i got successfully created.
> > reference:
> > http://blog.eventexchange.net/2009/05/creating-hbase-indexes.html
> >
> > for example i create a table called TestIndexTable using the above code.
> and
> > i get two extra indextables TestIndexTable-hostname
> > and TestIndexTable-msg.
> >
> >
> > but whn i insert data into TestIndexTable, the TestIndexTable-hostname
> and
> > TestIndexTable-msg remains empty. is this behavior expected?
> > how are indexes created?
> >
> > Regards,
> > Raakhi
> >
>
Re: Secondary Indexes on HBase table
Posted by Andrew Purtell <ap...@apache.org>.
Yes, there is a subclassed client needed: o.a.h.h.client.transactional.TransactionalTable. I guess the shell needs an option to use it?
- Andy
________________________________
From: stack <st...@duboce.net>
To: hbase-user@hadoop.apache.org
Sent: Monday, June 1, 2009 10:17:17 AM
Subject: Re: Secondary Indexes on HBase table
Shell is probably not using the right client? Could that be it? There is a
special client needed doing transational+indexed.
St.Ack
On Mon, Jun 1, 2009 at 8:57 AM, Rakhi Khatwani <ra...@gmail.com>wrote:
> Hi Stack,
> Its not working if i insert the data using hbase shell...
> but if i insert the data using the Hbase API, it works.
>
> Regards,
> Raakhi
>
> On Mon, Jun 1, 2009 at 7:27 PM, stack <st...@duboce.net> wrote:
>
> > Sorry. I don't follow. Is it or is it not working for you now?
> > Thanks,
> > St.Ack
> >
> > On Mon, Jun 1, 2009 at 4:12 AM, Rakhi Khatwani <rakhi.khatwani@gmail.com
> > >wrote:
> >
> > > Hi,
> > > yea i actually did tht... but i did it from hbase shell. when i
> do
> > it
> > > programitically, it works fine.
> > >
> > > Regards,
> > > Raakhi
> > >
> > > On Sat, May 30, 2009 at 12:32 AM, Xinan Wu <wu...@gmail.com> wrote:
> > >
> > > > don't see any obvious problems. you sure you changed conf correctly
> so
> > > > you are running indexed region server? you sure you insert values
> into
> > > > entry:hostname and entry:msg columns?
> > > >
> > > > On Fri, May 29, 2009 at 1:24 AM, Rakhi Khatwani
> > > > <ra...@gmail.com> wrote:
> > > > > Hi,
> > > > >
> > > > > I was trying to create secondary indexes on hbase table. i used
> the
> > > > below
> > > > > reference to create the table. and i got successfully created.
> > > > > reference:
> > > > >
> > http://blog.eventexchange.net/2009/05/creating-hbase-indexes.html
> > > > >
> > > > > for example i create a table called TestIndexTable using the above
> > > code.
> > > > and
> > > > > i get two extra indextables TestIndexTable-hostname
> > > > > and TestIndexTable-msg.
> > > > >
> > > > >
> > > > > but whn i insert data into TestIndexTable, the
> > TestIndexTable-hostname
> > > > and
> > > > > TestIndexTable-msg remains empty. is this behavior expected?
> > > > > how are indexes created?
> > > > >
> > > > > Regards,
> > > > > Raakhi
> > > > >
> > > >
> > >
> >
>
Re: Secondary Indexes on HBase table
Posted by stack <st...@duboce.net>.
Shell is probably not using the right client? Could that be it? There is a
special client needed doing transational+indexed.
St.Ack
On Mon, Jun 1, 2009 at 8:57 AM, Rakhi Khatwani <ra...@gmail.com>wrote:
> Hi Stack,
> Its not working if i insert the data using hbase shell...
> but if i insert the data using the Hbase API, it works.
>
> Regards,
> Raakhi
>
> On Mon, Jun 1, 2009 at 7:27 PM, stack <st...@duboce.net> wrote:
>
> > Sorry. I don't follow. Is it or is it not working for you now?
> > Thanks,
> > St.Ack
> >
> > On Mon, Jun 1, 2009 at 4:12 AM, Rakhi Khatwani <rakhi.khatwani@gmail.com
> > >wrote:
> >
> > > Hi,
> > > yea i actually did tht... but i did it from hbase shell. when i
> do
> > it
> > > programitically, it works fine.
> > >
> > > Regards,
> > > Raakhi
> > >
> > > On Sat, May 30, 2009 at 12:32 AM, Xinan Wu <wu...@gmail.com> wrote:
> > >
> > > > don't see any obvious problems. you sure you changed conf correctly
> so
> > > > you are running indexed region server? you sure you insert values
> into
> > > > entry:hostname and entry:msg columns?
> > > >
> > > > On Fri, May 29, 2009 at 1:24 AM, Rakhi Khatwani
> > > > <ra...@gmail.com> wrote:
> > > > > Hi,
> > > > >
> > > > > I was trying to create secondary indexes on hbase table. i used
> the
> > > > below
> > > > > reference to create the table. and i got successfully created.
> > > > > reference:
> > > > >
> > http://blog.eventexchange.net/2009/05/creating-hbase-indexes.html
> > > > >
> > > > > for example i create a table called TestIndexTable using the above
> > > code.
> > > > and
> > > > > i get two extra indextables TestIndexTable-hostname
> > > > > and TestIndexTable-msg.
> > > > >
> > > > >
> > > > > but whn i insert data into TestIndexTable, the
> > TestIndexTable-hostname
> > > > and
> > > > > TestIndexTable-msg remains empty. is this behavior expected?
> > > > > how are indexes created?
> > > > >
> > > > > Regards,
> > > > > Raakhi
> > > > >
> > > >
> > >
> >
>
Re: Secondary Indexes on HBase table
Posted by Rakhi Khatwani <ra...@gmail.com>.
Hi Stack,
Its not working if i insert the data using hbase shell...
but if i insert the data using the Hbase API, it works.
Regards,
Raakhi
On Mon, Jun 1, 2009 at 7:27 PM, stack <st...@duboce.net> wrote:
> Sorry. I don't follow. Is it or is it not working for you now?
> Thanks,
> St.Ack
>
> On Mon, Jun 1, 2009 at 4:12 AM, Rakhi Khatwani <rakhi.khatwani@gmail.com
> >wrote:
>
> > Hi,
> > yea i actually did tht... but i did it from hbase shell. when i do
> it
> > programitically, it works fine.
> >
> > Regards,
> > Raakhi
> >
> > On Sat, May 30, 2009 at 12:32 AM, Xinan Wu <wu...@gmail.com> wrote:
> >
> > > don't see any obvious problems. you sure you changed conf correctly so
> > > you are running indexed region server? you sure you insert values into
> > > entry:hostname and entry:msg columns?
> > >
> > > On Fri, May 29, 2009 at 1:24 AM, Rakhi Khatwani
> > > <ra...@gmail.com> wrote:
> > > > Hi,
> > > >
> > > > I was trying to create secondary indexes on hbase table. i used the
> > > below
> > > > reference to create the table. and i got successfully created.
> > > > reference:
> > > >
> http://blog.eventexchange.net/2009/05/creating-hbase-indexes.html
> > > >
> > > > for example i create a table called TestIndexTable using the above
> > code.
> > > and
> > > > i get two extra indextables TestIndexTable-hostname
> > > > and TestIndexTable-msg.
> > > >
> > > >
> > > > but whn i insert data into TestIndexTable, the
> TestIndexTable-hostname
> > > and
> > > > TestIndexTable-msg remains empty. is this behavior expected?
> > > > how are indexes created?
> > > >
> > > > Regards,
> > > > Raakhi
> > > >
> > >
> >
>
Re: Secondary Indexes on HBase table
Posted by stack <st...@duboce.net>.
Sorry. I don't follow. Is it or is it not working for you now?
Thanks,
St.Ack
On Mon, Jun 1, 2009 at 4:12 AM, Rakhi Khatwani <ra...@gmail.com>wrote:
> Hi,
> yea i actually did tht... but i did it from hbase shell. when i do it
> programitically, it works fine.
>
> Regards,
> Raakhi
>
> On Sat, May 30, 2009 at 12:32 AM, Xinan Wu <wu...@gmail.com> wrote:
>
> > don't see any obvious problems. you sure you changed conf correctly so
> > you are running indexed region server? you sure you insert values into
> > entry:hostname and entry:msg columns?
> >
> > On Fri, May 29, 2009 at 1:24 AM, Rakhi Khatwani
> > <ra...@gmail.com> wrote:
> > > Hi,
> > >
> > > I was trying to create secondary indexes on hbase table. i used the
> > below
> > > reference to create the table. and i got successfully created.
> > > reference:
> > > http://blog.eventexchange.net/2009/05/creating-hbase-indexes.html
> > >
> > > for example i create a table called TestIndexTable using the above
> code.
> > and
> > > i get two extra indextables TestIndexTable-hostname
> > > and TestIndexTable-msg.
> > >
> > >
> > > but whn i insert data into TestIndexTable, the TestIndexTable-hostname
> > and
> > > TestIndexTable-msg remains empty. is this behavior expected?
> > > how are indexes created?
> > >
> > > Regards,
> > > Raakhi
> > >
> >
>