Hello!
65 is RAWTOHEX.
You can't return Object from the function. You have to return some
supported SQL type.
Regards,
--
Ilya Kasnacheev
ср, 23 дек. 2020 г. в 18:50, siva <siva.ka...@bizruntime.com>:
> Hi,
> I am using .Net Client and Server app with Ignite v2.7.6.
>
> i have created custom sql function and when doing query with custom
> function
> using where clause getting an errors.
> here is the table,record,query and function are given below.
>
> *table*
>
> CREATE TABLE Student (
> ID LONG PRIMARY KEY, PAYLOAD VARCHAR, SCORE INTEGER)
> WITH "template=MyTemplate";
>
> *insert record*
> INSERT INTO Student (ID, PAYLOAD,SCORE) VALUES (2,
>
> '{"array":[1,2,3],"boolean":false,"color":"gold1","null":null,"number":4123,"object":{"a":"b","c":"d"},"string":"Hello
>
> World","test":{"test2":{"test3":"hello"}},"test2":{"test2":{"test3":"hello"}},"teststring":"{\"test1\":\"abc\"}"}',
> 80);
>
> *Error while doing query*
>
> SELECT *, Custom_Json_Value(PAYLOAD ,'$.number') foo FROM Student
> WHERE Custom_Json_Value(PAYLOAD ,'$.number') = 4123;
>
> *custom function*
>
> public class MyCustomSQLFunction {
>
> @QuerySqlFunction
> public static <T> T Custom_Json_Value(String expression ,String
> path,String... mode) throws Exception{
>
> return (T)JsonPath.read(expression, path);
> }
> }
>
>
>
> i am getting different different error like
>
> Error1:SQL Error [1] [50000]: javax.cache.CacheException: Failed to execute
> map query on remote node [nodeId=aec3cafd-acbb-4c0e-9b3b-8e219f2a303b,
> errMsg=Failed to execute SQL query. Deserialization failed, cause: "class
> org.apache.ignite.IgniteCheckedException: Invalid flag value: 65"; SQL
> statement:
>
> Error2:Failed to execute SQL query. Hexadecimal string contains non-hex
> character:
>
>
> Thanks.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
