Hi,
i have tried like below in both case i am getting error
1.Without cache name
0: jdbc:ignite:thin://127.0.0.1/> select Custom_Json_Value("","");
Error: Failed to parse query. Function "CUSTOM_JSON_VALUE" not found; SQL
statement:
select Custom_Json_Value("","") [90022-197] (state=42000,code=1001)
java.sql.SQLException: Failed to parse query. Function "CUSTOM_JSON_VALUE"
not found; SQL statement:
select Custom_Json_Value("","") [90022-197]
at
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:750)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:212)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:475)
at sqlline.Commands.execute(Commands.java:823)
at sqlline.Commands.sql(Commands.java:733)
at sqlline.SqlLine.dispatch(SqlLine.java:795)
at sqlline.SqlLine.begin(SqlLine.java:668)
at sqlline.SqlLine.start(SqlLine.java:373)
at sqlline.SqlLine.main(SqlLine.java:265)
2.i logged in with customfunction cache name 'MyTemplateFunction'
select Custom_Json_Value("","");
0: jdbc:ignite:thin://127.0.0.1/MyTemplateFun> select
Custom_Json_Value("","");
Error: Failed to set schema for DB connection for thread
[schema=MYTEMPLATEFUNCTION] (state=50000,code=1)
java.sql.SQLException: Failed to set schema for DB connection for thread
[schema=MYTEMPLATEFUNCTION]
at
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:750)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:212)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:475)
at sqlline.Commands.execute(Commands.java:823)
at sqlline.Commands.sql(Commands.java:733)
at sqlline.SqlLine.dispatch(SqlLine.java:795)
at sqlline.SqlLine.begin(SqlLine.java:668)
at sqlline.SqlLine.start(SqlLine.java:373)
at sqlline.SqlLine.main(SqlLine.java:265)
0: jdbc:ignite:thin://127.0.0.1/MyTemplateFun>
Thanks.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
