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 <[email protected]>
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
