Currently, user defined type is not supported in Calcite. But it's WIP, please see https://issues.apache.org/jira/browse/CALCITE-2045. With this PR, you can either use CREATE TYPE statement to define your own type or define your new type in the JSON schema.
Thanks Shuyi On Fri, Apr 20, 2018 at 4:27 AM, Valli Annamalai <[email protected]> wrote: > I want to parse a query having 'text' in place of 'varchar'. For > example, select > cast(ps_comment as text) from part While parsing calcite is showing, > Unknown data type name 'TEXT'. > > How can I make calcite to parse the above query successfully having > user-defined data type 'text'? > > > Thanks in advance > -- "So you have to trust that the dots will somehow connect in your future."
