SQL Query error in Canvas

Elastic Stack Kibana
1

Hi,

I am trying to create a chart in canvas using an SQL query but getting the Parse exception. Can anyone help me with the query. I am using the below query

SELECT COUNT("_id"), Category
FROM "vendor_master"
GROUP BY Category;

I tried in MSSQL, there it is working, but in Canvas I am getting the Parsing exception. What are the rules i need to follow in this? Uploaded my dummy table image also. Please check the attachment

Capture

2

Just passing through... but I've found that using single-quotes instead of double has occasionally helped.

3

It doesn't worked @999chris

4

@Sunil_Edupuganti can you, please, post the complete exception?

5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.