What connection type in Tableau are you using?
Thanks for the quick reply Tom.
We are using MySQL.
We can also do it by ODBC drivers.
My data team has informed me that tableau is changing the query so Sphinx server does not recognize it.
Are you writing queries in Tableau using custom XML, or adding objects like tables, making joins etc and getting tableau to generate the SQL?
Can you provide an example of a queries that's not getting recognized? How do they fail? Is that a syntax or complexity issue?
In any case, I'm pretty sure you should read this KB and prepare to tweak your datasource:
The issue described above happens while trying to connect Sphinx by using MySql ODBC connection
The connection to the Sphinx engine is successful.
But, While trying to execute the "New Custom Sql" there comes a Sphinx error.
Query format used for execution : select * from <table_name>
While comparing the log file the query has been rewritten before execution which is the root cause for the error
log File entry :
select * from <table_name>
) `Custom SQL Query`;
1464270279:Using direct execution;
1464270279:query has been executed;
1464270279:sphinxql: syntax error, unexpected $undefined, expecting ORDER near '`Custom SQL Query`';
Checked with / without TDC File "
connection-customization" disabled for the below
Even then No luck the same error persist, Please suggest
Thank You Ashok.
Ashok is my colleague. Is there any workaround or solution for this syntax error?
1. I would contact Tableau support for this.
2. Do you have to use Custom SQL? You're doing a select * from a specific table, can you not just drag that table object out into your connection dialog in Tableau instead? Does it work if you do that?
Do you have to use Custom SQL?
Yes, As sphinx is not an actual database and it doesn't support sub-query. Hence we won't get CATALOG support to drag and drop table into it. We need to query it through MySql ODBC.
After a long time on search got the below stating that Tableau will any way wrap the query as sub-query.
My experience was that if I disabled a few CAPs I was able to do extract only queries (with other non-supported, non-SQL databases). If extract is good for you, then this could be an option for you.
Extract is not possible , As the idea is to use real time text search output for viz.