Expand my Community achievements bar.

SOLVED

Query Service - Querying dataset from DB visualizer client

Avatar

Level 3

Hi All,

 

I've integrated query service with DB visualizer client and querying dataset. But it gives me syntax error.

 

Query : Select * from my_dataset

Error : [Code: 0, SQL State: 42601] ERROR: line 1:28: mismatched input ',' expecting {<EOF>, '.', '[', 'AT', '+', '-', '*', '/', '%', '||', '::', '^'}

Query Service log : 

vikash4_0-1661329275218.png

 

To check this issue, I've integrated query service with HeidiSQL client and executed the same query successfully.

Thanks.

1 Accepted Solution

Avatar

Correct answer by
Level 5

I see, issue could be with path. Do you have any attribute/column which is a root node and doesn't require (.) operator. E.g: Select timestamp from xxxxx . Also please check log on AEP side in query service section.

Edit : Can you please also confirm, which version of DBV you're using ? I tried same stuffs and they're working fine with DBV 13.0.4. 

AtulChavan_1-1661351124920.png

 


I feel, this is something to do with DBV not AEP. Looking at your editor of DBV if you see column path 'name' is interpreted as keyword. It could be earlier version of DBV results into error but they might have fixed it in latest version ? 

View solution in original post

3 Replies

Avatar

Level 5

Hi @vikash4,
You may try listing actual column names that are required instead '*'.     

Avatar

Level 3

Hi @AtulChavan ,

thanks for your reply.

Tried with column name but facing same error. Same query running successfully in AEP query service but not in DB visualizer.

vikash4_0-1661347427109.png

 

Avatar

Correct answer by
Level 5

I see, issue could be with path. Do you have any attribute/column which is a root node and doesn't require (.) operator. E.g: Select timestamp from xxxxx . Also please check log on AEP side in query service section.

Edit : Can you please also confirm, which version of DBV you're using ? I tried same stuffs and they're working fine with DBV 13.0.4. 

AtulChavan_1-1661351124920.png

 


I feel, this is something to do with DBV not AEP. Looking at your editor of DBV if you see column path 'name' is interpreted as keyword. It could be earlier version of DBV results into error but they might have fixed it in latest version ?