Start a new topic

Quoting for Apache Drill

[This topic is migrated from our old forums. The original author name has been removed]

DbVis 9.5 (and 9.2) seem to largely work with the Apache Drill JDBC driver, as Drill uses ANSI SQL. However the quoting for Drill uses backticks, and attempts to use the INFORMATION_SCHEMA views fail with: An error occurred while performing the operation: PARSE ERROR: Encountered "\"" at line 1, column 15. SQL Query SELECT * FROM "INFORMATION_SCHEMA"."VIEWS" This format works in an SQL Commander; SELECT * FROM INFORMATION_SCHEMA.`TABLES`; Is there a way into DbVis to configure quoting for built in queries like those to INFORMATION_SCHEMA?

[This reply is migrated from our old forums.]

Re: Quoting for Apache Drill
Hi Matt, Open the Properties tab for the connection and select the Delimited Identifiers category. There you can change the delimiter characters. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Quoting for Apache Drill
That solves the problem. Worth noting that using the Apache supplied Drill JDBC driver, DbVis is largely functional as a Drill query tool. The sys schema can be browsed showing system information such as version, configuration options. As Drill is an ANSI SQL engine on top of Hadoop, it might be worth looking into seeing if DbVis could be enhanced to view running queries, making it a first class Drill tool: https://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/
[This reply is migrated from our old forums.]

Re: Quoting for Apache Drill
Hi Matt, Thanks for the feedback. We are already aware of Drill and it's on the list of things we are looking at for enhanced support of various non-SQL databases. Your vote has been added. Best Regards, Hans

1 person likes this
Login or Signup to post a comment