Re: Doris UDF

[ling miao]

The varchar type needs to have a length, or *

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

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 &gt;0 :-1
> I don't know what it means.
>
>
> Thanks，
> look forward to your response
>
>
>
> ------------------&nbsp;原始邮件&nbsp;------------------
> 发件人:
>                                                   "吟游诗人"
>                                                                 <
> 751937...@qq.com&gt;;
> 发送时间:&nbsp;2021年7月28日(星期三) 中午11:33
> 收件人:&nbsp;"dev"<dev@doris.apache.org&gt;;
>
> 主题:&nbsp;Doris UDF
>
>
>
> Hi!
> I have one question about Doris UDF.
> Now,I have prepared one file named libudfsm4.so and &nbsp;I &nbsp;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"
> );