The getIdentifierQuoteString of the JDBC Driver return " which is not true
since Drill implement the backtick identifier.Does that bug requires a JIRA ?
Le Mercredi 26 août 2015 12h07, Boris Chmiel
<[email protected]> a écrit :
Hi Driller
I struggle configuring SQuirrel with Drill :Drill need the backtick quote
qualifier (`) to run proper queries. The documentation mentions it as a
configuration step for JReport
:https://drill.apache.org/docs/configuring-jreport-with-drill/
As far as I know, SQuirrel use the JDBC embedded (or a default) value for quote
qualifiers ("). As a result, pre-built queries of the GUI are faulty built for
Drill. In example when I click on the content Tab of a View, the resulting
query in Drill is :select tbl.field1 from "DRILL"."dfs.tmp"."My_view"
tblinstead of :select tbl.field1 from dfs.tmp.My_view tbl
When I look on 'Info" tab for My_View within SQuirrel, I can see
:qualifiedName: "DRILL"."dfs.tmp"."My_view"schemaName: dfs.tmpsimpleName :
My_view
Does anybody knows how to configure SQuirrel in order to implement the right
SQL syntax, allowing to use GUI functionnalities ?
ThxBoris
