Milan Stefanovic created SPARK-52159:
----------------------------------------

             Summary: Improve error handling in table exists check
                 Key: SPARK-52159
                 URL: https://issues.apache.org/jira/browse/SPARK-52159
             Project: Spark
          Issue Type: Improvement
          Components: Spark Core
    Affects Versions: 4.1.0
            Reporter: Milan Stefanovic


Currently JDBCTableCatalog table existence check is converting any exception 
thrown by dialect into `false`, and rethrowing as specific table not found 
exception.

 

This results in analysis failure saying `TABLE_OR_VIEW_NOT_FOUND`. This can be 
misleading as table existence check can fail for different reasons - for 
example connection failures.

 

`TABLE_OR_VIEW_NOT_FOUND` should be thrown only when table really does not 
exists on remote system.

 

Proposal is to extend JDBCDialect to process exception from table existence 
check, and rethrow only if exception matches table not found exception on 
remote system.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to