put 'tab_2_cf', 'r1', 'cf1:address', 'CALIF'

put to cf2 or cf1??   Typo?

-Anoop-

On Wed, Feb 11, 2015 at 2:16 AM, Siva <[email protected]> wrote:

> Hi Everyone,
>
>
>
> When I map a table in Phoenix from Hbase which has two column families, I
> could not able to see the data for 2nd column family from Phoenix.
>
>
>
> Hbase:
>
>
>
> create 'tab_2_cf', 'cf1', 'cf2'
>
>
>
> put 'tab_2_cf', 'r1', 'cf1:name', 'asdf'
>
>
>
> put 'tab_2_cf', 'r1', 'cf1:address', 'CALIF'
>
>
>
> From Phoenix:
>
>
>
> create view "tab_2_cf"(pk varchar primary key, "cf1"."name" varchar,
> "cf2"."address" varchar);
>
>
>
> queried the table from phoenix, data is being shown as NULL for Column
> address.
>
>
>
> 0: jdbc:phoenix:172.31.45.176:2181:/hbase> select * from "tab_2_cf";
>
> +------------+------------+------------+
>
> |     PK     |    name    |  *address*   |
>
> +------------+------------+------------+
>
> | r1         | asdf       | null       |
>
> +------------+------------+------------+
>
>
>
> Any help on this?
>
>
>
> Thanks,
>
> Siva.
>

Reply via email to