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/
