[jira] [Created] (CARBONDATA-3696) Avoid list db's all Tables to check if table exists in the db

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-3696) Avoid list db's all Tables to check if table exists in the db

Akash R Nilugal (Jira)
ShuMing Li created CARBONDATA-3696:
--------------------------------------

             Summary: Avoid list db's all Tables to check if table exists in the db
                 Key: CARBONDATA-3696
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3696
             Project: CarbonData
          Issue Type: Bug
          Components: sql
    Affects Versions: 1.6.1
            Reporter: ShuMing Li


I found a lot of `listTables` of the db to check if table exists like this:
{code:java}
sparkSession.sessionState.catalog.listTables(databaseName)
  .exists(_.table.equalsIgnoreCase(tableName){code}
This may affect performances if there are lots of tables in one database.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)