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:[email protected]]
Sent: 01 February 2011 19:49
To: [email protected]
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 <[email protected]> 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: [email protected] <mailto:[email protected]>
> 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
>
>
>
>
