You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by "liubo@fcyun.com" <li...@fcyun.com> on 2017/10/20 03:52:47 UTC

phoenix connect to hbase, cannot see the hive tables


Hi all,

    I have installed phoenix to connect hbase, I cannot see the kylin tables in phoenix client while the hbase shell can. Any ideas, thanks.
    
     I want quey kylin tables in phoenix, is it possible?


1.phoenix command: !tables 
just saw hbase system tables:


2.but in hbase shell, it can list all kylin tables:


Thanks very much!

Best Regards~



liubo@fcyun.com

Re: phoenix connect to hbase, cannot see the hive tables

Posted by Billy Liu <bi...@apache.org>.
Kylin does not save table structure into HBase, but the encoded cube
structure. You could not send SQL to HBase's Kylin tables from Phoenix.
Kylin has its own JDBC/ODBC/Query REST API.

2017-10-20 11:55 GMT+08:00 liubo@fcyun.com <li...@fcyun.com>:

> sorry, wrong written title, The correct is :
> phoenix connect to hbase, cannot see the Kylin tables in phoenix while
> they can seen by hbase shell.
>
>
>
> ------------------------------
> liubo@fcyun.com
>
>
> *From:* liubo@fcyun.com
> *Date:* 2017-10-20 11:52
> *To:* user <us...@kylin.apache.org>
> *Subject:* phoenix connect to hbase, cannot see the hive tables
>
>
> Hi all,
>
>     I have installed phoenix to connect hbase, I cannot see the kylin
> tables in phoenix client while the hbase shell can. Any ideas, thanks.
>
>      I want quey kylin tables in phoenix, is it possible?
>
>
> 1.phoenix command: !tables
> just saw hbase system tables:
>
>
> 2.but in hbase shell, it can list all kylin tables:
>
>
> Thanks very much!
>
> Best Regards~
>
> ------------------------------
> liubo@fcyun.com
>
>

Re: phoenix connect to hbase, cannot see the hive tables

Posted by "liubo@fcyun.com" <li...@fcyun.com>.

Hi all,

    I have installed phoenix to connect hbase, I cannot see the kylin tables in phoenix client while the hbase shell can. Any ideas, thanks.
    
     I want quey kylin tables in phoenix, is it possible?


1.phoenix command: !tables 
just saw hbase system tables:


2.but in hbase shell, it can list all kylin tables:


Thanks very much!

Best Regards~



liubo@fcyun.com