Re: select Dynamic column Name

ot;Manjee, Sunile" >>> wrote: >>> >>>> James, >>>> Where can I find info on "JDBC Metadata APIs for each view entity" >>>> >>>> From: James Taylor >>>> Reply-To: "user@phoenix.apache.org" >>>> Date: Monday, August 24, 2015 at 3:04 PM >>>> To: user >>>> Subject: Re: select Dynamic column Name >>>> >>>> JDBC Metadata APIs for each view entity >>>> >>>

Re: select Dynamic column Name

" >>> >>> From: James Taylor >>> Reply-To: "user@phoenix.apache.org" >>> Date: Monday, August 24, 2015 at 3:04 PM >>> To: user >>> Subject: Re: select Dynamic column Name >>> >>> JDBC Metadata APIs for each view entity >>> >>

Re: select Dynamic column Name

7:28 pm, "Manjee, Sunile" > wrote: > >> James, >> Where can I find info on "JDBC Metadata APIs for each view entity" >> >> From: James Taylor > > >> Reply-To: "user@phoenix.apache.org >> " < >> user@phoe

Re: select Dynamic column Name

ee, Sunile" wrote: > James, > Where can I find info on "JDBC Metadata APIs for each view entity" > > From: James Taylor > Reply-To: "user@phoenix.apache.org" > Date: Monday, August 24, 2015 at 3:04 PM > To: user > Subject: Re: select Dynamic column Name > > JDBC Metadata APIs for each view entity >

Re: select Dynamic column Name

, 2015 at 3:04 PM To: user mailto:user@phoenix.apache.org>> Subject: Re: select Dynamic column Name JDBC Metadata APIs for each view entity

Re: select Dynamic column Name

Hi Sunile, Dynamic columns are not tracked at all in Phoenix, however an alternative is to leverage support for updatable views[1] in Phoenix in which you can dynamically create and add columns on-the-fly. In many use cases I've seen where there are hundreds of sparse columns defined for a schema,

select Dynamic column Name

I am unable to find a sql way to retrieve dynamic column names. For example I have 1000 columns, and 100 of them start with name student. I would like to retrieve all columns which start with student*. Any ideas how I could do this with phoenix?