SHOW FUNCTIONS 信息不完整

Viewed 3

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下

0 Answers