A jira is open and we're targeting a 1.2 fix On Aug 26, 2015 8:11 AM, "Boris Chmiel" <[email protected]> wrote:
> 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 > >
