You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Simon Wang <si...@airbnb.com> on 2016/06/28 05:27:04 UTC
Re: phoenix do not show my tables
Do you mean your HBase tables? They don’t have Phoenix schema. Try map a HBase table into Phoenix. <https://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table>
-Tongzhou
> On Jun 27, 2016, at 10:18 PM, 易剑 <ey...@gmail.com> wrote:
>
> Why do not phoenix show my tables except SYSTEM TABLES.
>
>
> 0: jdbc:phoenix:hadoop-001:2181> !tables
> +------------+--------------+-------------+---------------+----------+---------+
> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_NA |
> +------------+--------------+-------------+---------------+----------+---------+
> | | SYSTEM | CATALOG | SYSTEM TABLE | | |
> | | SYSTEM | FUNCTION | SYSTEM TABLE | | |
> | | SYSTEM | SEQUENCE | SYSTEM TABLE | | |
> | | SYSTEM | STATS | SYSTEM TABLE | | |
> +------------+--------------+-------------+---------------+----------+---------+
> 0: jdbc:phoenix:hadoop-001:2181>
Re: phoenix do not show my tables
Posted by 易剑 <ey...@gmail.com>.
Thanks, Tongzhou. They have not Phoenix schama. I don't map the HBase
tables into Phoenix.
2016-06-28 13:27 GMT+08:00 Simon Wang <si...@airbnb.com>:
> Do you mean your HBase tables? They don’t have Phoenix schema. Try map a
> HBase table into Phoenix.
> <https://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table>
>
> -Tongzhou
>
> On Jun 27, 2016, at 10:18 PM, 易剑 <ey...@gmail.com> wrote:
>
> Why do not phoenix show my tables except SYSTEM TABLES.
>
>
> 0: jdbc:phoenix:hadoop-001:2181> !tables
>
> +------------+--------------+-------------+---------------+----------+---------+
> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS |
> TYPE_NA |
>
> +------------+--------------+-------------+---------------+----------+---------+
> | | SYSTEM | CATALOG | SYSTEM TABLE | |
> |
> | | SYSTEM | FUNCTION | SYSTEM TABLE | |
> |
> | | SYSTEM | SEQUENCE | SYSTEM TABLE | |
> |
> | | SYSTEM | STATS | SYSTEM TABLE | |
> |
>
> +------------+--------------+-------------+---------------+----------+---------+
> 0: jdbc:phoenix:hadoop-001:2181>
>
>
>
--
Hadoop Forum: http://www.hadoopor.com
Open mooon: https://github.com/eyjian/mooon