Erick,
Are you putting backticks around the table? IE:
SELECT <fields>
FROM sql.database.`TrackMan.Baseball`
On Mon, Jun 12, 2017 at 12:37 PM, Erick Reyes <EReyes@trackman.com> wrote:
> 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
>
>
|