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 ``` 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 } ] } } ','$') 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.
13-03-2024 10:15:57 -0400

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]( 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]( After downloading, you can [import]( the necessary jar using the Virtual DataPort Administration tool. For more information, please refer to the [Denodo XtraFuncs]( 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]( Hope this helps!
Denodo Team
14-03-2024 14:19:49 -0400
You must sign in to add an answer. If you do not have an account, you can register here