Athena: SYNTAX_ERROR: IN value and list items must be the same type

[9teen90nine]

This error happens when you set a filter for a numeric (or other non-string) dimension or measure with multiple values. It looks like athena requires to cast all values in the IN statement to the type of dimension/measure.

[rajanjha786]

Hello I'm getting a somewhat similar error IN value and list items must be the same type: varchar

I'm querying Athena using boto3 Query: SELECT a.column1 FROM ABC a WHERE a.column1 IN ('abc', 'xyz')

python: 3.8 boto3: 1.24.30

Is there any updates ?

[aayush801]

Any fixes to this ?

[chandrakantsn]

I am also facing the same issue, any fixes to this ?

[sankaramoctar]

Any fixes to this?

[github-actions[bot]]

If you are interested in working on this issue, please leave a comment below and we will be happy to assign the issue to you. If this is the first time you are contributing a Pull Request to Cube.js, please check our contribution guidelines. You can also post any questions while contributing in the #contributors channel in the Cube.js Slack.