Re: help with structured fields in JDBC table

2020-08-25 Thread Danny Chan
Calcite supports defining the user defined type (UDT) and also you can declare the type as a row type directly, for example: create table "my_table" (   my_field row(my_text_field varcher(2000)) ); Calcite does not support the “text” type, I’m not sure how you can define type like that. Maybe

help with structured fields in JDBC table

2020-08-25 Thread James Anderson
Hi, I'm having trouble successfully validating a SQL query against a postgres db where one of the selected fields is a postgres type (struct). Stepping through the code, it appears that the column is successfully interpreted as being of the type "STRUCTURED" (2002), but SqlTypeFactoryImpl.createS

[jira] [Created] (CALCITE-4193) Implemente new sort operator: EnumerableExternalSort

2020-08-25 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-4193: -- Summary: Implemente new sort operator: EnumerableExternalSort Key: CALCITE-4193 URL: https://issues.apache.org/jira/browse/CALCITE-4193 Project: Calcite Issue Ty

[jira] [Created] (CALCITE-4192) When the relNode has passed the AggregateProjectMergeRule rule, it will be wrong to calculate the column blood relationship through RelMdColumnOrigins tool

2020-08-25 Thread lifangzheng (Jira)
lifangzheng created CALCITE-4192: Summary: When the relNode has passed the AggregateProjectMergeRule rule, it will be wrong to calculate the column blood relationship through RelMdColumnOrigins tool Key: CALCITE-4192