In answer to your question, no, Calcite does not support ENUM. It looks as if only MySQL does this.
One idiomatic SQL way to achieve this would be to define a CHECK constraint that ensures that a column can only have a given set of values. Then hopefully a storage system would compress repeated values to a few bits each. Feel free to log a JIRA with your requirements. We'll see if anyone else wants this, and is prepared to implement it. Julian On Tue, Jul 14, 2020 at 7:00 PM Talat Uyarer <tuya...@paloaltonetworks.com> wrote: > > Hi, > I am using Beam SQL which uses calcite. IN Beam we have logical types which > we can use for Enumeration. But looks like they did not implement > enumeration support for calcite. I want to give that support. But I could > not find the right way to implement it. In my Enumeration is a > HashMap<String,Integer>. > > My question is: Does calcite support Enum types like mysql ? [1] if not > How can store metadata information such as (enum strings, beam type name > etc) for columns ? > > Thanks > > [1] https://dev.mysql.com/doc/refman/8.0/en/enum.html
