git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: How to create user-defined data types in calcite?


Is the CREATE TYPE feature available with current master for sure?

On 2018/04/22 05:13:45, Shuyi Chen <suez1224@xxxxxxxxx> wrote: 
> @Julian, thanks for reviewing the code. I think we need to regenerate the
> website as well so that it contains the latest documentation on type
> collection and type DDLs. Let me know how I can help.
> 
> @Valli, with the latest master, you should be able to either use CREATE
> TYPE statement to define your own type or define your new type in the JSON
> schema.
> 
> On Sat, Apr 21, 2018 at 12:48 AM, Shuyi Chen <suez1224@xxxxxxxxx> wrote:
> 
> > Thanks a lot for your time , Julian. Let me know if you need anything.
> >
> > shuyi
> > On Fri, Apr 20, 2018 at 5:57 PM Julian Hyde <jhyde@xxxxxxxxxx> wrote:
> >
> >> Yes, I’ve ignored that change for a couple of months (sorry Shuyi) but I
> >> reviewed it yesterday and am currently testing, so it should be committed
> >> to master shortly.
> >>
> >> > On Apr 20, 2018, at 5:41 PM, Shuyi Chen <suez1224@xxxxxxxxx> wrote:
> >> >
> >> > 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 <
> >> aishwaryaanns@xxxxxxxxx>
> >> > 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."
> >>
> >> --
> > "So you have to trust that the dots will somehow connect in your future."
> >
> 
> 
> 
> -- 
> "So you have to trust that the dots will somehow connect in your future."
> 



( ! ) Warning: include(msgfooter.php): failed to open stream: No such file or directory in /var/www/git/apache-calcite-development/msg03332.html on line 134
Call Stack
#TimeMemoryFunctionLocation
10.0006368792{main}( ).../msg03332.html:0

( ! ) Warning: include(): Failed opening 'msgfooter.php' for inclusion (include_path='.:/var/www/git') in /var/www/git/apache-calcite-development/msg03332.html on line 134
Call Stack
#TimeMemoryFunctionLocation
10.0006368792{main}( ).../msg03332.html:0