hive icon indicating copy to clipboard operation
hive copied to clipboard

HIVE-27855: Create external tables for Hive and Tez protologging events

Open KiranVelumuri opened this issue 2 years ago • 7 comments

What changes were proposed in this pull request?

HiveProtoLoggingHook in Hive and ProtoHistoryLoggingService in Tez logs details, such as query execution, query plan, runtime statistics, serialised as protobuf files. This PR exposes these protobuf log files as external tables. This would be done during the information schema upgrade to the next Hive version, which is 4.0.0-beta-2 in this case.

Why are the changes needed?

By exposing the protobuf log files as external tables, it can be useful for debugging, performance tuning and auditing purposes.

Does this PR introduce any user-facing change?

No

Is the change a dependency upgrade?

No

How was this patch tested?

This patch was tested by upgrading the information schema version and validating that the external tables have been created pointing to the correct specified locations.

KiranVelumuri avatar Jan 25 '24 05:01 KiranVelumuri

Quality Gate Passed Quality Gate passed

The SonarCloud Quality Gate passed, but some issues were introduced.

4 New issues
0 Security Hotspots
No data about Coverage
No data about Duplication

See analysis details on SonarCloud

sonarqubecloud[bot] avatar Jan 25 '24 06:01 sonarqubecloud[bot]

Quality Gate Passed Quality Gate passed

Issues
3 New issues
0 Accepted issues

Measures
0 Security Hotspots
No data about Coverage
No data about Duplication

See analysis details on SonarCloud

sonarqubecloud[bot] avatar Apr 08 '24 06:04 sonarqubecloud[bot]

Quality Gate Passed Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
No data about Coverage
No data about Duplication

See analysis details on SonarCloud

sonarqubecloud[bot] avatar Jun 16 '24 18:06 sonarqubecloud[bot]

We may need to fix some tests

okumin avatar Jun 20 '24 16:06 okumin

We may need to fix some tests

In the PR commit build I am getting this error, but I have not changed anything in TestMiniLlapLocalCliDriver. My changes are only related to schema and I'm unable to understand as to why this specific test is failing. Could you please help me with fixing the build? Thank you.

./itests/qtest/target/surefire-reports/TEST-org.apache.hadoop.hive.cli.split23.TestMiniLlapLocalCliDriver.xml:59905.176: internal error: Huge input lookup

KiranVelumuri avatar Jun 26 '24 11:06 KiranVelumuri

In the PR commit build I am getting this error, but I have not changed anything in TestMiniLlapLocalCliDriver. My changes are only related to schema and I'm unable to understand as to why this specific test is failing. Could you please help me with fixing the build? Thank you.

I think at least these failed because of this PR.

  • https://ci.hive.apache.org/blue/rest/organizations/jenkins/pipelines/hive-precommit/branches/PR-5036/runs/7/nodes/667/log/?start=0
  • https://ci.hive.apache.org/blue/rest/organizations/jenkins/pipelines/hive-precommit/branches/PR-5036/runs/7/nodes/514/log/?start=0
  • https://ci.hive.apache.org/blue/rest/organizations/jenkins/pipelines/hive-precommit/branches/PR-5036/runs/7/nodes/502/log/?start=0

okumin avatar Jun 27 '24 04:06 okumin