Doris4.0 4.1都有问题
SHOW GLOBAL FULL FUNCTIONS;
显示不完整没有类型
+---------------------+-------------+---------------+-------------------+------------+
| Signature | Return Type | Function Type | Intermediate Type | Properties |
+---------------------+-------------+---------------+-------------------+------------+
| car_type | | | | |
+---------------------+-------------+---------------+-------------------+------------+
select car_type('dsffds'); -- 可以查询
+--------------------+
| car_type('dsffds') |
+--------------------+
| pno_0 |
+--------------------+
show create GLOBAL FUNCTION car_type(text);
ERROR: 1105 (HY000): errCode = 2, detailMessage = Unknown function, function=car_type(text)
show create FUNCTION 无法查看
UDF创建方法
CREATE GLOBAL FUNCTION car_type(STRING) RETURNS STRING PROPERTIES(
'symbol'='udf.CarType',
'always_nullable'='true',
'type'='JAVA_UDF'
);
UDF的jar包放置在FE、BE节点的custom_lib下