Apache Drill - Language Support

Trying to use DataGrip with Apache Drill; I have no problem registering the JDBC driver and connecting to the database but when using the navigation and selecting a table the sql being generated is for example

select t.* from "database"."tablename" t

for this to work in apache drill it needs to be using the ` and not the " character  eg

select t.* from `database`.`tablename`t 

I've tried a few different dialects but am not getting any difference.  Is there a way around this as it's a similar issue when connecting to SparkSQL via the thriftserver?

2 comments
Comment actions Permalink

Hi,

Currently, we support only double quotes according to SQL standard and there is no way to change it. Try to use command line options mentioned in https://issues.apache.org/jira/browse/DRILL-3510

Thank you.

0
Comment actions Permalink

vasily chernov - It been 2 years, any developments on this. I am still facing this issue while navigating through tables in drill.

0

Please sign in to leave a comment.