phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Verhoeven <Kevin.Verhoe...@ds-iq.com>
Subject RE: Query DDL from Phoenix
Date Tue, 14 Jul 2015 18:42:19 GMT
Thank you for your input, I appreciate your help!

Kevin

From: Cody Marcel [mailto:cmarcel@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 resultSet = dbmd.getColumns(null, schemaName, tableName, null);

On Mon, Jul 13, 2015 at 8:51 PM, Eli Levine <elilevine@gmail.com<mailto:elilevine@gmail.com>>
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 Phoenix if you know what you are doing.


On Jul 13, 2015, at 4:57 PM, Kevin Verhoeven <Kevin.Verhoeven@ds-iq.com<mailto:Kevin.Verhoeven@ds-iq.com>>
wrote:
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


Mime
View raw message