hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject Re: HBase shell providing wrong results with startrow(with composite key having String and Ints)
Date Mon, 08 Jun 2015 23:07:20 GMT
Hi Anil,

Can you please clarify what seems to be wrong for you?

You asked for start row "33078". Which mean Rows starting with a "3",
followed by a "3", a "0", etc. and the first row returned start with a "4"
which is correct given the startrow you have specified.

You seems to have a composite key. And you seems to scan without building
the composite key. How have you created your table and what is your key
design?

JM

2015-06-08 16:56 GMT-04:00 anil gupta <anilgupta84@gmail.com>:

> Hi All,
>
> I m having a lot of trouble dealing with HBase shell. I am running
> following query:
>
> scan 'CAR_ARCHIVE' , {COLUMNS=>'A', STARTROW => '33078' , LIMIT=>1}
>
> ROW
> COLUMN+CELL
>
>  4\x0010135\x001C4BJWEG2CL117550\x00\x7F\xFF\xFF\xFF
> column=A:BODYSTYLE, timestamp=1430280906358, value=SPORT
> UTILITY
>
>  4\x0010135\x001C4BJWEG2CL117550\x00\x7F\xFF\xFF\xFF
> column=A:BODYSTYLESLUG, timestamp=1430280906358,
> value=sport-utility
>
>  4\x0010135\x001C4BJWEG2CL117550\x00\x7F\xFF\xFF\xFF
> column=A:CARFAXREPORTAVAILABLE, timestamp=1430280906358,
> value=\x01
>
>  4\x0010135\x001C4BJWEG2CL117550\x00\x7F\xFF\xFF\xFF
> column=A:CARTYPE, timestamp=1430280906358, value={"isLuxury": false,
> "isTruck": false, "isSedan": false, "isCoupe": false, "isSuv": true,
> "isConvertible": false, "isVan": false, "isWagon": false,
> "isEasyCareQualified": true}
>
> I specified, startRow='33078'. Then how come this result shows up? What's
> going over here?
>
> --
> Thanks & Regards,
> Anil Gupta
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message