Error running query over jdbc connection

1

I’m trying to execute a query via a JDBC connection but I’m getting an error (see below). The query runs correctly withing the Dremio interface. My SQL client is able to connect to the dremio server and browse the data sources/etc. But when I try to execute a view I get the following:

SQL Error: VALIDATION ERROR: Table ‘DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS’ not found

SQL Query SELECT Candidate_Code, Candidate_System_ID, Candidate_TaskUID, Candidate_Plan_ProjectUID, Candidate_Taskindex, Candidate_Project_Plan_Name, Candidate_Task_Name, Candidate_Task_Start_Date, Candidate_Task_End_Date, Candidate_Task_Pcnt_Comp, Candidate_Task_Actual_Or_Planned, Candidate_Task_Core_Code, Candidate_Task_Core_Code_Desc, Candidate_Task_Core_Code_Short_Desc, Candidate_Task_Duplicate_Milestone_Descriptor, Candidate_Task_Protocol_Num_Milestone_Alignment, Candidate_Task_Actual_StartDate, Candidate_Task_Actual_FinishDate, Candidate_Task_Comments, Candidate_Task_Is_Milestone, Candidate_Task_Is_Critical, Candidate_Task_Is_Summary, Candidate_Task_Duration, Candidate_Task_GenText1, Candidate_Task_GenText2, Candidate_Task_Successors, Candidate_Task_Predecessors, Candidate_Task_Endorsement, Candidate_Task_Hammock_Del, Candidate_Task_Acct_Person, Candidate_Task_Optimistic, Candidate_Task_Pessimistic, Candidate_Task_Traffic_Light, Candidate_Task_Baseline0_Start, Candidate_Task_Baseline0_Finish, Candidate_Task_Baseline0_Duration, Candidate_Task_Baseline1_Start, Candidate_Task_Baseline1_Finish, Candidate_Task_Baseline1_Duration, Candidate_Task_Baseline2_Start, Candidate_Task_Baseline2_Finish, Candidate_Task_Baseline2_Duration, Candidate_Task_Baseline3_Start, Candidate_Task_Baseline3_Finish, Candidate_Task_Baseline3_Duration, Candidate_Task_Baseline4_Start, Candidate_Task_Baseline4_Finish, Candidate_Task_Baseline4_Duration, Candidate_Task_Baseline5_Start, Candidate_Task_Baseline5_Finish, Candidate_Task_Baseline5_Duration, Candidate_Task_Baseline6_Start, Candidate_Task_Baseline6_Finish, Candidate_Task_Baseline6_Duration, Candidate_Task_Baseline7_Start, Candidate_Task_Baseline7_Finish, Candidate_Task_Baseline7_Duration, Candidate_Task_Baseline8_Start, Candidate_Task_Baseline8_Finish, Candidate_Task_Baseline8_Duration, Candidate_Task_Baseline9_Start, Candidate_Task_Baseline9_Finish, Candidate_Task_Baseline9_Duration, Candidate_Task_Baseline10_Start, Candidate_Task_Baseline10_Finish, Candidate_Task_Baseline10_Duration, Candidate_Task_Calendar, Candidate_Task_Current_GEM, Candidate_Task_Initial_GEM, Candidate_Task_GEM_Variance, Candidate_Task_SNET, Candidate_Task_FNLT, Candidate_Task_GenDate1, Candidate_Task_GenDate2, Candidate_Task_GenDate3, Candidate_Task_GenDate4, Candidate_Task_GenDate5, Candidate_Task_GenFlag1, Candidate_Task_GenFlag2, Candidate_Task_GenFlag3, Candidate_Task_GenFlag4, Candidate_Task_GenFlag5, Candidate_Task_GenText3, Candidate_Task_GenText4, Candidate_Task_GenText5, Candidate_Task_Target_Start, Candidate_Task_Target_Finish, Candidate_Task_Ind_Has_Rsrces, Candidate_Task_Ind_Target_Date, Candidate_Task_Ind_Task_Health, Candidate_Task_Ind_Task_Status, Candidate_Task_Required, Candidate_Planning_Source_Sys, Candidate_Task_Notepad, Candidate_Task_Activity_Status, Candidate_Task_Is_WBS_Element, Candidate_Task_Alignment FROM DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS
startLine 1
startColumn 2879
endLine 1
endColumn 2884

[Error Id: 9a87f6b8-aef9-417c-889a-64e56b54420a on hostname removed:31010]

(org.apache.calcite.runtime.CalciteContextException) From line 1, column 2879 to line 1, column 2884: Table ‘DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS’ not found
sun.reflect.GeneratedConstructorAccessor268.newInstance():-1
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45
java.lang.reflect.Constructor.newInstance():423
org.apache.calcite.runtime.Resources$ExInstWithCause.ex():463
org.apache.calcite.sql.SqlUtil.newContextException():803
org.apache.calcite.sql.SqlUtil.newContextException():788
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():4470
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl():104
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():120
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2971
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2956
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3197
org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.SqlSelect.validate():226
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():899
org.apache.calcite.sql.validate.SqlValidatorImpl.validate():609
com.dremio.exec.planner.sql.SqlConverter.validate():199
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():177
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():166
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():162
com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():43
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():69
com.dremio.exec.work.foreman.AttemptManager.run():288
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748
Caused By (org.apache.calcite.sql.validate.SqlValidatorException) Table ‘DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS’ not found
sun.reflect.GeneratedConstructorAccessor267.newInstance():-1
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45
java.lang.reflect.Constructor.newInstance():423
org.apache.calcite.runtime.Resources$ExInstWithCause.ex():463
org.apache.calcite.runtime.Resources$ExInst.ex():572
org.apache.calcite.sql.SqlUtil.newContextException():803
org.apache.calcite.sql.SqlUtil.newContextException():788
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():4470
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl():104
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():120
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2971
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2956
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3197
org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.SqlSelect.validate():226
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():899
org.apache.calcite.sql.validate.SqlValidatorImpl.validate():609
com.dremio.exec.planner.sql.SqlConverter.validate():199
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():177
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():166
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():162
com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():43
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():69
com.dremio.exec.work.foreman.AttemptManager.run():288
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748

VALIDATION ERROR: Table ‘DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS’ not found

SQL Query SELECT Candidate_Code, Candidate_System_ID, Candidate_TaskUID, Candidate_Plan_ProjectUID, Candidate_Taskindex, Candidate_Project_Plan_Name, Candidate_Task_Name, Candidate_Task_Start_Date, Candidate_Task_End_Date, Candidate_Task_Pcnt_Comp, Candidate_Task_Actual_Or_Planned, Candidate_Task_Core_Code, Candidate_Task_Core_Code_Desc, Candidate_Task_Core_Code_Short_Desc, Candidate_Task_Duplicate_Milestone_Descriptor, Candidate_Task_Protocol_Num_Milestone_Alignment, Candidate_Task_Actual_StartDate, Candidate_Task_Actual_FinishDate, Candidate_Task_Comments, Candidate_Task_Is_Milestone, Candidate_Task_Is_Critical, Candidate_Task_Is_Summary, Candidate_Task_Duration, Candidate_Task_GenText1, Candidate_Task_GenText2, Candidate_Task_Successors, Candidate_Task_Predecessors, Candidate_Task_Endorsement, Candidate_Task_Hammock_Del, Candidate_Task_Acct_Person, Candidate_Task_Optimistic, Candidate_Task_Pessimistic, Candidate_Task_Traffic_Light, Candidate_Task_Baseline0_Start, Candidate_Task_Baseline0_Finish, Candidate_Task_Baseline0_Duration, Candidate_Task_Baseline1_Start, Candidate_Task_Baseline1_Finish, Candidate_Task_Baseline1_Duration, Candidate_Task_Baseline2_Start, Candidate_Task_Baseline2_Finish, Candidate_Task_Baseline2_Duration, Candidate_Task_Baseline3_Start, Candidate_Task_Baseline3_Finish, Candidate_Task_Baseline3_Duration, Candidate_Task_Baseline4_Start, Candidate_Task_Baseline4_Finish, Candidate_Task_Baseline4_Duration, Candidate_Task_Baseline5_Start, Candidate_Task_Baseline5_Finish, Candidate_Task_Baseline5_Duration, Candidate_Task_Baseline6_Start, Candidate_Task_Baseline6_Finish, Candidate_Task_Baseline6_Duration, Candidate_Task_Baseline7_Start, Candidate_Task_Baseline7_Finish, Candidate_Task_Baseline7_Duration, Candidate_Task_Baseline8_Start, Candidate_Task_Baseline8_Finish, Candidate_Task_Baseline8_Duration, Candidate_Task_Baseline9_Start, Candidate_Task_Baseline9_Finish, Candidate_Task_Baseline9_Duration, Candidate_Task_Baseline10_Start, Candidate_Task_Baseline10_Finish, Candidate_Task_Baseline10_Duration, Candidate_Task_Calendar, Candidate_Task_Current_GEM, Candidate_Task_Initial_GEM, Candidate_Task_GEM_Variance, Candidate_Task_SNET, Candidate_Task_FNLT, Candidate_Task_GenDate1, Candidate_Task_GenDate2, Candidate_Task_GenDate3, Candidate_Task_GenDate4, Candidate_Task_GenDate5, Candidate_Task_GenFlag1, Candidate_Task_GenFlag2, Candidate_Task_GenFlag3, Candidate_Task_GenFlag4, Candidate_Task_GenFlag5, Candidate_Task_GenText3, Candidate_Task_GenText4, Candidate_Task_GenText5, Candidate_Task_Target_Start, Candidate_Task_Target_Finish, Candidate_Task_Ind_Has_Rsrces, Candidate_Task_Ind_Target_Date, Candidate_Task_Ind_Task_Health, Candidate_Task_Ind_Task_Status, Candidate_Task_Required, Candidate_Planning_Source_Sys, Candidate_Task_Notepad, Candidate_Task_Activity_Status, Candidate_Task_Is_WBS_Element, Candidate_Task_Alignment FROM DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS
startLine 1
startColumn 2879
endLine 1
endColumn 2884

[Error Id: 9a87f6b8-aef9-417c-889a-64e56b54420a on hostname remove:31010]

(org.apache.calcite.runtime.CalciteContextException) From line 1, column 2879 to line 1, column 2884: Table ‘DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS’ not found
sun.reflect.GeneratedConstructorAccessor268.newInstance():-1
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45
java.lang.reflect.Constructor.newInstance():423
org.apache.calcite.runtime.Resources$ExInstWithCause.ex():463
org.apache.calcite.sql.SqlUtil.newContextException():803
org.apache.calcite.sql.SqlUtil.newContextException():788
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():4470
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl():104
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():120
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2971
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2956
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3197
org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.SqlSelect.validate():226
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():899
org.apache.calcite.sql.validate.SqlValidatorImpl.validate():609
com.dremio.exec.planner.sql.SqlConverter.validate():199
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():177
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():166
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():162
com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():43
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():69
com.dremio.exec.work.foreman.AttemptManager.run():288
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748
Caused By (org.apache.calcite.sql.validate.SqlValidatorException) Table ‘DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS’ not found
sun.reflect.GeneratedConstructorAccessor267.newInstance():-1
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45
java.lang.reflect.Constructor.newInstance():423
org.apache.calcite.runtime.Resources$ExInstWithCause.ex():463
org.apache.calcite.runtime.Resources$ExInst.ex():572
org.apache.calcite.sql.SqlUtil.newContextException():803
org.apache.calcite.sql.SqlUtil.newContextException():788
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():4470
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl():104
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():120
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2971
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2956
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3197
org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.SqlSelect.validate():226
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():899
org.apache.calcite.sql.validate.SqlValidatorImpl.validate():609
com.dremio.exec.planner.sql.SqlConverter.validate():199
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():177
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():166
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():162
com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():43
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():69
com.dremio.exec.work.foreman.AttemptManager.run():288
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748

VALIDATION ERROR: Table ‘DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS’ not found

SQL Query SELECT Candidate_Code, Candidate_System_ID, Candidate_TaskUID, Candidate_Plan_ProjectUID, Candidate_Taskindex, Candidate_Project_Plan_Name, Candidate_Task_Name, Candidate_Task_Start_Date, Candidate_Task_End_Date, Candidate_Task_Pcnt_Comp, Candidate_Task_Actual_Or_Planned, Candidate_Task_Core_Code, Candidate_Task_Core_Code_Desc, Candidate_Task_Core_Code_Short_Desc, Candidate_Task_Duplicate_Milestone_Descriptor, Candidate_Task_Protocol_Num_Milestone_Alignment, Candidate_Task_Actual_StartDate, Candidate_Task_Actual_FinishDate, Candidate_Task_Comments, Candidate_Task_Is_Milestone, Candidate_Task_Is_Critical, Candidate_Task_Is_Summary, Candidate_Task_Duration, Candidate_Task_GenText1, Candidate_Task_GenText2, Candidate_Task_Successors, Candidate_Task_Predecessors, Candidate_Task_Endorsement, Candidate_Task_Hammock_Del, Candidate_Task_Acct_Person, Candidate_Task_Optimistic, Candidate_Task_Pessimistic, Candidate_Task_Traffic_Light, Candidate_Task_Baseline0_Start, Candidate_Task_Baseline0_Finish, Candidate_Task_Baseline0_Duration, Candidate_Task_Baseline1_Start, Candidate_Task_Baseline1_Finish, Candidate_Task_Baseline1_Duration, Candidate_Task_Baseline2_Start, Candidate_Task_Baseline2_Finish, Candidate_Task_Baseline2_Duration, Candidate_Task_Baseline3_Start, Candidate_Task_Baseline3_Finish, Candidate_Task_Baseline3_Duration, Candidate_Task_Baseline4_Start, Candidate_Task_Baseline4_Finish, Candidate_Task_Baseline4_Duration, Candidate_Task_Baseline5_Start, Candidate_Task_Baseline5_Finish, Candidate_Task_Baseline5_Duration, Candidate_Task_Baseline6_Start, Candidate_Task_Baseline6_Finish, Candidate_Task_Baseline6_Duration, Candidate_Task_Baseline7_Start, Candidate_Task_Baseline7_Finish, Candidate_Task_Baseline7_Duration, Candidate_Task_Baseline8_Start, Candidate_Task_Baseline8_Finish, Candidate_Task_Baseline8_Duration, Candidate_Task_Baseline9_Start, Candidate_Task_Baseline9_Finish, Candidate_Task_Baseline9_Duration, Candidate_Task_Baseline10_Start, Candidate_Task_Baseline10_Finish, Candidate_Task_Baseline10_Duration, Candidate_Task_Calendar, Candidate_Task_Current_GEM, Candidate_Task_Initial_GEM, Candidate_Task_GEM_Variance, Candidate_Task_SNET, Candidate_Task_FNLT, Candidate_Task_GenDate1, Candidate_Task_GenDate2, Candidate_Task_GenDate3, Candidate_Task_GenDate4, Candidate_Task_GenDate5, Candidate_Task_GenFlag1, Candidate_Task_GenFlag2, Candidate_Task_GenFlag3, Candidate_Task_GenFlag4, Candidate_Task_GenFlag5, Candidate_Task_GenText3, Candidate_Task_GenText4, Candidate_Task_GenText5, Candidate_Task_Target_Start, Candidate_Task_Target_Finish, Candidate_Task_Ind_Has_Rsrces, Candidate_Task_Ind_Target_Date, Candidate_Task_Ind_Task_Health, Candidate_Task_Ind_Task_Status, Candidate_Task_Required, Candidate_Planning_Source_Sys, Candidate_Task_Notepad, Candidate_Task_Activity_Status, Candidate_Task_Is_WBS_Element, Candidate_Task_Alignment FROM DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS
startLine 1
startColumn 2879
endLine 1
endColumn 2884

[Error Id: 9a87f6b8-aef9-417c-889a-64e56b54420a on <hostname removed for security reasons:31010]

(org.apache.calcite.runtime.CalciteContextException) From line 1, column 2879 to line 1, column 2884: Table ‘DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS’ not found
sun.reflect.GeneratedConstructorAccessor268.newInstance():-1
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45
java.lang.reflect.Constructor.newInstance():423
org.apache.calcite.runtime.Resources$ExInstWithCause.ex():463
org.apache.calcite.sql.SqlUtil.newContextException():803
org.apache.calcite.sql.SqlUtil.newContextException():788
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():4470
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl():104
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():120
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2971
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2956
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3197
org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.SqlSelect.validate():226
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():899
org.apache.calcite.sql.validate.SqlValidatorImpl.validate():609
com.dremio.exec.planner.sql.SqlConverter.validate():199
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():177
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():166
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():162
com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():43
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():69
com.dremio.exec.work.foreman.AttemptManager.run():288
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748
Caused By (org.apache.calcite.sql.validate.SqlValidatorException) Table ‘DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS’ not found
sun.reflect.GeneratedConstructorAccessor267.newInstance():-1
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45
java.lang.reflect.Constructor.newInstance():423
org.apache.calcite.runtime.Resources$ExInstWithCause.ex():463
org.apache.calcite.runtime.Resources$ExInst.ex():572
org.apache.calcite.sql.SqlUtil.newContextException():803
org.apache.calcite.sql.SqlUtil.newContextException():788
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():4470
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl():104
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():120
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2971
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2956
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3197
org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.SqlSelect.validate():226
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():899
org.apache.calcite.sql.validate.SqlValidatorImpl.validate():609
com.dremio.exec.planner.sql.SqlConverter.validate():199
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():177
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():166
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():162
com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():43
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():69
com.dremio.exec.work.foreman.AttemptManager.run():288
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748

2

Hi @summersmd

Can you please check “DREMIO.ONESOURCE_VIEWS.CV_CANDIDATE_TASKS”. What you can do is, navigate on the UI to that dataset and there would be a small copy icon to the immediate right of the dataset that you copy and use that in your query.

You could also use context in the query editor box, bottom right inside the box and switch context to point the parent folder of that dataset and simple use the dataset name without any prefix. See screenshots below

context
context.png1468×1062 26.4 KB
copy-icon