search

SAP-samples / hana-hdbext-promisfied-example

Example of how to use @sap/hdbext (standard node.js SAP HANA interface) via a promisfied wrapper.
Apache License 2.0
13 stars 8 forks source link

Prepared statements on JSONCollections tables #4

Closed fidsusj closed 3 years ago

fidsusj commented 3 years ago

Hey Thomas,

I am trying to prepare a SELECT statement using your promisfied hdbext library. Instead of a SELECT on a classic column table I'm trying to read from a JSONCollection in the HANA document store like this:

const statement = await db.preparePromisified("SELECT * FROM CollectionTable WHERE "itemkey"=? ORDER BY timestamp DESC LIMIT 1"); I am receiving the error message: "feature not supported: WHERE clause with unsupported expressions on collection tables"

Will this feature be added in near future or should I switch to normal column tables instead? Thanks a lot.

jung-thomas commented 3 years ago

You are getting that message from HANA itself not from my little wrapper around the client library. I couldn't comment on the support plans for this specific feature in HANA itself. That's way outside the scope of this helper utility.