You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Alex Levin <al...@gmail.com> on 2013/07/11 21:16:30 UTC

split region

Hi,

I'm trying to split one region in the table  ( hbase 0.92.2 )  but getting
"ERROR: Unknown table"  ...

I guess I'm doing something wrong and appreciate and recommendations

the region I'm trying to split is:


MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899


so I'm trying to run in hbase shell ( split 'regionName' # format:
'tableName,startKey,id'  )


hbase(main):003:0> split
'MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899'

ERROR: Unknown table
MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899!



Tried to manipulate with quotes and \ , but no luck ...


Thanks
-- Alex

Re: split region

Posted by Sergey Shelukhin <se...@hortonworks.com>.
That is right, double quotes must be used for binary encoding to work
correctly.

On Mon, Jul 15, 2013 at 11:20 AM, Alexandre Normand <
alexandre.normand@opower.com> wrote:

> Have you tried using double-quotes?
> I would try split
> "MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899."
> and if that still does't work maybe try:
> split 'MY_TABLE', "\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I"
>
> I'm suggesting this because I was dealing with splits last week and had to
> use double-quotes although I don't have the exact command I ended up using
> (I also had hex in my start key).
>
> On Monday, July 15, 2013 at 10:49 AM, Tianying Chang wrote:
>
> > I think the feature of using encoded name for split is only available in
> 94, not in 92? In 92, you have to use the full name as you first tried.
> Unfortunately there is bug for certain name.
> >
> > -----Original Message-----
> > From: Alex Levin [mailto:alevin@gmail.com]
> > Sent: Thursday, July 11, 2013 12:33 PM
> > To: user@hbase.apache.org (mailto:user@hbase.apache.org)
> > Subject: Re: split region
> >
> > tried it also,
> > I believe in my case the encoded region name is
> faa7f7c8d63a9d2e04566c4a97090899
> >
> > and result:
> >
> > hbase(main):004:0> split 'faa7f7c8d63a9d2e04566c4a97090899'
> >
> > │····
> >
> >
> > │····
> > ERROR: Unknown table faa7f7c8d63a9d2e04566c4a97090899!
> >
> > │····
> >
> >
> > Thanks
> > -- Alex
> >
> >
> >
> > On Thu, Jul 11, 2013 at 12:20 PM, Ted Yu <yuzhihong@gmail.com (mailto:
> yuzhihong@gmail.com)> wrote:
> >
> > > Can you try specifying encoded region name ?
> > >
> > > Cheers
> > >
> > > On Thu, Jul 11, 2013 at 12:16 PM, Alex Levin <alevin@gmail.com(mailto:
> alevin@gmail.com)> wrote:
> > >
> > > > Hi,
> > > >
> > > > I'm trying to split one region in the table ( hbase 0.92.2 ) but
> > > getting
> > > > "ERROR: Unknown table" ...
> > > >
> > > > I guess I'm doing something wrong and appreciate and recommendations
> > > >
> > > > the region I'm trying to split is:
> > > MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,13700203366
> > > 67.faa7f7c8d63a9d2e04566c4a97090899
> > > >
> > > >
> > > > so I'm trying to run in hbase shell ( split 'regionName' # format:
> > > > 'tableName,startKey,id' )
> > > >
> > > >
> > > > hbase(main):003:0> split
> > >
> 'MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899'
> > > >
> > > > ERROR: Unknown table
> > >
> MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899!
> > > >
> > > >
> > > >
> > > > Tried to manipulate with quotes and \ , but no luck ...
> > > >
> > > >
> > > > Thanks
> > > > -- Alex
> > > >
> > >
> > >
> >
> >
> >
>
>
>

Re: split region

Posted by Alex Levin <al...@gmail.com>.
bingo !!! :)

I've  tried combinations of double and single quotes, but probably not the
right one


this one is working:

 split
'MY_TABLE',"\xEBj\xF9G\xF0\x1F\xF1\xCC\xCB\xAFE\xAD:\x17\xAF\xD3,1373583389172.04035474cc17c50581fb8d54b57d3afd"


Thanks everyone !!!

-- Alex




On Mon, Jul 15, 2013 at 11:20 AM, Alexandre Normand <
alexandre.normand@opower.com> wrote:

> Have you tried using double-quotes?
> I would try split
> "MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899."
> and if that still does't work maybe try:
> split 'MY_TABLE', "\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I"
>
> I'm suggesting this because I was dealing with splits last week and had to
> use double-quotes although I don't have the exact command I ended up using
> (I also had hex in my start key).
>
> On Monday, July 15, 2013 at 10:49 AM, Tianying Chang wrote:
>
> > I think the feature of using encoded name for split is only available in
> 94, not in 92? In 92, you have to use the full name as you first tried.
> Unfortunately there is bug for certain name.
> >
> > -----Original Message-----
> > From: Alex Levin [mailto:alevin@gmail.com]
> > Sent: Thursday, July 11, 2013 12:33 PM
> > To: user@hbase.apache.org (mailto:user@hbase.apache.org)
> > Subject: Re: split region
> >
> > tried it also,
> > I believe in my case the encoded region name is
> faa7f7c8d63a9d2e04566c4a97090899
> >
> > and result:
> >
> > hbase(main):004:0> split 'faa7f7c8d63a9d2e04566c4a97090899'
> >
> > │····
> >
> >
> > │····
> > ERROR: Unknown table faa7f7c8d63a9d2e04566c4a97090899!
> >
> > │····
> >
> >
> > Thanks
> > -- Alex
> >
> >
> >
> > On Thu, Jul 11, 2013 at 12:20 PM, Ted Yu <yuzhihong@gmail.com (mailto:
> yuzhihong@gmail.com)> wrote:
> >
> > > Can you try specifying encoded region name ?
> > >
> > > Cheers
> > >
> > > On Thu, Jul 11, 2013 at 12:16 PM, Alex Levin <alevin@gmail.com(mailto:
> alevin@gmail.com)> wrote:
> > >
> > > > Hi,
> > > >
> > > > I'm trying to split one region in the table ( hbase 0.92.2 ) but
> > > getting
> > > > "ERROR: Unknown table" ...
> > > >
> > > > I guess I'm doing something wrong and appreciate and recommendations
> > > >
> > > > the region I'm trying to split is:
> > > MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,13700203366
> > > 67.faa7f7c8d63a9d2e04566c4a97090899
> > > >
> > > >
> > > > so I'm trying to run in hbase shell ( split 'regionName' # format:
> > > > 'tableName,startKey,id' )
> > > >
> > > >
> > > > hbase(main):003:0> split
> > >
> 'MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899'
> > > >
> > > > ERROR: Unknown table
> > >
> MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899!
> > > >
> > > >
> > > >
> > > > Tried to manipulate with quotes and \ , but no luck ...
> > > >
> > > >
> > > > Thanks
> > > > -- Alex
> > > >
> > >
> > >
> >
> >
> >
>
>
>

Re: split region

Posted by Alexandre Normand <al...@opower.com>.
Have you tried using double-quotes?   
I would try split "MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899." and if that still does't work maybe try:
split 'MY_TABLE', "\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I"

I'm suggesting this because I was dealing with splits last week and had to use double-quotes although I don't have the exact command I ended up using (I also had hex in my start key).  

On Monday, July 15, 2013 at 10:49 AM, Tianying Chang wrote:

> I think the feature of using encoded name for split is only available in 94, not in 92? In 92, you have to use the full name as you first tried. Unfortunately there is bug for certain name.  
>  
> -----Original Message-----
> From: Alex Levin [mailto:alevin@gmail.com]  
> Sent: Thursday, July 11, 2013 12:33 PM
> To: user@hbase.apache.org (mailto:user@hbase.apache.org)
> Subject: Re: split region
>  
> tried it also,
> I believe in my case the encoded region name is faa7f7c8d63a9d2e04566c4a97090899
>  
> and result:
>  
> hbase(main):004:0> split 'faa7f7c8d63a9d2e04566c4a97090899'
>  
> │····
>  
>  
> │····
> ERROR: Unknown table faa7f7c8d63a9d2e04566c4a97090899!
>  
> │····
>  
>  
> Thanks
> -- Alex
>  
>  
>  
> On Thu, Jul 11, 2013 at 12:20 PM, Ted Yu <yuzhihong@gmail.com (mailto:yuzhihong@gmail.com)> wrote:
>  
> > Can you try specifying encoded region name ?
> >  
> > Cheers
> >  
> > On Thu, Jul 11, 2013 at 12:16 PM, Alex Levin <alevin@gmail.com (mailto:alevin@gmail.com)> wrote:
> >  
> > > Hi,
> > >  
> > > I'm trying to split one region in the table ( hbase 0.92.2 ) but
> > getting
> > > "ERROR: Unknown table" ...
> > >  
> > > I guess I'm doing something wrong and appreciate and recommendations
> > >  
> > > the region I'm trying to split is:
> > MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,13700203366
> > 67.faa7f7c8d63a9d2e04566c4a97090899
> > >  
> > >  
> > > so I'm trying to run in hbase shell ( split 'regionName' # format:
> > > 'tableName,startKey,id' )
> > >  
> > >  
> > > hbase(main):003:0> split
> > 'MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899'
> > >  
> > > ERROR: Unknown table
> > MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899!
> > >  
> > >  
> > >  
> > > Tried to manipulate with quotes and \ , but no luck ...
> > >  
> > >  
> > > Thanks
> > > -- Alex
> > >  
> >  
> >  
>  
>  
>  



RE: split region

Posted by Tianying Chang <ti...@ebaysf.com>.
I think the feature of using encoded name for split is only available in 94, not in 92?  In 92, you have to use the full name as you first tried. Unfortunately there is bug for certain name. 

-----Original Message-----
From: Alex Levin [mailto:alevin@gmail.com] 
Sent: Thursday, July 11, 2013 12:33 PM
To: user@hbase.apache.org
Subject: Re: split region

tried it also,
I believe in my case the encoded region name is faa7f7c8d63a9d2e04566c4a97090899

and result:

hbase(main):004:0> split 'faa7f7c8d63a9d2e04566c4a97090899'

                                                   │····


                                                   │····
ERROR: Unknown table faa7f7c8d63a9d2e04566c4a97090899!

                                                    │····


Thanks
-- Alex



On Thu, Jul 11, 2013 at 12:20 PM, Ted Yu <yu...@gmail.com> wrote:

> Can you try specifying encoded region name ?
>
> Cheers
>
> On Thu, Jul 11, 2013 at 12:16 PM, Alex Levin <al...@gmail.com> wrote:
>
> > Hi,
> >
> > I'm trying to split one region in the table  ( hbase 0.92.2 )  but
> getting
> > "ERROR: Unknown table"  ...
> >
> > I guess I'm doing something wrong and appreciate and recommendations
> >
> > the region I'm trying to split is:
> >
> >
> >
> >
> MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,13700203366
> 67.faa7f7c8d63a9d2e04566c4a97090899
> >
> >
> > so I'm trying to run in hbase shell ( split 'regionName' # format:
> > 'tableName,startKey,id'  )
> >
> >
> > hbase(main):003:0> split
> >
> >
> 'MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899'
> >
> > ERROR: Unknown table
> >
> >
> MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899!
> >
> >
> >
> > Tried to manipulate with quotes and \ , but no luck ...
> >
> >
> > Thanks
> > -- Alex
> >
>

Re: split region

Posted by Alex Levin <al...@gmail.com>.
tried it also,
I believe in my case the encoded region name
is faa7f7c8d63a9d2e04566c4a97090899

and result:

hbase(main):004:0> split 'faa7f7c8d63a9d2e04566c4a97090899'

                                                   │····


                                                   │····
ERROR: Unknown table faa7f7c8d63a9d2e04566c4a97090899!

                                                    │····


Thanks
-- Alex



On Thu, Jul 11, 2013 at 12:20 PM, Ted Yu <yu...@gmail.com> wrote:

> Can you try specifying encoded region name ?
>
> Cheers
>
> On Thu, Jul 11, 2013 at 12:16 PM, Alex Levin <al...@gmail.com> wrote:
>
> > Hi,
> >
> > I'm trying to split one region in the table  ( hbase 0.92.2 )  but
> getting
> > "ERROR: Unknown table"  ...
> >
> > I guess I'm doing something wrong and appreciate and recommendations
> >
> > the region I'm trying to split is:
> >
> >
> >
> >
> MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899
> >
> >
> > so I'm trying to run in hbase shell ( split 'regionName' # format:
> > 'tableName,startKey,id'  )
> >
> >
> > hbase(main):003:0> split
> >
> >
> 'MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899'
> >
> > ERROR: Unknown table
> >
> >
> MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899!
> >
> >
> >
> > Tried to manipulate with quotes and \ , but no luck ...
> >
> >
> > Thanks
> > -- Alex
> >
>

Re: split region

Posted by Ted Yu <yu...@gmail.com>.
Can you try specifying encoded region name ?

Cheers

On Thu, Jul 11, 2013 at 12:16 PM, Alex Levin <al...@gmail.com> wrote:

> Hi,
>
> I'm trying to split one region in the table  ( hbase 0.92.2 )  but getting
> "ERROR: Unknown table"  ...
>
> I guess I'm doing something wrong and appreciate and recommendations
>
> the region I'm trying to split is:
>
>
>
> MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899
>
>
> so I'm trying to run in hbase shell ( split 'regionName' # format:
> 'tableName,startKey,id'  )
>
>
> hbase(main):003:0> split
>
> 'MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899'
>
> ERROR: Unknown table
>
> MY_TABLE,\x8D\xFD\xFA\xF0\x13\xB8\x1Fs\x934\xCC{h\x14\xE6I,1370020336667.faa7f7c8d63a9d2e04566c4a97090899!
>
>
>
> Tried to manipulate with quotes and \ , but no luck ...
>
>
> Thanks
> -- Alex
>