I am getting the error below when there are more than 19 elements in the IN
clause:
DrillRuntimeException: Join only supports implicit casts between 1. Numeric
data 2. Varchar, Varbinary data 3. Date, Timestamp data Left type:
TIMESTAMP, Right type: BIGINT. Add explicit casts to avoid this error.
The error would encounter when IN clause is rewritten into Join, and
planner chooses to use distributed join (involves a Hash Exchange). For
distributed join, when two join keys do not have same types, only certain
type of implicit cast will be allowed. In Khurram's case, I think the
query is
I tried the below query using data from your query from the IN clause (as is),
I didn't see an error/Exception on sqlline, I am on Drill 1.11.0
0: jdbc:drill:schema=dfs.tmp> select * from (values(137676420)) WHERE
EXPR$0 IN (137667780, 137676420, 137685060, 137702340,
