You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Zoltan Haindrich (Jira)" <ji...@apache.org> on 2022/06/14 13:16:00 UTC
[jira] [Resolved] (HIVE-25879) MetaStoreDirectSql test query should not query the whole DBS table
[ https://issues.apache.org/jira/browse/HIVE-25879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zoltan Haindrich resolved HIVE-25879.
-------------------------------------
Fix Version/s: 4.0.0-alpha-2
Assignee: Miklos Szurap
Resolution: Fixed
merged into master; Thank you [~mszurap] for fixing this!
> MetaStoreDirectSql test query should not query the whole DBS table
> ------------------------------------------------------------------
>
> Key: HIVE-25879
> URL: https://issues.apache.org/jira/browse/HIVE-25879
> Project: Hive
> Issue Type: Bug
> Reporter: Miklos Szurap
> Assignee: Miklos Szurap
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0-alpha-2
>
> Time Spent: 1.5h
> 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)