drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From WeiWan <wei...@sunteng.com>
Subject Join keys should be converted to target type
Date Mon, 05 Dec 2016 03:47:01 GMT

0: jdbc:drill:drillbit=localhost> set planner.in_subquery_threshold=20;
+-------+-----------------------------------------+
|  ok   |                 summary                 |
+-------+-----------------------------------------+
| true  | planner.in_subquery_threshold updated.  |
+-------+-----------------------------------------+
1 row selected (0.12 seconds)
0: jdbc:drill:drillbit=localhost> describe `test`;
+--------------+--------------------+--------------+
| COLUMN_NAME  |     DATA_TYPE      | IS_NULLABLE  |
+--------------+--------------------+--------------+
| time         | BIGINT             | NO           |
| d1           | CHARACTER VARYING  | NO           |
| m1           | BIGINT             | NO           |
| m2           | BIGINT             | NO           |
+--------------+--------------------+--------------+
4 rows selected (0.16 seconds)
0: jdbc:drill:drillbit=localhost> set planner.in_subquery_threshold=20;
+-------+-----------------------------------------+
|  ok   |                 summary                 |
+-------+-----------------------------------------+
| true  | planner.in_subquery_threshold updated.  |
+-------+-----------------------------------------+
1 row selected (0.068 seconds)
0: jdbc:drill:drillbit=localhost> select count(*) from `test` where m1 in ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20');
Error: SYSTEM ERROR: AssertionError: Internal error: Cannot find common type for join keys
$0 (type BIGINT) and $0 (type CHAR(2))


[Error Id: 70d0a0b3-a48b-489a-92fd-7cc934284f3d on bc41.clicki.cn:31010] (state=,code=0)



Regards
Flow Wei




Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message