[jira] [Created] (PHOENIX-6847) Provide a crisp API to check if a view exists.

["Rushabh Shah (Jira)" <ji...@apache.org>]

Rushabh Shah created PHOENIX-6847:
-------------------------------------

             Summary: Provide a crisp API to check if a view exists.
                 Key: PHOENIX-6847
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6847
             Project: Phoenix
          Issue Type: Bug
            Reporter: Rushabh Shah


Currently customer using phoenix runs the following statements to check if a view exists or not.
{noformat}
  public static boolean checkTableViewExists(Connection connection, String schema, String viewName)
      throws SQLException {
    DatabaseMetaData meta = connection.getMetaData();
    ResultSet resultSet = meta.getTables(null, schema, viewName, new String[] {"VIEW"});
    return resultSet.next();
  }
{noformat}

IMHO this is NOT very user friendly.
We need to provide either of the 2 APIs

{noformat}
public PTable getView(String viewName, String tenantID);  OR 
public boolean viewExists(String viewName, String tenantID);
{noformat}






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