Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of johnnyenglish739@gmail.com
 designates 209.85.215.46 as permitted sender)
MIME-Version: 1.0
Date: Fri, 13 Sep 2013 16:38:50 +0200
Message-ID: 
 <CAMPmjh=tAbO6xR+nS4OnqE5FdvP6WGATmD2wSk+0b5GQErp=SA@mail.gmail.com>
Subject: Wrong HBase Sort Order with Pig
From: John <johnnyenglish739@gmail.com>
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=001a11c238e81e77eb04e644d032

--001a11c238e81e77eb04e644d032
Content-Type: text/plain; charset=ISO-8859-1

Hi, I already ask this on the pig mailing list. But because I'm not sure if
it is a Pig or HBase issue, I will ask here too since the Pig Function is
using a hbae scan operation. Here is my Questions:

I have created a HBase Table in the hbase shell and added some data. In
http://hbase.apache.org/book/dm.sort.html is written that the datasets are
first sorted by the rowkey and then the column. So I tried something in the
HBase Shell: http://pastebin.com/gLVAX0rJ

Everything looks fine. I got the right order a -> c -> d like expected.

Now I tried the same with Apache Pig in Java: http://pastebin.com/jdTpj4Fu

I got this result:

(key1,[c#val,d#val,a#val])

So, now the order is c -> d -> a. That seems a little odd to me, shouldn't
it be the same like in HBase? It's important for me to get the right order
because I transform the map afterwards into a bag and then join it with
other tables. If both inputs are sorted I could use a merge join without
sorting these two datasets. So does anyone know how it is possible to get
the sorted map (or bag) of the columns?


thanks

--001a11c238e81e77eb04e644d032--