hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gang Tim Liu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-4235) CREATE TABLE IF NOT EXISTS uses inefficient way to check if table exists
Date Tue, 26 Mar 2013 22:29:16 GMT
Gang Tim Liu created HIVE-4235:
----------------------------------

             Summary: CREATE TABLE IF NOT EXISTS uses inefficient way to check if table exists
                 Key: HIVE-4235
                 URL: https://issues.apache.org/jira/browse/HIVE-4235
             Project: Hive
          Issue Type: Bug
          Components: JDBC, Query Processor, SQL
            Reporter: Gang Tim Liu
            Assignee: Gang Tim Liu


CREATE TABLE IF NOT EXISTS uses inefficient way to check if table exists.

It uses Hive.java's getTablesByPattern(...) to check if table exists. It involves regular
expression and eventually database join. Very efficient. May cause database lock time increases
and hurt db performance if a lot of such commands hit database.

The suggested approach is to use getTable(...) since we know tablename already

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message