Calcite surely supports strings. Can you give more details about what you are exactly doing to get this error? If you can give a test we can run it's best.
Mihai ________________________________ From: Kaushal Kishore <kaushalprofessiona...@gmail.com> Sent: Sunday, December 29, 2024 3:10 AM To: dev@calcite.apache.org <dev@calcite.apache.org> Subject: In clause having issues with string type Hello Team, schema of the table below: create table employee (empno int, department NVARCHAR); means list of string. now i am using select * from employee where department in (‘CSE’); after this statement execute we are getting below error - any help will be appreciated. I am getting IN clause error type while using string type, are calcite support only int type only ? org.apache.calcite.sql.validate.SqlValidatorException: Values passed to IN operator must have compatible types Many Thanks Kaushal Sengar
