[ https://issues.apache.org/jira/browse/CALCITE-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Garvit updated CALCITE-2777: ---------------------------- Description: Currently SqlTypeName does not have support for period data type in calcite. Need to include following data type for period data type support. :- Periond (Date) PERIOD(TIMESTAMP WITH TIMEZONE) PERIOD(TIMESTAMP ) PERIOD(TIME) PERIOD (TIME WITH TIME ZONE) These data type exists in Teradata (TDv13 onwards). Common use of these data types :- CREATE MULTISET TABLE person_coaching_period ( person_id INTEGER NOT NULL, coaching_program CHAR(2) NOT NULL, enrolled_period PERIOD(DATE) FORMAT 'YYYY-MM-DD' NULL ) PRIMARY INDEX (person_id); INSERT INTO person_coaching_period VALUES ( 1001, 'SC', PERIOD( DATE '2010-03-01', DATE '2010-08-01' ) ); Usage in the query :- SELECT person_id FROM person_coaching_period WHERE enrolled_period OVERLAPS PERIOD(DATE '2006-05-01', DATE '2007-09-24'); Other operators used :- LDIFF, OVERLAPS, BEGIN, END, EXPAND ON, By ANCHOR, NEXT, PRIOR, INTERVAL was: Currently SqlTypeName does not have support for period data type in calcite. Need to include following data type for period data type support. :- * Periond (Date) PERIOD(TIMESTAMP(n) WITH TIMEZONE) PERIOD(TIMESTAMP (n)) PERIOD(TIME(n)) PERIOD (TIME(n) WITH TIME ZONE) * These data type exists in Teradata (TDv13 onwards). Common use of these data types :- CREATE MULTISET TABLE person_coaching_period ( person_id INTEGER NOT NULL, coaching_program CHAR(2) NOT NULL, enrolled_period PERIOD(DATE) FORMAT 'YYYY-MM-DD' NULL ) PRIMARY INDEX (person_id); INSERT INTO person_coaching_period VALUES ( 1001, 'SC', PERIOD( DATE '2010-03-01', DATE '2010-08-01' ) ); Usage in the query :- SELECT person_id FROM person_coaching_period WHERE enrolled_period OVERLAPS PERIOD(DATE '2006-05-01', DATE '2007-09-24'); Other operators used :- LDIFF, OVERLAPS, BEGIN, END, EXPAND ON, By ANCHOR, NEXT, PRIOR, INTERVAL > Inclusion of Period data type in calcite. > ----------------------------------------- > > Key: CALCITE-2777 > URL: https://issues.apache.org/jira/browse/CALCITE-2777 > Project: Calcite > Issue Type: New Feature > Components: core > Affects Versions: 1.18.0 > Reporter: Garvit > Assignee: Julian Hyde > Priority: Major > > Currently SqlTypeName does not have support for period data type in calcite. > Need to include following data type for period data type support. :- > Periond (Date) > PERIOD(TIMESTAMP WITH TIMEZONE) > PERIOD(TIMESTAMP ) > PERIOD(TIME) > PERIOD (TIME WITH TIME ZONE) > These data type exists in Teradata (TDv13 onwards). > Common use of these data types :- > CREATE MULTISET TABLE person_coaching_period ( > person_id INTEGER NOT NULL, > coaching_program CHAR(2) NOT NULL, > enrolled_period PERIOD(DATE) FORMAT 'YYYY-MM-DD' NULL > ) > PRIMARY INDEX (person_id); > INSERT INTO person_coaching_period > VALUES ( > 1001, > 'SC', > PERIOD( > DATE '2010-03-01', > DATE '2010-08-01' > ) > ); > > Usage in the query :- > SELECT person_id > FROM person_coaching_period > WHERE enrolled_period OVERLAPS > PERIOD(DATE '2006-05-01', DATE '2007-09-24'); > Other operators used :- > LDIFF, OVERLAPS, BEGIN, END, EXPAND ON, By ANCHOR, NEXT, PRIOR, INTERVAL -- This message was sent by Atlassian JIRA (v7.6.3#76005)