Use of non-standard LIMIT keyword in JDBC tableExists code

tableExists in spark/sql/core/src/main/scala/org/apache/spark/sql/jdbc/JdbcUtils.scala uses non-standard SQL (specifically, the LIMIT keyword) to determine whether a table exists in a JDBC data source. This will cause an exception in many/most JDBC databases that doesn't support LIMIT keyword.

Re: Use of non-standard LIMIT keyword in JDBC tableExists code

Granted the 1=0 thing is ugly and assumes constant-folding support or reads way too much data. Submitted JIRA SPARK-9078 (thanks for pointers) and expounded on possible solutions a little bit more there. Cheers, and thanks, Bob -- View this message in context: