git.net

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

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


@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."