[function] typeof

[wangsimo0]

sometimes we don't know the exact type of an output, in starrocks there is not a good way to confirm that. so we need this function.

typeof

Returns the name of the type of the provided expression

syntax

TYPEOF( <expr> )

input

any expr, it can be a funtion's result or an expression of column..

output

the name of the type of the provided expression, like int(11),varchar(65533) or datetime.

reference
https://trino.io/docs/current/functions/conversion.html?highlight=typeof#typeof
https://docs.snowflake.com/en/sql-reference/functions/typeof

[xuzifu666]

@wangsimo0

[NeelakshSharma]

Hi @wangsimo0 , i would like to work on this issue. Can we please connect on how to get started?

[xuzifu666]

Hi @wangsimo0 , i would like to work on this issue. Can we please connect on how to get started?

i would do the issue recently @NeelakshSharma

[NeelakshSharma]

Oh okay, can you please attach the PR for my reference? I would like to see the implementation.

[MicePilot]

@xuzifu666 May I ask how the current progress is? We need this function.

[MicePilot]

@xuzifu666 Hi，I have implemented the typeof function, can I submit a PR for this issue?

[xuzifu666]

@xuzifu666 Hi，I have implemented the typeof function, can I submit a PR for this issue?

OK，you can submit it，Thanks @MicePilot