hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stuart Scott" <Stuart.Sc...@e-mis.com>
Subject RE: Accessing column information via Thrift/PHP/Scanner
Date Wed, 02 Feb 2011 07:03:12 GMT
Hi Ryan,

Thanks for the e-mail.
I can see all the data with the shell.
Currently I have all my column family and column names in uppercase (to avoid case sensitive
issues).
I can access the information without any problems via my Java project. This is fine. I use
Result.getValue(Bytes.toBytes("NAME"),Bytes.toBytes("FIRSTNAME));
It's just the thrift implementation. I can get the column data but I need to know the column-family:column-name
. What would be the correct syntax to access a column-family:column-name from a TRowResult?
Or can the column-family:column-name be accessed from a TCell some how? Or is it possible
to set the order the columns come back in when the scanner is created?

Regards

Stuart



-----Original Message-----
From: Ryan Rawson [mailto:ryanobjc@gmail.com] 
Sent: 01 February 2011 19:49
To: user@hbase.apache.org
Subject: Re: Accessing column information via Thrift/PHP/Scanner

when you scan using the shell what do you see?  Note that qualifier names are just byte[]
and thus caps sensitive.

-ryan

On Tue, Feb 1, 2011 at 6:38 AM, Stuart Scott <Stuart.Scott@e-mis.com> wrote:
> Hi,
>
>
>
> Wonder if anyone could offer any advice please? I've been working on 
> this for a few hours and can't suss it out.
>
> Using Thrift through PHP, I can loop down a Hbase table fine. I just 
> can't pull out the column values associated with the row. The row is 
> returned correctly but I can't seem to get access to the column data 
> within the column family array. I've tried various things... my latest 
> version is below. I've looked in the Hbase wrappers and can't see 
> anything obvious I'm doing wrong...
>
>
>
> Any help would be greatly appreciated..
>
>
>
> $tbl="TEST";
>
> $family = array("FNAMEINFO:TOTAL");
> //column family:column
>
> $X=$client->scannerOpen($tbl,"",$family);
>
> while (true )
>
> {
>
> $get_arr = $client->scannerGet($X);
>
> {
>
> if($get_arr == null) break;
>
>  foreach ( $get_arr as $TRowResult )
>
>    {
>
>      $row=$TRowResult->row;
>
>      echo $row;
> //returns the row number correctly
>
>      $column = $TRowResult->columns;
>
>      foreach ($column as $family_column=>$Tcell)
>
>       {
>
>        $rec=$Tcell->value;
> //doesn't return anything for the column family:column
>
>                echo $rec->value;
>
>       }
>
>    }
>
>  }
>
> }
>
>
>
> Regards
>
>
>
> Stuart Scott
>
> System Architect
> emis intellectual technology
> Fulford Grange, Micklefield Lane
> Rawdon Leeds LS19 6BA
> E-mail: stuart.scott@e-mis.com <mailto:stuart.scott@e-mis.com>
> Website: www.emisit.com <outbind://26/www.emisit.com>
>
> Privileged and/or Confidential information may be contained in this 
> message. If you are not the original addressee indicated in this 
> message (or responsible for delivery of the message to such person), 
> you may not copy or deliver this message to anyone. In such case, 
> please delete this message, and notify us immediately. Opinions, 
> conclusions and other information expressed in this message are not 
> given or endorsed by EMIS nor can I conclude contracts on its behalf 
> unless otherwise indicated by an authorised representative independently of this message.
>
> EMIS reserves the right to monitor, intercept and (where appropriate) 
> read all incoming and outgoing communications. By replying to this 
> message and where necessary you are taken as being aware of and giving 
> consent to such monitoring, interception and reading.
>
>
> EMIS is a trading name of Egton Medical Information Systems Limited.
> Registered in England. No 2117205. Registered Office: Fulford Grange, 
> Micklefield Lane, Rawdon, Leeds, LS19 6BA
>
>
>
>

Mime
View raw message