VARIANT and JSON data types

2023-06-21 Thread mbudiu
Hello, I have a question about Calcite and fancier data types. It looks like Calcite JSON operations are really implemented by treating JSON as a string. I expect that this is expensive, since the string needs to be parsed and serialized back for every operation. Snowflake uses VARIANT typ

Re: VARIANT and JSON data types

2023-06-21 Thread Julian Hyde
https://issues.apache.org/jira/browse/CALCITE-4918 > On Jun 21, 2023, at 6:41 PM, wrote: > > Hello, > > > > I have a question about Calcite and fancier data types. > > It looks like Calcite JSON operations are really implemented by treating > JSON as a string. I expect that this is expens