drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erick Reyes <ERe...@trackman.com>
Subject Problems querying with SQL server due to database name containing a period (.)
Date Mon, 12 Jun 2017 16:37:10 GMT
Hello,

I am a data engineer for a small start-up in the sport technology industry. We have SQL and
NoSQL databases and want to leverage Apache Drill as a way to query across our DBs. I was
able to set up our MongoDB and SQL server instances without major issues but querying one
of our SQL database with the name TrackMan.Baseball is giving us issues. I believe this is
due to the name containing a period.  Having a period as part of the database name was a horrible
design decision made by us several years ago and we are now living with the consequences,
is there any way I can work around this issue? Below is the error message I get when trying
to query this database, databases under the same connection string with a different name can
be queried without any problems. Is there a solution for me?

Best,

Erick S. Reyes
Data Platforms TrackMan Baseball
(312) 647-5373

Query Failed: An Error Occurred
org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: From line 1, column
15 to line 1, column 18: Table 'tsql.dbo.Game' not found SQL Query null [Error Id: 44aa1094-3bbc-4d9a-bb01-d021afa4fb6a
on Stamford-SQL01.ISG.local:31010] (org.apache.calcite.runtime.CalciteContextException) From
line 1, column 15 to line 1, column 18: Table 'tsql.dbo.Game' not found sun.reflect.GeneratedConstructorAccessor97.newInstance():-1
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45 java.lang.reflect.Constructor.newInstance():423
org.apache.calcite.runtime.Resources$ExInstWithCause.ex():405 org.apache.calcite.sql.SqlUtil.newContextException():765
org.apache.calcite.sql.SqlUtil.newContextException():753 org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():3974
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():106 org.apache.calcite.sql.validate.AbstractNamespace.validate():86
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():883 org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():869
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2806 org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2791
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3014 org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
org.apache.calcite.sql.validate.AbstractNamespace.validate():86 org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():883
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():869 org.apache.calcite.sql.SqlSelect.validate():210
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():843 org.apache.calcite.sql.validate.SqlValidatorImpl.validate():557
org.apache.drill.exec.planner.sql.SqlConverter.validate():169 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode():606
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert():192 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():164
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan():131 org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():79
org.apache.drill.exec.work.foreman.Foreman.runSQL():1050 org.apache.drill.exec.work.foreman.Foreman.run():281
java.util.concurrent.ThreadPoolExecutor.runWorker():1142 java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():748 Caused By (org.apache.calcite.sql.validate.SqlValidatorException)
Table 'tsql.dbo.Game' not found sun.reflect.GeneratedConstructorAccessor96.newInstance():-1
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45 java.lang.reflect.Constructor.newInstance():423
org.apache.calcite.runtime.Resources$ExInstWithCause.ex():405 org.apache.calcite.runtime.Resources$ExInst.ex():514
org.apache.calcite.sql.SqlUtil.newContextException():765 org.apache.calcite.sql.SqlUtil.newContextException():753
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():3974 org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():106
org.apache.calcite.sql.validate.AbstractNamespace.validate():86 org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():883
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():869 org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2806
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2791 org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3014
org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60 org.apache.calcite.sql.validate.AbstractNamespace.validate():86
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():883 org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():869
org.apache.calcite.sql.SqlSelect.validate():210 org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():843
org.apache.calcite.sql.validate.SqlValidatorImpl.validate():557 org.apache.drill.exec.planner.sql.SqlConverter.validate():169
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode():606 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert():192
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():164 org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan():131
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():79 org.apache.drill.exec.work.foreman.Foreman.runSQL():1050
org.apache.drill.exec.work.foreman.Foreman.run():281 java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617 java.lang.Thread.run():748


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message