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
