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
