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

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-3696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

ShuMing Li updated CARBONDATA-3696:
-----------------------------------
    Description:
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. In `spark`, we can check this by `tableExists` function. 

I can submit a pr If someone think this is ok.

  was:
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. In `spark`, we can check this by `tableExists` function. 

I can submit a pr If somebody think this is ok.

> 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
>            Priority: Minor
>
> 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. In `spark`, we can check this by `tableExists` function. 
> I can submit a pr If someone think this is ok.

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