selectdb-doris-2.1.6
sql server 2008
查询sql:
报错 :
errCode = 2, detailMessage = (172.16.9.7)[NOT_IMPLEMENTED_ERROR]Function in is not implemented
直接查表正常
explain
| 4:VJdbcScanNode(5672) |
| TABLE: [dbo].[SUPPLIER] |
| QUERY: SELECT [SUPPLIER_BUSINESS_ID], [SUPPLIER_CODE], [SUPPLIER_FULL_NAME], [XIS_POST] FROM [dbo].[SUPPLIER] WHERE ([SUPPLIER_CODE] IN ('10363', '10450', '10495', '10356', '10378', '10300', '10339', '10310', '10321', '10369')) AND (([XIS_POST] = 1))|
| PREDICATES: (SUPPLIER_CODE[#205] IN ('10363', '10450', '10495', '10356', '10378', '10300', '10339', '10310', '10321', '10369') AND (CAST(XIS_POST[#258] AS double) = 1)) |
| final projections: SUPPLIER_BUSINESS_ID[#204], SUPPLIER_CODE[#205], SUPPLIER_FULL_NAME[#207] |
| final project output tuple id: 3 |
| |
|PLAN FRAGMENT 12 |
| |
| PARTITION: RANDOM |
| |
| HAS_COLO_PLAN_NODE: false |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 03 |
| HASH_PARTITIONED: ITEM_BUSINESS_ID[#120]