https://calcite.apache.org/docs/reference.html
On Wed, Sep 23, 2020 at 3:24 PM Mike Thomsen <mikerthom...@gmail.com> wrote: > > Asmath, > > I would check the Apache Calcite docs to see what syntax is supported. > I ran into a minor head-scratcher there as well a few months ago when > some date function I was expecting turned out to not be implemented > yet. > > Mike > > On Wed, Sep 23, 2020 at 3:04 PM KhajaAsmath Mohammed > <mdkhajaasm...@gmail.com> wrote: > > > > Hi, > > > > I am looking for some information on how to check datatypes of the data and > > load transform them accordingly. I am okay to use any other processor to. > > > > My req: > > > > Check if column is Integer, if integer then load to _INT column else null > > value > > Check if column length is > 256, if more than 256 load to _Text column else > > load to varchar column. > > > > I am assuming we can use case statements and length in query record but not > > able to get the syntax. Any help is appreciated > > > > Thanks, > > Asmath