??????Doris UDF

[????????]

Hi!
This error I have fixed, but another occurs:ERROR 1064(HY000):errCode = 
2,detailMessage = Varchar Size must be >0 :-1
I don't know what it means.


Thanks??
look forward to your response



--  --
??: 
   ""   
 
<751937...@qq.com>;
: 2021??7??28??(??) 11:33
??: "dev"

Re: Doris UDF

[ling miao]

The varchar type needs to have a length, or *

```
CREATE FUNCTION dwd_smart_community.sm4Decry （VARCHAR(*)） RETURNS
VARCHAR(*) 
```

Ling Miao

吟游诗人 <751937...@qq.com.invalid> 于2021年7月28日周三 下午4:05写道：

> Hi!
> This error I have fixed, but another occurs:ERROR 1064(HY000):errCode =
> 2,detailMessage = Varchar Size must be >0 :-1
> I don't know what it means.
>
>
> Thanks，
> look forward to your response
>
>
>
> -- 原始邮件 --
> 发件人:
>   "吟游诗人"
> <
> 751937...@qq.com>;
> 发送时间: 2021年7月28日(星期三) 中午11:33
> 收件人: "dev"
> 主题: Doris UDF
>
>
>
> Hi!
> I have one question about Doris UDF.
> Now,I have prepared one file named libudfsm4.so and  I  want to
> create UDF.
> Follows are my sql, but error happens:ERROR 1064 (HY000): errCode = 2,
> detailMessage = Please check your sql, we meet an error when parsing.
> I don't know what this error means and how to fix it.
> My steps are:
> Step one:I put libudfsm4.so in /opt/doris/incubator-doris/udf_decry/ and
> send
> nm libudfsm4.so | grep udf
> to get symbol.I don't know what I have done is right or not.
> Step two:I don't know how to put libudfsm4.so to someplace where
> http/https can reach so I let object_file equals local uri,I don't know
> this is right or not.
> Thanks，
> look forward to your response
> CREATE FUNCTION dwd_smart_community.sm4Decry （VARCHAR） RETURNS VARCHAR
> PROPERTIES (
> "symbol" =
> "_ZN9doris_udf10sm4DecryptEPNS_15FunctionContextERKNS_9StringValE",
> "object_file" = "/opt/doris/incubator-doris/udf/udf_decry/libudfsm4.so"
> );