Miklos Szurap created HIVE-25879:
------------------------------------

             Summary: MetaStoreDirectSql test query should not query the DBS 
table
                 Key: HIVE-25879
                 URL: https://issues.apache.org/jira/browse/HIVE-25879
             Project: Hive
          Issue Type: Bug
            Reporter: Miklos Szurap


The runTestQuery() in the 
org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java is using a test query
{code:java}
select "DB_ID" from "DBS"{code}
to determine whether the direct SQL can be used.

With larger deployments with many (10k+) Hive databases it would be more 
efficienct to query a small table instead, for example the "VERSION" table 
should always have a single row only.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to