This is an automated email from the ASF dual-hosted git repository.
github-actions[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 384c0464 deploy: eec8aabf46963144f7500955ae33621b6f93f6cd
384c0464 is described below
commit 384c04642f82cc51d99f557f977070b7ba125a8a
Author: zabetak <[email protected]>
AuthorDate: Thu Aug 20 09:59:10 2026 +0000
deploy: eec8aabf46963144f7500955ae33621b6f93f6cd
---
community/resources/howtorelease/index.html | 11 +++--
development/index.xml | 19 ++------
development/quickstart/index.html | 74 ++++++++++++++---------------
index.json | 2 +-
index.xml | 19 ++------
5 files changed, 52 insertions(+), 73 deletions(-)
diff --git a/community/resources/howtorelease/index.html
b/community/resources/howtorelease/index.html
index c9139d19..c8b263d1 100644
--- a/community/resources/howtorelease/index.html
+++ b/community/resources/howtorelease/index.html
@@ -201,11 +201,12 @@ cp -r <hive_source_dir>/target/site/apidocs
./rX.Y.Z/api
svn add rX.Y.Z
svn commit -m "Hive X.Y.Z javadocs"
</code></pre><p>If this is a bugfix release, svn rm the obsoleted version.
(For eg., when committing javadocs for r0.13.1, r0.13.0 would have been
removed)</p><ol start=7><li>Prepare to edit the website.</li></ol><pre
tabindex=0><code>git clone https://github.com/apache/hive-site.git
-</code></pre><ol start=8><li>Edit files content/downloads.mdtext and
javadoc.mdtext to appropriately add entries for the new release in the
appropriate location. For example, for 1.2.0, the entries made were as
follows:</li></ol><pre tabindex=0><code>./downloads.md:### 18 May 2015 :
release 1.2.0 available
-./downloads.md:You can look at the complete [JIRA change log for this
release][HIVE_1_2_0_CL].
-./downloads.md:[HIVE_1_2_0_CL]:
https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12329345&styleName=Text&projectId=12310843
-./javadoc.md: * [Hive 1.2.0 Javadocs][r1.2.0]
-./javadoc.md:[r1.2.0]: /javadocs/r1.2.0/api/index.html
+</code></pre><ol start=8><li>Edit some files to appropriately add entries for
the new release in the appropriate location. For example, for 1.2.0, the
entries made were as follows:</li></ol><pre
tabindex=0><code>./content/general/downloads.md:### 18 May 2015 : release 1.2.0
available
+./content/general/downloads.md:You can look at the complete [JIRA change log
for this release][HIVE_1_2_0_CL].
+./content/general/downloads.md:[HIVE_1_2_0_CL]:
https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12329345&styleName=Text&projectId=12310843
+./content/docs/javadocs.md: * [Hive 1.2.0 Javadocs][r1.2.0]
+./content/docs/javadocs.md:[r1.2.0]: /javadocs/r1.2.0/api/index.html
+./config.toml: version = "1.2.0" (under [params.release])
</code></pre><p>As you can see, you will need a release note link for this
release as created previously for this section.</p><ol start=9><li>Push your
changes to the <a
href=https://github.com/apache/hive-site/tree/gh-pages>https://github.com/apache/hive-site/tree/gh-pages</a>
branch, and you can preview the results at <a
href=https://apache.github.io/hive-site/>https://apache.github.io/hive-site/</a>.
If everything is ok, then you can push your changes to <a
href=https://github.com/apa [...]
To: [email protected], [email protected], [email protected]
Subject: [ANNOUNCE] Apache Hive X.Y.Z Released
diff --git a/development/index.xml b/development/index.xml
index 60b434ef..40c8031c 100644
--- a/development/index.xml
+++ b/development/index.xml
@@ -26,20 +26,11 @@ Hive versions up to 0.13 also supported Hadoop 0.20.x,
0.23.x.</li>
<h3 id="quickstart">Quickstart</h3>
<hr>
<h5 id="step-1-pull-the-image"><strong>STEP 1: Pull the
image</strong></h5>
-<ul>
-<li>Pull the image from DockerHub: <a
href="https://hub.docker.com/r/apache/hive/tags">https://hub.docker.com/r/apache/hive/tags</a>.
Here are the latest images:
-<ul>
-<li>4.0.0</li>
-<li>3.1.3</li>
-</ul>
-</li>
-</ul>
-<div class="highlight"><pre tabindex="0"
style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none;"><code
class="language-shell" data-lang="shell"><span
style="display:flex;"><span>docker pull apache/hive:4.0.0
-</span></span></code></pre></div><p><code>
</code></p>
-<h5 id="step-2-export-the-hive-version"><strong>STEP 2: Export the
Hive version</strong></h5>
-<div class="highlight"><pre tabindex="0"
style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none;"><code
class="language-shell" data-lang="shell"><span
style="display:flex;"><span>export HIVE_VERSION<span
style="color:#f92672">=</span>4.0.0
-</span></span></code></pre></div><p><code>
</code></p>
-<h5
id="step-3--launch-the-hiveserver2-with-an-embedded-metastore"><strong>STEP
3: Launch the HiveServer2 with an embedded Metastore.</strong></h5>
+<p>Pull the image from DockerHub: <a
href="https://hub.docker.com/r/apache/hive/tags">https://hub.docker.com/r/apache/hive/tags</a>.
The latest image tag is <code>4.2.0</code>.</p>
+<div class="highlight"><pre tabindex="0"
style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none;"><code
class="language-shell" data-lang="shell"><span
style="display:flex;"><span>docker pull apache/hive:4.2.0
+</span></span></code></pre></div><h5
id="step-2-export-the-hive-version"><strong>STEP 2: Export the Hive
version</strong></h5>
+<div class="highlight"><pre tabindex="0"
style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none;"><code
class="language-shell" data-lang="shell"><span
style="display:flex;"><span>export HIVE_VERSION<span
style="color:#f92672">=</span>4.2.0
+</span></span></code></pre></div><h5
id="step-3--launch-the-hiveserver2-with-an-embedded-metastore"><strong>STEP
3: Launch the HiveServer2 with an embedded Metastore.</strong></h5>
<p>This is lightweight and for a quick setup, it uses Derby as metastore
db.</p></description></item><item><title>Getting
Started</title><link>https://hive.apache.org/development/gettingstarted/</link><pubDate>Tue,
10 Jan 2023 12:35:11
+0530</pubDate><guid>https://hive.apache.org/development/gettingstarted/</guid><description><p>The
Apache Hive ™ data warehouse software facilitates reading,
writing, and managing large datasets residing in distributed storage
using SQL. Structure can be projected onto data already in storage.
diff --git a/development/quickstart/index.html
b/development/quickstart/index.html
index 2fd6dc26..85c58405 100644
--- a/development/quickstart/index.html
+++ b/development/quickstart/index.html
@@ -3,51 +3,48 @@
<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-it [...]
<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>QuickStarted</li></ol></nav><header class=docs-header><h1
class=docs-title>QuickStarted</h1><div class=docs-meta><span class=docs-date><i
class=" [...]
-Last updated: May 12, 2023</span></div></header><div class=docs-toc><h4><i
class="fas fa-list"></i> Table of Contents</h4><nav
id=TableOfContents><ul><li><ul><li><ul><li><a
href=#introduction>Introduction</a></li><li><a
href=#quickstart>Quickstart</a></li></ul></li><li><a
href=#detailed-setup>Detailed Setup</a><ul><li></li><li><a
href=#run-services>Run services</a></li><li><a href=#usage>Usage</a></li><li><a
href=#quick-start-with-rest-catalog-integration>Quick Start with REST Catalog
In [...]
-</span></span></code></pre></div><p><code></code></p><h5
id=step-2-export-the-hive-version><strong>STEP 2: Export the Hive
version</strong></h5><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>export
HIVE_VERSION<span style=color:#f92672>=</span>4.0.0
-</span></span></code></pre></div><p><code></code></p><h5
id=step-3--launch-the-hiveserver2-with-an-embedded-metastore><strong>STEP 3:
Launch the HiveServer2 with an embedded Metastore.</strong></h5><p>This is
lightweight and for a quick setup, it uses Derby as metastore db.</p><div
class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=displa [...]
-</span></span></code></pre></div><p><code></code></p><h5
id=step-4-connect-to-beeline><strong>STEP 4: Connect to
beeline</strong></h5><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>docker
exec -it hiveserver2 beeline -u <span
style=color:#e6db74>'jdbc:hive2://hiveserver2:10000/'</span>
-</span></span></code></pre></div><p><code></code></p><h5
id=note-launch-standalone-metastore-to-use-standalone-metastore-with-derby>Note:
Launch Standalone Metastore To use standalone Metastore with Derby,</h5><div
class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>docker run
-d -p 9083:9083 --env SERVICE_NAME<span styl [...]
-</span></span></code></pre></div><p><code></code></p><h2
id=detailed-setup>Detailed Setup</h2><hr><h5 id=--build-image>- Build
image</h5><p>Apache Hive relies on Hadoop, Tez and some others to facilitate
reading, writing, and managing large datasets.
-The [/packaging/src/docker/build.sh] provides ways to build the image against
specified version of the dependent, as well as build from source.</p><h5
id=--build-from-source>- Build from source</h5><div class=highlight><pre
tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>mvn clean
package -pl packaging -DskipTests -Pdocker
-</span></span></code></pre></div><p><code></code></p><h5
id=--build-with-specified-version>- Build with specified version</h5><p>There
are some arguments to specify the component version:</p><div
class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>-hadoop
<hadoop version>
+Last updated: May 12, 2023</span></div></header><div class=docs-toc><h4><i
class="fas fa-list"></i> Table of Contents</h4><nav
id=TableOfContents><ul><li><ul><li><ul><li><a
href=#introduction>Introduction</a></li><li><a
href=#quickstart>Quickstart</a></li></ul></li><li><a
href=#detailed-setup>Detailed Setup</a><ul><li></li><li><a
href=#run-services>Run services</a></li><li><a href=#usage>Usage</a></li><li><a
href=#quick-start-with-rest-catalog-integration>Quick Start with REST Catalog
In [...]
+</span></span></code></pre></div><h5
id=step-2-export-the-hive-version><strong>STEP 2: Export the Hive
version</strong></h5><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>export
HIVE_VERSION<span style=color:#f92672>=</span>4.2.0
+</span></span></code></pre></div><h5
id=step-3--launch-the-hiveserver2-with-an-embedded-metastore><strong>STEP 3:
Launch the HiveServer2 with an embedded Metastore.</strong></h5><p>This is
lightweight and for a quick setup, it uses Derby as metastore db.</p><div
class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>docker
[...]
+</span></span></code></pre></div><h5 id=step-4-connect-to-beeline><strong>STEP
4: Connect to beeline</strong></h5><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>docker
exec -it hiveserver2 beeline -u <span
style=color:#e6db74>'jdbc:hive2://hiveserver2:10000/'</span>
+</span></span></code></pre></div><h5
id=note-launch-standalone-metastore-to-use-standalone-metastore-with-derby>Note:
Launch Standalone Metastore To use standalone Metastore with Derby,</h5><div
class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>docker run
-d -p 9083:9083 --env SERVICE_NAME<span style=color:#f92672>=</s [...]
+</span></span></code></pre></div><h2 id=detailed-setup>Detailed
Setup</h2><hr><h5 id=--build-image>- Build image</h5><p>Apache Hive relies on
Hadoop, Tez and some others to facilitate reading, writing, and managing large
datasets.
+The <a
href=https://github.com/apache/hive/blob/master/packaging/src/docker/build.sh>/packaging/src/docker/build.sh</a>
provides ways to build the image against specified version of the dependent,
as well as build from source.</p><h5 id=--build-from-source>- Build from
source</h5><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=dis [...]
+</span></span></code></pre></div><h5 id=--build-with-specified-version>- Build
with specified version</h5><p>There are some arguments to specify the component
version:</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>-hadoop
<hadoop version>
</span></span><span style=display:flex><span>-tez <tez version>
</span></span><span style=display:flex><span>-hive <hive version>
</span></span></code></pre></div><p>If the version is not provided, it will
read the version from current <code>pom.xml</code>:
<code>project.version</code>, <code>hadoop.version</code> and
<code>tez.version</code> for Hive, Hadoop and Tez respectively.
-For example, the following command uses Hive 4.0.0, Hadoop
<code>hadoop.version</code> and Tez <code>tez.version</code> to build the
image,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>./build.sh
-hive 4.0.0
-</span></span></code></pre></div><p>If the command does not specify the Hive
version, it will use the local
<code>apache-hive-${project.version}-bin.tar.gz</code>(will trigger a build if
it doesn’t exist),
-together with Hadoop 3.3.6 and Tez 0.10.3 to build the image,</p><div
class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>./build.sh
-hadoop 3.3.6 -tez 0.10.3
+For example, the following command uses Hive 4.2.0, Hadoop
<code>hadoop.version</code> and Tez <code>tez.version</code> to build the
image,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>./build.sh
-hive 4.2.0
+</span></span></code></pre></div><p>If the command does not specify the Hive
version, it will use the local
<code>apache-hive-${project.version}-bin.tar.gz</code>(will trigger a build if
it doesn’t exist), together with Hadoop 3.3.6 and Tez 0.10.3 to build the
image,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display [...]
</span></span></code></pre></div><p>After building successfully, we can get a
Docker image named <code>apache/hive</code> by default, the image is tagged by
the provided Hive version.</p><h3 id=run-services>Run
services</h3><hr><p>Before going further, we should define the environment
variable <code>HIVE_VERSION</code> first.
-For example, if <code>-hive 4.0.0</code> is specified to build the
image,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>export
HIVE_VERSION<span style=color:#f92672>=</span>4.0.0
+For example, if <code>-hive 4.2.0</code> is specified to build the
image,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>export
HIVE_VERSION<span style=color:#f92672>=</span>4.2.0
</span></span></code></pre></div><p>or assuming that you’re relying on
current <code>project.version</code> from pom.xml,</p><div class=highlight><pre
tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>export
HIVE_VERSION<span style=color:#f92672>=</span><span
style=color:#66d9ef>$(</span>mvn -f pom.xml -q help:evaluate -Dexpression<s
[...]
-</span></span></code></pre></div><p><code></code></p><h5
id=--metastore><strong>- Metastore</strong></h5><p>For a quick start, launch
the Metastore with Derby,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>docker run
-d -p 9083:9083 --env SERVICE_NAME<span style=color:#f92672>=</span>metastore
--name metast [...]
+</span></span></code></pre></div><h5 id=--metastore><strong>-
Metastore</strong></h5><p>For a quick start, launch the Metastore with
Derby,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>docker run
-d -p 9083:9083 --env SERVICE_NAME<span style=color:#f92672>=</span>metastore
--name metastore-standalone apach [...]
</span></span></code></pre></div><p>Everything would be lost when the service
is down. In order to save the Hive table’s schema and data, start the
container with an external Postgres and Volume to keep them,</p><div
class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>docker run
-d -p 9083:9083 --env SERVICE_NAME<s [...]
-</span></span></span><span style=display:flex><span> --env SERVICE_OPTS<span
style=color:#f92672>=</span><span
style=color:#e6db74>"-Djavax.jdo.option.ConnectionDriverName=org.postgresql.Driver
-Djavax.jdo.option.ConnectionURL=jdbc:postgresql://postgres:5432/metastore_db
-Djavax.jdo.option.ConnectionUserName=hive
-Djavax.jdo.option.ConnectionPassword=password"</span> <span
style=color:#ae81ff>\
-</span></span></span><span style=display:flex><span> --mount source<span
style=color:#f92672>=</span>warehouse,target<span
style=color:#f92672>=</span>/opt/hive/data/warehouse <span style=color:#ae81ff>\
-</span></span></span><span style=display:flex><span> --mount type<span
style=color:#f92672>=</span>bind,source<span style=color:#f92672>=</span><span
style=color:#e6db74>`</span>mvn help:evaluate -Dexpression<span
style=color:#f92672>=</span>settings.localRepository -q -DforceStdout<span
style=color:#e6db74>`</span>/org/postgresql/postgresql/42.5.1/postgresql-42.5.1.jar,target<span
style=color:#f92672>=</span>/opt/hive/lib/postgres.jar <span
style=color:#ae81ff>\
-</span></span></span><span style=display:flex><span> --name
metastore-standalone apache/hive:<span
style=color:#e6db74>${</span>HIVE_VERSION<span style=color:#e6db74>}</span>
+</span></span></span><span style=display:flex><span> --env SERVICE_OPTS<span
style=color:#f92672>=</span><span
style=color:#e6db74>"-Djavax.jdo.option.ConnectionDriverName=org.postgresql.Driver
-Djavax.jdo.option.ConnectionURL=jdbc:postgresql://postgres:5432/metastore_db
-Djavax.jdo.option.ConnectionUserName=hive
-Djavax.jdo.option.ConnectionPassword=password"</span> <span
style=color:#ae81ff>\
+</span></span></span><span style=display:flex><span> --mount source<span
style=color:#f92672>=</span>warehouse,target<span
style=color:#f92672>=</span>/opt/hive/data/warehouse <span style=color:#ae81ff>\
+</span></span></span><span style=display:flex><span> --mount type<span
style=color:#f92672>=</span>bind,source<span style=color:#f92672>=</span><span
style=color:#e6db74>`</span>mvn help:evaluate -Dexpression<span
style=color:#f92672>=</span>settings.localRepository -q -DforceStdout<span
style=color:#e6db74>`</span>/org/postgresql/postgresql/42.5.1/postgresql-42.5.1.jar,target<span
style=color:#f92672>=</span>/opt/hive/lib/postgres.jar <span
style=color:#ae81ff>\
+</span></span></span><span style=display:flex><span> --name
metastore-standalone apache/hive:<span
style=color:#e6db74>${</span>HIVE_VERSION<span style=color:#e6db74>}</span>
</span></span></code></pre></div><p>If you want to use your own
<code>hdfs-site.xml</code> or <code>yarn-site.xml</code> for the service, you
can provide the environment variable <code>HIVE_CUSTOM_CONF_DIR</code> for the
command. For instance, put the custom configuration file under the directory
<code>/opt/hive/conf</code>, then,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><co
[...]
-</span></span></span><span style=display:flex><span> -v
/opt/hive/conf:/hive_custom_conf --env HIVE_CUSTOM_CONF_DIR<span
style=color:#f92672>=</span>/hive_custom_conf <span style=color:#ae81ff>\
-</span></span></span><span style=display:flex><span> --mount type<span
style=color:#f92672>=</span>bind,source<span style=color:#f92672>=</span><span
style=color:#e6db74>`</span>mvn help:evaluate -Dexpression<span
style=color:#f92672>=</span>settings.localRepository -q -DforceStdout<span
style=color:#e6db74>`</span>/org/postgresql/postgresql/42.5.1/postgresql-42.5.1.jar,target<span
style=color:#f92672>=</span>/opt/hive/lib/postgres.jar <span
style=color:#ae81ff>\
-</span></span></span><span style=display:flex><span> --name metastore
apache/hive:<span style=color:#e6db74>${</span>HIVE_VERSION<span
style=color:#e6db74>}</span>
-</span></span></code></pre></div><p>For Hive releases before 4.0, if you want
to upgrade the existing external Metastore schema to the target version, then
add <code>--env SCHEMA_COMMAND=upgradeSchema</code> to the command.
-To skip schematool initialisation or upgrade for metastore use <code>--env
IS_RESUME="true"</code>, for verbose logging set <code>--env
VERBOSE="true"</code>.</p><p><code></code></p><h5 id=--hiveserver2><strong>-
HiveServer2</strong></h5><p>Launch the HiveServer2 with an embedded
Metastore,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell>< [...]
-</span></span></code></pre></div><p>or specify a remote Metastore if
it’s available,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span> docker
run -d -p 10000:10000 -p 10002:10002 --env SERVICE_NAME<span
style=color:#f92672>=</span>hiveserver2 <span style=color:#ae81ff>\
-</span></span></span><span style=display:flex><span> --env
SERVICE_OPTS<span style=color:#f92672>=</span><span
style=color:#e6db74>"-Dhive.metastore.uris=thrift://metastore:9083"</span>
<span style=color:#ae81ff>\
-</span></span></span><span style=display:flex><span> --env IS_RESUME<span
style=color:#f92672>=</span><span style=color:#e6db74>"true"</span>
<span style=color:#ae81ff>\
-</span></span></span><span style=display:flex><span> --name
hiveserver2-standalone apache/hive:<span
style=color:#e6db74>${</span>HIVE_VERSION<span style=color:#e6db74>}</span>
+</span></span></span><span style=display:flex><span> -v
/opt/hive/conf:/hive_custom_conf --env HIVE_CUSTOM_CONF_DIR<span
style=color:#f92672>=</span>/hive_custom_conf <span style=color:#ae81ff>\
+</span></span></span><span style=display:flex><span> --mount type<span
style=color:#f92672>=</span>bind,source<span style=color:#f92672>=</span><span
style=color:#e6db74>`</span>mvn help:evaluate -Dexpression<span
style=color:#f92672>=</span>settings.localRepository -q -DforceStdout<span
style=color:#e6db74>`</span>/org/postgresql/postgresql/42.5.1/postgresql-42.5.1.jar,target<span
style=color:#f92672>=</span>/opt/hive/lib/postgres.jar <span
style=color:#ae81ff>\
+</span></span></span><span style=display:flex><span> --name metastore
apache/hive:<span style=color:#e6db74>${</span>HIVE_VERSION<span
style=color:#e6db74>}</span>
+</span></span></code></pre></div><p>For Hive releases before 4.2, if you want
to upgrade the existing external Metastore schema to the target version, then
add <code>--env SCHEMA_COMMAND=upgradeSchema</code> to the command.
+To skip schematool initialisation or upgrade for metastore use <code>--env
IS_RESUME="true"</code>, for verbose logging set <code>--env
VERBOSE="true"</code>.</p><h5 id=--hiveserver2><strong>-
HiveServer2</strong></h5><p>Launch the HiveServer2 with an embedded
Metastore,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:f [...]
+</span></span></code></pre></div><p>or specify a remote Metastore if
it’s available,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>docker run
-d -p 10000:10000 -p 10002:10002 --env SERVICE_NAME<span
style=color:#f92672>=</span>hiveserver2 <span style=color:#ae81ff>\
+</span></span></span><span style=display:flex><span> --env SERVICE_OPTS<span
style=color:#f92672>=</span><span
style=color:#e6db74>"-Dhive.metastore.uris=thrift://metastore:9083"</span>
<span style=color:#ae81ff>\
+</span></span></span><span style=display:flex><span> --env IS_RESUME<span
style=color:#f92672>=</span><span style=color:#e6db74>"true"</span>
<span style=color:#ae81ff>\
+</span></span></span><span style=display:flex><span> --name
hiveserver2-standalone apache/hive:<span
style=color:#e6db74>${</span>HIVE_VERSION<span style=color:#e6db74>}</span>
</span></span></code></pre></div><p>To save the data between container
restarts, you can start the HiveServer2 with a Volume,</p><div
class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>docker run
-d -p 10000:10000 -p 10002:10002 --env SERVICE_NAME<span
style=color:#f92672>=</span>hiveserver2 <span style=color:#ae81ff>\
-</span></span></span><span style=display:flex><span> --env SERVICE_OPTS<span
style=color:#f92672>=</span><span
style=color:#e6db74>"-Dhive.metastore.uris=thrift://metastore:9083"</span>
<span style=color:#ae81ff>\
-</span></span></span><span style=display:flex><span> --mount source<span
style=color:#f92672>=</span>warehouse,target<span
style=color:#f92672>=</span>/opt/hive/data/warehouse <span style=color:#ae81ff>\
-</span></span></span><span style=display:flex><span> --env IS_RESUME<span
style=color:#f92672>=</span><span style=color:#e6db74>"true"</span>
<span style=color:#ae81ff>\
-</span></span></span><span style=display:flex><span> --name hiveserver2
apache/hive:<span style=color:#e6db74>${</span>HIVE_VERSION<span
style=color:#e6db74>}</span>
-</span></span></code></pre></div><p><code></code></p><h5
id=--hiveserver2-metastore><strong>- HiveServer2, Metastore</strong></h5><p>To
get a quick overview of both HiveServer2 and Metastore, there is a
<code>docker-compose.yml</code> placed under <code>packaging/src/docker</code>
for this purpose,
-specify the <code>POSTGRES_LOCAL_PATH</code> first:</p><div
class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>export
POSTGRES_LOCAL_PATH<span
style=color:#f92672>=</span>your_local_path_to_postgres_driver
+</span></span></span><span style=display:flex><span> --env SERVICE_OPTS<span
style=color:#f92672>=</span><span
style=color:#e6db74>"-Dhive.metastore.uris=thrift://metastore:9083"</span>
<span style=color:#ae81ff>\
+</span></span></span><span style=display:flex><span> --mount source<span
style=color:#f92672>=</span>warehouse,target<span
style=color:#f92672>=</span>/opt/hive/data/warehouse <span style=color:#ae81ff>\
+</span></span></span><span style=display:flex><span> --env IS_RESUME<span
style=color:#f92672>=</span><span style=color:#e6db74>"true"</span>
<span style=color:#ae81ff>\
+</span></span></span><span style=display:flex><span> --name hiveserver2
apache/hive:<span style=color:#e6db74>${</span>HIVE_VERSION<span
style=color:#e6db74>}</span>
+</span></span></code></pre></div><h5 id=--hiveserver2-metastore><strong>-
HiveServer2, Metastore</strong></h5><p>To get a quick overview of both
HiveServer2 and Metastore, there is a <code>docker-compose.yml</code> placed
under <code>packaging/src/docker</code> for this purpose, specify the
<code>POSTGRES_LOCAL_PATH</code> first:</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><cod
[...]
</span></span></code></pre></div><p>Example:</p><div class=highlight><pre
tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>mvn
dependency:copy -Dartifact<span style=color:#f92672>=</span><span
style=color:#e6db74>"org.postgresql:postgresql:42.5.1"</span> <span
style=color:#f92672>&&</span> <span style=color:#ae81ff>\
</span></span></span><span style=display:flex><span>export
POSTGRES_LOCAL_PATH<span style=color:#f92672>=</span><span
style=color:#e6db74>`</span>mvn help:evaluate -Dexpression<span
style=color:#f92672>=</span>settings.localRepository -q -DforceStdout<span
style=color:#e6db74>`</span>/org/postgresql/postgresql/42.5.1/postgresql-42.5.1.jar
-</span></span></code></pre></div><p>If you don’t install maven or have
problem in resolving the postgres driver, you can always download this jar
yourself,
-change the <code>POSTGRES_LOCAL_PATH</code> to the path of the downloaded jar.
Then,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>docker
compose up -d
+</span></span></code></pre></div><p>If you don’t install maven or have
problem in resolving the postgres driver, you can always download this jar
yourself, change the <code>POSTGRES_LOCAL_PATH</code> to the path of the
downloaded jar. Then,</p><div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span>docker
compose up -d
</span></span></code></pre></div><p>HiveServer2, Metastore and Postgres
services will be started as a consequence. Volumes are used to persist data
generated by Hive inside Postgres and HiveServer2
containers:</p><ul><li>hive_db<ul><li>The volume persists the metadata of Hive
tables inside Postgres container.</li></ul></li><li>warehouse<ul><li>The volume
stores tables’ files inside HiveServer2
container.</li></ul></li></ul><p>To stop/remove them all,</p><div
class=highlight><pre ta [...]
</span></span></code></pre></div><h3
id=usage>Usage</h3><hr><ul><li>HiveServer2 web<ul><li>Accessed on browser at
http://localhost:10002/</li></ul></li><li>Beeline:<div class=highlight><pre
tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-shell data-lang=shell><span style=display:flex><span> docker
exec -it hiveserver2 beeline -u <span
style=color:#e6db74>'jdbc:hive2://hiveserver2:10000 [...]
</span></span><span style=display:flex><span> <span style=color:#75715e># If
beeline is installed on host machine, HiveServer2 can be simply reached
via:</span>
@@ -59,8 +56,7 @@ change the <code>POSTGRES_LOCAL_PATH</code> to the path of
the downloaded jar. T
</span></span><span style=display:flex><span> <span
style=color:#66d9ef>select</span> <span style=color:#66d9ef>count</span>(<span
style=color:#66d9ef>distinct</span> a) <span style=color:#66d9ef>from</span>
hive_example;
</span></span><span style=display:flex><span> <span
style=color:#66d9ef>select</span> <span style=color:#66d9ef>sum</span>(b) <span
style=color:#66d9ef>from</span> hive_example;
</span></span></code></pre></div></li></ul><h4
id=sys-schema-and-information_schema-schema><code>sys</code> Schema and
<code>information_schema</code> Schema</h4><p><code>Hive Schema Tool</code> is
located in the Docker Image at <code>/opt/hive/bin/schematool</code>.</p><p>By
default, system schemas such as <code>information_schema</code> for HiveServer2
are not created.
-To create system schemas for a HiveServer2 instance,
-users need to configure the Hive Metastore Server used by HiveServer2 to use a
database other than the embedded Derby.
+To create system schemas for a HiveServer2 instance, users need to configure
the Hive Metastore Server used by HiveServer2 to use a database other than the
embedded Derby.
The following text discusses how to configure HiveServer2 when the Hive
Metastore Server is in different locations.</p><h5
id=hiveserver2-with-embedded-hive-metastore-server>HiveServer2 with embedded
Hive Metastore Server</h5><p>Assuming <code>Maven</code> and <code>Docker
CE</code> are installed, a possible use case is as follows.
Create a <code>compose.yaml</code> file in the current directory,</p><div
class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none><code
class=language-yaml data-lang=yaml><span style=display:flex><span><span
style=color:#f92672>services</span>:
</span></span><span style=display:flex><span> <span
style=color:#f92672>some-postgres</span>:
@@ -68,7 +64,7 @@ Create a <code>compose.yaml</code> file in the current
directory,</p><div class=
</span></span><span style=display:flex><span> <span
style=color:#f92672>environment</span>:
</span></span><span style=display:flex><span> <span
style=color:#f92672>POSTGRES_PASSWORD</span>: <span
style=color:#e6db74>"example"</span>
</span></span><span style=display:flex><span> <span
style=color:#f92672>hiveserver2-standalone</span>:
-</span></span><span style=display:flex><span> <span
style=color:#f92672>image</span>: <span
style=color:#ae81ff>apache/hive:4.0.1</span>
+</span></span><span style=display:flex><span> <span
style=color:#f92672>image</span>: <span
style=color:#ae81ff>apache/hive:4.2.0</span>
</span></span><span style=display:flex><span> <span
style=color:#f92672>depends_on</span>:
</span></span><span style=display:flex><span> - <span
style=color:#ae81ff>some-postgres</span>
</span></span><span style=display:flex><span> <span
style=color:#f92672>environment</span>:
@@ -93,7 +89,7 @@ Create a <code>compose.yaml</code> file in the current
directory,</p><div class=
</span></span><span style=display:flex><span> <span
style=color:#f92672>environment</span>:
</span></span><span style=display:flex><span> <span
style=color:#f92672>POSTGRES_PASSWORD</span>: <span
style=color:#e6db74>"example"</span>
</span></span><span style=display:flex><span> <span
style=color:#f92672>metastore-standalone</span>:
-</span></span><span style=display:flex><span> <span
style=color:#f92672>image</span>: <span
style=color:#ae81ff>apache/hive:4.0.1</span>
+</span></span><span style=display:flex><span> <span
style=color:#f92672>image</span>: <span
style=color:#ae81ff>apache/hive:4.2.0</span>
</span></span><span style=display:flex><span> <span
style=color:#f92672>depends_on</span>:
</span></span><span style=display:flex><span> - <span
style=color:#ae81ff>some-postgres</span>
</span></span><span style=display:flex><span> <span
style=color:#f92672>environment</span>:
@@ -107,7 +103,7 @@ Create a <code>compose.yaml</code> file in the current
directory,</p><div class=
</span></span><span style=display:flex><span> <span
style=color:#f92672>volumes</span>:
</span></span><span style=display:flex><span> - <span
style=color:#ae81ff>~/.m2/repository/org/postgresql/postgresql/42.7.5/postgresql-42.7.5.jar:/opt/hive/lib/postgres.jar</span>
</span></span><span style=display:flex><span> <span
style=color:#f92672>hiveserver2-standalone</span>:
-</span></span><span style=display:flex><span> <span
style=color:#f92672>image</span>: <span
style=color:#ae81ff>apache/hive:4.0.1</span>
+</span></span><span style=display:flex><span> <span
style=color:#f92672>image</span>: <span
style=color:#ae81ff>apache/hive:4.2.0</span>
</span></span><span style=display:flex><span> <span
style=color:#f92672>depends_on</span>:
</span></span><span style=display:flex><span> - <span
style=color:#ae81ff>metastore-standalone</span>
</span></span><span style=display:flex><span> <span
style=color:#f92672>environment</span>:
diff --git a/index.json b/index.json
index 74644460..ee32c7e0 100644
--- a/index.json
+++ b/index.json
@@ -1 +1 @@
-[{"categories":null,"contents":"Apache Hive : Iceberg REST Catalog API backed
by Hive Metastore Introduction Hive Metastore offers Iceberg REST API endpoints
for clients native to Apache Iceberg. Consequently, Iceberg users can access
Iceberg tables via either Hive Metastore Thrift API (using HiveCatalog) or
Iceberg REST Catalog API.\nBasic configurations You must configure the
following parameters.\nKey Required? Default Value
metastore.catalog.servlet.port Yes -1 The port number to whi [...]
\ No newline at end of file
+[{"categories":null,"contents":"Apache Hive : Iceberg REST Catalog API backed
by Hive Metastore Introduction Hive Metastore offers Iceberg REST API endpoints
for clients native to Apache Iceberg. Consequently, Iceberg users can access
Iceberg tables via either Hive Metastore Thrift API (using HiveCatalog) or
Iceberg REST Catalog API.\nBasic configurations You must configure the
following parameters.\nKey Required? Default Value
metastore.catalog.servlet.port Yes -1 The port number to whi [...]
\ No newline at end of file
diff --git a/index.xml b/index.xml
index 4f60bd17..dbc853c9 100644
--- a/index.xml
+++ b/index.xml
@@ -10908,20 +10908,11 @@ Hive&rsquo;s SQL can also be extended with user
code via user defined functi
<h3 id="quickstart">Quickstart</h3>
<hr>
<h5 id="step-1-pull-the-image"><strong>STEP 1: Pull the
image</strong></h5>
-<ul>
-<li>Pull the image from DockerHub: <a
href="https://hub.docker.com/r/apache/hive/tags">https://hub.docker.com/r/apache/hive/tags</a>.
Here are the latest images:
-<ul>
-<li>4.0.0</li>
-<li>3.1.3</li>
-</ul>
-</li>
-</ul>
-<div class="highlight"><pre tabindex="0"
style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none;"><code
class="language-shell" data-lang="shell"><span
style="display:flex;"><span>docker pull apache/hive:4.0.0
-</span></span></code></pre></div><p><code>
</code></p>
-<h5 id="step-2-export-the-hive-version"><strong>STEP 2: Export the
Hive version</strong></h5>
-<div class="highlight"><pre tabindex="0"
style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none;"><code
class="language-shell" data-lang="shell"><span
style="display:flex;"><span>export HIVE_VERSION<span
style="color:#f92672">=</span>4.0.0
-</span></span></code></pre></div><p><code>
</code></p>
-<h5
id="step-3--launch-the-hiveserver2-with-an-embedded-metastore"><strong>STEP
3: Launch the HiveServer2 with an embedded Metastore.</strong></h5>
+<p>Pull the image from DockerHub: <a
href="https://hub.docker.com/r/apache/hive/tags">https://hub.docker.com/r/apache/hive/tags</a>.
The latest image tag is <code>4.2.0</code>.</p>
+<div class="highlight"><pre tabindex="0"
style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none;"><code
class="language-shell" data-lang="shell"><span
style="display:flex;"><span>docker pull apache/hive:4.2.0
+</span></span></code></pre></div><h5
id="step-2-export-the-hive-version"><strong>STEP 2: Export the Hive
version</strong></h5>
+<div class="highlight"><pre tabindex="0"
style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-text-size-adjust:none;"><code
class="language-shell" data-lang="shell"><span
style="display:flex;"><span>export HIVE_VERSION<span
style="color:#f92672">=</span>4.2.0
+</span></span></code></pre></div><h5
id="step-3--launch-the-hiveserver2-with-an-embedded-metastore"><strong>STEP
3: Launch the HiveServer2 with an embedded Metastore.</strong></h5>
<p>This is lightweight and for a quick setup, it uses Derby as metastore
db.</p></description></item><item><title>Getting
Started</title><link>https://hive.apache.org/development/gettingstarted/</link><pubDate>Tue,
10 Jan 2023 12:35:11
+0530</pubDate><guid>https://hive.apache.org/development/gettingstarted/</guid><description><p>The
Apache Hive ™ data warehouse software facilitates reading,
writing, and managing large datasets residing in distributed storage
using SQL. Structure can be projected onto data already in storage.
