You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gi...@apache.org on 2025/10/15 10:15:23 UTC
(hive-site) branch asf-site updated: deploy: 07b3afd1f4aad11ff07565459ce9c49c64b09ded
This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/hive-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 3f381e9 deploy: 07b3afd1f4aad11ff07565459ce9c49c64b09ded
3f381e9 is described below
commit 3f381e998eae86b3f15daf9507999f15100cd6f5
Author: zabetak <za...@users.noreply.github.com>
AuthorDate: Wed Oct 15 10:15:18 2025 +0000
deploy: 07b3afd1f4aad11ff07565459ce9c49c64b09ded
---
development/desingdocs/statsdev/index.html | 3 +-
docs/index.xml | 2 +-
.../admin/adminmanual-configuration/index.html | 5 -
.../admin/copy-of-hive-schema-tool/index.html | 442 ---------------------
docs/latest/admin/hive-schema-tool/index.html | 240 +++++++----
docs/latest/admin/index.html | 57 +--
docs/latest/admin/index.xml | 10 +-
.../user/configuration-properties/index.html | 8 +-
index.json | 2 +-
index.xml | 10 +-
sitemap.xml | 2 +-
11 files changed, 195 insertions(+), 586 deletions(-)
diff --git a/development/desingdocs/statsdev/index.html b/development/desingdocs/statsdev/index.html
index bacfb9f..36e4a54 100644
--- a/development/desingdocs/statsdev/index.html
+++ b/development/desingdocs/statsdev/index.html
@@ -488,10 +488,9 @@ public interface IStatsAggregator {
</code></pre><p>The user can also specify the implementation to be used for the storage of temporary statistics setting the variable <strong><a href=#hive-stats-dbclass>hive.stats.dbclass</a></strong>. For example, to set HBase as the implementation of temporary statistics storage (the default is <code>jdbc:derby</code> or <code>fs</code>, depending on the Hive version) the user should issue the following command:</p>
<pre tabindex=0><code>set hive.stats.dbclass=hbase;
-</code></pre><p>In case of JDBC implementations of temporary stored statistics (ex. Derby or MySQL), the user should specify the appropriate connection string to the database by setting the variable <strong><a href=#hive-stats-dbconnectionstring>hive.stats.dbconnectionstring</a></strong>. Also the user should specify the appropriate JDBC driver by setting the variable <strong><a href=#hive-stats-jdbcdriver>hive.stats.jdbcdriver</a></strong>.</p>
+</code></pre><p>In case of JDBC implementations of temporary stored statistics (ex. Derby or MySQL), the user should specify the appropriate connection string to the database by setting the variable <strong><a href=#hive-stats-dbconnectionstring>hive.stats.dbconnectionstring</a></strong>.</p>
<pre tabindex=0><code>set hive.stats.dbclass=jdbc:derby;
set hive.stats.dbconnectionstring="jdbc:derby:;databaseName=TempStatsStore;create=true";
-set hive.stats.jdbcdriver="org.apache.derby.jdbc.EmbeddedDriver";
</code></pre><p>Queries can fail to collect stats completely accurately. There is a setting <strong><a href=#hive-stats-reliable>hive.stats.reliable</a></strong> that fails queries if the stats can’t be reliably collected. This is <code>false</code> by default.</p>
<h3 id=existing-tables-analyze>Existing Tables – ANALYZE</h3>
diff --git a/docs/index.xml b/docs/index.xml
index 69930cf..c91976c 100644
--- a/docs/index.xml
+++ b/docs/index.xml
@@ -1 +1 @@
-<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom"><channel><title>Docs on Hive Site</title><link>https://hive.apache.org/docs/</link><description>Recent content in Docs on Hive Site</description><generator>Hugo -- gohugo.io</generator><language>en-us</language><lastBuildDate>Tue, 30 Sep 2025 00:00:00 +0000</lastBuildDate><atom:link href="https://hive.apache.org/docs/index.xml" rel="self" type="application/rss+xml"/><item><t [...]
\ No newline at end of file
+<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom"><channel><title>Docs on Hive Site</title><link>https://hive.apache.org/docs/</link><description>Recent content in Docs on Hive Site</description><generator>Hugo -- gohugo.io</generator><language>en-us</language><lastBuildDate>Tue, 14 Oct 2025 00:00:00 +0000</lastBuildDate><atom:link href="https://hive.apache.org/docs/index.xml" rel="self" type="application/rss+xml"/><item><t [...]
\ No newline at end of file
diff --git a/docs/latest/admin/adminmanual-configuration/index.html b/docs/latest/admin/adminmanual-configuration/index.html
index 61d9197..6de95b1 100644
--- a/docs/latest/admin/adminmanual-configuration/index.html
+++ b/docs/latest/admin/adminmanual-configuration/index.html
@@ -425,11 +425,6 @@ hive-site.xml -> hivemetastore-site.xml -> hiveserver2-site.xml -> ‘<code>
<td>jdbc:derby:;databaseName=TempStatsStore;create=true</td>
</tr>
<tr>
-<td>hive.stats.jdbcdriver</td>
-<td>The JDBC driver for the database that stores temporary hive statistics. (As of Hive <a href=https://issues.apache.org/jira/browse/HIVE-1361>0.7.0</a>.)</td>
-<td>org.apache.derby.jdbc.EmbeddedDriver</td>
-</tr>
-<tr>
<td>hive.stats.reliable</td>
<td>Whether queries will fail because stats cannot be collected completely accurately. If this is set to true, reading/writing from/into a partition may fail becuase the stats could not be computed accurately. (As of Hive <a href=https://issues.apache.org/jira/browse/HIVE-1653>0.10.0</a>.)</td>
<td>false</td>
diff --git a/docs/latest/admin/copy-of-hive-schema-tool/index.html b/docs/latest/admin/copy-of-hive-schema-tool/index.html
deleted file mode 100644
index 4acdefa..0000000
--- a/docs/latest/admin/copy-of-hive-schema-tool/index.html
+++ /dev/null
@@ -1,442 +0,0 @@
-<!doctype html><html><!doctype html>
-<html>
-<head>
-<meta charset=utf-8>
-<meta http-equiv=x-ua-compatible content="IE=edge">
-<meta name=viewport content="width=device-width,initial-scale=1">
-<meta name=description content>
-<meta name=author content>
-<title>Apache Hive : Copy of Hive Schema Tool - [TODO: move it under a 4.0 admin manual page, find a proper name]</title>
-<link rel=icon href=/images/hive.svg sizes=any type=image/svg+xml>
-<link rel=stylesheet href=https://hive.apache.org/css/hive-theme.css>
-<link rel=stylesheet href=https://hive.apache.org/css/font-awesome.all.min.css>
-<link rel=stylesheet href=https://hive.apache.org/css/bootstrap.min.css>
-<link rel=stylesheet href=https://hive.apache.org/css/termynal.css>
-<link rel=apple-touch-icon sizes=180x180 href=https://hive.apache.org/images/apple-touch-icon.png>
-<link rel=icon type=image/png sizes=32x32 href=https://hive.apache.org/images/favicon-32x32.png>
-<link rel=icon type=image/png sizes=16x16 href=https://hive.apache.org/images/favicon-16x16.png>
-<link rel=manifest href=https://hive.apache.org/images/site.webmanifest>
-<link rel=mask-icon href=https://hive.apache.org/images/safari-pinned-tab.svg color=#5bbad5>
-<meta name=msapplication-TileColor content="#da532c">
-<meta name=theme-color content="#ffffff">
-<script>var _paq=window._paq=window._paq||[];_paq.push(['disableCookies']),_paq.push(['trackPageView']),_paq.push(['enableLinkTracking']),function(){var b="https://analytics.apache.org/",c,a,d;_paq.push(['setTrackerUrl',b+'matomo.php']),_paq.push(['setSiteId','30']),c=document,a=c.createElement('script'),d=c.getElementsByTagName('script')[0],a.async=!0,a.src=b+'matomo.js',d.parentNode.insertBefore(a,d)}()</script>
-</head>
-<body>
-<body>
-<header>
-<menu class=main-menu>
-<nav class="navbar navbar-expand-lg navbar-dark">
-<div class=container-fluid>
-<div class=navbar-brand-wrapper>
-<a href=https://hive.apache.org class=navbar-logo>
-<img src=https://hive.apache.org/images/hive.svg width=50 height=30 alt="Apache Hive Logo">
-</a>
-<a class=navbar-brand href=https://hive.apache.org>Apache Hive</a>
-</div>
-<button class=navbar-toggler type=button data-bs-toggle=collapse data-bs-target=#navbarSupportedContent aria-controls=navbarSupportedContent aria-expanded=false aria-label="Toggle navigation">
-<span class=navbar-toggler-icon></span>
-</button>
-<div class="collapse navbar-collapse" id=navbarSupportedContent>
-<ul class="navbar-nav me-auto">
-<li class=nav-item>
-<a class=nav-link href=https://hive.apache.org/general/downloads>
-Releases
-</a>
-</li>
-<li class="nav-item dropdown">
-<a class="nav-link dropdown-toggle" href=/Document id=docsDropdown role=button data-bs-toggle=dropdown aria-expanded=false>
-Documentation
-</a>
-<ul class=dropdown-menu aria-labelledby=docsDropdown>
-<li><a class=dropdown-item href=https://hive.apache.org/docs/latest/>Latest</a></li>
-<li><a class=dropdown-item href=https://hive.apache.org/docs/javadocs/>Javadocs</a></li>
-<li><a class=dropdown-item href=https://hive.apache.org/docs/latest/language/languagemanual>Language Manual</a></li>
-</ul>
-</li>
-<li class="nav-item dropdown">
-<a class="nav-link dropdown-toggle" href=/general id=generalDropdown role=button data-bs-toggle=dropdown aria-expanded=false>
-General
-</a>
-<ul class=dropdown-menu aria-labelledby=generalDropdown>
-<li><a class=dropdown-item href=https://www.apache.org/licenses/LICENSE-2.0.html>License</a></li>
-<li><a class=dropdown-item href=https://hive.apache.org/general/privacypolicy/>Privacy Policy</a></li>
-<li><a class=dropdown-item href=/general/poweredby/>Powered by</a></li>
-</ul>
-</li>
-<li class="nav-item dropdown">
-<a class="nav-link dropdown-toggle" href=# id=devDropdown role=button data-bs-toggle=dropdown aria-expanded=false>
-Development
-</a>
-<ul class=dropdown-menu aria-labelledby=devDropdown>
-<li><a class=dropdown-item href=https://hive.apache.org/development/gettingstarted/>Getting Started</a></li>
-<li><a class=dropdown-item href=https://hive.apache.org/development/quickstart/>Quickstart with Docker</a></li>
-<li><a class=dropdown-item href=https://hive.apache.org/development/desingdocs/>Design Docs</a></li>
-<li><a class=dropdown-item href=https://issues.apache.org/jira/projects/HIVE/issues>Hive JIRA</a></li>
-<li><a class=dropdown-item href=https://hive.apache.org/community/resources/hivedeveloperfaq>Hive Developer FAQ</a></li>
-<li><a class=dropdown-item href=https://hive.apache.org/development/versioncontrol/>Version Control</a></li>
-</ul>
-</li>
-<li class="nav-item dropdown">
-<a class="nav-link dropdown-toggle" href=# id=communityDropdown role=button data-bs-toggle=dropdown aria-expanded=false>
-Community
-</a>
-<ul class=dropdown-menu aria-labelledby=communityDropdown>
-<li><a class=dropdown-item href=/community/becomingcommitter/>Becoming A Committer</a></li>
-<li><a class=dropdown-item href=https://hive.apache.org/community/resources/howtocontribute>How To Contribute</a></li>
-<li><a class=dropdown-item href=/community/resources/>Resources</a></li>
-<li><a class=dropdown-item href=/community/meetings/>Meetings</a></li>
-<li><a class=dropdown-item href=https://hive.apache.org/community/mailinglists/>Mailing Lists</a></li>
-<li><a class=dropdown-item href=https://hive.apache.org/community/issuetracking/>Issue Tracking</a></li>
-<li><a class=dropdown-item href=https://hive.apache.org/community/people/>People</a></li>
-<li><hr class=dropdown-divider></li>
-<li><a class=dropdown-item href=/community/bylaws/>By Laws</a></li>
-<li><a class=dropdown-item href=/community/resources/howtorelease/>How To Release</a></li>
-</ul>
-</li>
-<li class=nav-item>
-<a class=nav-link href=https://hive.blog.apache.org/>
-Blogs
-</a>
-</li>
-<li class="nav-item dropdown">
-<a class="nav-link dropdown-toggle" href=# id=asfDropdown role=button data-bs-toggle=dropdown aria-expanded=false>
-ASF
-</a>
-<ul class=dropdown-menu aria-labelledby=asfDropdown>
-<li><a class=dropdown-item href=https://www.apache.org/foundation/contributing.html>Donations</a></li>
-<li><a class=dropdown-item href=https://www.apache.org/foundation/sponsorship.html>Sponsorship</a></li>
-<li><a class=dropdown-item href=https://www.apache.org/foundation/thanks.html>Thanks</a></li>
-<li><a class=dropdown-item href=https://www.apache.org/>Website</a></li>
-</ul>
-</li>
-</ul>
-<div class=navbar-search>
-<form action=/search method=get class=search-form>
-<div class=search-input-group>
-<input type=search name=q id=search-query placeholder=Search... class=search-input aria-label=Search>
-<button type=submit class=search-button aria-label="Submit search">
-<i class="fas fa-search"></i>
-</button>
-</div>
-</form>
-</div>
-</div>
-</div>
-</nav>
-</menu>
-</header>
-<div class=content>
-<div class=docs-container>
-<main class="docs-main docs-main-full">
-<article class=docs-content>
-<nav class=docs-breadcrumb>
-<ol>
-<li><a href=/><i class="fas fa-home"></i> Home</a></li>
-<li><a href=/docs/>Documentation</a></li>
-<li class=active>Apache Hive : Copy of Hive Schema Tool - [TODO: move it under a 4.0 admin manual page, find a proper name]</li>
-</ol>
-</nav>
-<header class=docs-header>
-<h1 class=docs-title>Apache Hive : Copy of Hive Schema Tool - [TODO: move it under a 4.0 admin manual page, find a proper name]</h1>
-<div class=docs-meta>
-<span class=docs-date>
-<i class="fas fa-calendar-alt"></i>
-Last updated: December 12, 2024
-</span>
-</div>
-</header>
-<div class=docs-toc>
-<h4><i class="fas fa-list"></i> Table of Contents</h4>
-<nav id=TableOfContents>
-<ul>
-<li><a href=#apache-hive--copy-of-hive-schema-tool---todo-move-it-under-a-40-admin-manual-page-find-a-proper-name>Apache Hive : Copy of Hive Schema Tool - [TODO: move it under a 4.0 admin manual page, find a proper name]</a>
-<ul>
-<li><a href=#about>About</a></li>
-<li><a href=#metastore-schema-verification>Metastore Schema Verification</a></li>
-<li><a href=#the-hive-schema-tool>The Hive Schema Tool</a>
-<ul>
-<li><a href=#the-schematool-command>The <code>schematool</code> Command</a></li>
-<li><a href=#usage-examples>Usage Examples</a></li>
-</ul>
-</li>
-</ul>
-</li>
-</ul>
-</nav>
-</div>
-<div class=docs-article>
-<h1 id=apache-hive--copy-of-hive-schema-tool---todo-move-it-under-a-40-admin-manual-page-find-a-proper-name>Apache Hive : Copy of Hive Schema Tool - [TODO: move it under a 4.0 admin manual page, find a proper name]</h1>
-<aside class=table-of-contents>
-<nav id=TableOfContents>
-<ul>
-<li><a href=#apache-hive--copy-of-hive-schema-tool---todo-move-it-under-a-40-admin-manual-page-find-a-proper-name>Apache Hive : Copy of Hive Schema Tool - [TODO: move it under a 4.0 admin manual page, find a proper name]</a>
-<ul>
-<li><a href=#about>About</a></li>
-<li><a href=#metastore-schema-verification>Metastore Schema Verification</a></li>
-<li><a href=#the-hive-schema-tool>The Hive Schema Tool</a>
-<ul>
-<li><a href=#the-schematool-command>The <code>schematool</code> Command</a></li>
-<li><a href=#usage-examples>Usage Examples</a></li>
-</ul>
-</li>
-</ul>
-</li>
-</ul>
-</nav>
-</aside>
-<h2 id=about>About</h2>
-<p>Schema tool helps to initialise and upgrade metastore database and hive sys schema.</p>
-<h2 id=metastore-schema-verification>Metastore Schema Verification</h2>
-<p>Hive records the schema version in the metastore database and verifies that the metastore schema version is compatible with Hive binaries that are going to access the metastore. Note that the Hive properties to implicitly create or alter the existing schema are disabled by default. Hive will not attempt to change the metastore schema implicitly. When you execute a Hive query against an old schema, it will fail to access the metastore:</p>
-<pre tabindex=0><code>$ build/dist/bin/hive -e "show tables"
-FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
-
-</code></pre><p>The log will contain an error about version information not found:</p>
-<pre tabindex=0><code>...
-Caused by: MetaException(message:Version information not found in metastore. )
-...
-
-</code></pre><p>By default the configuration property <strong>metastore.schema.verification</strong> is true. If we set it false, metastore implicitly writes the schema version if it’s not matching. To disable the strict schema verification, you need to set this property to false in <code>hive-site.xml</code>.</p>
-<p>See <a href=https://hive.apache.org/docs/latest/admin/adminmanual-metastore-administration/>Hive Metastore Administration</a> for general information about the metastore.</p>
-<h2 id=the-hive-schema-tool>The Hive Schema Tool</h2>
-<p>The Hive distribution now includes an offline tool for Hive metastore schema manipulation. This tool can be used to initialize the metastore schema for the current Hive version. It can also handle upgrading the schema from an older version to current. It tries to find the current schema from the metastore if it is available. This will be applicable to future upgrades like 0.12.0 to 0.13.0. In case of upgrades from older releases like 0.7.0 or 0.10.0, you can specify the schema version [...]
-<p>The <code>schematool</code> figures out the SQL scripts required to initialize or upgrade the schema and then executes those scripts against the backend database. The metastore DB connection information like JDBC URL, JDBC driver and DB credentials are extracted from the Hive configuration. You can provide alternate DB credentials if needed.</p>
-<p><strong>Warning</strong>: You should always initialize the metastore schema first and the Hive schema second. The Hive schema initialization checks the metastore database schema and if it is not initialized, it puts some objects into the metastore database as well to make sure hive schema is running. That also means if you want to run the metastore schema initialization after the hive one, it will fail as it finds a database that already contains some objects. </p>
-<h3 id=the-schematool-command>The <code>schematool</code> Command</h3>
-<p>The <code>schematool</code> command invokes the Hive schema tool with these options:</p>
-<pre tabindex=0><code>$ usage: schemaTool
- -alterCatalog <arg> Alter a catalog, requires
- --catalogLocation and/or
- --catalogDescription parameter as well
- -catalogDescription <arg> Description of new catalog
- -catalogLocation <arg> Location of new catalog, required when
- adding a catalog
- -createCatalog <arg> Create a catalog, requires
- --catalogLocation parameter as well
- -createLogsTable <arg> Create table for Hive
- warehouse/compute logs
- -createUser Create the Hive user, set hiveUser to
- the db admin user and the hive
- password to the db admin password with
- this
- -dbOpts <databaseOpts> Backend DB specific options
- -dbType <databaseType> Metastore database type
- -driver <driver> driver name for connection
- -dropAllDatabases Drop all Hive databases (with
- CASCADE). This will remove all managed
- data!
- -dryRun list SQL scripts (no execute)
- -fromCatalog <arg> Catalog a moving database or table is
- coming from. This is required if you
- are moving a database or table.
- -fromDatabase <arg> Database a moving table is coming
- from. This is required if you are
- moving a table.
- -help print this message
- -hiveDb <arg> Hive database (for use with
- createUser)
- -hivePassword <arg> Hive password (for use with
- createUser)
- -hiveUser <arg> Hive user (for use with createUser)
- -ifNotExists If passed then it is not an error to
- create an existing catalog
- -info Show config and schema details
- -initOrUpgradeSchema Initialize or upgrade schema to latest
- version
- -initSchema Schema initialization
- -initSchemaTo <initTo> Schema initialization to a version
- -mergeCatalog <arg> Merge databases from a catalog into
- other, Argument is the source catalog
- name Requires --toCatalog to indicate
- the destination catalog
- -metaDbType <metaDatabaseType> Used only if upgrading the system
- catalog for hive
- -moveDatabase <arg> Move a database between catalogs.
- Argument is the database name.
- Requires --fromCatalog and --toCatalog
- parameters as well
- -moveTable <arg> Move a table to a different database.
- Argument is the table name. Requires
- --fromCatalog, --toCatalog,
- --fromDatabase, and --toDatabase
- parameters as well.
- -passWord <password> Override config file password
- -retentionPeriod <arg> Specify logs table retention period
- -servers <serverList> a comma-separated list of servers used
- in location validation in the format
- of scheme://authority (e.g.
- hdfs://localhost:8000)
- -toCatalog <arg> Catalog a moving database or table is
- going to. This is required if you are
- moving a database or table.
- -toDatabase <arg> Database a moving table is going to.
- This is required if you are moving a
- table.
- -upgradeSchema Schema upgrade
- -upgradeSchemaFrom <upgradeFrom> Schema upgrade from a version
- -url <url> connection url to the database
- -userName <user> Override config file user name
- -validate Validate the database
- -verbose only print SQL statements
- -yes Don't ask for confirmation when using
- -dropAllDatabases.
-</code></pre><p>The <strong>dbType</strong> is required and can be one of:</p>
-<pre tabindex=0><code> derby|mysql|postgres|oracle|mssql|hive
-</code></pre><p>Note: dbType=hive only can be used on Hive sys schema. The others are metastore db types and in case of dbType=hive, it is mandatory to set metaDbType as well. </p>
-<h3 id=usage-examples>Usage Examples</h3>
-<ul>
-<li>Initialize to current schema for a new Hive setup:</li>
-</ul>
-<pre tabindex=0><code>$ schematool -dbType derby -initSchema Initializing the schema to: 4.0.0-beta-2
-Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
-Metastore connection Driver : org.apache.derby.jdbc.EmbeddedDriver
-Metastore connection User: APP
-Starting metastore schema initialization to 4.0.0-beta-2
-Initialization script hive-schema-4.0.0-beta-2.derby.sql
-Initialization script completed
-</code></pre><ul>
-<li>Get schema information:</li>
-</ul>
-<pre tabindex=0><code>$ schematool -dbType derby -info
-Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
-Metastore connection Driver : org.apache.derby.jdbc.EmbeddedDriver
-Metastore connection User: APP
-Hive distribution version: 4.0.0-beta-2
-Metastore schema version: 4.0.0-beta-2
-</code></pre><ul>
-<li>Init schema to for a given version: </li>
-</ul>
-<pre tabindex=0><code>$ schematool -dbType derby -initSchemaTo 3.1.0
-Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
-Metastore connection Driver : org.apache.derby.jdbc.EmbeddedDriver
-Metastore connection User: APP
-Starting metastore schema initialization to 3.1.0
-Initialization script hive-schema-3.1.0.derby.sql
-</code></pre><ul>
-<li>Upgrade schema from an 3.1.0 release by specifying the ‘from’ version:</li>
-</ul>
-<pre tabindex=0><code>$ schematool -dbType derby -upgradeSchemaFrom 3.1.0 Upgrading from the user input version 3.1.0
-Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
-Metastore connection Driver : org.apache.derby.jdbc.EmbeddedDriver
-Metastore connection User: APP
-Starting upgrade metastore schema from version 3.1.0 to 4.0.0-beta-2
-Upgrade script upgrade-3.1.0-to-3.2.0.derby.sql
-Completed upgrade-3.1.0-to-3.2.0.derby.sql
-...
-Completed upgrade-4.0.0-beta-1-to-4.0.0-beta-2.derby.sql
-</code></pre><ul>
-<li>Upgrade dry run can be used to list the required scripts for the given upgrade.</li>
-</ul>
-<pre tabindex=0><code>$ schematool -dbType derby -upgradeSchemaFrom 3.1.0 -dryRun Upgrading from the user input version 3.1.0
-Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
-Metastore connection Driver : org.apache.derby.jdbc.EmbeddedDriver
-Metastore connection User: APP
-Starting upgrade metastore schema from version 3.1.0 to 4.0.0-beta-2
-Upgrade script upgrade-3.1.0-to-3.2.0.derby.sql
-Upgrade script upgrade-3.2.0-to-4.0.0-alpha-1.derby.sql
-Upgrade script upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.derby.sql
-Upgrade script upgrade-4.0.0-alpha-2-to-4.0.0-beta-1.derby.sql
-Upgrade script upgrade-4.0.0-beta-1-to-4.0.0-beta-2.derby.sql
-</code></pre><p>This is useful if you just want to find out all the required scripts for the schema upgrade.</p>
-<ul>
-<li>Initialise Hive sys schema </li>
-</ul>
-<pre tabindex=0><code>$ ./schematool -dbType hive -metaDbType derby -initSchema --verbose -url="jdbc:hive2://localhost:10000"
-</code></pre><p>Note 1: As</p>
-<ul>
-<li>Moving a database and tables under it from default Hive catalog to a custom spark catalog</li>
-</ul>
-<pre tabindex=0><code>build/dist/bin/schematool -moveDatabase db1 -fromCatalog hive -toCatalog spark
-
-</code></pre><ul>
-<li>Moving a table from Hive catalog to Spark Catalog</li>
-</ul>
-<pre tabindex=0><code># Create the desired target database in spark catalog if it doesn't already exist.
-beeline ... -e "create database if not exists newdb";
-schematool -moveDatabase newdb -fromCatalog hive -toCatalog spark
-
-# Now move the table to target db under the spark catalog.
-schematool -moveTable table1 -fromCatalog hive -toCatalog spark -fromDatabase db1 -toDatabase newdb
-
-</code></pre>
-</div>
-<footer class=docs-footer>
-<div class=docs-feedback>
-<h4><i class="fas fa-comment"></i> Feedback</h4>
-<p>Was this page helpful? Let us know how we can improve.</p>
-<div class=docs-feedback-buttons>
-<button class="btn btn-feedback btn-positive">
-<i class="fas fa-thumbs-up"></i> Yes
-</button>
-<button class="btn btn-feedback btn-negative">
-<i class="fas fa-thumbs-down"></i> No
-</button>
-</div>
-</div>
-<div class=docs-edit>
-<a href=https://github.com/apache/hive-site/edit/main/content/docs/latest/admin/copy-of-hive-schema-tool.md class="btn btn-outline">
-<i class="fab fa-github"></i> Edit this page on GitHub
-</a>
-</div>
-</footer>
-</article>
-<aside class=docs-toc-sidebar>
-<div class=docs-toc-sticky>
-<h4><i class="fas fa-list"></i> On this page</h4>
-<nav id=TableOfContents>
-<ul>
-<li><a href=#apache-hive--copy-of-hive-schema-tool---todo-move-it-under-a-40-admin-manual-page-find-a-proper-name>Apache Hive : Copy of Hive Schema Tool - [TODO: move it under a 4.0 admin manual page, find a proper name]</a>
-<ul>
-<li><a href=#about>About</a></li>
-<li><a href=#metastore-schema-verification>Metastore Schema Verification</a></li>
-<li><a href=#the-hive-schema-tool>The Hive Schema Tool</a>
-<ul>
-<li><a href=#the-schematool-command>The <code>schematool</code> Command</a></li>
-<li><a href=#usage-examples>Usage Examples</a></li>
-</ul>
-</li>
-</ul>
-</li>
-</ul>
-</nav>
-</div>
-</aside>
-</main>
-</div>
-</div>
-<footer class="black-background static-bottom" style=padding:30px>
-<div class=row>
-<div class=col-3>
-<a href=https://www.apache.org/>
-<img src=https://hive.apache.org/images/asf_logo.png width=270 height=100 alt="Apache Software Foundation"></a>
-</a>
-</div>
-<div class=col-9>
-<p class=footer-text>Apache is a non-profit organization helping open-source
-software projects released under the Apache
-<a href=https://www.apache.org/licenses/>license</a>
-and managed with
-<a href=https://www.apache.org/foundation/how-it-works.html>
-open governance</a> and
-<a href=https://privacy.apache.org/policies/privacy-policy-public.html>
-privacy policy</a>. See upcoming
-<a href=https://www.apache.org/events/current-event>Apache Events</a>.
-If you discover any
-<a href=https://www.apache.org/security/>security</a> vulnerabilities, please
-report them privately. Finally,
-<a href=https://www.apache.org/foundation/sponsorship.html>thanks
-</a> to the sponsors who
-<a href=https://www.apache.org/foundation/contributing.html>
-donate</a> to the Apache Foundation.
-</p>
-</div>
-</div>
-<div class="copyright row">
-<a href=https://hive.apache.org style=color:grey>
-The contents of this website are © 2023 Apache Software Foundation under the terms of the Apache License v2. Apache Hive and its logo are trademarks of the Apache Software Foundation.
-</a>
-</div>
-</footer>
-<script src=https://hive.apache.org/js/bootstrap.bundle.min.js></script>
-</body>
-</html>
\ No newline at end of file
diff --git a/docs/latest/admin/hive-schema-tool/index.html b/docs/latest/admin/hive-schema-tool/index.html
index d24e2c9..a9184d0 100644
--- a/docs/latest/admin/hive-schema-tool/index.html
+++ b/docs/latest/admin/hive-schema-tool/index.html
@@ -141,7 +141,7 @@ ASF
<div class=docs-meta>
<span class=docs-date>
<i class="fas fa-calendar-alt"></i>
-Last updated: December 12, 2024
+Last updated: October 14, 2025
</span>
</div>
</header>
@@ -151,6 +151,7 @@ Last updated: December 12, 2024
<ul>
<li><a href=#apache-hive--hive-schema-tool>Apache Hive : Hive Schema Tool</a>
<ul>
+<li><a href=#about>About</a></li>
<li><a href=#metastore-schema-verification>Metastore Schema Verification</a></li>
<li><a href=#the-hive-schema-tool>The Hive Schema Tool</a>
<ul>
@@ -170,6 +171,7 @@ Last updated: December 12, 2024
<ul>
<li><a href=#apache-hive--hive-schema-tool>Apache Hive : Hive Schema Tool</a>
<ul>
+<li><a href=#about>About</a></li>
<li><a href=#metastore-schema-verification>Metastore Schema Verification</a></li>
<li><a href=#the-hive-schema-tool>The Hive Schema Tool</a>
<ul>
@@ -182,132 +184,210 @@ Last updated: December 12, 2024
</ul>
</nav>
</aside>
+<h2 id=about>About</h2>
+<p>Schema tool helps to initialise and upgrade metastore database and hive sys schema.</p>
<h2 id=metastore-schema-verification>Metastore Schema Verification</h2>
-<p>Version</p>
<p>Introduced in Hive 0.12.0. See <a href=https://issues.apache.org/jira/browse/HIVE-3764>HIVE-3764</a>.</p>
-<p>Hive now records the schema version in the metastore database and verifies that the metastore schema version is compatible with Hive binaries that are going to accesss the metastore. Note that the Hive properties to implicitly create or alter the existing schema are disabled by default. Hive will not attempt to change the metastore schema implicitly. When you execute a Hive query against an old schema, it will fail to access the metastore:</p>
+<p>Hive records the schema version in the metastore database and verifies that the metastore schema version is compatible with Hive binaries that are going to access the metastore. Note that the Hive properties to implicitly create or alter the existing schema are disabled by default. Hive will not attempt to change the metastore schema implicitly. When you execute a Hive query against an old schema, it will fail to access the metastore:</p>
<pre tabindex=0><code>$ build/dist/bin/hive -e "show tables"
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
-
</code></pre><p>The log will contain an error about version information not found:</p>
<pre tabindex=0><code>...
Caused by: MetaException(message:Version information not found in metastore. )
...
-
-</code></pre><p>By default the configuration property <strong>hive.metastore.schema.verification</strong> is false and metastore to implicitly write the schema version if it’s not matching. To enable the strict schema verification, you need to set this property to true in <code>hive-site.xml</code>.</p>
+</code></pre><p>By default the configuration property <strong>metastore.schema.verification</strong> is true. If we set it false, metastore implicitly writes the schema version if it’s not matching. To disable the strict schema verification, you need to set this property to false in <code>hive-site.xml</code>.</p>
<p>See <a href=https://hive.apache.org/docs/latest/admin/adminmanual-metastore-administration/>Hive Metastore Administration</a> for general information about the metastore.</p>
<h2 id=the-hive-schema-tool>The Hive Schema Tool</h2>
-<p>Version</p>
<p>Introduced in Hive 0.12.0. See <a href=https://issues.apache.org/jira/browse/HIVE-5301>HIVE-5301</a>. (Also see <a href=https://issues.apache.org/jira/browse/HIVE-5449>HIVE-5449</a> for a bug fix.)</p>
<p>The Hive distribution now includes an offline tool for Hive metastore schema manipulation. This tool can be used to initialize the metastore schema for the current Hive version. It can also handle upgrading the schema from an older version to current. It tries to find the current schema from the metastore if it is available. This will be applicable to future upgrades like 0.12.0 to 0.13.0. In case of upgrades from older releases like 0.7.0 or 0.10.0, you can specify the schema version [...]
<p>The <code>schematool</code> figures out the SQL scripts required to initialize or upgrade the schema and then executes those scripts against the backend database. The metastore DB connection information like JDBC URL, JDBC driver and DB credentials are extracted from the Hive configuration. You can provide alternate DB credentials if needed.</p>
+<p><strong>Warning</strong>: You should always initialize the metastore schema first and the Hive schema second. The Hive schema initialization checks the metastore database schema and if it is not initialized, it puts some objects into the metastore database as well to make sure hive schema is running. That also means if you want to run the metastore schema initialization after the hive one, it will fail as it finds a database that already contains some objects. </p>
<h3 id=the-schematool-command>The <code>schematool</code> Command</h3>
<p>The <code>schematool</code> command invokes the Hive schema tool with these options:</p>
-<pre tabindex=0><code>$ schematool -help
-usage: schemaTool
+<pre tabindex=0><code>usage: schemaTool
+ -alterCatalog <arg> Alter a catalog, requires
+ --catalogLocation and/or
+ --catalogDescription parameter as well
+ -catalogDescription <arg> Description of new catalog
+ -catalogLocation <arg> Location of new catalog, required when
+ adding a catalog
+ -createCatalog <arg> Create a catalog, requires
+ --catalogLocation parameter as well
+ -createLogsTable <arg> Create table for Hive
+ warehouse/compute logs
+ -createUser Create the Hive user, set hiveUser to
+ the db admin user and the hive
+ password to the db admin password with
+ this
+ -dbOpts <databaseOpts> Backend DB specific options
-dbType <databaseType> Metastore database type
- -driver <driver> Driver name for connection
- -dryRun List SQL scripts (no execute)
- -help Print this message
+ -driver <driver> driver name for connection
+ -dropAllDatabases Drop all Hive databases (with
+ CASCADE). This will remove all managed
+ data!
+ -dryRun list SQL scripts (no execute)
+ -fromCatalog <arg> Catalog a moving database or table is
+ coming from. This is required if you
+ are moving a database or table.
+ -fromDatabase <arg> Database a moving table is coming
+ from. This is required if you are
+ moving a table.
+ -help print this message
+ -hiveDb <arg> Hive database (for use with
+ createUser)
+ -hivePassword <arg> Hive password (for use with
+ createUser)
+ -hiveUser <arg> Hive user (for use with createUser)
+ -ifNotExists If passed then it is not an error to
+ create an existing catalog
-info Show config and schema details
+ -initOrUpgradeSchema Initialize or upgrade schema to latest
+ version
-initSchema Schema initialization
-initSchemaTo <initTo> Schema initialization to a version
- -metaDbType <metaDatabaseType> Used only if upgrading the system catalog for hive
+ -mergeCatalog <arg> Merge databases from a catalog into
+ other, Argument is the source catalog
+ name Requires --toCatalog to indicate
+ the destination catalog
+ -metaDbType <metaDatabaseType> Used only if upgrading the system
+ catalog for hive
+ -moveDatabase <arg> Move a database between catalogs.
+ Argument is the database name.
+ Requires --fromCatalog and --toCatalog
+ parameters as well
+ -moveTable <arg> Move a table to a different database.
+ Argument is the table name. Requires
+ --fromCatalog, --toCatalog,
+ --fromDatabase, and --toDatabase
+ parameters as well.
-passWord <password> Override config file password
+ -retentionPeriod <arg> Specify logs table retention period
+ -servers <serverList> a comma-separated list of servers used
+ in location validation in the format
+ of scheme://authority (e.g.
+ hdfs://localhost:8000)
+ -toCatalog <arg> Catalog a moving database or table is
+ going to. This is required if you are
+ moving a database or table.
+ -toDatabase <arg> Database a moving table is going to.
+ This is required if you are moving a
+ table.
-upgradeSchema Schema upgrade
-upgradeSchemaFrom <upgradeFrom> Schema upgrade from a version
- -url <url> Connection url to the database
+ -url <url> connection url to the database
-userName <user> Override config file user name
- -verbose Only print SQL statements
-(Additional catalog related options added in Hive 3.0.0 (HIVE-19135] release are below.
- -createCatalog <catalog> Create catalog with given name
- -catalogLocation <location> Location of new catalog, required when adding a catalog
- -catalogDescription <description> Description of new catalog
- -ifNotExists If passed then it is not an error to create an existing catalog
- -moveDatabase <database> Move a database between catalogs. All tables under it would still be under it as part of new catalog. Argument is the database name. Requires --fromCatalog and --toCatalog parameters as well
- -moveTable <table> Move a table to a different database. Argument is the table name. Requires --fromCatalog, --toCatalog, --fromDatabase, and --toDatabase
- -toCatalog <catalog> Catalog a moving database or table is going to. This is required if you are moving a database or table.
- -fromCatalog <catalog> Catalog a moving database or table is coming from. This is required if you are moving a database or table.
- -toDatabase <database> Database a moving table is going to. This is required if you are moving a table.
- -fromDatabase <database> Database a moving table is coming from. This is required if you are moving a table.
-
+ -validate Validate the database
+ -verbose only print SQL statements
+ -yes Don't ask for confirmation when using
+ -dropAllDatabases.
</code></pre><p>The <strong>dbType</strong> is required and can be one of:</p>
-<pre tabindex=0><code> derby|mysql|postgres|oracle|mssql
-</code></pre><p>Version</p>
-<p>The dbType “<code>mssql</code>” was added in Hive 0.13.1 with <a href=https://issues.apache.org/jira/browse/HIVE-6862>HIVE-6862</a>.</p>
-<h3 id=usage-examples>Usage Examples</h3>
+<pre tabindex=0><code>derby|mysql|postgres|oracle|mssql|hive
+</code></pre><p>The dbType “<code>mssql</code>” was added in Hive 0.13.1 with <a href=https://issues.apache.org/jira/browse/HIVE-6862>HIVE-6862</a>.</p>
+<p>Note: dbType=hive only can be used on Hive sys schema. The others are metastore db types and in case of dbType=hive, it is mandatory to set metaDbType as well i.e.</p>
+<pre tabindex=0><code>schematool -dbType derby -initSchema
+schematool -dbType hive -initSchema -metaDbType derby
+</code></pre><h3 id=usage-examples>Usage Examples</h3>
<ul>
<li>Initialize to current schema for a new Hive setup:</li>
</ul>
<pre tabindex=0><code>$ schematool -dbType derby -initSchema
-Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
-Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver
-Metastore connection User: APP
-Starting metastore schema initialization to 0.13.0
-Initialization script hive-schema-0.13.0.derby.sql
-Initialization script completed
-schemaTool completed
+Initializing the schema to: 4.2.0
+2025-10-14 16:21:20,427 INFO schematool.HiveSchemaHelper: Metastore connection URL: jdbc:derby:metastore_db;create=true
+Metastore connection URL: jdbc:derby:metastore_db;create=true
+2025-10-14 16:21:20,427 INFO schematool.HiveSchemaHelper: Metastore connection Driver : org.apache.derby.iapi.jdbc.AutoloadedDriver
+Metastore connection Driver : org.apache.derby.iapi.jdbc.AutoloadedDriver
+2025-10-14 16:21:20,427 INFO schematool.HiveSchemaHelper: Metastore connection User: APP
+Metastore connection User: APP
+Starting metastore schema initialization to 4.2.0
+Initialization script hive-schema-4.2.0.derby.sql
+...
+Initialization script completed
</code></pre><ul>
<li>Get schema information:</li>
</ul>
<pre tabindex=0><code>$ schematool -dbType derby -info
-Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
-Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver
-Metastore connection User: APP
-Hive distribution version: 0.13.0
-Metastore schema version: 0.13.0
-schemaTool completed
+2025-10-14 16:29:13,116 INFO schematool.HiveSchemaHelper: Metastore connection URL: jdbc:derby:metastore_db;create=true
+Metastore connection URL: jdbc:derby:metastore_db;create=true
+2025-10-14 16:29:13,116 INFO schematool.HiveSchemaHelper: Metastore connection Driver : org.apache.derby.iapi.jdbc.AutoloadedDriver
+Metastore connection Driver : org.apache.derby.iapi.jdbc.AutoloadedDriver
+2025-10-14 16:29:13,116 INFO schematool.HiveSchemaHelper: Metastore connection User: APP
+Metastore connection User: APP
+Hive distribution version: 4.2.0
+Metastore schema version: 4.2.0
</code></pre><ul>
-<li>Attempt to get schema information with older metastore:</li>
+<li>Init schema to for a given version:</li>
</ul>
-<pre tabindex=0><code>$ schematool -dbType derby -info
-Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
-Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver
-Metastore connection User: APP
-Hive distribution version: 0.13.0
-org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
-*** schemaTool failed ***
+<pre tabindex=0><code>$ schematool -dbType derby -initSchemaTo 3.1.0
-</code></pre><p>Since the older metastore doesn’t store the version information, the tool reports an error retrieving it.</p>
-<ul>
-<li>Upgrade schema from an 0.10.0 release by specifying the ‘from’ version:</li>
+2025-10-14 16:37:11,089 INFO schematool.HiveSchemaHelper: Metastore connection URL: jdbc:derby:metastore_db;create=true
+Metastore connection URL: jdbc:derby:metastore_db;create=true
+2025-10-14 16:37:11,089 INFO schematool.HiveSchemaHelper: Metastore connection Driver : org.apache.derby.iapi.jdbc.AutoloadedDriver
+Metastore connection Driver : org.apache.derby.iapi.jdbc.AutoloadedDriver
+2025-10-14 16:37:11,089 INFO schematool.HiveSchemaHelper: Metastore connection User: APP
+Metastore connection User: APP
+Starting metastore schema initialization to 3.1.0
+Initialization script hive-schema-3.1.0.derby.sql
+...
+Initialization script completed
+</code></pre><ul>
+<li>Upgrade schema from an 3.1.0 release by specifying the ‘from’ version:</li>
</ul>
-<pre tabindex=0><code>$ schematool -dbType derby -upgradeSchemaFrom 0.10.0
-Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true
-Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver
-Metastore connection User: APP
-Starting upgrade metastore schema from version 0.10.0 to 0.13.0
-Upgrade script upgrade-0.10.0-to-0.11.0.derby.sql
-Completed upgrade-0.10.0-to-0.11.0.derby.sql
-Upgrade script upgrade-0.11.0-to-0.12.0.derby.sql
-Completed upgrade-0.11.0-to-0.12.0.derby.sql
-Upgrade script upgrade-0.12.0-to-0.13.0.derby.sql
-Completed upgrade-0.12.0-to-0.13.0.derby.sql
-schemaTool completed
+<pre tabindex=0><code>$ schematool -dbType derby -upgradeSchemaFrom 3.1.0
+Upgrading from the user input version 3.1.0
+2025-10-14 16:41:04,018 INFO schematool.HiveSchemaHelper: Metastore connection URL: jdbc:derby:metastore_db;create=true
+Metastore connection URL: jdbc:derby:metastore_db;create=true
+2025-10-14 16:41:04,018 INFO schematool.HiveSchemaHelper: Metastore connection Driver : org.apache.derby.iapi.jdbc.AutoloadedDriver
+Metastore connection Driver : org.apache.derby.iapi.jdbc.AutoloadedDriver
+2025-10-14 16:41:04,018 INFO schematool.HiveSchemaHelper: Metastore connection User: APP
+Metastore connection User: APP
+Starting upgrade metastore schema from version 3.1.0 to 4.2.0
+Upgrade script upgrade-3.1.0-to-3.2.0.derby.sql
+2025-10-14 16:41:04,142 INFO conf.HiveConf: Found configuration file file:/Users/raghav/Desktop/setup/hive/conf/hive-site.xml
+2025-10-14 16:41:04,143 INFO conf.HiveConf: Found configuration file null
+2025-10-14 16:41:04,143 INFO conf.HiveConf: Found configuration file null
+2025-10-14 16:41:04,143 INFO conf.HiveConf: Found configuration file null
+2025-10-14 16:41:04,173 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
+Completed upgrade-3.1.0-to-3.2.0.derby.sql
+Upgrade script upgrade-3.2.0-to-4.0.0-alpha-1.derby.sql
+Completed upgrade-3.2.0-to-4.0.0-alpha-1.derby.sql
+Upgrade script upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.derby.sql
+Completed upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.derby.sql
+Upgrade script upgrade-4.0.0-alpha-2-to-4.0.0-beta-1.derby.sql
+Completed upgrade-4.0.0-alpha-2-to-4.0.0-beta-1.derby.sql
+Upgrade script upgrade-4.0.0-beta-1-to-4.0.0.derby.sql
+Completed upgrade-4.0.0-beta-1-to-4.0.0.derby.sql
+Upgrade script upgrade-4.0.0-to-4.1.0.derby.sql
+Completed upgrade-4.0.0-to-4.1.0.derby.sql
+Upgrade script upgrade-4.1.0-to-4.2.0.derby.sql
+Completed upgrade-4.1.0-to-4.2.0.derby.sql
</code></pre><ul>
<li>Upgrade dry run can be used to list the required scripts for the given upgrade.</li>
</ul>
-<pre tabindex=0><code>$ build/dist/bin/schematool -dbType derby -upgradeSchemaFrom 0.7.0 -dryRun
-Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver
-Metastore connection User: APP
-Starting upgrade metastore schema from version 0.7.0 to 0.13.0
-Upgrade script upgrade-0.7.0-to-0.8.0.derby.sql
-Upgrade script upgrade-0.8.0-to-0.9.0.derby.sql
-Upgrade script upgrade-0.9.0-to-0.10.0.derby.sql
-Upgrade script upgrade-0.10.0-to-0.11.0.derby.sql
-Upgrade script upgrade-0.11.0-to-0.12.0.derby.sql
-Upgrade script upgrade-0.12.0-to-0.13.0.derby.sql
-schemaTool completed
+<pre tabindex=0><code>$ schematool -dbType derby -upgradeSchemaFrom 3.1.0 -dryRun
+Upgrading from the user input version 3.1.0
+2025-10-14 16:43:16,211 INFO schematool.HiveSchemaHelper: Metastore connection URL: jdbc:derby:metastore_db;create=true
+Metastore connection URL: jdbc:derby:metastore_db;create=true
+2025-10-14 16:43:16,211 INFO schematool.HiveSchemaHelper: Metastore connection Driver : org.apache.derby.iapi.jdbc.AutoloadedDriver
+Metastore connection Driver : org.apache.derby.iapi.jdbc.AutoloadedDriver
+2025-10-14 16:43:16,211 INFO schematool.HiveSchemaHelper: Metastore connection User: APP
+Metastore connection User: APP
+Starting upgrade metastore schema from version 3.1.0 to 4.2.0
+Upgrade script upgrade-3.1.0-to-3.2.0.derby.sql
+Upgrade script upgrade-3.2.0-to-4.0.0-alpha-1.derby.sql
+Upgrade script upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.derby.sql
+Upgrade script upgrade-4.0.0-alpha-2-to-4.0.0-beta-1.derby.sql
+Upgrade script upgrade-4.0.0-beta-1-to-4.0.0.derby.sql
+Upgrade script upgrade-4.0.0-to-4.1.0.derby.sql
+Upgrade script upgrade-4.1.0-to-4.2.0.derby.sql
</code></pre><p>This is useful if you just want to find out all the required scripts for the schema upgrade.</p>
<ul>
<li>Moving a database and tables under it from default Hive catalog to a custom spark catalog</li>
</ul>
<pre tabindex=0><code>build/dist/bin/schematool -moveDatabase db1 -fromCatalog hive -toCatalog spark
-
</code></pre><ul>
<li>Moving a table from Hive catalog to Spark Catalog</li>
</ul>
@@ -317,7 +397,6 @@ schematool -moveDatabase newdb -fromCatalog hive -toCatalog spark
# Now move the table to target db under the spark catalog.
schematool -moveTable table1 -fromCatalog hive -toCatalog spark -fromDatabase db1 -toDatabase newdb
-
</code></pre>
</div>
<footer class=docs-footer>
@@ -347,6 +426,7 @@ schematool -moveTable table1 -fromCatalog hive -toCatalog spark -fromDatabase d
<ul>
<li><a href=#apache-hive--hive-schema-tool>Apache Hive : Hive Schema Tool</a>
<ul>
+<li><a href=#about>About</a></li>
<li><a href=#metastore-schema-verification>Metastore Schema Verification</a></li>
<li><a href=#the-hive-schema-tool>The Hive Schema Tool</a>
<ul>
diff --git a/docs/latest/admin/index.html b/docs/latest/admin/index.html
index 86ff74d..7f1be52 100644
--- a/docs/latest/admin/index.html
+++ b/docs/latest/admin/index.html
@@ -140,7 +140,7 @@ ASF
<div class=docs-meta>
<span class=docs-count>
<i class="fas fa-file-alt"></i>
-22 documents
+21 documents
</span>
</div>
</header>
@@ -148,6 +148,25 @@ ASF
<div class=docs-grid>
<div class=docs-card>
<div class=docs-card-header>
+<h3><a href=https://hive.apache.org/docs/latest/admin/hive-schema-tool/>Apache Hive : Hive Schema Tool</a></h3>
+<span class=docs-card-date>
+<i class="fas fa-calendar-alt"></i>
+Oct 14, 2025
+</span>
+</div>
+<div class=docs-card-summary>
+Apache Hive : Hive Schema Tool Apache Hive : Hive Schema Tool About Metastore Schema Verification The Hive Schema Tool The schematool Command Usage Examples About Schema tool helps to initialise and upgrade metastore database and hive sys schema.
+Metastore Schema Verification Introduced in Hive 0.12.0. See HIVE-3764.
+Hive records the schema version in the metastore database and verifies that the metastore schema version is compatible with Hive binaries that are going to access the metastore.
+</div>
+<div class=docs-card-footer>
+<a href=https://hive.apache.org/docs/latest/admin/hive-schema-tool/ class=docs-card-link>
+Read more <i class="fas fa-arrow-right"></i>
+</a>
+</div>
+</div>
+<div class=docs-card>
+<div class=docs-card-header>
<h3><a href=https://hive.apache.org/docs/latest/admin/oauth2/>Apache Hive : Setting Up OAuth 2</a></h3>
<span class=docs-card-date>
<i class="fas fa-calendar-alt"></i>
@@ -270,23 +289,6 @@ Read more <i class="fas fa-arrow-right"></i>
</div>
<div class=docs-card>
<div class=docs-card-header>
-<h3><a href=https://hive.apache.org/docs/latest/admin/copy-of-hive-schema-tool/>Apache Hive : Copy of Hive Schema Tool - [TODO: move it under a 4.0 admin manual page, find a proper name]</a></h3>
-<span class=docs-card-date>
-<i class="fas fa-calendar-alt"></i>
-Dec 12, 2024
-</span>
-</div>
-<div class=docs-card-summary>
-Apache Hive : Copy of Hive Schema Tool - [TODO: move it under a 4.0 admin manual page, find a proper name] Apache Hive : Copy of Hive Schema Tool - [TODO: move it under a 4.0 admin manual page, find a proper name] About Metastore Schema Verification The Hive Schema Tool The schematool Command Usage Examples About Schema tool helps to initialise and upgrade metastore database and hive sys schema.
-</div>
-<div class=docs-card-footer>
-<a href=https://hive.apache.org/docs/latest/admin/copy-of-hive-schema-tool/ class=docs-card-link>
-Read more <i class="fas fa-arrow-right"></i>
-</a>
-</div>
-</div>
-<div class=docs-card>
-<div class=docs-card-header>
<h3><a href=https://hive.apache.org/docs/latest/admin/hive-metatool/>Apache Hive : Hive MetaTool</a></h3>
<span class=docs-card-date>
<i class="fas fa-calendar-alt"></i>
@@ -325,25 +327,6 @@ Read more <i class="fas fa-arrow-right"></i>
</div>
<div class=docs-card>
<div class=docs-card-header>
-<h3><a href=https://hive.apache.org/docs/latest/admin/hive-schema-tool/>Apache Hive : Hive Schema Tool</a></h3>
-<span class=docs-card-date>
-<i class="fas fa-calendar-alt"></i>
-Dec 12, 2024
-</span>
-</div>
-<div class=docs-card-summary>
-Apache Hive : Hive Schema Tool Apache Hive : Hive Schema Tool Metastore Schema Verification The Hive Schema Tool The schematool Command Usage Examples Metastore Schema Verification Version
-Introduced in Hive 0.12.0. See HIVE-3764.
-Hive now records the schema version in the metastore database and verifies that the metastore schema version is compatible with Hive binaries that are going to accesss the metastore.
-</div>
-<div class=docs-card-footer>
-<a href=https://hive.apache.org/docs/latest/admin/hive-schema-tool/ class=docs-card-link>
-Read more <i class="fas fa-arrow-right"></i>
-</a>
-</div>
-</div>
-<div class=docs-card>
-<div class=docs-card-header>
<h3><a href=https://hive.apache.org/docs/latest/admin/hiveamazonelasticmapreduce/>Apache Hive : HiveAmazonElasticMapReduce</a></h3>
<span class=docs-card-date>
<i class="fas fa-calendar-alt"></i>
diff --git a/docs/latest/admin/index.xml b/docs/latest/admin/index.xml
index 17201a0..1040356 100644
--- a/docs/latest/admin/index.xml
+++ b/docs/latest/admin/index.xml
@@ -1,11 +1,11 @@
-<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom"><channel><title>Administration Manual on Hive Site</title><link>https://hive.apache.org/docs/latest/admin/</link><description>Recent content in Administration Manual on Hive Site</description><generator>Hugo -- gohugo.io</generator><language>en-us</language><lastBuildDate>Thu, 24 Jul 2025 00:00:00 +0000</lastBuildDate><atom:link href="https://hive.apache.org/docs/latest/admi [...]
-Apache Hive : AdminManual Metastore Administration Introduction Local/Embedded Metastore Database (Derby) Remote Metastore Database Local/Embedded Metastore Server Remote Metastore Server Supported Backend Databases for Metastore Metastore Schema Consistency and Upgrades Introduction All the metadata for Hive tables and partitions are accessed through the Hive Metastore.</description></item><item><title>Apache Hive : AdminManual SettingUpHiveServer</title><link>https://hive.apache.org/do [...]
+<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom"><channel><title>Administration Manual on Hive Site</title><link>https://hive.apache.org/docs/latest/admin/</link><description>Recent content in Administration Manual on Hive Site</description><generator>Hugo -- gohugo.io</generator><language>en-us</language><lastBuildDate>Thu, 24 Jul 2025 00:00:00 +0000</lastBuildDate><atom:link href="https://hive.apache.org/docs/latest/admi [...]
+Metastore Schema Verification Introduced in Hive 0.12.0. See HIVE-3764.
+Hive records the schema version in the metastore database and verifies that the metastore schema version is compatible with Hive binaries that are going to access the metastore.</description></item><item><title>Apache Hive : AdminManual</title><link>https://hive.apache.org/docs/latest/admin/adminmanual/</link><pubDate>Thu, 12 Dec 2024 00:00:00 +0000</pubDate><guid>https://hive.apache.org/docs/latest/admin/adminmanual/</guid><description>Apache Hive : AdminManual Hive Administrator&rs [...]
+Apache Hive : AdminManual Metastore Administration Introduction Local/Embedded Metastore Database (Derby) Remote Metastore Database Local/Embedded Metastore Server Remote Metastore Server Supported Backend Databases for Metastore Metastore Schema Consistency and Upgrades Introduction All the metadata for Hive tables and partitions are accessed through the Hive Metastore.</description></item><item><title>Apache Hive : AdminManual SettingUpHiveServer</title><link>https://hive.apache.org/do [...]
The Hive MetaTool enables administrators to do bulk updates on the location fields in database, table, and partition records in the metastore. It provides the following functionality:
Ability to search and replace the HDFS NN (NameNode) location in metastore records that reference the NN. One use is to transition a Hive deployment to HDFS HA NN (HDFS High Availability NameNode).</description></item><item><title>Apache Hive : Hive on Spark: Getting Started</title><link>https://hive.apache.org/docs/latest/admin/hive-on-spark-getting-started/</link><pubDate>Thu, 12 Dec 2024 00:00:00 +0000</pubDate><guid>https://hive.apache.org/docs/latest/admin/hive-on-spark-getting-star [...]
set hive.execution.engine=spark; Hive on Spark was added in HIVE-7292.
-Apache Hive : Hive on Spark: Getting Started Version Compatibility Spark Installation Configuring YARN Configuring Hive Configuration property details Configuring Spark Tuning Details Common Issues (Green are resolved, will be removed from this list) Recommended Configuration Design documents Attachments: Version Compatibility Hive on Spark is only tested with a specific version of Spark, so a given version of Hive is only guaranteed to work with a specific version of Spark.</description [...]
-Introduced in Hive 0.12.0. See HIVE-3764.
-Hive now records the schema version in the metastore database and verifies that the metastore schema version is compatible with Hive binaries that are going to accesss the metastore.</description></item><item><title>Apache Hive : HiveAmazonElasticMapReduce</title><link>https://hive.apache.org/docs/latest/admin/hiveamazonelasticmapreduce/</link><pubDate>Thu, 12 Dec 2024 00:00:00 +0000</pubDate><guid>https://hive.apache.org/docs/latest/admin/hiveamazonelasticmapreduce/</guid><description>A [...]
+Apache Hive : Hive on Spark: Getting Started Version Compatibility Spark Installation Configuring YARN Configuring Hive Configuration property details Configuring Spark Tuning Details Common Issues (Green are resolved, will be removed from this list) Recommended Configuration Design documents Attachments: Version Compatibility Hive on Spark is only tested with a specific version of Spark, so a given version of Hive is only guaranteed to work with a specific version of Spark.</description [...]
Background This document explores the different ways of leveraging Hive on Amazon Web Services - namely S3, EC2 and Elastic Map-Reduce.
Hadoop already has a long tradition of being run on EC2 and S3. These are well documented in the links below which are a must read:
Hadoop and S3 Amazon and EC2 The second document also has pointers on how to get started using EC2 and S3.</description></item><item><title>Apache Hive : HiveDerbyServerMode</title><link>https://hive.apache.org/docs/latest/admin/hivederbyservermode/</link><pubDate>Thu, 12 Dec 2024 00:00:00 +0000</pubDate><guid>https://hive.apache.org/docs/latest/admin/hivederbyservermode/</guid><description>Apache Hive : Using Derby in Server Mode Hive in embedded mode has a limitation of one active user [...]
diff --git a/docs/latest/user/configuration-properties/index.html b/docs/latest/user/configuration-properties/index.html
index 1da9d8e..cb48326 100644
--- a/docs/latest/user/configuration-properties/index.html
+++ b/docs/latest/user/configuration-properties/index.html
@@ -2015,7 +2015,7 @@ NOTE: This property will influence how HBase files using the AvroSerDe and times
<p>JDBC connect string for a JDBC metastore.</p>
<h5 id=javaxjdooptionconnectiondrivername>javax.jdo.option.ConnectionDriverName</h5>
<ul>
-<li>Default Value: <code>org.apache.derby.jdbc.EmbeddedDriver</code></li>
+<li>Default Value: <code>org.apache.derby.iapi.jdbc.AutoloadedDriver</code></li>
<li>Added In: Hive 0.8.1</li>
</ul>
<p>Driver class name for a JDBC metastore.</p>
@@ -3982,12 +3982,6 @@ Caution: Rebuilding indexes can be a lengthy and computationally expensive opera
<li>Added In: <a href=https://issues.apache.org/jira/browse/HIVE-13566>Hive 2.1</a></li>
</ul>
<p>Extends statistics autogathering to also collect column level statistics.</p>
-<h5 id=hivestatsjdbcdriver>hive.stats.jdbcdriver</h5>
-<ul>
-<li>Default Value: <code>org.apache.derby.jdbc.EmbeddedDriver</code></li>
-<li>Added In: Hive 0.7 with <a href=https://issues.apache.org/jira/browse/HIVE-1361>HIVE-1361</a></li>
-</ul>
-<p>The JDBC driver for the database that stores temporary Hive statistics.</p>
<h5 id=hivestatsdbconnectionstring>hive.stats.dbconnectionstring</h5>
<ul>
<li>Default Value: <code>jdbc:derby:;databaseName=TempStatsStore;create=true</code></li>
diff --git a/index.json b/index.json
index ba992b5..9a91796 100644
--- a/index.json
+++ b/index.json
@@ -1 +1 @@
-[{"categories":null,"contents":"Apache Hive : Setting Up OAuth 2 with Keycloak Keycloak Settings 1. Register Hive Metastore as a Resource Server Browse Manage -\u0026gt; Clients -\u0026gt; Create client, and create a client for HMS, as an OAuth 2 resource server. This example useshive-metastore as a client ID. You can access the client secret in the Credentials tab.\n2. Define the \u0026ldquo;catalog\u0026rdquo; scope Iceberg REST Catalog uses \u0026ldquo;catalog\u0026rdquo; as the defau [...]
\ No newline at end of file
+[{"categories":null,"contents":"Apache Hive : Hive Schema Tool Apache Hive : Hive Schema Tool About Metastore Schema Verification The Hive Schema Tool The schematool Command Usage Examples About Schema tool helps to initialise and upgrade metastore database and hive sys schema.\nMetastore Schema Verification Introduced in Hive 0.12.0. See HIVE-3764.\nHive records the schema version in the metastore database and verifies that the metastore schema version is compatible with Hive [...]
\ No newline at end of file
diff --git a/index.xml b/index.xml
index 5cd6359..5ddfbc2 100644
--- a/index.xml
+++ b/index.xml
@@ -1,4 +1,6 @@
-<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom"><channel><title>Apache Hive on Hive Site</title><link>https://hive.apache.org/</link><description>Recent content in Apache Hive on Hive Site</description><generator>Hugo -- gohugo.io</generator><language>en-us</language><lastBuildDate>Fri, 27 Jan 2023 19:16:15 +0530</lastBuildDate><atom:link href="https://hive.apache.org/index.xml" rel="self" type="application/rss+xml"/><ite [...]
+<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom"><channel><title>Apache Hive on Hive Site</title><link>https://hive.apache.org/</link><description>Recent content in Apache Hive on Hive Site</description><generator>Hugo -- gohugo.io</generator><language>en-us</language><lastBuildDate>Fri, 27 Jan 2023 19:16:15 +0530</lastBuildDate><atom:link href="https://hive.apache.org/index.xml" rel="self" type="application/rss+xml"/><ite [...]
+Metastore Schema Verification Introduced in Hive 0.12.0. See HIVE-3764.
+Hive records the schema version in the metastore database and verifies that the metastore schema version is compatible with Hive binaries that are going to access the metastore.</description></item><item><title>Apache Hive : Setting Up OAuth 2 with Keycloak</title><link>https://hive.apache.org/docs/latest/admin/oauth2/keycloak/</link><pubDate>Tue, 30 Sep 2025 00:00:00 +0000</pubDate><guid>https://hive.apache.org/docs/latest/admin/oauth2/keycloak/</guid><description>Apache Hive : Setting [...]
2. Define the &ldquo;catalog&rdquo; scope Iceberg REST Catalog uses &ldquo;catalog&rdquo; as the default scope name.</description></item><item><title>Capture Lineage Information In Hive Hooks</title><link>https://hive.apache.org/docs/latest/user/capture-lineage-info/</link><pubDate>Tue, 29 Jul 2025 00:00:00 +0000</pubDate><guid>https://hive.apache.org/docs/latest/user/capture-lineage-info/</guid><description>Background In Hive, lineage information is captured in the form [...]
Existing Hooks org.apache.hadoop.hive.ql.hooks.PostExecutePrinter org.apache.hadoop.hive.ql.hooks.LineageLogger org.apache.atlas.hive.hook.HiveHook To facilitate the capture of lineage information in a custom hook or in a use case where the existing hooks are not set in hive.</description></item><item><title>Query File Test(qtest)</title><link>https://hive.apache.org/development/qtest/</link><pubDate>Fri, 28 Mar 2025 00:00:00 +0000</pubDate><guid>https://hive.apache.org/development/qtest [...]
Query File Test(qtest) Tutorial: How to run a specific test case Preparation Run a test case Tutorial: How to add a new test case Add a QFile Generate a result file Verify the new result file Commandline options Test options Test Iceberg, Accumulo, or Kudu QTestOptionHandler: pre/post-processor Using test data Mask non-deterministic outputs Advanced Locations of log files Negative tests How to specify drivers How to use PostgreSQL/MySQL/Oracle as a backend database for Hive Metastore Rem [...]
@@ -30,7 +32,7 @@ Carl asked for more details about the impact of HIVE-2795 on the upgrade process
Location: Cloudera (Palo Alto)
Attendees: http://www.meetup.com/Hive-Contributors-Group/events/26345541/
Carl proposed end of August as target for 0.8 release, with branch cut in a couple of weeks. Work is still underway for publishing release artifacts in Maven for 0.7.1 and 0.8 (development snapshots are already being published).
-Ashutosh gave an update on HCatalog development status; no blocking issues from Hive for the 0.2 release; some ideas are being discussed for the 0.</description></item><item><title>Apache Hive : Copy of Hive Schema Tool - [TODO: move it under a 4.0 admin manual page, find a proper name]</title><link>https://hive.apache.org/docs/latest/admin/copy-of-hive-schema-tool/</link><pubDate>Thu, 12 Dec 2024 00:00:00 +0000</pubDate><guid>https://hive.apache.org/docs/latest/admin/copy-of-hive-schema [...]
+Ashutosh gave an update on HCatalog development status; no blocking issues from Hive for the 0.2 release; some ideas are being discussed for the 0.</description></item><item><title>Apache Hive : Correlation Optimizer</title><link>https://hive.apache.org/development/desingdocs/correlation-optimizer/</link><pubDate>Thu, 12 Dec 2024 00:00:00 +0000</pubDate><guid>https://hive.apache.org/development/desingdocs/correlation-optimizer/</guid><description>Apache Hive : Correlation Optimizer This [...]
set hive.optimize.correlation=true; 1. Overview In Hadoop environments, an SQL query submitted to Hive will be evaluated in distributed systems. Thus, after generating a query operator tree representing the submitted SQL query, Hive needs to determine what operations can be executed in a task which will be evalauted in a single node.</description></item><item><title>Apache Hive : Cost-based optimization in Hive</title><link>https://hive.apache.org/docs/latest/user/cost-based-optimization [...]
The CSVSerde is available in Hive 0.14 and greater.
Background The CSV SerDe is based on https://github.com/ogrodnek/csv-serde, and was added to the Hive distribution in HIVE-7777.
@@ -105,9 +107,7 @@ Ability to search and replace the HDFS NN (NameNode) location in metastore recor
The metrics dump will display any metric available over JMX encoded in JSON: Alternatively the metrics can be written directly into HDFS, a JSON file on the local file system where the HS2 instance is running or to the console by enabling the corresponding metric reporters. By default only the JMX and the JSON file reporter are enabled.</description></item><item><title>Apache Hive : Hive on Spark</title><link>https://hive.apache.org/docs/latest/user/hive-on-spark/</link><pubDate>Thu, 12 [...]
set hive.execution.engine=spark; Hive on Spark was added in HIVE-7292.
Apache Hive : Hive on Spark: Getting Started Version Compatibility Spark Installation Configuring YARN Configuring Hive Configuration property details Configuring Spark Tuning Details Common Issues (Green are resolved, will be removed from this list) Recommended Configuration Design documents Attachments: Version Compatibility Hive on Spark is only tested with a specific version of Spark, so a given version of Hive is only guaranteed to work with a specific version of Spark.</description [...]
-We believe that this type of functionality will be of increasing importance as Hadoop and Hive workloads migrate to the cloud.</description></item><item><title>Apache Hive : Hive Schema Tool</title><link>https://hive.apache.org/docs/latest/admin/hive-schema-tool/</link><pubDate>Thu, 12 Dec 2024 00:00:00 +0000</pubDate><guid>https://hive.apache.org/docs/latest/admin/hive-schema-tool/</guid><description>Apache Hive : Hive Schema Tool Apache Hive : Hive Schema Tool Metastore Schema Verifica [...]
-Introduced in Hive 0.12.0. See HIVE-3764.
-Hive now records the schema version in the metastore database and verifies that the metastore schema version is compatible with Hive binaries that are going to accesss the metastore.</description></item><item><title>Apache Hive : Hive Transactions</title><link>https://hive.apache.org/docs/latest/user/hive-transactions/</link><pubDate>Thu, 12 Dec 2024 00:00:00 +0000</pubDate><guid>https://hive.apache.org/docs/latest/user/hive-transactions/</guid><description>Apache Hive : ACID Transaction [...]
+We believe that this type of functionality will be of increasing importance as Hadoop and Hive workloads migrate to the cloud.</description></item><item><title>Apache Hive : Hive Transactions</title><link>https://hive.apache.org/docs/latest/user/hive-transactions/</link><pubDate>Thu, 12 Dec 2024 00:00:00 +0000</pubDate><guid>https://hive.apache.org/docs/latest/user/hive-transactions/</guid><description>Apache Hive : ACID Transactions Apache Hive : ACID Transactions Upgrade to Hive 3+ Wha [...]
Creating an Iceberg Table
An iceberg table can be created using STORED BY ICEBERG keywords while creating a table.
Creating an Iceberg table using normal create command CREATE TABLE TBL_ICE (ID INT) STORED BY ICEBERG; The above creates an iceberg table named &lsquo;TBL_ICE&rsquo;</description></item><item><title>Apache Hive : Hive-Tez Compatibility</title><link>https://hive.apache.org/development/desingdocs/hive-tez-compatibility/</link><pubDate>Thu, 12 Dec 2024 00:00:00 +0000</pubDate><guid>https://hive.apache.org/development/desingdocs/hive-tez-compatibility/</guid><description>Apache Hive [...]
diff --git a/sitemap.xml b/sitemap.xml
index 9d625ce..b7954c2 100644
--- a/sitemap.xml
+++ b/sitemap.xml
@@ -1 +1 @@
-<?xml version="1.0" encoding="utf-8" standalone="yes"?><urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xhtml="http://www.w3.org/1999/xhtml"><url><loc>https://hive.apache.org/docs/latest/admin/oauth2/</loc><lastmod>2025-09-30T00:00:00+00:00</lastmod></url><url><loc>https://hive.apache.org/docs/latest/admin/oauth2/keycloak/</loc><lastmod>2025-09-30T00:00:00+00:00</lastmod></url><url><loc>https://hive.apache.org/docs/</loc><lastmod>2025-09-30T00:00:00+00:00</lastmod></url> [...]
\ No newline at end of file
+<?xml version="1.0" encoding="utf-8" standalone="yes"?><urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xhtml="http://www.w3.org/1999/xhtml"><url><loc>https://hive.apache.org/docs/latest/admin/hive-schema-tool/</loc><lastmod>2025-10-14T00:00:00+00:00</lastmod></url><url><loc>https://hive.apache.org/docs/</loc><lastmod>2025-10-14T00:00:00+00:00</lastmod></url><url><loc>https://hive.apache.org/docs/latest/admin/oauth2/</loc><lastmod>2025-09-30T00:00:00+00:00</lastmod></url [...]
\ No newline at end of file