Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1B73F18FA7 for ; Mon, 8 Jun 2015 23:07:46 +0000 (UTC) Received: (qmail 51549 invoked by uid 500); 8 Jun 2015 23:07:44 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 51480 invoked by uid 500); 8 Jun 2015 23:07:44 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 51469 invoked by uid 99); 8 Jun 2015 23:07:43 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Jun 2015 23:07:43 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 72E231A4761 for ; Mon, 8 Jun 2015 23:07:43 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.98 X-Spam-Level: *** X-Spam-Status: No, score=3.98 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=3, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01] autolearn=disabled Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id Tvf4LIAA9GPM for ; Mon, 8 Jun 2015 23:07:42 +0000 (UTC) Received: from mail-vn0-f49.google.com (mail-vn0-f49.google.com [209.85.216.49]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id EBD34275E9 for ; Mon, 8 Jun 2015 23:07:41 +0000 (UTC) Received: by vnbg190 with SMTP id g190so306943vnb.6 for ; Mon, 08 Jun 2015 16:07:41 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:content-type; bh=mjROTuhdlA5ReCp/oWqJ5Sh1WfGd/Hs9MUt8boMpt1E=; b=kFZswUD73LFeU3x/LgHJ57Fty2Tv+xdecJ4QH2yJ/UCj+mZZ5wYSRrxIcdL2f1ggMS 8jA9e2o6S+zO9juFiaGfI4vV5qbkJTCxSDUDbtHidwP95TZFv8DcXKO9sfVoC4Trf62H Ih6YHOBhcSJq5Bc56wr732se43HYLXBG/tgVx9QMGSvtrz68ZMv0L0Poqk+fboBcX9Jz M12pHANeshCGJH9Mow9eKthVEz4FZDy+90xtW2BdYwqMl4EQYQgRQMnghotHt8MDP62N AvaDS7EBBebKVyuQF4/SEZ4/ybQSbGIrlh+4o/3Qj9UHVl+5QSt0u738fUCQCm9SzESo dzwA== X-Gm-Message-State: ALoCoQnHY7sJrdTFetW6xBkGAC+jPPZ0xMd/KfcaksJHJwUX5w1SFpjiwmwwuTrht2NG+sj9cseH X-Received: by 10.52.88.111 with SMTP id bf15mr1968869vdb.20.1433804860912; Mon, 08 Jun 2015 16:07:40 -0700 (PDT) MIME-Version: 1.0 Received: by 10.52.21.35 with HTTP; Mon, 8 Jun 2015 16:07:20 -0700 (PDT) In-Reply-To: References: From: Jean-Marc Spaggiari Date: Mon, 8 Jun 2015 19:07:20 -0400 Message-ID: Subject: Re: HBase shell providing wrong results with startrow(with composite key having String and Ints) To: user Content-Type: multipart/alternative; boundary=20cf307cfbe6698b16051809b534 --20cf307cfbe6698b16051809b534 Content-Type: text/plain; charset=UTF-8 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 : > 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 > --20cf307cfbe6698b16051809b534--