phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: select Dynamic column Name
Date Thu, 27 Aug 2015 14:56:36 GMT
Use these standard JDBC APIs:
http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html

Querying directly against the SYSTEM.CATALOG is not recommended as
underlying schema changes may impact you.

Thanks,
James

On Thursday, August 27, 2015, Ns G <nsgnsg84@gmail.com> wrote:

> Hi James,
>
> I think we can get the dynamic column names from SYSTEM.CATALOG table.
> Using as co-related sub query we can use  in select statement and fetch
> details. Isn't this an option to consider? Do you see anything wrong with
> this approach?
>
> Thanks,
> Satya
> On 27-Aug-2015 7:28 pm, "Manjee, Sunile" <Sunile.Manjee@teradata.com
> <javascript:_e(%7B%7D,'cvml','Sunile.Manjee@teradata.com');>> wrote:
>
>> James,
>> Where can I find info on "JDBC Metadata APIs for each view entity"
>>
>> From: James Taylor <jamestaylor@apache.org
>> <javascript:_e(%7B%7D,'cvml','jamestaylor@apache.org');>>
>> Reply-To: "user@phoenix.apache.org
>> <javascript:_e(%7B%7D,'cvml','user@phoenix.apache.org');>" <
>> user@phoenix.apache.org
>> <javascript:_e(%7B%7D,'cvml','user@phoenix.apache.org');>>
>> Date: Monday, August 24, 2015 at 3:04 PM
>> To: user <user@phoenix.apache.org
>> <javascript:_e(%7B%7D,'cvml','user@phoenix.apache.org');>>
>> Subject: Re: select Dynamic column Name
>>
>> JDBC Metadata APIs for each view entity
>>
>

Mime
View raw message