Github user HanumathRao commented on a diff in the pull request: https://github.com/apache/drill/pull/996#discussion_r145268123 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/planner/sql/SqlConverter.java --- @@ -481,6 +485,19 @@ public RelOptTableImpl getTable(final List<String> names) { .message("Temporary tables usage is disallowed. Used temporary table name: %s.", names) .build(logger); } + + // Check the schema and throw a valid SchemaNotFound exception instead of TableNotFound exception. --- End diff -- Thank you for the review. I agree that this should ideally be handled at Calcite layer. I also think that even after Calcite providing this functionality there should be some customization that needs to be done as we understand the context better than Calcite. Once the calcite fixes this issue then we can always change the code accordingly.
---