HIVE-28994: Implement direct sql for getAllDatabases and getDatabases in RawStore

[shuyouZZ]

What changes were proposed in this pull request?

Implement direct sql for getAllDatabases and getDatabases in RawStore.

Why are the changes needed?

Improve the performance of getAllDatabases and getDatabases.

Does this PR introduce any user-facing change?

No

How was this patch tested?

mvn test -Dtest.groups= -Dtest=org.apache.hadoop.hive.metastore.TestObjectStore#testDatabaseOps -pl :hive-standalone-metastore-server

[okumin]

CI failed probably because of this change.

[shuyouZZ]

CI failed probably because of this change.

I can not open the continuous-integration page, it shows Not Found. The previous execution of CI was successful.

[okumin]

@shuyouZZ You can sign in the Jenkins with a GitHub account

[shuyouZZ]

@shuyouZZ You can sign in the Jenkins with a GitHub account

thanks, let me try

[sonarqubecloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarQube Cloud

[deniskuzZ]

is that PR abandoned?

[shuyouZZ]

is that PR abandoned?

Sorry for taking so long to reply. I still hope to continue working on this PR, but I'm not sure why this build failed.

[okumin]

@shuyouZZ Although this might not be the direct reason, you have to rebase the topic branch. The CI says it was tested with JDK 17, but the upstream uses JDK 21 https://github.com/apache/hive/actions/runs/15722082143/job/44304757814?pr=5852

[shuyouZZ]

@shuyouZZ Although this might not be the direct reason, you have to rebase the topic branch. The CI says it was tested with JDK 17, but the upstream uses JDK 21 https://github.com/apache/hive/actions/runs/15722082143/job/44304757814?pr=5852

Ok. Let me try force rebase.

[sonarqubecloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarQube Cloud

[github-actions[bot]]

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 [email protected] list if the patch is in need of reviews.