You can translate the question and the replies:

Function 'jsonpath' with arity 2 not found

I am trying to execute the following query in VQL Shell: ``` select * from my_table t where jsonpath(t.json_data, '$.property')='value'; ``` But I get the following issue: *Finished with error: Error in select view conditions: Function 'jsonpath' not created. Function 'jsonpath' not found.* Then I try to execute the example given here https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/json_functions/json_functions#jsonpath ``` SELECT jsonpath(' { "store":{ "book":[ { "category":"reference", "author":"Nigel Rees", "title":"Sayings of the Century", "price":8.95 }, { "category":"fiction", "author":"Evelyn Waugh", "title":"Sword of Honour", "price":12.99 }, { "category":"fiction", "author":"Herman Melville", "title":"Moby Dick", "isbn":"0-553-21311-3", "price":8.99 } ] } } ','$.store..author') as jsonpath_results from Dual(); ``` But I get the following issue after the execution: *Finished with error: Function 'jsonpath' with arity 2 not found* Could you please help me to solve this issue? Thank you in advance.
user
13-03-2024 10:15:57 -0400
code

1 Answer

Hi, The error message "*Finished with error: Function 'jsonpath' with arity 2 not found*" indicates that there isn't a function named "jsonpath" with two parameters. This function is part of Virtual DataPort's custom functions, known as **Denodo XtraFuncs**. To use this function, you must import these functions into the Virtual DataPort Server. XtraFuncs, a feature of Denodo Connects, is only available with the full Denodo Platform. With a complete Denodo Platform installation, these components can be imported and utilized. The [Restrictions of Express Edition](https://community.denodo.com/docs/html/browse/latest/platform/installation/appendix/limitations_of_the_denodo_express_license/limitations_of_the_denodo_express_license) guide discusses the incapability to support custom functions and import jar files. If you are a user with valid support credentials, you have the ability to download the **Denodo XtraFuncs** for VDP. This file is available to download from the [Denodo Support Site](https://support.denodo.com/resources/denodo-connect/list/Denodo%208.0). After downloading, you can [import](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/importing_extensions/importing_extensions#importing-extensions) the necessary jar using the Virtual DataPort Administration tool. For more information, please refer to the [Denodo XtraFuncs](https://community.denodo.com/docs/html/document/denodoconnects/8.0/Denodo%20XtraFuncs%20-%20User%20Manual) User Manual. For further information about this error, you can refer to a similar question asked in the community: [Finished with error: Function 'ifnull' with arity 2 not found](https://community.denodo.com/answers/question/details?questionId=9060g000000L7E8AAK) Hope this helps!
Denodo Team
14-03-2024 14:19:49 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here