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 <[email protected]> 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 > >
