Is there a way to query the table structure of user tables from Phoenix? For
example, to retrieve the CREATE TABLE syntax?
Thank you,
Kevin Verhoeven
The standard JDBC way is to use Connection.getMetadata(). See if that does what
you need. You can also query SYSTEM.TABLE directly via Phoenix if you know what
you are doing.
> On Jul 13, 2015, at 4:57 PM, Kevin Verhoeven
> wrote:
>
> Is there a way to query the table structure of user tab
You can use !describe or !tables from the sqlline. Also typing
!help you can find other helpful things
On יום ג׳, 14 ביול 2015 at 06:52 Eli Levine wrote:
> The standard JDBC way is to use Connection.getMetadata(). See if that does
> what you need. You can also query SYSTEM.TABLE directly via Pho
This should do it.
DatabaseMetaData dbmd = connection.getMetaData();
ResultSet resultSet = dbmd.getColumns(null, schemaName, tableName, null);
On Mon, Jul 13, 2015 at 8:51 PM, Eli Levine wrote:
> The standard JDBC way is to use Connection.getMetadata(). See if that does
> what you need. You ca
Thank you for your input, I appreciate your help!
Kevin
From: Cody Marcel [mailto:cmar...@salesforce.com]
Sent: Tuesday, July 14, 2015 9:18 AM
To: user@phoenix.apache.org
Subject: Re: Query DDL from Phoenix
This should do it.
DatabaseMetaData dbmd = connection.getMetaData();
ResultSet