[jira] [Work logged] (HIVE-25879) MetaStoreDirectSql test query should not query the DBS table

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-25879?focusedWorklogId=765770&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-765770 ]

ASF GitHub Bot logged work on HIVE-25879:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 04/May/22 00:19
            Start Date: 04/May/22 00:19
    Worklog Time Spent: 10m 
      Work Description: github-actions[bot] commented on PR #2964:
URL: https://github.com/apache/hive/pull/2964#issuecomment-1116789118

   This pull request has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
   Feel free to reach out on the dev@hive.apache.org list if the patch is in need of reviews.




Issue Time Tracking
-------------------

    Worklog Id:     (was: 765770)
    Time Spent: 40m  (was: 0.5h)

> 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
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> 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.7#820007)