phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arun J <mail....@gmail.com>
Subject Re: Add pseudo columns to an existing view
Date Tue, 04 Aug 2020 19:21:52 GMT
Josh,

I had looked through the documentation
<https://phoenix.apache.org/views.html> and all the tests (core/../end2end)
on CREATE/ALTER VIEW usage.  I could not find appropriate documentation
around this.

I am trying to ALTER VIEW as below and it doesn't seem to be supported.
Here the STRVALUE is one of column in the original View.  Appreciate any
pointers.

ALTER VIEW MY_VIEW_NAME ADD NUMVALUE DECIMAL TO_NUMBER(STRVALUE)


On Fri, Jul 31, 2020 at 7:53 PM Josh Elser <elserj@apache.org> wrote:

> Yes. Please see the docs which illustrate how to create views.
>
> On 7/28/20 2:12 AM, Arun J wrote:
> > Team,
> > Can we create or alter a view to add a column which is pseudo columns
> > such as
> >
> > # FULLNAME from other columns such as FIRSTNAME + LASTNAME
> > # NUMVALUE from other columns TO_NUMBER(STRVALUE)
> >
> > This would be quite helpful to avoid changing data types everytime in
> > the client query.
> >
> > Thanks in advance.
> > JAK
>

Mime
View raw message