Enterprise Maps Practitioners Forum
cancel

DQL Error using naitive query

SOLVED
Go to solution
Highlighted
tobiasbrecht
Trusted Contributor.

DQL Error using naitive query

Hi All,

I want to execute a native SQL query within a DQL query, based on the documentation I've built an easy example to understand the naitive clause.
But I am always getting an error while executing the query.

Here is the DQL query:

select s.name from (naitive (name) {select name_val as name from ryga_nodeArtifacts where discriminator = 'server'}) s

Here is the error:

Error: Error processing the DQL statement [dql=select s.name from (naitive (name) {select name_val as name from ryga_nodeArtifacts where discriminator = 'server'}) s]; nested exception is com.hp.systinet.dql.impl.parser.DqlParseExceptionImpl: DQL Parsing error: no viable alternative at input 'naitive' in phase PARSER at line 1, column 20 for query: "select s.name from (naitive (name) {select name_val as name from ryga_nodeArtifacts where discriminator = 'server'}) s".
SQLState:  null
ErrorCode: 0

 

Does any one have an idea how to fix this?

Thanks,
Tobi

 

 

2 REPLIES
pz1
Respected Contributor.
Solution

Re: DQL Error using naitive query

Hi Tobi,

There is a typo in the query.

select s.name from ( naitive native (name) {select name_val as name from ryga_nodeArtifacts where discriminator = 'server'})s

Best Regards

 -pavel-

tobiasbrecht
Trusted Contributor.

Re: DQL Error using naitive query

Ops... sorry I ddint saw that...

Thanks!