You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Tu Pham Phuong <ph...@gmail.com> on 2014/05/10 06:17:27 UTC

How to list all table, show table describe in Phoenix ?

Hi all,

I have a question is "How to list all table, show table describe in Phoenix
?" Without this fearture, it's relly hard to administration phoenix.

Thanks a lot.

-- 
*-----------------------------------------*
*Back-end & Big data developerPham Phuong Tu*

Re: How to list all table, show table describe in Phoenix ?

Posted by anil gupta <an...@gmail.com>.

If you are using phoenix via sqlline(i.e. on commandline) then use
following command:
list tables: "!tables"
describe table:"!describe <tablename>"

Thanks,
Anil



On Sat, May 10, 2014 at 8:51 PM, Tu Pham Phuong <ph...@gmail.com> wrote:

>
> On May 11, 2014, at 9:48 AM, Simon Toens <si...@gmail.com> wrote:
>
> Hi Pham,
>
> You can just use the regular jdbc metadata API.  See the getTables method
> in http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html
> .
>
>
> Simon
>
>
>
> On Sat, May 10, 2014 at 1:17 PM, Tu Pham Phuong <ph...@gmail.com> wrote:
>
>> Hi all,
>>
>> I have a question is "How to list all table, show table describe in
>> Phoenix ?" Without this fearture, it's relly hard to administration phoenix.
>>
>> Thanks a lot.
>>
>> --
>> *-----------------------------------------*
>> * Back-end & Big data developerPham Phuong Tu*
>>
>>
>>
>>
> Thanks, i mean is list by phoenix shell, can you do it?
>
>
>


-- 
Thanks & Regards,
Anil Gupta

Re: How to list all table, show table describe in Phoenix ?

Posted by Tu Pham Phuong <ph...@gmail.com>.

On May 11, 2014, at 9:48 AM, Simon Toens <si...@gmail.com> wrote:

> Hi Pham, 
> 
> You can just use the regular jdbc metadata API.  See the getTables method in http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html.
> 
> 
> Simon
> 
> 
> 
> On Sat, May 10, 2014 at 1:17 PM, Tu Pham Phuong <ph...@gmail.com> wrote:
> Hi all,
> 
> I have a question is "How to list all table, show table describe in Phoenix ?" Without this fearture, it's relly hard to administration phoenix.
> 
> Thanks a lot.
> 
> -- 
> -----------------------------------------
> Back-end & Big data developer
> Pham Phuong Tu
> 
> 
>  
> Thanks, i mean is list by phoenix shell, can you do it?

Re: How to list all table, show table describe in Phoenix ?

Posted by Simon Toens <si...@gmail.com>.

Hi Pham,

You can just use the regular jdbc metadata API.  See the getTables method
in http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html.

Simon

On Sat, May 10, 2014 at 1:17 PM, Tu Pham Phuong <ph...@gmail.com> wrote:

> Hi all,
>
> I have a question is "How to list all table, show table describe in
> Phoenix ?" Without this fearture, it's relly hard to administration phoenix.
>
> Thanks a lot.
>
> --
> *-----------------------------------------*
> * Back-end & Big data developerPham Phuong Tu*
>
>
>
>