SAP DBTech JDBC: [8]: invalid argument: column must be prefixed with table(IN HANA SQL Console)

[former_member603230]

Hi,

I have a Table "QUOTATION_DETAIL" having JSON objects. How can i read the tags and its individual values against it?

I tried this with below script:

SELECT *

FROM JSON_TABLE(

QUOTATION_DETAIL,'$'

COLUMNS (

RN FOR ORDINALITY,

totalValue NVARCHAR(50) PATH '$."finalTaxAndOtherCharges".totalValue'

)

) AS JT;

ERROR: SAP DBTech JDBC: [8]: invalid argument: column must be prefixed with table

JSON :-

{

"app": "COLT",

"createdByName": "Ajay",

"quotationID": 108,

"groups":{

"groupName": "Test-PASSAGE",

"groupDiscountValue": 0,

}

"finalTaxAndOtherCharges":{

"totalValue": "Test-PASSAGE",

"otherCharges": 0,

}}

[brampurnot]

Were you able to solve this? I'm experiencing the same issue...