You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by za...@apache.org on 2025/08/11 07:05:26 UTC

(hive-site) branch main updated: HIVE-29113: Reorganize documentation content into appropriate sections/directories (#57)

This is an automated email from the ASF dual-hosted git repository.

zabetak pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/hive-site.git


The following commit(s) were added to refs/heads/main by this push:
     new 3e1991b  HIVE-29113: Reorganize documentation content into appropriate sections/directories (#57)
3e1991b is described below

commit 3e1991b81e6b5e30e6060112214b9043ef1632df
Author: Stamatis Zampetakis <za...@gmail.com>
AuthorDate: Mon Aug 11 10:05:22 2025 +0300

    HIVE-29113: Reorganize documentation content into appropriate sections/directories (#57)
    
    1. Move and group pages under the following categories
    * development/designdocs (feature proposals, wip features, etc.)
    * community/meetings (meeting notes from various events)
    * community/resources (build instructions, dev guides, books, faqs, presentations, etc.)
    * docs/latest (Product documenation)
    - language manual
    - Admin manual
    - User Manual
    - HCatalog Manual
    - Webhcat Manual
    
    2. Drop obsolete/redundant pages
    * apache-hive-4-0-x_282102245.md
    * developerdocs_42568263.md
    * gettingstarted-eclipsesetup_27362091.md
    * home_27362069.md
    * roadmap_27362057.md
    * userguide_27362066.md
    
    The content of home_27362069.md was one of the basis that was used to create the section decomposition above.
    
    3. Remove General navigation links from HCatalog/WebHCat pages
    Every HCatalog/WebHCat page had some links to navigate back to the top of the documentation. All those links are redundant and difficult to maintain given the new structure of the doc.
    
    4. Add frontmatter title for capture-lineage-info.md to fix display in sections
    5. Update some links due to refactoring to avoid unreachable pages
    6. Add new menu entries for navigating to content under new location
---
 config.toml                                        |   8 +-
 content/Development/_index.md                      |   4 +
 .../latest => Development/desingdocs}/158869886.md |   0
 .../latest => Development/desingdocs}/170266662.md |   0
 .../latest => Development/desingdocs}/27837073.md  |   0
 .../latest => Development/desingdocs}/50858744.md  |   0
 .../latest => Development/desingdocs}/50860526.md  |   0
 .../latest => Development/desingdocs}/75963441.md  |   0
 .../latest => Development/desingdocs}/75969407.md  |   0
 .../latest => Development/desingdocs}/75977362.md  |   0
 .../latest => Development/desingdocs}/80452092.md  |   0
 content/Development/desingdocs/_index.md           |   4 +
 .../accessserver-design-proposal_31823045.md       |   0
 .../binary-datatype-proposal_27826614.md           |   0
 .../column-statistics-in-hive_29131019.md          |   0
 .../desingdocs}/correlation-optimizer_34019487.md  |   0
 .../desingdocs}/dependent-tables_30151205.md       |   0
 .../desingdocs}/design_27362072.md                 |   0
 .../desingdocs}/designdocs_27362075.md             |   0
 .../different-timestamp-types_103091503.md         |   0
 .../desingdocs}/dynamicpartitions_27823715.md      |   2 +-
 .../desingdocs}/filterpushdowndev_27362092.md      |   0
 .../desingdocs}/groupbywithrollup_27826238.md      |   0
 ...atible-input-output-format-for-hive_30745805.md |   0
 ...rawstore-partition-filter-condition_55151993.md |   0
 .../desingdocs}/hbasebulkload_27362088.md          |   0
 .../hbasemetastoredevelopmentguide_55151960.md     |   0
 .../hive-metadata-caching-proposal_69407514.md     |   0
 .../desingdocs}/hive-on-tez_33296197.md            |   0
 .../desingdocs}/hive-tez-compatibility_59689974.md |   0
 .../hivereplicationdevelopment_55155632.md         |   0
 .../hivereplicationv2development_66850051.md       |   0
 .../desingdocs}/hiveserver2-thrift-api_27843687.md |   0
 .../desingdocs}/howl_27362109.md                   |   0
 .../desingdocs}/indexdev-bitmap_27362028.md        |   0
 .../desingdocs}/indexdev_27362104.md               |   0
 .../desingdocs}/links_27847416.md                  |   0
 .../desingdocs}/listbucketing_27846854.md          |   0
 .../desingdocs}/llap_62689557.md                   |   0
 .../desingdocs}/locking_27362050.md                |   0
 .../mapjoin-and-partition-pruning_34015666.md      |   0
 .../desingdocs}/mapjoinoptimization_27362029.md    |   0
 .../desingdocs}/metastore-tlp-proposal_71013238.md |   0
 .../desingdocs}/outerjoinbehavior_35749927.md      |   2 +-
 .../desingdocs}/partitionedviews_27362053.md       |   0
 .../desingdocs}/security_27362056.md               |   0
 .../skewed-join-optimization_27847852.md           |   0
 .../desingdocs}/spatial-queries_34022710.md        |   0
 .../desingdocs}/statsdev_27362062.md               |   0
 .../storage-api-release-proposal_67635447.md       |   0
 .../desingdocs}/storagehandlers_27362063.md        |   0
 .../desingdocs}/subqueries-in-select_68717850.md   |   0
 ...ands-in-hms-schema-upgrade-scripts_138022168.md |   0
 .../synchronized-metastore-cache_110692851.md      |   0
 .../desingdocs}/theta-join_33293991.md             |   0
 .../desingdocs}/top-k-stats_30150275.md            |   0
 .../type-qualifiers-in-hive_33298524.md            |   0
 .../desingdocs}/updatableviews_27824044.md         |   0
 .../vectorized-query-execution_34838326.md         |   0
 .../desingdocs}/viewdev_27362067.md                |   0
 content/Development/gettingStarted.md              |   2 +-
 .../gettingstarted_27362090.md                     |   0
 content/community/meetings/_index.md               |   4 +
 .../meetings}/contributorday2011_27820725.md       |   0
 .../contributorminutes20110907_27826430.md         |   0
 .../contributorminutes20111205_27833038.md         |   0
 .../contributorminutes20120418_27844528.md         |   0
 .../contributorsminutes110726_27822784.md          |   0
 ...tings-hivecontributorsminutes100601_27362084.md |   0
 ...tings-hivecontributorsminutes100706_27362085.md |   0
 ...tings-hivecontributorsminutes100808_27362082.md |   0
 ...tings-hivecontributorsminutes100913_27362083.md |   0
 ...tings-hivecontributorsminutes101025_27362080.md |   0
 ...tings-hivecontributorsminutes110425_27362081.md |   0
 .../development-contributorsmeetings_27362087.md   |   0
 .../hivecontributorsminutes100601_27362064.md      |   0
 .../hivecontributorsminutes100706_27362065.md      |   0
 .../latest => community/resources}/282102318.md    |   0
 content/community/resources/_index.md              |   4 +
 .../resources}/books-about-hive_61322063.md        |   0
 .../building-hive-from-source_282102252.md         |   0
 .../resources}/developerguide-udtf_27362086.md     |   0
 .../resources}/developerguide_27362074.md          |   0
 .../resources}/hive-apis-overview_61326349.md      |   0
 .../resources}/hivedeveloperfaq_27823747.md        |   0
 .../resources}/howtocommit_27362108.md             |   0
 .../resources}/howtocontribute_27362107.md         |   0
 .../resources}/howtorelease_27362106.md            |   0
 .../resources}/metastore-api-tests_75958143.md     |   0
 .../resources}/performance_27362052.md             |   0
 .../resources}/plugindeveloperkit_27820324.md      |   0
 .../resources}/presentations_27362054.md           |   0
 .../resources}/relatedprojects_34836686.md         |   0
 .../resources}/running-yetus_71012969.md           |   0
 .../resources}/testingdocs_42567126.md             |   0
 .../resources}/unit-testing-hive-sql_61328063.md   |   0
 content/docs/latest/_index.md                      | 292 +----------
 content/docs/latest/{ => admin}/284790216.md       |   0
 content/docs/latest/{ => admin}/44302539.md        |   0
 content/docs/latest/admin/_index.md                |   4 +
 .../adminmanual-configuration_27362070.md          |   0
 .../adminmanual-installation_27362077.md           |   0
 ...manual-metastore-3-0-administration_75978150.md |   0
 ...dminmanual-metastore-administration_27362076.md |   0
 .../adminmanual-settinguphiveserver_27362079.md    |   0
 .../latest/{ => admin}/adminmanual_27362071.md     |   0
 .../latest/{ => admin}/hive-metatool_55156221.md   |   0
 .../{ => admin}/hive-schema-tool_34835119.md       |   0
 .../hiveamazonelasticmapreduce_27825646.md         |   0
 .../docs/latest/{ => admin}/hiveaws_27362103.md    |   0
 .../{ => admin}/hivederbyservermode_27362068.md    |   0
 .../{ => admin}/hivejdbcinterface_27362100.md      |   0
 .../docs/latest/{ => admin}/hiveodbc_27362099.md   |   3 +-
 .../docs/latest/{ => admin}/hiveserver_27362111.md |   0
 .../{ => admin}/manual-installation_283118363.md   |   0
 .../latest/{ => admin}/replication_61336919.md     |   0
 .../setting-up-hive-with-docker_282102281.md       |   0
 .../{ => admin}/setting-up-hiveserver2_30758712.md |   0
 ...th-ldap-atn-provider-in-hiveserver2_58852417.md |   0
 content/docs/latest/apache-hive-4-0-x_282102245.md |  41 --
 content/docs/latest/developerdocs_42568263.md      |  29 --
 .../latest/gettingstarted-eclipsesetup_27362091.md |  38 --
 content/docs/latest/{ => hcatalog}/283118454.md    |   0
 content/docs/latest/hcatalog/_index.md             |   4 +
 .../hcatalog-authorization_34014782.md             |   2 +-
 .../latest/{ => hcatalog}/hcatalog-cli_34013932.md |   2 +-
 .../hcatalog-configuration-properties_39622369.md  |   2 +-
 .../hcatalog-dynamicpartitions_34014006.md         |   2 +-
 .../hcatalog-inputoutput_34013776.md               |   2 +-
 .../hcatalog-installhcat_34013403.md               |   2 +-
 .../{ => hcatalog}/hcatalog-loadstore_34013511.md  |   2 +-
 .../hcatalog-notification_34014558.md              |   2 +-
 .../hcatalog-readerwriter_34013921.md              |   2 +-
 .../hcatalog-storageformats_34013997.md            |   2 +-
 .../hcatalog-streaming-mutation-api_61337025.md    |   0
 .../{ => hcatalog}/hcatalog-usinghcat_34013260.md  |   2 +-
 .../latest/{ => hcatalog}/hcatalog_33299065.md     |   2 +-
 content/docs/latest/home_27362069.md               | 139 ------
 content/docs/latest/{ => language}/122917025.md    |   0
 content/docs/latest/{ => language}/30151323.md     |   0
 content/docs/latest/{ => language}/67641451.md     |   0
 content/docs/latest/{ => language}/73632935.md     |   0
 content/docs/latest/{ => language}/97551656.md     |   0
 content/docs/latest/language/_index.md             |   4 +
 .../apache-hive-sql-conformance_67641449.md        |   0
 .../common-table-expression_38572242.md            |   0
 .../{ => language}/compaction-pooling_240884493.md |   0
 .../datasketches-integration_177050456.md          |   0
 .../{ => language}/exchange-partition_30755801.md  |   0
 .../genericudafcasestudy_27362093.md               |   0
 .../{ => language}/hive-operators_283118406.md     |   0
 .../latest/{ => language}/hive-udfs_282102277.md   |   0
 .../latest/{ => language}/hiveplugins_27362098.md  |   0
 .../docs/latest/{ => language}/hiveql_27362097.md  |   0
 .../languagemanual-archiving_27362031.md           |   0
 .../languagemanual-authorization_27362032.md       |   0
 .../{ => language}/languagemanual-cli_27362033.md  |   0
 .../languagemanual-commands_34838882.md            |   0
 .../languagemanual-ddl-bucketedtables_27362035.md  |   0
 .../{ => language}/languagemanual-ddl_27362034.md  |   0
 .../{ => language}/languagemanual-dml_27362036.md  |   0
 .../languagemanual-explain_27362037.md             |   0
 .../languagemanual-groupby_27362038.md             |   0
 .../languagemanual-importexport_27837968.md        |   0
 .../languagemanual-indexing_31822176.md            |   0
 .../languagemanual-joinoptimization_33293167.md    |   0
 .../languagemanual-joins_27362039.md               |   0
 .../languagemanual-lateralview_27362040.md         |   0
 .../{ => language}/languagemanual-lzo_33298193.md  |   0
 .../{ => language}/languagemanual-orc_31818911.md  |   0
 .../languagemanual-sampling_27362042.md            |   0
 .../languagemanual-select_27362043.md              |   0
 .../languagemanual-sortby_27362045.md              |   0
 .../languagemanual-subqueries_27362044.md          |   0
 .../languagemanual-transform_27362047.md           |   0
 .../languagemanual-types_27838462.md               |   0
 .../{ => language}/languagemanual-udf_27362046.md  |   0
 .../languagemanual-union_27362049.md               |   0
 ...languagemanual-variablesubstitution_30754722.md |   0
 .../languagemanual-virtualcolumns_27362048.md      |   0
 ...anguagemanual-windowingandanalytics_31819589.md |   0
 .../languagemanual-xpathudf_27362051.md            |   0
 .../{ => language}/languagemanual_27362030.md      |   0
 .../latest/{ => language}/literals_27829682.md     |   0
 .../managed-vs--external-tables_95654003.md        |   0
 .../{ => language}/materialized-views_80447331.md  |   0
 .../operatorsandfunctions_30754909.md              |   0
 .../partition-filter-syntax_103092177.md           |   0
 .../latest/{ => language}/reflectudf_30754716.md   |   0
 .../{ => language}/scheduled-queries_145724128.md  |   0
 ...l-standard-based-hive-authorization_40509928.md |   0
 .../statisticsanddatamining_27362058.md            |   0
 content/docs/latest/roadmap_27362057.md            |  88 ----
 content/docs/latest/{ => user}/283118453.md        |   0
 content/docs/latest/{ => user}/45876173.md         |   0
 content/docs/latest/{ => user}/59690156.md         |   0
 content/docs/latest/user/_index.md                 |   4 +
 .../{ => user}/accumulointegration_46633569.md     |   0
 content/docs/latest/{ => user}/authdev_27362078.md |   0
 .../docs/latest/{ => user}/avroserde_27850707.md   |   0
 .../docs/latest/{ => user}/capture-lineage-info.md |   5 +-
 .../{ => user}/compressedstorage_27362073.md       |   0
 .../configuration-properties_27842758.md           |   0
 .../cost-based-optimization-in-hive_42566775.md    |   0
 .../docs/latest/{ => user}/csv-serde_48202659.md   |   0
 ...tor-for-hive-and-hive-like-engines_288885794.md |   0
 .../data-connectors-in-hive_177049669.md           |   0
 .../{ => user}/druid-integration_65866491.md       |   0
 .../docs/latest/{ => user}/fileformats_47384180.md |   0
 .../latest/{ => user}/hbaseintegration_27362089.md |   0
 .../latest/{ => user}/hive-aws-emr_27823791.md     |   0
 .../{ => user}/hive-configurations_283118321.md    |   0
 .../hive-iceberg-integration_282102247.md          |   0
 .../latest/{ => user}/hive-metrics_65872987.md     |   0
 .../latest/{ => user}/hive-on-spark_42567714.md    |   0
 .../{ => user}/hive-transactions_40509723.md       |   0
 .../hiveaws-hivings3nremotely_27362102.md          |   0
 .../docs/latest/{ => user}/hiveclient_27362101.md  |   0
 .../latest/{ => user}/hivecounters_67636835.md     |   0
 .../{ => user}/hiveserver2-clients_30758725.md     |   0
 .../{ => user}/hiveserver2-overview_65147648.md    |   0
 .../{ => user}/jdbc-storage-handler_95651916.md    |   0
 .../{ => user}/kudu-integration_133631955.md       |   0
 .../materialized-views-in-hive_283118346.md        |   0
 .../{ => user}/multidelimitserde_46631999.md       |   0
 content/docs/latest/{ => user}/parquet_38570914.md |   0
 .../permission-inheritance-in-hive_48203008.md     |   0
 .../{ => user}/query-reexecution_87298873.md       |   0
 content/docs/latest/{ => user}/rcfile_58851803.md  |   0
 .../docs/latest/{ => user}/rcfilecat_30748712.md   |   0
 .../{ => user}/rebalance-compaction_240884502.md   |   0
 ...mentation-of-hive-cli-using-beeline_61311909.md |   0
 content/docs/latest/{ => user}/serde_27362059.md   |   0
 .../{ => user}/starrocks-integration_272927528.md  |   0
 ...thorization-in-the-metastore-server_45876440.md |   0
 .../streaming-data-ingest-v2_85477610.md           |   0
 .../{ => user}/streaming-data-ingest_40509746.md   |   0
 .../{ => user}/teradatabinaryserde_89068127.md     |   0
 .../transitivity-on-predicate-pushdown_27823388.md |   0
 .../docs/latest/{ => user}/tutorial_27362061.md    |   0
 .../{ => user}/union-optimization_29688910.md      |   0
 .../docs/latest/{ => user}/user-faq_27362095.md    |   0
 ...idb-as-the-hive-metastore-database_158872426.md |   0
 content/docs/latest/userguide_27362066.md          | 151 ------
 content/docs/latest/webhcat/_index.md              |   4 +
 .../{ => webhcat}/webhcat-configure_34015738.md    |   2 +-
 .../webhcat-installwebhcat_34015585.md             |   2 +-
 .../webhcat-reference-allddl_34016001.md           |   6 -
 .../webhcat-reference-ddl_34015990.md              |   2 +-
 .../webhcat-reference-deletedb_34016281.md         |   2 +-
 .../webhcat-reference-deletejob_34017204.md        |   2 +-
 .../webhcat-reference-deletejobid_34835045.md      |   2 +-
 .../webhcat-reference-deletepartition_34016611.md  |   2 +-
 .../webhcat-reference-deletetable_34016561.md      |   2 +-
 .../webhcat-reference-getcolumn_34016979.md        |   2 +-
 .../webhcat-reference-getcolumns_34016970.md       |   2 +-
 .../webhcat-reference-getdb_34016250.md            |   2 +-
 .../webhcat-reference-getdbs_34016238.md           |   2 +-
 .../webhcat-reference-getpartition_34016592.md     |   2 +-
 .../webhcat-reference-getpartitions_34016583.md    |   2 +-
 .../webhcat-reference-getproperties_34016995.md    |   2 +-
 .../webhcat-reference-getproperty_34017004.md      |   2 +-
 .../webhcat-reference-gettable_34016519.md         |   2 +-
 .../webhcat-reference-gettables_34016290.md        |   2 +-
 .../webhcat-reference-hive_34017180.md             |   2 +-
 .../webhcat-reference-job_34835065.md              |   2 +-
 .../webhcat-reference-jobids_34017187.md           |   2 +-
 .../webhcat-reference-jobinfo_34017194.md          |   2 +-
 .../webhcat-reference-jobs_34835057.md             |   2 +-
 .../webhcat-reference-mapreducejar_34017030.md     |   2 +-
 .../webhcat-reference-mapreducestream_34017023.md  |   2 +-
 .../webhcat-reference-pig_34017169.md              |   2 +-
 .../webhcat-reference-posttable_34016548.md        |   2 +-
 .../webhcat-reference-putcolumn_34016987.md        |   2 +-
 .../webhcat-reference-putdb_34016273.md            |   2 +-
 .../webhcat-reference-putpartition_34016600.md     |   2 +-
 .../webhcat-reference-putproperty_34017012.md      |   2 +-
 .../webhcat-reference-puttable_34016540.md         |   2 +-
 .../webhcat-reference-puttablelike_34016572.md     |   2 +-
 .../webhcat-reference-responsetypes_34015937.md    |   2 +-
 .../webhcat-reference-status_34015941.md           |   2 +-
 .../webhcat-reference-version_34015986.md          |   2 +-
 .../webhcat-reference-versionhadoop_44303410.md    |   2 +-
 .../webhcat-reference-versionhive_44303406.md      |   2 +-
 .../{ => webhcat}/webhcat-reference_34015762.md    |   2 +-
 .../{ => webhcat}/webhcat-usingwebhcat_34015492.md |   2 +-
 .../docs/latest/{ => webhcat}/webhcat_33299069.md  |   2 +-
 .../poweredby_27362055.md => general/poweredby.md} |   0
 themes/hive/layouts/partials/menu.html             |   4 +-
 .../hive/static/attachments/OuterJoinBehavior.html | 535 +++++++++++++++++++++
 290 files changed, 642 insertions(+), 845 deletions(-)

diff --git a/config.toml b/config.toml
index b92374f..6e48d73 100644
--- a/config.toml
+++ b/config.toml
@@ -27,24 +27,26 @@ theme = 'hive'
 
 [params.navbar]
     release = "/general/downloads"
+    poweredby = "/general/poweredby/"
     javaDocs = "/docs/javadocs/"
     latest = "/docs/latest/"
     languageManual = "https://cwiki.apache.org/confluence/display/Hive/LanguageManual"
     license2 = "https://www.apache.org/licenses/LICENSE-2.0.html"
     privacyPolicy = "/general/privacypolicy/"
-    designDocs = "https://cwiki.apache.org/confluence/display/Hive/DesignDocs"
+    designDocs = "/development/desingdocs/"
     hiveJira = "https://issues.apache.org/jira/projects/HIVE/issues"
     precommit = "https://cwiki.apache.org/confluence/display/Hive/Hive+PreCommit+Patch+Testing"
     faq = "https://cwiki.apache.org/confluence/display/Hive/HiveDeveloperFAQ"
     vcs = "/development/versioncontrol/"
     committer = "/community/becomingcommitter/"
     contribute = "https://cwiki.apache.org/confluence/display/Hive/HowToContribute"
-    resourcesForDev = "https://cwiki.apache.org/confluence/display/Hive/Home#Home-ResourcesforContributors"
+    resourcesForDev = "/community/resources/"
+    meetings = "/community/meetings/"
     mailinglists = "/community/mailinglists/"
     issueTracking = "/community/issuetracking/"
     people = "/community/people/"
     bylaws = "/community/bylaws/"
-    howToRelease = "/docs/latest/howtorelease_27362106/"
+    howToRelease = "/community/resources/howtorelease_27362106/"
     gettingStarted = "/development/gettingstarted/"
     docker = "/development/quickstart/"
     blogs = "https://hive.blog.apache.org/"
diff --git a/content/Development/_index.md b/content/Development/_index.md
new file mode 100644
index 0000000..e314b2e
--- /dev/null
+++ b/content/Development/_index.md
@@ -0,0 +1,4 @@
+---
+title: "Development"
+date: 2025-07-24
+---
diff --git a/content/docs/latest/158869886.md b/content/Development/desingdocs/158869886.md
similarity index 100%
rename from content/docs/latest/158869886.md
rename to content/Development/desingdocs/158869886.md
diff --git a/content/docs/latest/170266662.md b/content/Development/desingdocs/170266662.md
similarity index 100%
rename from content/docs/latest/170266662.md
rename to content/Development/desingdocs/170266662.md
diff --git a/content/docs/latest/27837073.md b/content/Development/desingdocs/27837073.md
similarity index 100%
rename from content/docs/latest/27837073.md
rename to content/Development/desingdocs/27837073.md
diff --git a/content/docs/latest/50858744.md b/content/Development/desingdocs/50858744.md
similarity index 100%
rename from content/docs/latest/50858744.md
rename to content/Development/desingdocs/50858744.md
diff --git a/content/docs/latest/50860526.md b/content/Development/desingdocs/50860526.md
similarity index 100%
rename from content/docs/latest/50860526.md
rename to content/Development/desingdocs/50860526.md
diff --git a/content/docs/latest/75963441.md b/content/Development/desingdocs/75963441.md
similarity index 100%
rename from content/docs/latest/75963441.md
rename to content/Development/desingdocs/75963441.md
diff --git a/content/docs/latest/75969407.md b/content/Development/desingdocs/75969407.md
similarity index 100%
rename from content/docs/latest/75969407.md
rename to content/Development/desingdocs/75969407.md
diff --git a/content/docs/latest/75977362.md b/content/Development/desingdocs/75977362.md
similarity index 100%
rename from content/docs/latest/75977362.md
rename to content/Development/desingdocs/75977362.md
diff --git a/content/docs/latest/80452092.md b/content/Development/desingdocs/80452092.md
similarity index 100%
rename from content/docs/latest/80452092.md
rename to content/Development/desingdocs/80452092.md
diff --git a/content/Development/desingdocs/_index.md b/content/Development/desingdocs/_index.md
new file mode 100644
index 0000000..c00f76a
--- /dev/null
+++ b/content/Development/desingdocs/_index.md
@@ -0,0 +1,4 @@
+---
+title: "Design Documents"
+date: 2025-07-24
+---
diff --git a/content/docs/latest/accessserver-design-proposal_31823045.md b/content/Development/desingdocs/accessserver-design-proposal_31823045.md
similarity index 100%
rename from content/docs/latest/accessserver-design-proposal_31823045.md
rename to content/Development/desingdocs/accessserver-design-proposal_31823045.md
diff --git a/content/docs/latest/binary-datatype-proposal_27826614.md b/content/Development/desingdocs/binary-datatype-proposal_27826614.md
similarity index 100%
rename from content/docs/latest/binary-datatype-proposal_27826614.md
rename to content/Development/desingdocs/binary-datatype-proposal_27826614.md
diff --git a/content/docs/latest/column-statistics-in-hive_29131019.md b/content/Development/desingdocs/column-statistics-in-hive_29131019.md
similarity index 100%
rename from content/docs/latest/column-statistics-in-hive_29131019.md
rename to content/Development/desingdocs/column-statistics-in-hive_29131019.md
diff --git a/content/docs/latest/correlation-optimizer_34019487.md b/content/Development/desingdocs/correlation-optimizer_34019487.md
similarity index 100%
rename from content/docs/latest/correlation-optimizer_34019487.md
rename to content/Development/desingdocs/correlation-optimizer_34019487.md
diff --git a/content/docs/latest/dependent-tables_30151205.md b/content/Development/desingdocs/dependent-tables_30151205.md
similarity index 100%
rename from content/docs/latest/dependent-tables_30151205.md
rename to content/Development/desingdocs/dependent-tables_30151205.md
diff --git a/content/docs/latest/design_27362072.md b/content/Development/desingdocs/design_27362072.md
similarity index 100%
rename from content/docs/latest/design_27362072.md
rename to content/Development/desingdocs/design_27362072.md
diff --git a/content/docs/latest/designdocs_27362075.md b/content/Development/desingdocs/designdocs_27362075.md
similarity index 100%
rename from content/docs/latest/designdocs_27362075.md
rename to content/Development/desingdocs/designdocs_27362075.md
diff --git a/content/docs/latest/different-timestamp-types_103091503.md b/content/Development/desingdocs/different-timestamp-types_103091503.md
similarity index 100%
rename from content/docs/latest/different-timestamp-types_103091503.md
rename to content/Development/desingdocs/different-timestamp-types_103091503.md
diff --git a/content/docs/latest/dynamicpartitions_27823715.md b/content/Development/desingdocs/dynamicpartitions_27823715.md
similarity index 97%
rename from content/docs/latest/dynamicpartitions_27823715.md
rename to content/Development/desingdocs/dynamicpartitions_27823715.md
index 10a82de..1ea4dfd 100644
--- a/content/docs/latest/dynamicpartitions_27823715.md
+++ b/content/Development/desingdocs/dynamicpartitions_27823715.md
@@ -9,7 +9,7 @@ date: 2024-12-12
 
 ## Documentation
 
-This is the [design]({{< ref "designdocs_27362075" >}}) document for dynamic partitions in Hive. Usage information is also available: 
+This is the design document for dynamic partitions in Hive. Usage information is also available: 
 
 * [Tutorial: Dynamic-Partition Insert]({{< ref "#tutorial:-dynamic-partition-insert" >}})
 * [Hive DML: Dynamic Partition Inserts]({{< ref "#hive-dml:-dynamic-partition-inserts" >}})
diff --git a/content/docs/latest/filterpushdowndev_27362092.md b/content/Development/desingdocs/filterpushdowndev_27362092.md
similarity index 100%
rename from content/docs/latest/filterpushdowndev_27362092.md
rename to content/Development/desingdocs/filterpushdowndev_27362092.md
diff --git a/content/docs/latest/groupbywithrollup_27826238.md b/content/Development/desingdocs/groupbywithrollup_27826238.md
similarity index 100%
rename from content/docs/latest/groupbywithrollup_27826238.md
rename to content/Development/desingdocs/groupbywithrollup_27826238.md
diff --git a/content/docs/latest/hadoop-compatible-input-output-format-for-hive_30745805.md b/content/Development/desingdocs/hadoop-compatible-input-output-format-for-hive_30745805.md
similarity index 100%
rename from content/docs/latest/hadoop-compatible-input-output-format-for-hive_30745805.md
rename to content/Development/desingdocs/hadoop-compatible-input-output-format-for-hive_30745805.md
diff --git a/content/docs/latest/hbase-execution-plans-for-rawstore-partition-filter-condition_55151993.md b/content/Development/desingdocs/hbase-execution-plans-for-rawstore-partition-filter-condition_55151993.md
similarity index 100%
rename from content/docs/latest/hbase-execution-plans-for-rawstore-partition-filter-condition_55151993.md
rename to content/Development/desingdocs/hbase-execution-plans-for-rawstore-partition-filter-condition_55151993.md
diff --git a/content/docs/latest/hbasebulkload_27362088.md b/content/Development/desingdocs/hbasebulkload_27362088.md
similarity index 100%
rename from content/docs/latest/hbasebulkload_27362088.md
rename to content/Development/desingdocs/hbasebulkload_27362088.md
diff --git a/content/docs/latest/hbasemetastoredevelopmentguide_55151960.md b/content/Development/desingdocs/hbasemetastoredevelopmentguide_55151960.md
similarity index 100%
rename from content/docs/latest/hbasemetastoredevelopmentguide_55151960.md
rename to content/Development/desingdocs/hbasemetastoredevelopmentguide_55151960.md
diff --git a/content/docs/latest/hive-metadata-caching-proposal_69407514.md b/content/Development/desingdocs/hive-metadata-caching-proposal_69407514.md
similarity index 100%
rename from content/docs/latest/hive-metadata-caching-proposal_69407514.md
rename to content/Development/desingdocs/hive-metadata-caching-proposal_69407514.md
diff --git a/content/docs/latest/hive-on-tez_33296197.md b/content/Development/desingdocs/hive-on-tez_33296197.md
similarity index 100%
rename from content/docs/latest/hive-on-tez_33296197.md
rename to content/Development/desingdocs/hive-on-tez_33296197.md
diff --git a/content/docs/latest/hive-tez-compatibility_59689974.md b/content/Development/desingdocs/hive-tez-compatibility_59689974.md
similarity index 100%
rename from content/docs/latest/hive-tez-compatibility_59689974.md
rename to content/Development/desingdocs/hive-tez-compatibility_59689974.md
diff --git a/content/docs/latest/hivereplicationdevelopment_55155632.md b/content/Development/desingdocs/hivereplicationdevelopment_55155632.md
similarity index 100%
rename from content/docs/latest/hivereplicationdevelopment_55155632.md
rename to content/Development/desingdocs/hivereplicationdevelopment_55155632.md
diff --git a/content/docs/latest/hivereplicationv2development_66850051.md b/content/Development/desingdocs/hivereplicationv2development_66850051.md
similarity index 100%
rename from content/docs/latest/hivereplicationv2development_66850051.md
rename to content/Development/desingdocs/hivereplicationv2development_66850051.md
diff --git a/content/docs/latest/hiveserver2-thrift-api_27843687.md b/content/Development/desingdocs/hiveserver2-thrift-api_27843687.md
similarity index 100%
rename from content/docs/latest/hiveserver2-thrift-api_27843687.md
rename to content/Development/desingdocs/hiveserver2-thrift-api_27843687.md
diff --git a/content/docs/latest/howl_27362109.md b/content/Development/desingdocs/howl_27362109.md
similarity index 100%
rename from content/docs/latest/howl_27362109.md
rename to content/Development/desingdocs/howl_27362109.md
diff --git a/content/docs/latest/indexdev-bitmap_27362028.md b/content/Development/desingdocs/indexdev-bitmap_27362028.md
similarity index 100%
rename from content/docs/latest/indexdev-bitmap_27362028.md
rename to content/Development/desingdocs/indexdev-bitmap_27362028.md
diff --git a/content/docs/latest/indexdev_27362104.md b/content/Development/desingdocs/indexdev_27362104.md
similarity index 100%
rename from content/docs/latest/indexdev_27362104.md
rename to content/Development/desingdocs/indexdev_27362104.md
diff --git a/content/docs/latest/links_27847416.md b/content/Development/desingdocs/links_27847416.md
similarity index 100%
rename from content/docs/latest/links_27847416.md
rename to content/Development/desingdocs/links_27847416.md
diff --git a/content/docs/latest/listbucketing_27846854.md b/content/Development/desingdocs/listbucketing_27846854.md
similarity index 100%
rename from content/docs/latest/listbucketing_27846854.md
rename to content/Development/desingdocs/listbucketing_27846854.md
diff --git a/content/docs/latest/llap_62689557.md b/content/Development/desingdocs/llap_62689557.md
similarity index 100%
rename from content/docs/latest/llap_62689557.md
rename to content/Development/desingdocs/llap_62689557.md
diff --git a/content/docs/latest/locking_27362050.md b/content/Development/desingdocs/locking_27362050.md
similarity index 100%
rename from content/docs/latest/locking_27362050.md
rename to content/Development/desingdocs/locking_27362050.md
diff --git a/content/docs/latest/mapjoin-and-partition-pruning_34015666.md b/content/Development/desingdocs/mapjoin-and-partition-pruning_34015666.md
similarity index 100%
rename from content/docs/latest/mapjoin-and-partition-pruning_34015666.md
rename to content/Development/desingdocs/mapjoin-and-partition-pruning_34015666.md
diff --git a/content/docs/latest/mapjoinoptimization_27362029.md b/content/Development/desingdocs/mapjoinoptimization_27362029.md
similarity index 100%
rename from content/docs/latest/mapjoinoptimization_27362029.md
rename to content/Development/desingdocs/mapjoinoptimization_27362029.md
diff --git a/content/docs/latest/metastore-tlp-proposal_71013238.md b/content/Development/desingdocs/metastore-tlp-proposal_71013238.md
similarity index 100%
rename from content/docs/latest/metastore-tlp-proposal_71013238.md
rename to content/Development/desingdocs/metastore-tlp-proposal_71013238.md
diff --git a/content/docs/latest/outerjoinbehavior_35749927.md b/content/Development/desingdocs/outerjoinbehavior_35749927.md
similarity index 97%
rename from content/docs/latest/outerjoinbehavior_35749927.md
rename to content/Development/desingdocs/outerjoinbehavior_35749927.md
index 800cf2f..de16c9d 100644
--- a/content/docs/latest/outerjoinbehavior_35749927.md
+++ b/content/Development/desingdocs/outerjoinbehavior_35749927.md
@@ -17,7 +17,7 @@ date: 2024-12-12
 		- [Case W1: Where Predicate on Preserved Row Table]({{< ref "#case-w1-where-predicate-on-preserved-row-table" >}})
 		- [Case W2: Where Predicate on Null Supplying Table]({{< ref "#case-w2-where-predicate-on-null-supplying-table" >}})
 
-This document is based on a writeup of [DB2 Outer Join Behavior](http://www.ibm.com/developerworks/data/library/techarticle/purcell/0112purcell.html). The original HTML document is attached to the [Hive Design Docs]({{< ref "designdocs_27362075" >}}) and can be [downloaded here](https://cwiki.apache.org/confluence/download/attachments/27362075/OuterJoinBehavior.html).
+This document is based on a writeup of [DB2 Outer Join Behavior](http://www.ibm.com/developerworks/data/library/techarticle/purcell/0112purcell.html). The original HTML can be found [here](/attachments/OuterJoinBehavior.html).
 
 ## Definitions
 
diff --git a/content/docs/latest/partitionedviews_27362053.md b/content/Development/desingdocs/partitionedviews_27362053.md
similarity index 100%
rename from content/docs/latest/partitionedviews_27362053.md
rename to content/Development/desingdocs/partitionedviews_27362053.md
diff --git a/content/docs/latest/security_27362056.md b/content/Development/desingdocs/security_27362056.md
similarity index 100%
rename from content/docs/latest/security_27362056.md
rename to content/Development/desingdocs/security_27362056.md
diff --git a/content/docs/latest/skewed-join-optimization_27847852.md b/content/Development/desingdocs/skewed-join-optimization_27847852.md
similarity index 100%
rename from content/docs/latest/skewed-join-optimization_27847852.md
rename to content/Development/desingdocs/skewed-join-optimization_27847852.md
diff --git a/content/docs/latest/spatial-queries_34022710.md b/content/Development/desingdocs/spatial-queries_34022710.md
similarity index 100%
rename from content/docs/latest/spatial-queries_34022710.md
rename to content/Development/desingdocs/spatial-queries_34022710.md
diff --git a/content/docs/latest/statsdev_27362062.md b/content/Development/desingdocs/statsdev_27362062.md
similarity index 100%
rename from content/docs/latest/statsdev_27362062.md
rename to content/Development/desingdocs/statsdev_27362062.md
diff --git a/content/docs/latest/storage-api-release-proposal_67635447.md b/content/Development/desingdocs/storage-api-release-proposal_67635447.md
similarity index 100%
rename from content/docs/latest/storage-api-release-proposal_67635447.md
rename to content/Development/desingdocs/storage-api-release-proposal_67635447.md
diff --git a/content/docs/latest/storagehandlers_27362063.md b/content/Development/desingdocs/storagehandlers_27362063.md
similarity index 100%
rename from content/docs/latest/storagehandlers_27362063.md
rename to content/Development/desingdocs/storagehandlers_27362063.md
diff --git a/content/docs/latest/subqueries-in-select_68717850.md b/content/Development/desingdocs/subqueries-in-select_68717850.md
similarity index 100%
rename from content/docs/latest/subqueries-in-select_68717850.md
rename to content/Development/desingdocs/subqueries-in-select_68717850.md
diff --git a/content/docs/latest/suggestion-for-ddl-commands-in-hms-schema-upgrade-scripts_138022168.md b/content/Development/desingdocs/suggestion-for-ddl-commands-in-hms-schema-upgrade-scripts_138022168.md
similarity index 100%
rename from content/docs/latest/suggestion-for-ddl-commands-in-hms-schema-upgrade-scripts_138022168.md
rename to content/Development/desingdocs/suggestion-for-ddl-commands-in-hms-schema-upgrade-scripts_138022168.md
diff --git a/content/docs/latest/synchronized-metastore-cache_110692851.md b/content/Development/desingdocs/synchronized-metastore-cache_110692851.md
similarity index 100%
rename from content/docs/latest/synchronized-metastore-cache_110692851.md
rename to content/Development/desingdocs/synchronized-metastore-cache_110692851.md
diff --git a/content/docs/latest/theta-join_33293991.md b/content/Development/desingdocs/theta-join_33293991.md
similarity index 100%
rename from content/docs/latest/theta-join_33293991.md
rename to content/Development/desingdocs/theta-join_33293991.md
diff --git a/content/docs/latest/top-k-stats_30150275.md b/content/Development/desingdocs/top-k-stats_30150275.md
similarity index 100%
rename from content/docs/latest/top-k-stats_30150275.md
rename to content/Development/desingdocs/top-k-stats_30150275.md
diff --git a/content/docs/latest/type-qualifiers-in-hive_33298524.md b/content/Development/desingdocs/type-qualifiers-in-hive_33298524.md
similarity index 100%
rename from content/docs/latest/type-qualifiers-in-hive_33298524.md
rename to content/Development/desingdocs/type-qualifiers-in-hive_33298524.md
diff --git a/content/docs/latest/updatableviews_27824044.md b/content/Development/desingdocs/updatableviews_27824044.md
similarity index 100%
rename from content/docs/latest/updatableviews_27824044.md
rename to content/Development/desingdocs/updatableviews_27824044.md
diff --git a/content/docs/latest/vectorized-query-execution_34838326.md b/content/Development/desingdocs/vectorized-query-execution_34838326.md
similarity index 100%
rename from content/docs/latest/vectorized-query-execution_34838326.md
rename to content/Development/desingdocs/vectorized-query-execution_34838326.md
diff --git a/content/docs/latest/viewdev_27362067.md b/content/Development/desingdocs/viewdev_27362067.md
similarity index 100%
rename from content/docs/latest/viewdev_27362067.md
rename to content/Development/desingdocs/viewdev_27362067.md
diff --git a/content/Development/gettingStarted.md b/content/Development/gettingStarted.md
index 631bf80..cac55f6 100644
--- a/content/Development/gettingStarted.md
+++ b/content/Development/gettingStarted.md
@@ -57,7 +57,7 @@ project and contribute your expertise.
 * Become a [Hive Fan on Facebook][HIVE_FACEBOOK]
 * Follow [@ApacheHive on Twitter][HIVE_TWITTER]
 
-[GETTING_STARTED]: https://cwiki.apache.org/confluence/display/Hive/GettingStarted
+[GETTING_STARTED]: /development/gettingstarted_27362090/
 [APACHE_HADOOP]: http://hadoop.apache.org
 [ISSUE_TRACKING]: /community/issuetracking/
 [MAILING_LISTS]: /community/mailinglists/
diff --git a/content/docs/latest/gettingstarted_27362090.md b/content/Development/gettingstarted_27362090.md
similarity index 100%
rename from content/docs/latest/gettingstarted_27362090.md
rename to content/Development/gettingstarted_27362090.md
diff --git a/content/community/meetings/_index.md b/content/community/meetings/_index.md
new file mode 100644
index 0000000..de61657
--- /dev/null
+++ b/content/community/meetings/_index.md
@@ -0,0 +1,4 @@
+---
+title: "Contributor Meetings"
+date: 2025-07-24
+---
diff --git a/content/docs/latest/contributorday2011_27820725.md b/content/community/meetings/contributorday2011_27820725.md
similarity index 100%
rename from content/docs/latest/contributorday2011_27820725.md
rename to content/community/meetings/contributorday2011_27820725.md
diff --git a/content/docs/latest/contributorminutes20110907_27826430.md b/content/community/meetings/contributorminutes20110907_27826430.md
similarity index 100%
rename from content/docs/latest/contributorminutes20110907_27826430.md
rename to content/community/meetings/contributorminutes20110907_27826430.md
diff --git a/content/docs/latest/contributorminutes20111205_27833038.md b/content/community/meetings/contributorminutes20111205_27833038.md
similarity index 100%
rename from content/docs/latest/contributorminutes20111205_27833038.md
rename to content/community/meetings/contributorminutes20111205_27833038.md
diff --git a/content/docs/latest/contributorminutes20120418_27844528.md b/content/community/meetings/contributorminutes20120418_27844528.md
similarity index 100%
rename from content/docs/latest/contributorminutes20120418_27844528.md
rename to content/community/meetings/contributorminutes20120418_27844528.md
diff --git a/content/docs/latest/contributorsminutes110726_27822784.md b/content/community/meetings/contributorsminutes110726_27822784.md
similarity index 100%
rename from content/docs/latest/contributorsminutes110726_27822784.md
rename to content/community/meetings/contributorsminutes110726_27822784.md
diff --git a/content/docs/latest/development-contributorsmeetings-hivecontributorsminutes100601_27362084.md b/content/community/meetings/development-contributorsmeetings-hivecontributorsminutes100601_27362084.md
similarity index 100%
rename from content/docs/latest/development-contributorsmeetings-hivecontributorsminutes100601_27362084.md
rename to content/community/meetings/development-contributorsmeetings-hivecontributorsminutes100601_27362084.md
diff --git a/content/docs/latest/development-contributorsmeetings-hivecontributorsminutes100706_27362085.md b/content/community/meetings/development-contributorsmeetings-hivecontributorsminutes100706_27362085.md
similarity index 100%
rename from content/docs/latest/development-contributorsmeetings-hivecontributorsminutes100706_27362085.md
rename to content/community/meetings/development-contributorsmeetings-hivecontributorsminutes100706_27362085.md
diff --git a/content/docs/latest/development-contributorsmeetings-hivecontributorsminutes100808_27362082.md b/content/community/meetings/development-contributorsmeetings-hivecontributorsminutes100808_27362082.md
similarity index 100%
rename from content/docs/latest/development-contributorsmeetings-hivecontributorsminutes100808_27362082.md
rename to content/community/meetings/development-contributorsmeetings-hivecontributorsminutes100808_27362082.md
diff --git a/content/docs/latest/development-contributorsmeetings-hivecontributorsminutes100913_27362083.md b/content/community/meetings/development-contributorsmeetings-hivecontributorsminutes100913_27362083.md
similarity index 100%
rename from content/docs/latest/development-contributorsmeetings-hivecontributorsminutes100913_27362083.md
rename to content/community/meetings/development-contributorsmeetings-hivecontributorsminutes100913_27362083.md
diff --git a/content/docs/latest/development-contributorsmeetings-hivecontributorsminutes101025_27362080.md b/content/community/meetings/development-contributorsmeetings-hivecontributorsminutes101025_27362080.md
similarity index 100%
rename from content/docs/latest/development-contributorsmeetings-hivecontributorsminutes101025_27362080.md
rename to content/community/meetings/development-contributorsmeetings-hivecontributorsminutes101025_27362080.md
diff --git a/content/docs/latest/development-contributorsmeetings-hivecontributorsminutes110425_27362081.md b/content/community/meetings/development-contributorsmeetings-hivecontributorsminutes110425_27362081.md
similarity index 100%
rename from content/docs/latest/development-contributorsmeetings-hivecontributorsminutes110425_27362081.md
rename to content/community/meetings/development-contributorsmeetings-hivecontributorsminutes110425_27362081.md
diff --git a/content/docs/latest/development-contributorsmeetings_27362087.md b/content/community/meetings/development-contributorsmeetings_27362087.md
similarity index 100%
rename from content/docs/latest/development-contributorsmeetings_27362087.md
rename to content/community/meetings/development-contributorsmeetings_27362087.md
diff --git a/content/docs/latest/hivecontributorsminutes100601_27362064.md b/content/community/meetings/hivecontributorsminutes100601_27362064.md
similarity index 100%
rename from content/docs/latest/hivecontributorsminutes100601_27362064.md
rename to content/community/meetings/hivecontributorsminutes100601_27362064.md
diff --git a/content/docs/latest/hivecontributorsminutes100706_27362065.md b/content/community/meetings/hivecontributorsminutes100706_27362065.md
similarity index 100%
rename from content/docs/latest/hivecontributorsminutes100706_27362065.md
rename to content/community/meetings/hivecontributorsminutes100706_27362065.md
diff --git a/content/docs/latest/282102318.md b/content/community/resources/282102318.md
similarity index 100%
rename from content/docs/latest/282102318.md
rename to content/community/resources/282102318.md
diff --git a/content/community/resources/_index.md b/content/community/resources/_index.md
new file mode 100644
index 0000000..9e710a4
--- /dev/null
+++ b/content/community/resources/_index.md
@@ -0,0 +1,4 @@
+---
+title: "Resources"
+date: 2025-07-24
+---
diff --git a/content/docs/latest/books-about-hive_61322063.md b/content/community/resources/books-about-hive_61322063.md
similarity index 100%
rename from content/docs/latest/books-about-hive_61322063.md
rename to content/community/resources/books-about-hive_61322063.md
diff --git a/content/docs/latest/building-hive-from-source_282102252.md b/content/community/resources/building-hive-from-source_282102252.md
similarity index 100%
rename from content/docs/latest/building-hive-from-source_282102252.md
rename to content/community/resources/building-hive-from-source_282102252.md
diff --git a/content/docs/latest/developerguide-udtf_27362086.md b/content/community/resources/developerguide-udtf_27362086.md
similarity index 100%
rename from content/docs/latest/developerguide-udtf_27362086.md
rename to content/community/resources/developerguide-udtf_27362086.md
diff --git a/content/docs/latest/developerguide_27362074.md b/content/community/resources/developerguide_27362074.md
similarity index 100%
rename from content/docs/latest/developerguide_27362074.md
rename to content/community/resources/developerguide_27362074.md
diff --git a/content/docs/latest/hive-apis-overview_61326349.md b/content/community/resources/hive-apis-overview_61326349.md
similarity index 100%
rename from content/docs/latest/hive-apis-overview_61326349.md
rename to content/community/resources/hive-apis-overview_61326349.md
diff --git a/content/docs/latest/hivedeveloperfaq_27823747.md b/content/community/resources/hivedeveloperfaq_27823747.md
similarity index 100%
rename from content/docs/latest/hivedeveloperfaq_27823747.md
rename to content/community/resources/hivedeveloperfaq_27823747.md
diff --git a/content/docs/latest/howtocommit_27362108.md b/content/community/resources/howtocommit_27362108.md
similarity index 100%
rename from content/docs/latest/howtocommit_27362108.md
rename to content/community/resources/howtocommit_27362108.md
diff --git a/content/docs/latest/howtocontribute_27362107.md b/content/community/resources/howtocontribute_27362107.md
similarity index 100%
rename from content/docs/latest/howtocontribute_27362107.md
rename to content/community/resources/howtocontribute_27362107.md
diff --git a/content/docs/latest/howtorelease_27362106.md b/content/community/resources/howtorelease_27362106.md
similarity index 100%
rename from content/docs/latest/howtorelease_27362106.md
rename to content/community/resources/howtorelease_27362106.md
diff --git a/content/docs/latest/metastore-api-tests_75958143.md b/content/community/resources/metastore-api-tests_75958143.md
similarity index 100%
rename from content/docs/latest/metastore-api-tests_75958143.md
rename to content/community/resources/metastore-api-tests_75958143.md
diff --git a/content/docs/latest/performance_27362052.md b/content/community/resources/performance_27362052.md
similarity index 100%
rename from content/docs/latest/performance_27362052.md
rename to content/community/resources/performance_27362052.md
diff --git a/content/docs/latest/plugindeveloperkit_27820324.md b/content/community/resources/plugindeveloperkit_27820324.md
similarity index 100%
rename from content/docs/latest/plugindeveloperkit_27820324.md
rename to content/community/resources/plugindeveloperkit_27820324.md
diff --git a/content/docs/latest/presentations_27362054.md b/content/community/resources/presentations_27362054.md
similarity index 100%
rename from content/docs/latest/presentations_27362054.md
rename to content/community/resources/presentations_27362054.md
diff --git a/content/docs/latest/relatedprojects_34836686.md b/content/community/resources/relatedprojects_34836686.md
similarity index 100%
rename from content/docs/latest/relatedprojects_34836686.md
rename to content/community/resources/relatedprojects_34836686.md
diff --git a/content/docs/latest/running-yetus_71012969.md b/content/community/resources/running-yetus_71012969.md
similarity index 100%
rename from content/docs/latest/running-yetus_71012969.md
rename to content/community/resources/running-yetus_71012969.md
diff --git a/content/docs/latest/testingdocs_42567126.md b/content/community/resources/testingdocs_42567126.md
similarity index 100%
rename from content/docs/latest/testingdocs_42567126.md
rename to content/community/resources/testingdocs_42567126.md
diff --git a/content/docs/latest/unit-testing-hive-sql_61328063.md b/content/community/resources/unit-testing-hive-sql_61328063.md
similarity index 100%
rename from content/docs/latest/unit-testing-hive-sql_61328063.md
rename to content/community/resources/unit-testing-hive-sql_61328063.md
diff --git a/content/docs/latest/_index.md b/content/docs/latest/_index.md
index c0bdc1b..f4ba6e0 100644
--- a/content/docs/latest/_index.md
+++ b/content/docs/latest/_index.md
@@ -1,292 +1,4 @@
 ---
-title: "Space Details:"
-date: 2024-12-12
+title: "Documentation"
+date: 2025-07-24
 ---
-
-## Available Pages:
-
-* [AdminManual]({{< ref "adminmanual_27362071" >}})
-* [AdminManual Configuration]({{< ref "adminmanual-configuration_27362070" >}})
-* [AdminManual Installation]({{< ref "adminmanual-installation_27362077" >}})
-* [AdminManual Metastore Administration]({{< ref "adminmanual-metastore-administration_27362076" >}})
-	+ [Hive MetaTool]({{< ref "hive-metatool_55156221" >}})
-	+ [Hive Schema Tool]({{< ref "hive-schema-tool_34835119" >}})
-* [AdminManual SettingUpHiveServer]({{< ref "adminmanual-settinguphiveserver_27362079" >}})
-	+ [Setting Up HiveServer2]({{< ref "setting-up-hiveserver2_30758712" >}})
-		- [User and Group Filter Support with LDAP Atn Provider in HiveServer2]({{< ref "user-and-group-filter-support-with-ldap-atn-provider-in-hiveserver2_58852417" >}})
-* [AuthDev]({{< ref "authdev_27362078" >}})
-* [CompressedStorage]({{< ref "compressedstorage_27362073" >}})
-* [Design]({{< ref "design_27362072" >}})
-* [DesignDocs]({{< ref "designdocs_27362075" >}})
-	+ [AccessServer Design Proposal]({{< ref "accessserver-design-proposal_31823045" >}})
-	+ [Binary DataType Proposal]({{< ref "binary-datatype-proposal_27826614" >}})
-	+ [Column Statistics in Hive]({{< ref "column-statistics-in-hive_29131019" >}})
-	+ [Correlation Optimizer]({{< ref "correlation-optimizer_34019487" >}})
-	+ [Cost-based optimization in Hive]({{< ref "cost-based-optimization-in-hive_42566775" >}})
-	+ [DynamicPartitions]({{< ref "dynamicpartitions_27823715" >}})
-	+ [GroupByWithRollup]({{< ref "groupbywithrollup_27826238" >}})
-	+ [Hive on Spark]({{< ref "hive-on-spark_42567714" >}})
-	+ [Hive on Spark: Join Design Master]({{< ref "50858744" >}})
-	+ [Hive on Tez]({{< ref "hive-on-tez_33296197" >}})
-		- [Hive-Tez Compatibility]({{< ref "hive-tez-compatibility_59689974" >}})
-	+ [HiveReplicationDevelopment]({{< ref "hivereplicationdevelopment_55155632" >}})
-	+ [HiveServer2 Thrift API]({{< ref "hiveserver2-thrift-api_27843687" >}})
-	+ [Hybrid Hybrid Grace Hash Join, v1.0]({{< ref "50860526" >}})
-	+ [IndexDev]({{< ref "indexdev_27362104" >}})
-	+ [Links]({{< ref "links_27847416" >}})
-	+ [ListBucketing]({{< ref "listbucketing_27846854" >}})
-	+ [LLAP]({{< ref "llap_62689557" >}})
-	+ [Locking]({{< ref "locking_27362050" >}})
-		- [Hive across Multiple Data Centers (Physical Clusters)]({{< ref "27837073" >}})
-	+ [MapJoin and Partition Pruning]({{< ref "mapjoin-and-partition-pruning_34015666" >}})
-	+ [OuterJoinBehavior]({{< ref "outerjoinbehavior_35749927" >}})
-	+ [PartitionedViews]({{< ref "partitionedviews_27362053" >}})
-	+ [Skewed Join Optimization]({{< ref "skewed-join-optimization_27847852" >}})
-		- [Union Optimization]({{< ref "union-optimization_29688910" >}})
-	+ [Spatial queries]({{< ref "spatial-queries_34022710" >}})
-	+ [Theta Join]({{< ref "theta-join_33293991" >}})
-	+ [Top K Stats]({{< ref "top-k-stats_30150275" >}})
-	+ [Transitivity on predicate pushdown]({{< ref "transitivity-on-predicate-pushdown_27823388" >}})
-	+ [Type Qualifiers in Hive]({{< ref "type-qualifiers-in-hive_33298524" >}})
-	+ [Vectorized Query Execution]({{< ref "vectorized-query-execution_34838326" >}})
-	+ [ViewDev]({{< ref "viewdev_27362067" >}})
-		- [UpdatableViews]({{< ref "updatableviews_27824044" >}})
-	+ [HiveReplicationv2Development]({{< ref "hivereplicationv2development_66850051" >}})
-	+ [Subqueries in SELECT]({{< ref "subqueries-in-select_68717850" >}})
-	+ [Query Results Caching (HIVE-18513)]({{< ref "75963441" >}})
-	+ [Default Constraint (HIVE-18726)]({{< ref "75969407" >}})
-		- [DEFAULT Keyword (HIVE-19059)]({{< ref "75977362" >}})
-	+ [Hive remote databases/tables]({{< ref "80452092" >}})
-	+ [Different TIMESTAMP types]({{< ref "different-timestamp-types_103091503" >}})
-	+ [HIVE-24543: Support SAML 2.0 authentication mode]({{< ref "170266662" >}})
-* [DeveloperGuide]({{< ref "developerguide_27362074" >}})
-* [DeveloperGuide UDTF]({{< ref "developerguide-udtf_27362086" >}})
-* [Development ContributorsMeetings]({{< ref "development-contributorsmeetings_27362087" >}})
-	+ [ContributorDay2011]({{< ref "contributorday2011_27820725" >}})
-	+ [ContributorMinutes20110907]({{< ref "contributorminutes20110907_27826430" >}})
-	+ [ContributorMinutes20111205]({{< ref "contributorminutes20111205_27833038" >}})
-	+ [ContributorMinutes20120418]({{< ref "contributorminutes20120418_27844528" >}})
-	+ [ContributorsMinutes110726]({{< ref "contributorsminutes110726_27822784" >}})
-* [Development ContributorsMeetings HiveContributorsMinutes100601]({{< ref "development-contributorsmeetings-hivecontributorsminutes100601_27362084" >}})
-* [Development ContributorsMeetings HiveContributorsMinutes100706]({{< ref "development-contributorsmeetings-hivecontributorsminutes100706_27362085" >}})
-* [Development ContributorsMeetings HiveContributorsMinutes100808]({{< ref "development-contributorsmeetings-hivecontributorsminutes100808_27362082" >}})
-* [Development ContributorsMeetings HiveContributorsMinutes100913]({{< ref "development-contributorsmeetings-hivecontributorsminutes100913_27362083" >}})
-* [Development ContributorsMeetings HiveContributorsMinutes101025]({{< ref "development-contributorsmeetings-hivecontributorsminutes101025_27362080" >}})
-* [Development ContributorsMeetings HiveContributorsMinutes110425]({{< ref "development-contributorsmeetings-hivecontributorsminutes110425_27362081" >}})
-* [User FAQ]({{< ref "user-faq_27362095" >}})
-* [FilterPushdownDev]({{< ref "filterpushdowndev_27362092" >}})
-* [GenericUDAFCaseStudy]({{< ref "genericudafcasestudy_27362093" >}})
-* [GettingStarted]({{< ref "gettingstarted_27362090" >}})
-* [GettingStarted EclipseSetup]({{< ref "gettingstarted-eclipsesetup_27362091" >}})
-* [HBaseBulkLoad]({{< ref "hbasebulkload_27362088" >}})
-* [HBaseIntegration]({{< ref "hbaseintegration_27362089" >}})
-* [HiveAws]({{< ref "hiveaws_27362103" >}})
-* [HiveAws HivingS3nRemotely]({{< ref "hiveaws-hivings3nremotely_27362102" >}})
-* [HiveClient]({{< ref "hiveclient_27362101" >}})
-* [HiveContributorsMinutes100601]({{< ref "hivecontributorsminutes100601_27362064" >}})
-* [HiveContributorsMinutes100706]({{< ref "hivecontributorsminutes100706_27362065" >}})
-* [HiveDerbyServerMode]({{< ref "hivederbyservermode_27362068" >}})
-* [HiveJDBCInterface]({{< ref "hivejdbcinterface_27362100" >}})
-* [HiveODBC]({{< ref "hiveodbc_27362099" >}})
-* [HivePlugins]({{< ref "hiveplugins_27362098" >}})
-	+ [ReflectUDF]({{< ref "reflectudf_30754716" >}})
-* [HiveQL]({{< ref "hiveql_27362097" >}})
-* [HiveServer]({{< ref "hiveserver_27362111" >}})
-* [Home]({{< ref "home_27362069" >}})
-![](images/icons/contenttypes/home_page_16.png)
-	+ [AccumuloIntegration]({{< ref "accumulointegration_46633569" >}})
-	+ [AdminManual Metastore 3.0 Administration]({{< ref "adminmanual-metastore-3-0-administration_75978150" >}})
-	+ [Apache Hive 4.0.X]({{< ref "apache-hive-4-0-x_282102245" >}})
-		- [Books, Blogs & Talks]({{< ref "282102318" >}})
-		- [Building Hive from Source]({{< ref "building-hive-from-source_282102252" >}})
-		- [ChangeLog]({{< ref "changelog_283118275" >}})
-		- [Copy of Hive Schema Tool - [TODO: move it under a 4.0 admin manual page, find a proper name]]({{< ref "284790216" >}})
-		- [Hive Configurations]({{< ref "hive-configurations_283118321" >}})
-		- [Hive-Iceberg Integration]({{< ref "hive-iceberg-integration_282102247" >}})
-		- [Hive Operators]({{< ref "hive-operators_283118406" >}})
-		- [Hive Transactions (Hive ACID)]({{< ref "283118453" >}})
-			* [HCatalog Streaming Mutation API (Copy)]({{< ref "283118454" >}})
-		- [Hive UDFs]({{< ref "hive-udfs_282102277" >}})
-		- [Introduction to Apache Hive]({{< ref "introduction-to-apache-hive_283118337" >}})
-		- [Manual Installation]({{< ref "manual-installation_283118363" >}})
-		- [Materialized views in Hive]({{< ref "materialized-views-in-hive_283118346" >}})
-		- [Overview of Major Changes]({{< ref "overview-of-major-changes_283118379" >}})
-		- [Setting Up Hive with Docker]({{< ref "setting-up-hive-with-docker_282102281" >}})
-	+ [Apache Hive SQL Conformance]({{< ref "apache-hive-sql-conformance_67641449" >}})
-		- [Supported Features: Apache Hive 2.1]({{< ref "67641451" >}})
-		- [Supported Features: Apache Hive 2.3]({{< ref "73632935" >}})
-		- [Supported Features: Apache Hive 3.1]({{< ref "97551656" >}})
-	+ [AvroSerDe]({{< ref "avroserde_27850707" >}})
-	+ [Books about Hive]({{< ref "books-about-hive_61322063" >}})
-	+ [CSV Serde]({{< ref "csv-serde_48202659" >}})
-	+ [Dependent Tables]({{< ref "dependent-tables_30151205" >}})
-	+ [DeveloperDocs]({{< ref "developerdocs_42568263" >}})
-	+ [Druid Integration]({{< ref "druid-integration_65866491" >}})
-	+ [Enabling gRPC in Hive/Hive Metastore (Proposal)]({{< ref "158869886" >}})
-	+ [Hadoop-compatible Input-Output Format for Hive]({{< ref "hadoop-compatible-input-output-format-for-hive_30745805" >}})
-	+ [HiveAmazonElasticMapReduce]({{< ref "hiveamazonelasticmapreduce_27825646" >}})
-	+ [Hive APIs Overview]({{< ref "hive-apis-overview_61326349" >}})
-	+ [Hive Aws EMR]({{< ref "hive-aws-emr_27823791" >}})
-	+ [HiveCounters]({{< ref "hivecounters_67636835" >}})
-	+ [HiveDeveloperFAQ]({{< ref "hivedeveloperfaq_27823747" >}})
-	+ [Hive Metadata Caching Proposal]({{< ref "hive-metadata-caching-proposal_69407514" >}})
-	+ [Hive on Spark: Getting Started]({{< ref "44302539" >}})
-	+ [HiveServer2 Clients]({{< ref "hiveserver2-clients_30758725" >}})
-		- [Replacing the Implementation of Hive CLI Using Beeline]({{< ref "replacing-the-implementation-of-hive-cli-using-beeline_61311909" >}})
-	+ [HiveServer2 Overview]({{< ref "hiveserver2-overview_65147648" >}})
-		- [Hive Metrics]({{< ref "hive-metrics_65872987" >}})
-	+ [Hive Transactions]({{< ref "hive-transactions_40509723" >}})
-		- [HCatalog Streaming Mutation API]({{< ref "hcatalog-streaming-mutation-api_61337025" >}})
-	+ [JDBC Storage Handler]({{< ref "jdbc-storage-handler_95651916" >}})
-	+ [Kudu Integration]({{< ref "kudu-integration_133631955" >}})
-	+ [Materialized views]({{< ref "materialized-views_80447331" >}})
-	+ [Metastore TLP Proposal]({{< ref "metastore-tlp-proposal_71013238" >}})
-	+ [OperatorsAndFunctions]({{< ref "operatorsandfunctions_30754909" >}})
-	+ [Permission Inheritance in Hive]({{< ref "permission-inheritance-in-hive_48203008" >}})
-	+ [PluginDeveloperKit]({{< ref "plugindeveloperkit_27820324" >}})
-	+ [Query ReExecution]({{< ref "query-reexecution_87298873" >}})
-	+ [RCFileCat]({{< ref "rcfilecat_30748712" >}})
-	+ [RelatedProjects]({{< ref "relatedprojects_34836686" >}})
-	+ [Replication]({{< ref "replication_61336919" >}})
-	+ [StarRocks Integration]({{< ref "starrocks-integration_272927528" >}})
-	+ [Streaming Data Ingest]({{< ref "streaming-data-ingest_40509746" >}})
-	+ [Streaming Data Ingest V2]({{< ref "streaming-data-ingest-v2_85477610" >}})
-	+ [Suggestion for DDL Commands in HMS schema upgrade scripts]({{< ref "suggestion-for-ddl-commands-in-hms-schema-upgrade-scripts_138022168" >}})
-	+ [Synchronized Metastore Cache]({{< ref "synchronized-metastore-cache_110692851" >}})
-	+ [TeradataBinarySerde]({{< ref "teradatabinaryserde_89068127" >}})
-	+ [TestingDocs]({{< ref "testingdocs_42567126" >}})
-		- [MetaStore API Tests]({{< ref "metastore-api-tests_75958143" >}})
-		- [Running Yetus]({{< ref "running-yetus_71012969" >}})
-	+ [Unit Testing Hive SQL]({{< ref "unit-testing-hive-sql_61328063" >}})
-	+ [Using TiDB as the Hive Metastore database]({{< ref "using-tidb-as-the-hive-metastore-database_158872426" >}})
-* [Howl]({{< ref "howl_27362109" >}})
-* [HowToCommit]({{< ref "howtocommit_27362108" >}})
-* [HowToContribute]({{< ref "howtocontribute_27362107" >}})
-	+ [HBaseMetastoreDevelopmentGuide]({{< ref "hbasemetastoredevelopmentguide_55151960" >}})
-		- [Hbase execution plans for RawStore partition filter condition]({{< ref "hbase-execution-plans-for-rawstore-partition-filter-condition_55151993" >}})
-* [HowToRelease]({{< ref "howtorelease_27362106" >}})
-	+ [Storage API Release Proposal]({{< ref "storage-api-release-proposal_67635447" >}})
-* [IndexDev Bitmap]({{< ref "indexdev-bitmap_27362028" >}})
-* [MapJoinOptimization]({{< ref "mapjoinoptimization_27362029" >}})
-* [LanguageManual]({{< ref "languagemanual_27362030" >}})
-	+ [LanguageManual Cli]({{< ref "languagemanual-cli_27362033" >}})
-	+ [LanguageManual DDL]({{< ref "languagemanual-ddl_27362034" >}})
-		- [LanguageManual DDL BucketedTables]({{< ref "languagemanual-ddl-bucketedtables_27362035" >}})
-		- [Managed vs. External Tables]({{< ref "managed-vs--external-tables_95654003" >}})
-		- [Scheduled Queries]({{< ref "scheduled-queries_145724128" >}})
-		- [Datasketches Integration]({{< ref "datasketches-integration_177050456" >}})
-		- [Data Connectors in Hive]({{< ref "data-connectors-in-hive_177049669" >}})
-			* [Data Connector for Hive and Hive-like engines]({{< ref "data-connector-for-hive-and-hive-like-engines_288885794" >}})
-		- [Compaction pooling]({{< ref "compaction-pooling_240884493" >}})
-		- [Rebalance compaction]({{< ref "rebalance-compaction_240884502" >}})
-		- [Exchange Partition]({{< ref "exchange-partition_30755801" >}})
-	+ [LanguageManual DML]({{< ref "languagemanual-dml_27362036" >}})
-	+ [LanguageManual Select]({{< ref "languagemanual-select_27362043" >}})
-		- [Common Table Expression]({{< ref "common-table-expression_38572242" >}})
-		- [Partition Filter Syntax]({{< ref "partition-filter-syntax_103092177" >}})
-	+ [LanguageManual Joins]({{< ref "languagemanual-joins_27362039" >}})
-	+ [LanguageManual LateralView]({{< ref "languagemanual-lateralview_27362040" >}})
-	+ [LanguageManual Union]({{< ref "languagemanual-union_27362049" >}})
-	+ [LanguageManual SubQueries]({{< ref "languagemanual-subqueries_27362044" >}})
-	+ [LanguageManual Sampling]({{< ref "languagemanual-sampling_27362042" >}})
-	+ [LanguageManual Explain]({{< ref "languagemanual-explain_27362037" >}})
-	+ [LanguageManual VirtualColumns]({{< ref "languagemanual-virtualcolumns_27362048" >}})
-	+ [Configuration Properties]({{< ref "configuration-properties_27842758" >}})
-	+ [LanguageManual ImportExport]({{< ref "languagemanual-importexport_27837968" >}})
-	+ [LanguageManual Authorization]({{< ref "languagemanual-authorization_27362032" >}})
-		- [Storage Based Authorization in the Metastore Server]({{< ref "storage-based-authorization-in-the-metastore-server_45876440" >}})
-		- [SQL Standard Based Hive Authorization]({{< ref "sql-standard-based-hive-authorization_40509928" >}})
-		- [Hive deprecated authorization mode / Legacy Mode]({{< ref "45876173" >}})
-	+ [LanguageManual Types]({{< ref "languagemanual-types_27838462" >}})
-		- [CAST...FORMAT with SQL:2016 datetime formats]({{< ref "122917025" >}})
-	+ [Literals]({{< ref "literals_27829682" >}})
-	+ [LanguageManual VariableSubstitution]({{< ref "languagemanual-variablesubstitution_30754722" >}})
-	+ [LanguageManual ORC]({{< ref "languagemanual-orc_31818911" >}})
-	+ [LanguageManual WindowingAndAnalytics]({{< ref "languagemanual-windowingandanalytics_31819589" >}})
-	+ [LanguageManual Indexing]({{< ref "languagemanual-indexing_31822176" >}})
-	+ [LanguageManual JoinOptimization]({{< ref "languagemanual-joinoptimization_33293167" >}})
-	+ [LanguageManual LZO]({{< ref "languagemanual-lzo_33298193" >}})
-	+ [LanguageManual Commands]({{< ref "languagemanual-commands_34838882" >}})
-	+ [Parquet]({{< ref "parquet_38570914" >}})
-	+ [Enhanced Aggregation, Cube, Grouping and Rollup]({{< ref "30151323" >}})
-	+ [FileFormats]({{< ref "fileformats_47384180" >}})
-		- [RCFile]({{< ref "rcfile_58851803" >}})
-	+ [Hive HPL/SQL]({{< ref "59690156" >}})
-* [LanguageManual Archiving]({{< ref "languagemanual-archiving_27362031" >}})
-* [LanguageManual GroupBy]({{< ref "languagemanual-groupby_27362038" >}})
-* [LanguageManual Locks]({{< ref "locking_27362050.md" >}})
-* [LanguageManual SortBy]({{< ref "languagemanual-sortby_27362045" >}})
-* [LanguageManual Transform]({{< ref "languagemanual-transform_27362047" >}})
-* [LanguageManual UDF]({{< ref "languagemanual-udf_27362046" >}})
-* [LanguageManual XPathUDF]({{< ref "languagemanual-xpathudf_27362051" >}})
-* [HCatalog]({{< ref "hcatalog_33299065" >}})
-	+ [HCatalog UsingHCat]({{< ref "hcatalog-usinghcat_34013260" >}})
-	+ [HCatalog InstallHCat]({{< ref "hcatalog-installhcat_34013403" >}})
-	+ [HCatalog LoadStore]({{< ref "hcatalog-loadstore_34013511" >}})
-	+ [HCatalog InputOutput]({{< ref "hcatalog-inputoutput_34013776" >}})
-	+ [HCatalog ReaderWriter]({{< ref "hcatalog-readerwriter_34013921" >}})
-	+ [HCatalog CLI]({{< ref "hcatalog-cli_34013932" >}})
-	+ [HCatalog StorageFormats]({{< ref "hcatalog-storageformats_34013997" >}})
-	+ [HCatalog DynamicPartitions]({{< ref "hcatalog-dynamicpartitions_34014006" >}})
-	+ [HCatalog Notification]({{< ref "hcatalog-notification_34014558" >}})
-	+ [HCatalog Authorization]({{< ref "hcatalog-authorization_34014782" >}})
-	+ [HCatalog Configuration Properties]({{< ref "hcatalog-configuration-properties_39622369" >}})
-* [WebHCat]({{< ref "webhcat_33299069" >}})
-	+ [WebHCat UsingWebHCat]({{< ref "webhcat-usingwebhcat_34015492" >}})
-	+ [WebHCat InstallWebHCat]({{< ref "webhcat-installwebhcat_34015585" >}})
-	+ [WebHCat Configure]({{< ref "webhcat-configure_34015738" >}})
-	+ [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}})
-		- [WebHCat Reference ResponseTypes]({{< ref "webhcat-reference-responsetypes_34015937" >}})
-		- [WebHCat Reference Status]({{< ref "webhcat-reference-status_34015941" >}})
-		- [WebHCat Reference Version]({{< ref "webhcat-reference-version_34015986" >}})
-		- [WebHCat Reference VersionHive]({{< ref "webhcat-reference-versionhive_44303406" >}})
-		- [WebHCat Reference VersionHadoop]({{< ref "webhcat-reference-versionhadoop_44303410" >}})
-		- [WebHCat Reference AllDDL]({{< ref "webhcat-reference-allddl_34016001" >}})
-			* [WebHCat Reference DDL]({{< ref "webhcat-reference-ddl_34015990" >}})
-			* [WebHCat Reference GetDBs]({{< ref "webhcat-reference-getdbs_34016238" >}})
-			* [WebHCat Reference GetDB]({{< ref "webhcat-reference-getdb_34016250" >}})
-			* [WebHCat Reference PutDB]({{< ref "webhcat-reference-putdb_34016273" >}})
-			* [WebHCat Reference DeleteDB]({{< ref "webhcat-reference-deletedb_34016281" >}})
-			* [WebHCat Reference GetTables]({{< ref "webhcat-reference-gettables_34016290" >}})
-			* [WebHCat Reference GetTable]({{< ref "webhcat-reference-gettable_34016519" >}})
-			* [WebHCat Reference PutTable]({{< ref "webhcat-reference-puttable_34016540" >}})
-			* [WebHCat Reference PostTable]({{< ref "webhcat-reference-posttable_34016548" >}})
-			* [WebHCat Reference DeleteTable]({{< ref "webhcat-reference-deletetable_34016561" >}})
-			* [WebHCat Reference PutTableLike]({{< ref "webhcat-reference-puttablelike_34016572" >}})
-			* [WebHCat Reference GetPartitions]({{< ref "webhcat-reference-getpartitions_34016583" >}})
-			* [WebHCat Reference GetPartition]({{< ref "webhcat-reference-getpartition_34016592" >}})
-			* [WebHCat Reference PutPartition]({{< ref "webhcat-reference-putpartition_34016600" >}})
-			* [WebHCat Reference DeletePartition]({{< ref "webhcat-reference-deletepartition_34016611" >}})
-			* [WebHCat Reference GetColumns]({{< ref "webhcat-reference-getcolumns_34016970" >}})
-			* [WebHCat Reference GetColumn]({{< ref "webhcat-reference-getcolumn_34016979" >}})
-			* [WebHCat Reference PutColumn]({{< ref "webhcat-reference-putcolumn_34016987" >}})
-			* [WebHCat Reference GetProperties]({{< ref "webhcat-reference-getproperties_34016995" >}})
-			* [WebHCat Reference GetProperty]({{< ref "webhcat-reference-getproperty_34017004" >}})
-			* [WebHCat Reference PutProperty]({{< ref "webhcat-reference-putproperty_34017012" >}})
-		- [WebHCat Reference MapReduceStream]({{< ref "webhcat-reference-mapreducestream_34017023" >}})
-		- [WebHCat Reference MapReduceJar]({{< ref "webhcat-reference-mapreducejar_34017030" >}})
-		- [WebHCat Reference Pig]({{< ref "webhcat-reference-pig_34017169" >}})
-		- [WebHCat Reference Hive]({{< ref "webhcat-reference-hive_34017180" >}})
-		- [WebHCat Reference JobIDs]({{< ref "webhcat-reference-jobids_34017187" >}})
-		- [WebHCat Reference JobInfo]({{< ref "webhcat-reference-jobinfo_34017194" >}})
-		- [WebHCat Reference DeleteJob]({{< ref "webhcat-reference-deletejob_34017204" >}})
-		- [WebHCat Reference Jobs]({{< ref "webhcat-reference-jobs_34835057" >}})
-		- [WebHCat Reference Job]({{< ref "webhcat-reference-job_34835065" >}})
-		- [WebHCat Reference DeleteJobID]({{< ref "webhcat-reference-deletejobid_34835045" >}})
-* [Performance]({{< ref "performance_27362052" >}})
-* [PoweredBy]({{< ref "poweredby_27362055" >}})
-* [Presentations]({{< ref "presentations_27362054" >}})
-* [Roadmap]({{< ref "roadmap_27362057" >}})
-* [Security]({{< ref "security_27362056" >}})
-* [SerDe]({{< ref "serde_27362059" >}})
-	+ [MultiDelimitSerDe]({{< ref "multidelimitserde_46631999" >}})
-	+ [UserGuide]({{< ref "userguide_27362066" >}})
-* [StatisticsAndDataMining]({{< ref "statisticsanddatamining_27362058" >}})
-* [StatsDev]({{< ref "statsdev_27362062" >}})
-* [StorageHandlers]({{< ref "storagehandlers_27362063" >}})
-* [Tutorial]({{< ref "tutorial_27362061" >}})
-
- 
-
- 
-
diff --git a/content/docs/latest/284790216.md b/content/docs/latest/admin/284790216.md
similarity index 100%
rename from content/docs/latest/284790216.md
rename to content/docs/latest/admin/284790216.md
diff --git a/content/docs/latest/44302539.md b/content/docs/latest/admin/44302539.md
similarity index 100%
rename from content/docs/latest/44302539.md
rename to content/docs/latest/admin/44302539.md
diff --git a/content/docs/latest/admin/_index.md b/content/docs/latest/admin/_index.md
new file mode 100644
index 0000000..04dd41a
--- /dev/null
+++ b/content/docs/latest/admin/_index.md
@@ -0,0 +1,4 @@
+---
+title: "Administration Manual"
+date: 2025-07-24
+---
diff --git a/content/docs/latest/adminmanual-configuration_27362070.md b/content/docs/latest/admin/adminmanual-configuration_27362070.md
similarity index 100%
rename from content/docs/latest/adminmanual-configuration_27362070.md
rename to content/docs/latest/admin/adminmanual-configuration_27362070.md
diff --git a/content/docs/latest/adminmanual-installation_27362077.md b/content/docs/latest/admin/adminmanual-installation_27362077.md
similarity index 100%
rename from content/docs/latest/adminmanual-installation_27362077.md
rename to content/docs/latest/admin/adminmanual-installation_27362077.md
diff --git a/content/docs/latest/adminmanual-metastore-3-0-administration_75978150.md b/content/docs/latest/admin/adminmanual-metastore-3-0-administration_75978150.md
similarity index 100%
rename from content/docs/latest/adminmanual-metastore-3-0-administration_75978150.md
rename to content/docs/latest/admin/adminmanual-metastore-3-0-administration_75978150.md
diff --git a/content/docs/latest/adminmanual-metastore-administration_27362076.md b/content/docs/latest/admin/adminmanual-metastore-administration_27362076.md
similarity index 100%
rename from content/docs/latest/adminmanual-metastore-administration_27362076.md
rename to content/docs/latest/admin/adminmanual-metastore-administration_27362076.md
diff --git a/content/docs/latest/adminmanual-settinguphiveserver_27362079.md b/content/docs/latest/admin/adminmanual-settinguphiveserver_27362079.md
similarity index 100%
rename from content/docs/latest/adminmanual-settinguphiveserver_27362079.md
rename to content/docs/latest/admin/adminmanual-settinguphiveserver_27362079.md
diff --git a/content/docs/latest/adminmanual_27362071.md b/content/docs/latest/admin/adminmanual_27362071.md
similarity index 100%
rename from content/docs/latest/adminmanual_27362071.md
rename to content/docs/latest/admin/adminmanual_27362071.md
diff --git a/content/docs/latest/hive-metatool_55156221.md b/content/docs/latest/admin/hive-metatool_55156221.md
similarity index 100%
rename from content/docs/latest/hive-metatool_55156221.md
rename to content/docs/latest/admin/hive-metatool_55156221.md
diff --git a/content/docs/latest/hive-schema-tool_34835119.md b/content/docs/latest/admin/hive-schema-tool_34835119.md
similarity index 100%
rename from content/docs/latest/hive-schema-tool_34835119.md
rename to content/docs/latest/admin/hive-schema-tool_34835119.md
diff --git a/content/docs/latest/hiveamazonelasticmapreduce_27825646.md b/content/docs/latest/admin/hiveamazonelasticmapreduce_27825646.md
similarity index 100%
rename from content/docs/latest/hiveamazonelasticmapreduce_27825646.md
rename to content/docs/latest/admin/hiveamazonelasticmapreduce_27825646.md
diff --git a/content/docs/latest/hiveaws_27362103.md b/content/docs/latest/admin/hiveaws_27362103.md
similarity index 100%
rename from content/docs/latest/hiveaws_27362103.md
rename to content/docs/latest/admin/hiveaws_27362103.md
diff --git a/content/docs/latest/hivederbyservermode_27362068.md b/content/docs/latest/admin/hivederbyservermode_27362068.md
similarity index 100%
rename from content/docs/latest/hivederbyservermode_27362068.md
rename to content/docs/latest/admin/hivederbyservermode_27362068.md
diff --git a/content/docs/latest/hivejdbcinterface_27362100.md b/content/docs/latest/admin/hivejdbcinterface_27362100.md
similarity index 100%
rename from content/docs/latest/hivejdbcinterface_27362100.md
rename to content/docs/latest/admin/hivejdbcinterface_27362100.md
diff --git a/content/docs/latest/hiveodbc_27362099.md b/content/docs/latest/admin/hiveodbc_27362099.md
similarity index 99%
rename from content/docs/latest/hiveodbc_27362099.md
rename to content/docs/latest/admin/hiveodbc_27362099.md
index 55b0dbd..5a4a284 100644
--- a/content/docs/latest/hiveodbc_27362099.md
+++ b/content/docs/latest/admin/hiveodbc_27362099.md
@@ -18,9 +18,8 @@ The Hive ODBC Driver is a software library that implements the Open Database Con
 
 ### Suggested Reading
 
-This guide assumes you are already familiar with the following:
+This guide assumes you are already familiar with Hive and in particular with the following:
 
-* [Hive]({{< ref "home_27362069" >}})
 * [Hive Server]({{< ref "hiveserver_27362111" >}})
 * [Thrift](http://wiki.apache.org/thrift/)
 * [ODBC API](http://msdn.microsoft.com/en-us/library/ms714177(VS.85).aspx)
diff --git a/content/docs/latest/hiveserver_27362111.md b/content/docs/latest/admin/hiveserver_27362111.md
similarity index 100%
rename from content/docs/latest/hiveserver_27362111.md
rename to content/docs/latest/admin/hiveserver_27362111.md
diff --git a/content/docs/latest/manual-installation_283118363.md b/content/docs/latest/admin/manual-installation_283118363.md
similarity index 100%
rename from content/docs/latest/manual-installation_283118363.md
rename to content/docs/latest/admin/manual-installation_283118363.md
diff --git a/content/docs/latest/replication_61336919.md b/content/docs/latest/admin/replication_61336919.md
similarity index 100%
rename from content/docs/latest/replication_61336919.md
rename to content/docs/latest/admin/replication_61336919.md
diff --git a/content/docs/latest/setting-up-hive-with-docker_282102281.md b/content/docs/latest/admin/setting-up-hive-with-docker_282102281.md
similarity index 100%
rename from content/docs/latest/setting-up-hive-with-docker_282102281.md
rename to content/docs/latest/admin/setting-up-hive-with-docker_282102281.md
diff --git a/content/docs/latest/setting-up-hiveserver2_30758712.md b/content/docs/latest/admin/setting-up-hiveserver2_30758712.md
similarity index 100%
rename from content/docs/latest/setting-up-hiveserver2_30758712.md
rename to content/docs/latest/admin/setting-up-hiveserver2_30758712.md
diff --git a/content/docs/latest/user-and-group-filter-support-with-ldap-atn-provider-in-hiveserver2_58852417.md b/content/docs/latest/admin/user-and-group-filter-support-with-ldap-atn-provider-in-hiveserver2_58852417.md
similarity index 100%
rename from content/docs/latest/user-and-group-filter-support-with-ldap-atn-provider-in-hiveserver2_58852417.md
rename to content/docs/latest/admin/user-and-group-filter-support-with-ldap-atn-provider-in-hiveserver2_58852417.md
diff --git a/content/docs/latest/apache-hive-4-0-x_282102245.md b/content/docs/latest/apache-hive-4-0-x_282102245.md
deleted file mode 100644
index 19c653f..0000000
--- a/content/docs/latest/apache-hive-4-0-x_282102245.md
+++ /dev/null
@@ -1,41 +0,0 @@
----
-title: "Apache Hive : Apache Hive 4.0.X"
-date: 2024-12-12
----
-
-# Apache Hive : Apache Hive 4.0.X
-
-* [Overview of Major Changes]({{< ref "overview-of-major-changes_283118379" >}})
-* [ChangeLog](https://cwiki.apache.org/confluence/display/Hive/ChangeLog)
-* [Introduction to Apache Hive]({{< ref "introduction-to-apache-hive_283118337" >}})
-* [Building from Source](https://cwiki.apache.org/confluence/display/Hive/Building+Hive+from+Source)
-* Installing Hive
-	+ [From Docker](https://cwiki.apache.org/confluence/display/Hive/Setting+Up+Hive+with+Docker)
-	+ [Manual Installation]({{< ref "manual-installation_283118363" >}})
-* [HiveServer2 Overview]({{< ref "hiveserver2-overview_65147648" >}})
-* [HiveServer2 Clients]({{< ref "hiveserver2-clients_30758725" >}})
-* [AdminManual Metastore 3.0+ Administration]({{< ref "adminmanual-metastore-3-0-administration_75978150" >}})
-	+ [SchemaTool]({{< ref "284790216" >}})
-* [Supported Features: Apache Hive 3.1]({{< ref "97551656" >}})+
-* [Hive Metrics]({{< ref "hive-metrics_65872987" >}})
-* [HiveCounters]({{< ref "hivecounters_67636835" >}})
-* [Hive APIs Overview]({{< ref "hive-apis-overview_61326349" >}})
-* [UDFs]({{< ref "hive-udfs_282102277" >}})
-* [Operators]({{< ref "hive-operators_283118406" >}})
-* [Hive-Iceberg Integration](https://cwiki.apache.org/confluence/display/Hive/Hive-Iceberg+Integration)
-* [Accumulo Integration]({{< ref "accumulointegration_46633569" >}})
-* [Druid Integration]({{< ref "druid-integration_65866491" >}})
-* [Kudu Integration]({{< ref "kudu-integration_133631955" >}})
-* [Hive Transactions (HIVE ACID)]({{< ref "283118453" >}})
-* [JDBC Storage Handler]({{< ref "jdbc-storage-handler_95651916" >}})
-* [Materialized Views]({{< ref "materialized-views-in-hive_283118346" >}})
-* [Hive Replication](https://cwiki.apache.org/confluence/display/Hive/HiveReplicationv2Development)
-* [Streaming Data Ingest V2]({{< ref "streaming-data-ingest-v2_85477610" >}})
-* [Configuration Defaults](https://cwiki.apache.org/confluence/display/Hive/Configuration+Defaults)
-* [HiveDeveloperFAQ]({{< ref "hivedeveloperfaq_27823747" >}})
-* [Books, Blogs & Talks](https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=282102318)
-
- 
-
- 
-
diff --git a/content/docs/latest/developerdocs_42568263.md b/content/docs/latest/developerdocs_42568263.md
deleted file mode 100644
index dc73699..0000000
--- a/content/docs/latest/developerdocs_42568263.md
+++ /dev/null
@@ -1,29 +0,0 @@
----
-title: "Apache Hive : DeveloperDocs"
-date: 2024-12-12
----
-
-# Apache Hive : DeveloperDocs
-
-# Hive Developer Documentation
-
-Information for Hive developers is available in these documents:
-
-* [Hive Developer Guide]({{< ref "developerguide_27362074" >}})
-	+ [Code organization and architecture]({{< ref "#code-organization-and-architecture" >}})
-	+ [Compiling and running Hive]({{< ref "#compiling-and-running-hive" >}})
-	+ [Unit tests]({{< ref "#unit-tests" >}})
-	+ [Debugging Hive code]({{< ref "#debugging-hive-code" >}})
-	+ [Pluggable interfaces]({{< ref "#pluggable-interfaces" >}})
-* [Hive Developer FAQ]({{< ref "hivedeveloperfaq_27823747" >}})
-	+ [Moving files]({{< ref "#moving-files" >}})
-	+ [Building Hive]({{< ref "#building-hive" >}})
-	+ [Testing Hive]({{< ref "#testing-hive" >}})
-* [Plugin Developer Kit]({{< ref "plugindeveloperkit_27820324" >}})
-* [Writing UDTFs]({{< ref "developerguide-udtf_27362086" >}})
-* [Hive on Spark: Getting Started]({{< ref "44302539" >}})
-
- 
-
- 
-
diff --git a/content/docs/latest/gettingstarted-eclipsesetup_27362091.md b/content/docs/latest/gettingstarted-eclipsesetup_27362091.md
deleted file mode 100644
index ff7d58f..0000000
--- a/content/docs/latest/gettingstarted-eclipsesetup_27362091.md
+++ /dev/null
@@ -1,38 +0,0 @@
----
-title: "Apache Hive : GettingStarted EclipseSetup"
-date: 2024-12-12
----
-
-# Apache Hive : GettingStarted EclipseSetup
-
-Page does not apply to trunk
-
-The following page only applies to branch-0.12 and earlier. For trunk see [HiveDeveloperFAQ]({{< ref "hivedeveloperfaq_27823747" >}})
-
-After checking out the source code run the following command from the top-level directory:
-
-```
-$ ant clean package eclipse-files
-
-```
-
-Now open up Eclipse and do the following:
-
-* File->Import->General->Existing Projects Into Workspace->Select root directory (point to <top-level-directory>)
-
-Make sure that Eclipse Java Compiler is in 1.6 compatibility mode:
-
-* Project->Properties->Java Compiler->(Check)Enable project specific settings->(Change to 1.6)Compiler compliance level
-
-This should import the project and the launch configurations. You can run the Hive CLI from within Eclipse by right clicking on the HiveCLI launch configuration and selecting "Run". You can also look for JUnit launch configurations by checking:
-
-* Run->Run Configurations->JUnit.
-
-There should be several configurations including `TestCliDriver`, `TestJdbc`, and `TestHive`.
-
-Then, you should be able to run all the unit tests by Run->Run.
-
- 
-
- 
-
diff --git a/content/docs/latest/283118454.md b/content/docs/latest/hcatalog/283118454.md
similarity index 100%
rename from content/docs/latest/283118454.md
rename to content/docs/latest/hcatalog/283118454.md
diff --git a/content/docs/latest/hcatalog/_index.md b/content/docs/latest/hcatalog/_index.md
new file mode 100644
index 0000000..ca903b2
--- /dev/null
+++ b/content/docs/latest/hcatalog/_index.md
@@ -0,0 +1,4 @@
+---
+title: "HCatalog Manual"
+date: 2025-07-24
+---
diff --git a/content/docs/latest/hcatalog-authorization_34014782.md b/content/docs/latest/hcatalog/hcatalog-authorization_34014782.md
similarity index 97%
rename from content/docs/latest/hcatalog-authorization_34014782.md
rename to content/docs/latest/hcatalog/hcatalog-authorization_34014782.md
index 17c7584..518c026 100644
--- a/content/docs/latest/hcatalog-authorization_34014782.md
+++ b/content/docs/latest/hcatalog/hcatalog-authorization_34014782.md
@@ -131,7 +131,7 @@ Previous: [Notification]({{< ref "hcatalog-notification_34014558" >}})
 
 Hive documents: [Authorization]({{< ref "languagemanual-authorization_27362032" >}}) and [Storage Based Authorization in the Metastore Server]({{< ref "storage-based-authorization-in-the-metastore-server_45876440" >}})
 
-General: [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/hcatalog-cli_34013932.md b/content/docs/latest/hcatalog/hcatalog-cli_34013932.md
similarity index 96%
rename from content/docs/latest/hcatalog-cli_34013932.md
rename to content/docs/latest/hcatalog/hcatalog-cli_34013932.md
index 7a2bcd8..10e62f3 100644
--- a/content/docs/latest/hcatalog-cli_34013932.md
+++ b/content/docs/latest/hcatalog/hcatalog-cli_34013932.md
@@ -161,7 +161,7 @@ Hive command line interface: [Hive CLI]({{< ref "languagemanual-cli_27362033" >}
  Hive DDL commands: [Hive Data Definition Language]({{< ref "languagemanual-ddl_27362034" >}})  
  WebHCat DDL resources: [WebHCat Reference: DDL]({{< ref "webhcat-reference-allddl_34016001" >}})
 
-General: [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/hcatalog-configuration-properties_39622369.md b/content/docs/latest/hcatalog/hcatalog-configuration-properties_39622369.md
similarity index 97%
rename from content/docs/latest/hcatalog-configuration-properties_39622369.md
rename to content/docs/latest/hcatalog/hcatalog-configuration-properties_39622369.md
index 6f3a64b..b0e40d4 100644
--- a/content/docs/latest/hcatalog-configuration-properties_39622369.md
+++ b/content/docs/latest/hcatalog/hcatalog-configuration-properties_39622369.md
@@ -61,7 +61,7 @@ While reading, it is understandable that data might contain errors, but we may n
 Previous: [Installation from Tarball]({{< ref "hcatalog-installhcat_34013403" >}})  
 Next: [Load and Store Interfaces]({{< ref "hcatalog-loadstore_34013511" >}})
 
-General: [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/hcatalog-dynamicpartitions_34014006.md b/content/docs/latest/hcatalog/hcatalog-dynamicpartitions_34014006.md
similarity index 97%
rename from content/docs/latest/hcatalog-dynamicpartitions_34014006.md
rename to content/docs/latest/hcatalog/hcatalog-dynamicpartitions_34014006.md
index 3eba675..bfbc0bc 100644
--- a/content/docs/latest/hcatalog-dynamicpartitions_34014006.md
+++ b/content/docs/latest/hcatalog/hcatalog-dynamicpartitions_34014006.md
@@ -150,7 +150,7 @@ Hive design document: [Dynamic Partitions]({{< ref "dynamicpartitions_27823715"
  Hive tutorial: [Dynamic-Partition Insert]({{< ref "#dynamic-partition-insert" >}})  
  Hive DML: [Dynamic Partition Inserts]({{< ref "#dynamic-partition-inserts" >}})
 
-General: [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/hcatalog-inputoutput_34013776.md b/content/docs/latest/hcatalog/hcatalog-inputoutput_34013776.md
similarity index 98%
rename from content/docs/latest/hcatalog-inputoutput_34013776.md
rename to content/docs/latest/hcatalog/hcatalog-inputoutput_34013776.md
index 9515804..94a1216 100644
--- a/content/docs/latest/hcatalog-inputoutput_34013776.md
+++ b/content/docs/latest/hcatalog/hcatalog-inputoutput_34013776.md
@@ -357,7 +357,7 @@ To write multiple partitions simultaneously you can leave the Map null, but all
 Previous: [Load and Store Interfaces]({{< ref "hcatalog-loadstore_34013511" >}})  
  Next: [Reader and Writer Interfaces]({{< ref "hcatalog-readerwriter_34013921" >}})
 
-General: [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/hcatalog-installhcat_34013403.md b/content/docs/latest/hcatalog/hcatalog-installhcat_34013403.md
similarity index 90%
rename from content/docs/latest/hcatalog-installhcat_34013403.md
rename to content/docs/latest/hcatalog/hcatalog-installhcat_34013403.md
index c7e013a..4692431 100644
--- a/content/docs/latest/hcatalog-installhcat_34013403.md
+++ b/content/docs/latest/hcatalog/hcatalog-installhcat_34013403.md
@@ -41,7 +41,7 @@ Previous: [Using HCatalog]({{< ref "hcatalog-usinghcat_34013260" >}})
 Hive installation and configuration: [Installing Hive]({{< ref "adminmanual-installation_27362077" >}}), [Configuring Hive]({{< ref "adminmanual-configuration_27362070" >}}), [Hive Configuration Properties](https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties)  
  WebHCat installation and configuration: [WebHCat Installation]({{< ref "webhcat-installwebhcat_34015585" >}}), [WebHCat Configuration]({{< ref "webhcat-configure_34015738" >}})
 
-General: [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/hcatalog-loadstore_34013511.md b/content/docs/latest/hcatalog/hcatalog-loadstore_34013511.md
similarity index 98%
rename from content/docs/latest/hcatalog-loadstore_34013511.md
rename to content/docs/latest/hcatalog/hcatalog-loadstore_34013511.md
index cfe36c2..7105693 100644
--- a/content/docs/latest/hcatalog-loadstore_34013511.md
+++ b/content/docs/latest/hcatalog/hcatalog-loadstore_34013511.md
@@ -396,7 +396,7 @@ Hive does not have a data type corresponding to the BIGINTEGER type in Pig (java
 Previous: [HCatalog Configuration Properties]({{< ref "hcatalog-configuration-properties_39622369" >}})  
  Next: [Input and Output Interfaces]({{< ref "hcatalog-inputoutput_34013776" >}})
 
-General: [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/hcatalog-notification_34014558.md b/content/docs/latest/hcatalog/hcatalog-notification_34014558.md
similarity index 97%
rename from content/docs/latest/hcatalog-notification_34014558.md
rename to content/docs/latest/hcatalog/hcatalog-notification_34014558.md
index 1a49e6f..80e1d23 100644
--- a/content/docs/latest/hcatalog-notification_34014558.md
+++ b/content/docs/latest/hcatalog/hcatalog-notification_34014558.md
@@ -214,7 +214,7 @@ You then need to configure your ActiveMQ Consumer(s) to listen for messages on t
 Previous: [Dynamic Partitioning]({{< ref "hcatalog-dynamicpartitions_34014006" >}})  
 Next: [Storage Based Authorization]({{< ref "hcatalog-authorization_34014782" >}})
 
-General: [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/hcatalog-readerwriter_34013921.md b/content/docs/latest/hcatalog/hcatalog-readerwriter_34013921.md
similarity index 95%
rename from content/docs/latest/hcatalog-readerwriter_34013921.md
rename to content/docs/latest/hcatalog/hcatalog-readerwriter_34013921.md
index 98d365e..1c09c3d 100644
--- a/content/docs/latest/hcatalog-readerwriter_34013921.md
+++ b/content/docs/latest/hcatalog/hcatalog-readerwriter_34013921.md
@@ -120,7 +120,7 @@ A complete java program for the reader and writer examples above can be found he
 Previous: [Input and Output Interfaces]({{< ref "hcatalog-inputoutput_34013776" >}})  
  Next: [Command Line Interface]({{< ref "hcatalog-cli_34013932" >}})
 
-General: [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/hcatalog-storageformats_34013997.md b/content/docs/latest/hcatalog/hcatalog-storageformats_34013997.md
similarity index 93%
rename from content/docs/latest/hcatalog-storageformats_34013997.md
rename to content/docs/latest/hcatalog/hcatalog-storageformats_34013997.md
index 700eebc..4e5372f 100644
--- a/content/docs/latest/hcatalog-storageformats_34013997.md
+++ b/content/docs/latest/hcatalog/hcatalog-storageformats_34013997.md
@@ -46,7 +46,7 @@ SerDe general information: [Hive SerDe]({{< ref "#hive-serde" >}})
  SerDe details: [SerDe]({{< ref "serde_27362059" >}})  
  SerDe DDL: [Row Format, Storage Format, and SerDe]({{< ref "#row-format,-storage-format,-and-serde" >}})
 
-General: [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/hcatalog-streaming-mutation-api_61337025.md b/content/docs/latest/hcatalog/hcatalog-streaming-mutation-api_61337025.md
similarity index 100%
rename from content/docs/latest/hcatalog-streaming-mutation-api_61337025.md
rename to content/docs/latest/hcatalog/hcatalog-streaming-mutation-api_61337025.md
diff --git a/content/docs/latest/hcatalog-usinghcat_34013260.md b/content/docs/latest/hcatalog/hcatalog-usinghcat_34013260.md
similarity index 97%
rename from content/docs/latest/hcatalog-usinghcat_34013260.md
rename to content/docs/latest/hcatalog/hcatalog-usinghcat_34013260.md
index c5f134e..5221004 100644
--- a/content/docs/latest/hcatalog-usinghcat_34013260.md
+++ b/content/docs/latest/hcatalog/hcatalog-usinghcat_34013260.md
@@ -114,7 +114,7 @@ group by advertiser_id;
 **Navigation Links**
 Next: [HCatalog Installation]({{< ref "hcatalog-installhcat_34013403" >}})
 
-General: [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
 ## Attachments:
 
diff --git a/content/docs/latest/hcatalog_33299065.md b/content/docs/latest/hcatalog/hcatalog_33299065.md
similarity index 91%
rename from content/docs/latest/hcatalog_33299065.md
rename to content/docs/latest/hcatalog/hcatalog_33299065.md
index 27d1086..f1e7cac 100644
--- a/content/docs/latest/hcatalog_33299065.md
+++ b/content/docs/latest/hcatalog/hcatalog_33299065.md
@@ -30,7 +30,7 @@ For information about the REST API for HCatalog, *WebHCat* (formerly *Templeton*
 **Navigation Links**
 Next: [Using HCatalog]({{< ref "hcatalog-usinghcat_34013260" >}})
 
-General: [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/home_27362069.md b/content/docs/latest/home_27362069.md
deleted file mode 100644
index b6390b1..0000000
--- a/content/docs/latest/home_27362069.md
+++ /dev/null
@@ -1,139 +0,0 @@
----
-title: "Apache Hive : Home"
-date: 2024-12-12
----
-
-# Apache Hive : Home
-
-{{< toc >}}
-
-# Apache Hive
-
-The **[Apache Hive™](http://hive.apache.org)** data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage and queried using SQL syntax.   
-  
-Built on top of **[Apache Hadoop™](http://hadoop.apache.org)**, Hive provides the following features:
-
-* Tools to enable easy access to data via SQL, thus enabling data warehousing tasks such as extract/transform/load (ETL), reporting, and data analysis.
-* A mechanism to impose structure on a variety of data formats
-* Access to files stored either directly in **[Apache HDFS](http://hadoop.apache.org/docs/current/hadoop-project-dist/hadoop-hdfs/HdfsUserGuide.html)**[™](http://hadoop.apache.org/)**** or in other data storage systems such as **[Apache HBase](http://hbase.apache.org)**[™](http://hadoop.apache.org/)****
-* Query execution via [Apache Tez](http://tez.apache.org/)**[™](http://hadoop.apache.org/)**, [Apache Spark](http://spark.apache.org/)**[™](http://hadoop.apache.org/)**, or [MapReduce](http://hadoop.apache.org/docs/current/hadoop-mapreduce-client/hadoop-mapreduce-client-core/MapReduceTutorial.html)
-* Procedural language with HPL-SQL
-* Sub-second query retrieval via [Hive LLAP]({{< ref "llap_62689557" >}}), [Apache YARN](https://hadoop.apache.org/docs/r2.7.2/hadoop-yarn/hadoop-yarn-site/YARN.html) and [Apache Slider](https://slider.incubator.apache.org/).
-
-[Hive provides standard SQL functionality]({{< ref "apache-hive-sql-conformance_67641449" >}}), including many of the later [SQL:2003](https://en.wikipedia.org/wiki/SQL:2003), [SQL:2011](https://en.wikipedia.org/wiki/SQL:2011), and [SQL:2016](https://en.wikipedia.org/wiki/SQL:2016) features for analytics.   
-Hive's SQL can also be extended with user code via user defined functions (UDFs), user defined aggregates (UDAFs), and user defined table functions (UDTFs).
-
-There is not a single "Hive format" in which data must be stored. Hive comes with built in connectors for comma and tab-separated values (CSV/TSV) text files, [Apache Parquet](http://parquet.apache.org/)****[™](http://hadoop.apache.org/)****, [Apache ORC](http://orc.apache.org/)****[™](http://hadoop.apache.org/)****, and other formats. Users can extend Hive with connectors for other formats. Please see [File Formats]({{< ref "#file-formats" >}}) and [Hive SerDe]({{< ref "#hive-serde" >}} [...]
-
-Hive is not designed for online transaction processing (OLTP) workloads. It is best used for traditional data warehousing tasks.
-
-Hive is designed to maximize scalability (scale out with more machines added dynamically to the Hadoop cluster), performance, extensibility, fault-tolerance, and loose-coupling with its input formats.
-
-Components of Hive include HCatalog and WebHCat.
-
-* **[HCatalog]({{< ref "hcatalog_33299065" >}})** is a table and storage management layer for Hadoop that enables users with different data processing tools — including Pig and MapReduce — to more easily read and write data on the grid.
-* **[WebHCat]({{< ref "webhcat_33299069" >}})** provides a service that you can use to run Hadoop MapReduce (or YARN), Pig, Hive jobs. You can also perform Hive metadata operations using an HTTP (REST style) interface.
-
-# Hive Documentation
-
-The links below provide access to the Apache Hive wiki documents. This list is not complete, but you can navigate through these wiki pages to find additional documents. For more information, please see the official [Hive website](http://hive.apache.org).
-
-## General Information about Hive
-
-* [Getting Started]({{< ref "gettingstarted_27362090" >}})
-* [Books about Hive]({{< ref "books-about-hive_61322063" >}})
-* [Presentations and Papers about Hive]({{< ref "presentations_27362054" >}})
-* [Sites and Applications Powered by Hive]({{< ref "poweredby_27362055" >}})
-* [Related Projects]({{< ref "relatedprojects_34836686" >}})
-* [FAQ]({{< ref "user-faq_27362095" >}})
-* [Hive Users Mailing List](http://hive.apache.org/mailing_lists.html#Users)
-* Hive IRC Channel: `#hive` on irc.freenode.net
-
-## User Documentation
-
-* [Hive Tutorial]({{< ref "tutorial_27362061" >}})
-* [Hive SQL Language Manual]({{< ref "languagemanual_27362030" >}}):  [Commands]({{< ref "languagemanual-commands_34838882" >}}), [CLIs]({{< ref "languagemanual-cli_27362033" >}}), [Data Types]({{< ref "languagemanual-types_27838462" >}}),  
-DDL ([create/drop/alter/truncate/show/describe]({{< ref "languagemanual-ddl_27362034" >}})), [Statistics (analyze)]({{< ref "statsdev_27362062" >}}), [Indexes]({{< ref "languagemanual-indexing_31822176" >}}), [Archiving]({{< ref "languagemanual-archiving_27362031" >}}),  
-DML ([load/insert/update/delete/merge]({{< ref "languagemanual-dml_27362036" >}}), [import/export]({{< ref "languagemanual-importexport_27837968" >}}), [explain plan]({{< ref "languagemanual-explain_27362037" >}})),  
-[Queries (select)]({{< ref "languagemanual-select_27362043" >}}), [Operators and UDFs]({{< ref "languagemanual-udf_27362046" >}}), [Locks]({{< ref "locking_27362050.md" >}}), [Authorization]({{< ref "languagemanual-authorization_27362032" >}})
-* [File Formats and Compression]({{< ref "fileformats_47384180" >}}):  [RCFile]({{< ref "rcfile_58851803" >}}), [Avro]({{< ref "avroserde_27850707" >}}), [ORC]({{< ref "languagemanual-orc_31818911" >}}), [Parquet]({{< ref "parquet_38570914" >}}); [Compression]({{< ref "compressedstorage_27362073" >}}), [LZO]({{< ref "languagemanual-lzo_33298193" >}})
-* Procedural Language:   [Hive HPL/SQL]({{< ref "59690156" >}})
-* [Hive Configuration Properties]({{< ref "configuration-properties_27842758" >}})
-* Hive Clients
-	+ [Hive Client]({{< ref "hiveclient_27362101" >}}) ([JDBC]({{< ref "#jdbc" >}}), [ODBC]({{< ref "#odbc" >}}), [Thrift]({{< ref "#thrift" >}}))
-	+ HiveServer2:  [Overview]({{< ref "hiveserver2-overview_65147648" >}}), [HiveServer2 Client and Beeline]({{< ref "hiveserver2-clients_30758725" >}}), [Hive Metrics]({{< ref "hive-metrics_65872987" >}})
-* [Hive SerDes]({{< ref "serde_27362059" >}}):  [Avro SerDe]({{< ref "avroserde_27850707" >}}), [Parquet SerDe]({{< ref "#parquet-serde" >}}), [CSV SerDe]({{< ref "csv-serde_48202659" >}}), [JSON SerDe]({{< ref "#json-serde" >}})
-* [Hive Accumulo Integration]({{< ref "accumulointegration_46633569" >}})
-* [Hive HBase Integration]({{< ref "hbaseintegration_27362089" >}})
-* [Druid Integration]({{< ref "druid-integration_65866491" >}})
-* [Kudu Integration]({{< ref "kudu-integration_133631955" >}})
-* [Hive Transactions]({{< ref "hive-transactions_40509723" >}}), [Streaming Data Ingest]({{< ref "streaming-data-ingest_40509746" >}}), and [Streaming Mutation API]({{< ref "hcatalog-streaming-mutation-api_61337025" >}})
-* [Hive Counters]({{< ref "hivecounters_67636835" >}})
-* [Using TiDB as the Hive Metastore database]({{< ref "using-tidb-as-the-hive-metastore-database_158872426" >}})
-* [StarRocks Integration](https://cwiki.apache.org/confluence/display/Hive/StarRocks+Integration)
-
-## Administrator Documentation
-
-* [Installing Hive]({{< ref "adminmanual-installation_27362077" >}})
-* [Configuring Hive]({{< ref "adminmanual-configuration_27362070" >}})
-* [Setting Up Metastore]({{< ref "adminmanual-metastore-administration_27362076" >}})
-	+ [Hive Schema Tool]({{< ref "hive-schema-tool_34835119" >}})
-* [Setting Up Hive Server]({{< ref "adminmanual-settinguphiveserver_27362079" >}}) ([JDBC]({{< ref "hivejdbcinterface_27362100" >}}), [ODBC]({{< ref "hiveodbc_27362099" >}}), [Thrift]({{< ref "hiveserver_27362111" >}}), [HiveServer2]({{< ref "setting-up-hiveserver2_30758712" >}}))
-* [Hive Replication]({{< ref "replication_61336919" >}})
-* [Hive on Amazon Web Services]({{< ref "hiveaws_27362103" >}})
-* [Hive on Amazon Elastic MapReduce]({{< ref "hiveamazonelasticmapreduce_27825646" >}})
-* [Hive on Spark: Getting Started]({{< ref "44302539" >}})
-
-## HCatalog and WebHCat Documentation
-
-* [HCatalog]({{< ref "hcatalog_33299065" >}})
-* [WebHCat (Templeton)]({{< ref "webhcat_33299069" >}})
-
-## Resources for Contributors
-
-* [How to Contribute]({{< ref "howtocontribute_27362107" >}})
-* [Hive Contributors Meetings]({{< ref "development-contributorsmeetings_27362087" >}})
-* [Hive Developer Docs]({{< ref "developerdocs_42568263" >}})
-	+ [Hive Developer Guide]({{< ref "developerguide_27362074" >}}) ([code organization]({{< ref "#code-organization" >}}), [compile and run Hive]({{< ref "#compile-and-run-hive" >}}), [unit tests]({{< ref "#unit-tests" >}}), [debug]({{< ref "#debug" >}}), [pluggable interfaces]({{< ref "#pluggable-interfaces" >}}))
-	+ [Hive Developer FAQ]({{< ref "hivedeveloperfaq_27823747" >}}) ([move files]({{< ref "#move-files" >}}), [build Hive]({{< ref "#build-hive" >}}), [test Hive]({{< ref "#test-hive" >}})
-	+ [Plugin Developer Kit]({{< ref "plugindeveloperkit_27820324" >}})
-	+ [Writing UDTFs]({{< ref "developerguide-udtf_27362086" >}})
-	+ [Hive APIs Overview]({{< ref "hive-apis-overview_61326349" >}})
-* [Hive Testing Docs]({{< ref "testingdocs_42567126" >}})
-	+ [FAQ: Testing]({{< ref "#faq:-testing" >}})
-	+ [Developer Guide: Unit Tests]({{< ref "#developer-guide:-unit-tests" >}})
-	+ [Unit Testing Hive SQL]({{< ref "unit-testing-hive-sql_61328063" >}})
-	+ [Running Yetus]({{< ref "running-yetus_71012969" >}})
-	+ [MetaStore API Tests]({{< ref "metastore-api-tests_75958143" >}})
-* [Hive Performance]({{< ref "performance_27362052" >}})
-* [Hive Architecture Overview]({{< ref "design_27362072" >}})
-* [Hive Design Docs]({{< ref "designdocs_27362075" >}}):  [Completed]({{< ref "#completed" >}}); [In Progress]({{< ref "#in-progress" >}}); [Proposed]({{< ref "#proposed" >}}); [Incomplete, Abandoned, Other]({{< ref "#incomplete,-abandoned,-other" >}})
-* [Roadmap/Call to Add More Features]({{< ref "roadmap_27362057" >}})
-* [Becoming a Committer]({{< ref "/community/becomingcommitter" >}})
-* [How to Commit]({{< ref "howtocommit_27362108" >}})
-* [How to Release]({{< ref "howtorelease_27362106" >}})
-
-# Hive Versions and Branches
-
-Recent versions of Hive are available on the [Downloads](http://hive.apache.org/downloads.html) page of the Hive website. For each version, the page provides the release date and a link to the change log. If you want a change log for an earlier version (or a development branch), use the [Configure Release Notes](https://issues.apache.org/jira/secure/ConfigureReleaseNote.jspa?projectId=12310843&version=12329278) page.
-
-The [Apache Hive JIRA](https://issues.apache.org/jira/browse/HIVE) keeps track of changes to Hive code, documentation, infrastructure, etc. The version number or branch for each resolved JIRA issue is shown in the "Fix Version/s" field in the Details section at the top of the issue page. For example, [HIVE-5107](https://issues.apache.org/jira/browse/HIVE-5107) has a fix version of 0.13.0.
-
-Sometimes a version number changes before the release. When that happens, the original number might still be found in JIRA, wiki, and [mailing list](http://hive.apache.org/mailing_lists.html) discussions. For example:
-
-| Release Number | Original Number |
-| --- | --- |
-| 1.0.0 | 0.14.1 |
-| 1.1.0 | 0.15.0 |
-| 2.3.0 | 2.2.0 |
-
-More information about Hive branches is available in How to Contribute: [Understanding Hive Branches]({{< ref "#understanding-hive-branches" >}}).
-
-*Apache Hive, Apache Hadoop, Apache HBase, Apache HDFS, Apache, the Apache feather logo, and the Apache Hive project logo are trademarks of The Apache Software Foundation.*
-
-  
-
- 
-
- 
-
diff --git a/content/docs/latest/122917025.md b/content/docs/latest/language/122917025.md
similarity index 100%
rename from content/docs/latest/122917025.md
rename to content/docs/latest/language/122917025.md
diff --git a/content/docs/latest/30151323.md b/content/docs/latest/language/30151323.md
similarity index 100%
rename from content/docs/latest/30151323.md
rename to content/docs/latest/language/30151323.md
diff --git a/content/docs/latest/67641451.md b/content/docs/latest/language/67641451.md
similarity index 100%
rename from content/docs/latest/67641451.md
rename to content/docs/latest/language/67641451.md
diff --git a/content/docs/latest/73632935.md b/content/docs/latest/language/73632935.md
similarity index 100%
rename from content/docs/latest/73632935.md
rename to content/docs/latest/language/73632935.md
diff --git a/content/docs/latest/97551656.md b/content/docs/latest/language/97551656.md
similarity index 100%
rename from content/docs/latest/97551656.md
rename to content/docs/latest/language/97551656.md
diff --git a/content/docs/latest/language/_index.md b/content/docs/latest/language/_index.md
new file mode 100644
index 0000000..c7e9265
--- /dev/null
+++ b/content/docs/latest/language/_index.md
@@ -0,0 +1,4 @@
+---
+title: "Language Manual"
+date: 2025-07-24
+---
diff --git a/content/docs/latest/apache-hive-sql-conformance_67641449.md b/content/docs/latest/language/apache-hive-sql-conformance_67641449.md
similarity index 100%
rename from content/docs/latest/apache-hive-sql-conformance_67641449.md
rename to content/docs/latest/language/apache-hive-sql-conformance_67641449.md
diff --git a/content/docs/latest/common-table-expression_38572242.md b/content/docs/latest/language/common-table-expression_38572242.md
similarity index 100%
rename from content/docs/latest/common-table-expression_38572242.md
rename to content/docs/latest/language/common-table-expression_38572242.md
diff --git a/content/docs/latest/compaction-pooling_240884493.md b/content/docs/latest/language/compaction-pooling_240884493.md
similarity index 100%
rename from content/docs/latest/compaction-pooling_240884493.md
rename to content/docs/latest/language/compaction-pooling_240884493.md
diff --git a/content/docs/latest/datasketches-integration_177050456.md b/content/docs/latest/language/datasketches-integration_177050456.md
similarity index 100%
rename from content/docs/latest/datasketches-integration_177050456.md
rename to content/docs/latest/language/datasketches-integration_177050456.md
diff --git a/content/docs/latest/exchange-partition_30755801.md b/content/docs/latest/language/exchange-partition_30755801.md
similarity index 100%
rename from content/docs/latest/exchange-partition_30755801.md
rename to content/docs/latest/language/exchange-partition_30755801.md
diff --git a/content/docs/latest/genericudafcasestudy_27362093.md b/content/docs/latest/language/genericudafcasestudy_27362093.md
similarity index 100%
rename from content/docs/latest/genericudafcasestudy_27362093.md
rename to content/docs/latest/language/genericudafcasestudy_27362093.md
diff --git a/content/docs/latest/hive-operators_283118406.md b/content/docs/latest/language/hive-operators_283118406.md
similarity index 100%
rename from content/docs/latest/hive-operators_283118406.md
rename to content/docs/latest/language/hive-operators_283118406.md
diff --git a/content/docs/latest/hive-udfs_282102277.md b/content/docs/latest/language/hive-udfs_282102277.md
similarity index 100%
rename from content/docs/latest/hive-udfs_282102277.md
rename to content/docs/latest/language/hive-udfs_282102277.md
diff --git a/content/docs/latest/hiveplugins_27362098.md b/content/docs/latest/language/hiveplugins_27362098.md
similarity index 100%
rename from content/docs/latest/hiveplugins_27362098.md
rename to content/docs/latest/language/hiveplugins_27362098.md
diff --git a/content/docs/latest/hiveql_27362097.md b/content/docs/latest/language/hiveql_27362097.md
similarity index 100%
rename from content/docs/latest/hiveql_27362097.md
rename to content/docs/latest/language/hiveql_27362097.md
diff --git a/content/docs/latest/languagemanual-archiving_27362031.md b/content/docs/latest/language/languagemanual-archiving_27362031.md
similarity index 100%
rename from content/docs/latest/languagemanual-archiving_27362031.md
rename to content/docs/latest/language/languagemanual-archiving_27362031.md
diff --git a/content/docs/latest/languagemanual-authorization_27362032.md b/content/docs/latest/language/languagemanual-authorization_27362032.md
similarity index 100%
rename from content/docs/latest/languagemanual-authorization_27362032.md
rename to content/docs/latest/language/languagemanual-authorization_27362032.md
diff --git a/content/docs/latest/languagemanual-cli_27362033.md b/content/docs/latest/language/languagemanual-cli_27362033.md
similarity index 100%
rename from content/docs/latest/languagemanual-cli_27362033.md
rename to content/docs/latest/language/languagemanual-cli_27362033.md
diff --git a/content/docs/latest/languagemanual-commands_34838882.md b/content/docs/latest/language/languagemanual-commands_34838882.md
similarity index 100%
rename from content/docs/latest/languagemanual-commands_34838882.md
rename to content/docs/latest/language/languagemanual-commands_34838882.md
diff --git a/content/docs/latest/languagemanual-ddl-bucketedtables_27362035.md b/content/docs/latest/language/languagemanual-ddl-bucketedtables_27362035.md
similarity index 100%
rename from content/docs/latest/languagemanual-ddl-bucketedtables_27362035.md
rename to content/docs/latest/language/languagemanual-ddl-bucketedtables_27362035.md
diff --git a/content/docs/latest/languagemanual-ddl_27362034.md b/content/docs/latest/language/languagemanual-ddl_27362034.md
similarity index 100%
rename from content/docs/latest/languagemanual-ddl_27362034.md
rename to content/docs/latest/language/languagemanual-ddl_27362034.md
diff --git a/content/docs/latest/languagemanual-dml_27362036.md b/content/docs/latest/language/languagemanual-dml_27362036.md
similarity index 100%
rename from content/docs/latest/languagemanual-dml_27362036.md
rename to content/docs/latest/language/languagemanual-dml_27362036.md
diff --git a/content/docs/latest/languagemanual-explain_27362037.md b/content/docs/latest/language/languagemanual-explain_27362037.md
similarity index 100%
rename from content/docs/latest/languagemanual-explain_27362037.md
rename to content/docs/latest/language/languagemanual-explain_27362037.md
diff --git a/content/docs/latest/languagemanual-groupby_27362038.md b/content/docs/latest/language/languagemanual-groupby_27362038.md
similarity index 100%
rename from content/docs/latest/languagemanual-groupby_27362038.md
rename to content/docs/latest/language/languagemanual-groupby_27362038.md
diff --git a/content/docs/latest/languagemanual-importexport_27837968.md b/content/docs/latest/language/languagemanual-importexport_27837968.md
similarity index 100%
rename from content/docs/latest/languagemanual-importexport_27837968.md
rename to content/docs/latest/language/languagemanual-importexport_27837968.md
diff --git a/content/docs/latest/languagemanual-indexing_31822176.md b/content/docs/latest/language/languagemanual-indexing_31822176.md
similarity index 100%
rename from content/docs/latest/languagemanual-indexing_31822176.md
rename to content/docs/latest/language/languagemanual-indexing_31822176.md
diff --git a/content/docs/latest/languagemanual-joinoptimization_33293167.md b/content/docs/latest/language/languagemanual-joinoptimization_33293167.md
similarity index 100%
rename from content/docs/latest/languagemanual-joinoptimization_33293167.md
rename to content/docs/latest/language/languagemanual-joinoptimization_33293167.md
diff --git a/content/docs/latest/languagemanual-joins_27362039.md b/content/docs/latest/language/languagemanual-joins_27362039.md
similarity index 100%
rename from content/docs/latest/languagemanual-joins_27362039.md
rename to content/docs/latest/language/languagemanual-joins_27362039.md
diff --git a/content/docs/latest/languagemanual-lateralview_27362040.md b/content/docs/latest/language/languagemanual-lateralview_27362040.md
similarity index 100%
rename from content/docs/latest/languagemanual-lateralview_27362040.md
rename to content/docs/latest/language/languagemanual-lateralview_27362040.md
diff --git a/content/docs/latest/languagemanual-lzo_33298193.md b/content/docs/latest/language/languagemanual-lzo_33298193.md
similarity index 100%
rename from content/docs/latest/languagemanual-lzo_33298193.md
rename to content/docs/latest/language/languagemanual-lzo_33298193.md
diff --git a/content/docs/latest/languagemanual-orc_31818911.md b/content/docs/latest/language/languagemanual-orc_31818911.md
similarity index 100%
rename from content/docs/latest/languagemanual-orc_31818911.md
rename to content/docs/latest/language/languagemanual-orc_31818911.md
diff --git a/content/docs/latest/languagemanual-sampling_27362042.md b/content/docs/latest/language/languagemanual-sampling_27362042.md
similarity index 100%
rename from content/docs/latest/languagemanual-sampling_27362042.md
rename to content/docs/latest/language/languagemanual-sampling_27362042.md
diff --git a/content/docs/latest/languagemanual-select_27362043.md b/content/docs/latest/language/languagemanual-select_27362043.md
similarity index 100%
rename from content/docs/latest/languagemanual-select_27362043.md
rename to content/docs/latest/language/languagemanual-select_27362043.md
diff --git a/content/docs/latest/languagemanual-sortby_27362045.md b/content/docs/latest/language/languagemanual-sortby_27362045.md
similarity index 100%
rename from content/docs/latest/languagemanual-sortby_27362045.md
rename to content/docs/latest/language/languagemanual-sortby_27362045.md
diff --git a/content/docs/latest/languagemanual-subqueries_27362044.md b/content/docs/latest/language/languagemanual-subqueries_27362044.md
similarity index 100%
rename from content/docs/latest/languagemanual-subqueries_27362044.md
rename to content/docs/latest/language/languagemanual-subqueries_27362044.md
diff --git a/content/docs/latest/languagemanual-transform_27362047.md b/content/docs/latest/language/languagemanual-transform_27362047.md
similarity index 100%
rename from content/docs/latest/languagemanual-transform_27362047.md
rename to content/docs/latest/language/languagemanual-transform_27362047.md
diff --git a/content/docs/latest/languagemanual-types_27838462.md b/content/docs/latest/language/languagemanual-types_27838462.md
similarity index 100%
rename from content/docs/latest/languagemanual-types_27838462.md
rename to content/docs/latest/language/languagemanual-types_27838462.md
diff --git a/content/docs/latest/languagemanual-udf_27362046.md b/content/docs/latest/language/languagemanual-udf_27362046.md
similarity index 100%
rename from content/docs/latest/languagemanual-udf_27362046.md
rename to content/docs/latest/language/languagemanual-udf_27362046.md
diff --git a/content/docs/latest/languagemanual-union_27362049.md b/content/docs/latest/language/languagemanual-union_27362049.md
similarity index 100%
rename from content/docs/latest/languagemanual-union_27362049.md
rename to content/docs/latest/language/languagemanual-union_27362049.md
diff --git a/content/docs/latest/languagemanual-variablesubstitution_30754722.md b/content/docs/latest/language/languagemanual-variablesubstitution_30754722.md
similarity index 100%
rename from content/docs/latest/languagemanual-variablesubstitution_30754722.md
rename to content/docs/latest/language/languagemanual-variablesubstitution_30754722.md
diff --git a/content/docs/latest/languagemanual-virtualcolumns_27362048.md b/content/docs/latest/language/languagemanual-virtualcolumns_27362048.md
similarity index 100%
rename from content/docs/latest/languagemanual-virtualcolumns_27362048.md
rename to content/docs/latest/language/languagemanual-virtualcolumns_27362048.md
diff --git a/content/docs/latest/languagemanual-windowingandanalytics_31819589.md b/content/docs/latest/language/languagemanual-windowingandanalytics_31819589.md
similarity index 100%
rename from content/docs/latest/languagemanual-windowingandanalytics_31819589.md
rename to content/docs/latest/language/languagemanual-windowingandanalytics_31819589.md
diff --git a/content/docs/latest/languagemanual-xpathudf_27362051.md b/content/docs/latest/language/languagemanual-xpathudf_27362051.md
similarity index 100%
rename from content/docs/latest/languagemanual-xpathudf_27362051.md
rename to content/docs/latest/language/languagemanual-xpathudf_27362051.md
diff --git a/content/docs/latest/languagemanual_27362030.md b/content/docs/latest/language/languagemanual_27362030.md
similarity index 100%
rename from content/docs/latest/languagemanual_27362030.md
rename to content/docs/latest/language/languagemanual_27362030.md
diff --git a/content/docs/latest/literals_27829682.md b/content/docs/latest/language/literals_27829682.md
similarity index 100%
rename from content/docs/latest/literals_27829682.md
rename to content/docs/latest/language/literals_27829682.md
diff --git a/content/docs/latest/managed-vs--external-tables_95654003.md b/content/docs/latest/language/managed-vs--external-tables_95654003.md
similarity index 100%
rename from content/docs/latest/managed-vs--external-tables_95654003.md
rename to content/docs/latest/language/managed-vs--external-tables_95654003.md
diff --git a/content/docs/latest/materialized-views_80447331.md b/content/docs/latest/language/materialized-views_80447331.md
similarity index 100%
rename from content/docs/latest/materialized-views_80447331.md
rename to content/docs/latest/language/materialized-views_80447331.md
diff --git a/content/docs/latest/operatorsandfunctions_30754909.md b/content/docs/latest/language/operatorsandfunctions_30754909.md
similarity index 100%
rename from content/docs/latest/operatorsandfunctions_30754909.md
rename to content/docs/latest/language/operatorsandfunctions_30754909.md
diff --git a/content/docs/latest/partition-filter-syntax_103092177.md b/content/docs/latest/language/partition-filter-syntax_103092177.md
similarity index 100%
rename from content/docs/latest/partition-filter-syntax_103092177.md
rename to content/docs/latest/language/partition-filter-syntax_103092177.md
diff --git a/content/docs/latest/reflectudf_30754716.md b/content/docs/latest/language/reflectudf_30754716.md
similarity index 100%
rename from content/docs/latest/reflectudf_30754716.md
rename to content/docs/latest/language/reflectudf_30754716.md
diff --git a/content/docs/latest/scheduled-queries_145724128.md b/content/docs/latest/language/scheduled-queries_145724128.md
similarity index 100%
rename from content/docs/latest/scheduled-queries_145724128.md
rename to content/docs/latest/language/scheduled-queries_145724128.md
diff --git a/content/docs/latest/sql-standard-based-hive-authorization_40509928.md b/content/docs/latest/language/sql-standard-based-hive-authorization_40509928.md
similarity index 100%
rename from content/docs/latest/sql-standard-based-hive-authorization_40509928.md
rename to content/docs/latest/language/sql-standard-based-hive-authorization_40509928.md
diff --git a/content/docs/latest/statisticsanddatamining_27362058.md b/content/docs/latest/language/statisticsanddatamining_27362058.md
similarity index 100%
rename from content/docs/latest/statisticsanddatamining_27362058.md
rename to content/docs/latest/language/statisticsanddatamining_27362058.md
diff --git a/content/docs/latest/roadmap_27362057.md b/content/docs/latest/roadmap_27362057.md
deleted file mode 100644
index 64af28e..0000000
--- a/content/docs/latest/roadmap_27362057.md
+++ /dev/null
@@ -1,88 +0,0 @@
----
-title: "Apache Hive : Roadmap"
-date: 2024-12-12
----
-
-# Apache Hive : Roadmap
-
-Before adding to the list below, please check [JIRA](https://issues.apache.org/jira/browse/HADOOP/component/12312455) to see if a ticket has already been opened for the feature. If not, please open a ticket on the [Hive JIRA](http://issues.apache.org/jira/browse/HIVE) and also update the following list.
-
-# Features to be added
-
-## Major Recent Changes
-
-* [Table Statistics](https://issues.apache.org/jira/browse/HIVE-33)
-* [Archiving](https://issues.apache.org/jira/browse/HIVE-1299)
-* [Indexing First Cut](https://issues.apache.org/jira/browse/HIVE-417)
-* [Concurrency](https://issues.apache.org/jira/browse/HIVE-1293)
-* [Conversion to Map-Join at Runtime](https://issues.apache.org/jira/browse/HIVE-1642)
-* [Support for Multiple Distincts](https://issues.apache.org/jira/browse/HIVE-474)
-* [Remove Partition Filtering Conditions](https://issues.apache.org/jira/browse/HIVE-1750)
-* [INSERT INTO statement](https://issues.apache.org/jira/browse/HIVE-306)
-* [Block-level merge](https://issues.apache.org/jira/browse/HIVE-2035)
-* [HAVING clause support](https://issues.apache.org/jira/browse/HIVE-1790)
-* [Cross-database queries](https://issues.apache.org/jira/browse/HIVE-1517)
-* [Bitmap Index](https://issues.apache.org/jira/browse/HIVE-1803)
-* [Use Filter Pushdown for Automatically Accessing Indexes](https://issues.apache.org/jira/browse/HIVE-1644)
-* [Remove Duplicate Filters](https://issues.apache.org/jira/browse/HIVE-1538)
-* [Authentication](https://issues.apache.org/jira/browse/HIVE-842)
-* [Authorization](https://issues.apache.org/jira/browse/HIVE-78)
-
-## Current Projects
-
-* [Bloom Filters](https://issues.apache.org/jira/browse/HIVE-1721)
-* [TIMESTAMP data type](https://issues.apache.org/jira/browse/HIVE-2272)
-
-## Up For Grabs
-
-Priorities are denoted as P0 > P1 > ...
-
-### Query Optimization
-
-* P0 Optimizing JOIN followed by GROUP BY
-	+ A lot of analytics queries are JOINs followed by GROUP BY (join keys and group by keys may or may not be the same or related). We need a better optimization for this kind of query (optimize number of MapReduce Jobs vs. optimize data transfer size etc.)
-* P0 Optimize JOINs using Bloom Filters
-	+ This is to optimize the case where two big tables are joined but the results are small.
-* P1 Column-level statistics
-	+ We already have UDAFs for percentile, histogram etc. We need to figure out a smart way to compute column-level (approximate) stats in a streaming fashion (during/piggy-backing the scan/loading data process) without firing a new query.
-* P1 Determining whether to use skew for a count distinct in group by
-	+ Need column level stats or a sample task before the real query.
-* P1 Exploit clustering information in the input data
-	+ Some data are generated using 'GROUP BY', 'CLUSTER BY', 'ORDER BY' etc. that implicit ordering in the data. We should exploit this metadata to do better join in choosing joins (e.g., map-side sort-merge join).
-* Cost-based Optimization
-### Query Execution
-* P0 Native Support for types of numbers, datetime, and IP addresses
-	+ Currently most numbers, datetimes, and IP addresses are treated as strings. If we know their data types we should store these data types in a more effective manner (see also "Binary Storage and SerDe").
-* P0 Create a URL data type that is more friendly to data compression.
-	+ URLs are very long and can contribute to large portion of storage. They are treated as generic strings and use string compression algorithms. We should investigate if there are ways to treate URL data types in a clever way so that the compression algorithm (may be a customized compression algorithm) can compress the data better in small enough overhead.
-* P1 Binary storage format and SerDe
-	+ The idea is to store data in their native format (rather than converting to UTF-8 string type) before stored on disk. This can potentially save a lot of CPU/IO cost in data conversion and object creations.
-	+ Also investigating the compression technics used in other column-stores that does not require decompression before query (filtering).
-	+ Revisit the LazyBinarySerDe and see if they can be reused or extended to this storage format.
-	+ Make this storage format amenable to mmap() (or FileChannel in Java) so that the system can skip I/O if memory random access can skip part of data (e.g., columns)
-* Support for IN, exists and correlated subqueries
-* More native types - Enums, timestamp
-* Persistent UDF's
-* SQL/OLAP
-* Storage handler improvements
-* System views
-* JDBC/ODBC improvements
-* mapred to mapreduce transition (no longer needed since mapred got undeprecated)
-### Metadata Management
-* P0 Reducing the size of the metastore – whatever it takes: some ideas were to not store COLUMNS etc.
-	+ One idea here is to introduce something like a schema object that contains the column objects. Partitions would inherit the schema object, which would only change when the table schema changes. Also work would be involved to migrate the existing setup. This would greatly reduce the number of rows in columns (current in the billions).
-* P1 View improvements
-### Test, Error Messages and Debugging
-* P0 Heavy-duty test infrastructure
-* Automated code coverage reports
-* Hive CLI improvement/Error messages
-* HiveServer robustness
-* Debuggability / Resumability:
-	+ Show users the last portion of the data that caused the task to fail
-	+ Restart a job with a particular mapper (that failed earlier, for debugging purposes)
-	+ Resume at map-reduce job level.
-
- 
-
- 
-
diff --git a/content/docs/latest/283118453.md b/content/docs/latest/user/283118453.md
similarity index 100%
rename from content/docs/latest/283118453.md
rename to content/docs/latest/user/283118453.md
diff --git a/content/docs/latest/45876173.md b/content/docs/latest/user/45876173.md
similarity index 100%
rename from content/docs/latest/45876173.md
rename to content/docs/latest/user/45876173.md
diff --git a/content/docs/latest/59690156.md b/content/docs/latest/user/59690156.md
similarity index 100%
rename from content/docs/latest/59690156.md
rename to content/docs/latest/user/59690156.md
diff --git a/content/docs/latest/user/_index.md b/content/docs/latest/user/_index.md
new file mode 100644
index 0000000..8a09a12
--- /dev/null
+++ b/content/docs/latest/user/_index.md
@@ -0,0 +1,4 @@
+---
+title: "User Manual"
+date: 2025-07-24
+---
diff --git a/content/docs/latest/accumulointegration_46633569.md b/content/docs/latest/user/accumulointegration_46633569.md
similarity index 100%
rename from content/docs/latest/accumulointegration_46633569.md
rename to content/docs/latest/user/accumulointegration_46633569.md
diff --git a/content/docs/latest/authdev_27362078.md b/content/docs/latest/user/authdev_27362078.md
similarity index 100%
rename from content/docs/latest/authdev_27362078.md
rename to content/docs/latest/user/authdev_27362078.md
diff --git a/content/docs/latest/avroserde_27850707.md b/content/docs/latest/user/avroserde_27850707.md
similarity index 100%
rename from content/docs/latest/avroserde_27850707.md
rename to content/docs/latest/user/avroserde_27850707.md
diff --git a/content/docs/latest/capture-lineage-info.md b/content/docs/latest/user/capture-lineage-info.md
similarity index 98%
rename from content/docs/latest/capture-lineage-info.md
rename to content/docs/latest/user/capture-lineage-info.md
index 60e015f..a8ba7e8 100644
--- a/content/docs/latest/capture-lineage-info.md
+++ b/content/docs/latest/user/capture-lineage-info.md
@@ -1,4 +1,7 @@
-# Capture Lineage Information In Hive Hooks
+---
+title: "Capture Lineage Information In Hive Hooks"
+date: 2025-07-29
+---
 
 ## Background
 
diff --git a/content/docs/latest/compressedstorage_27362073.md b/content/docs/latest/user/compressedstorage_27362073.md
similarity index 100%
rename from content/docs/latest/compressedstorage_27362073.md
rename to content/docs/latest/user/compressedstorage_27362073.md
diff --git a/content/docs/latest/configuration-properties_27842758.md b/content/docs/latest/user/configuration-properties_27842758.md
similarity index 100%
rename from content/docs/latest/configuration-properties_27842758.md
rename to content/docs/latest/user/configuration-properties_27842758.md
diff --git a/content/docs/latest/cost-based-optimization-in-hive_42566775.md b/content/docs/latest/user/cost-based-optimization-in-hive_42566775.md
similarity index 100%
rename from content/docs/latest/cost-based-optimization-in-hive_42566775.md
rename to content/docs/latest/user/cost-based-optimization-in-hive_42566775.md
diff --git a/content/docs/latest/csv-serde_48202659.md b/content/docs/latest/user/csv-serde_48202659.md
similarity index 100%
rename from content/docs/latest/csv-serde_48202659.md
rename to content/docs/latest/user/csv-serde_48202659.md
diff --git a/content/docs/latest/data-connector-for-hive-and-hive-like-engines_288885794.md b/content/docs/latest/user/data-connector-for-hive-and-hive-like-engines_288885794.md
similarity index 100%
rename from content/docs/latest/data-connector-for-hive-and-hive-like-engines_288885794.md
rename to content/docs/latest/user/data-connector-for-hive-and-hive-like-engines_288885794.md
diff --git a/content/docs/latest/data-connectors-in-hive_177049669.md b/content/docs/latest/user/data-connectors-in-hive_177049669.md
similarity index 100%
rename from content/docs/latest/data-connectors-in-hive_177049669.md
rename to content/docs/latest/user/data-connectors-in-hive_177049669.md
diff --git a/content/docs/latest/druid-integration_65866491.md b/content/docs/latest/user/druid-integration_65866491.md
similarity index 100%
rename from content/docs/latest/druid-integration_65866491.md
rename to content/docs/latest/user/druid-integration_65866491.md
diff --git a/content/docs/latest/fileformats_47384180.md b/content/docs/latest/user/fileformats_47384180.md
similarity index 100%
rename from content/docs/latest/fileformats_47384180.md
rename to content/docs/latest/user/fileformats_47384180.md
diff --git a/content/docs/latest/hbaseintegration_27362089.md b/content/docs/latest/user/hbaseintegration_27362089.md
similarity index 100%
rename from content/docs/latest/hbaseintegration_27362089.md
rename to content/docs/latest/user/hbaseintegration_27362089.md
diff --git a/content/docs/latest/hive-aws-emr_27823791.md b/content/docs/latest/user/hive-aws-emr_27823791.md
similarity index 100%
rename from content/docs/latest/hive-aws-emr_27823791.md
rename to content/docs/latest/user/hive-aws-emr_27823791.md
diff --git a/content/docs/latest/hive-configurations_283118321.md b/content/docs/latest/user/hive-configurations_283118321.md
similarity index 100%
rename from content/docs/latest/hive-configurations_283118321.md
rename to content/docs/latest/user/hive-configurations_283118321.md
diff --git a/content/docs/latest/hive-iceberg-integration_282102247.md b/content/docs/latest/user/hive-iceberg-integration_282102247.md
similarity index 100%
rename from content/docs/latest/hive-iceberg-integration_282102247.md
rename to content/docs/latest/user/hive-iceberg-integration_282102247.md
diff --git a/content/docs/latest/hive-metrics_65872987.md b/content/docs/latest/user/hive-metrics_65872987.md
similarity index 100%
rename from content/docs/latest/hive-metrics_65872987.md
rename to content/docs/latest/user/hive-metrics_65872987.md
diff --git a/content/docs/latest/hive-on-spark_42567714.md b/content/docs/latest/user/hive-on-spark_42567714.md
similarity index 100%
rename from content/docs/latest/hive-on-spark_42567714.md
rename to content/docs/latest/user/hive-on-spark_42567714.md
diff --git a/content/docs/latest/hive-transactions_40509723.md b/content/docs/latest/user/hive-transactions_40509723.md
similarity index 100%
rename from content/docs/latest/hive-transactions_40509723.md
rename to content/docs/latest/user/hive-transactions_40509723.md
diff --git a/content/docs/latest/hiveaws-hivings3nremotely_27362102.md b/content/docs/latest/user/hiveaws-hivings3nremotely_27362102.md
similarity index 100%
rename from content/docs/latest/hiveaws-hivings3nremotely_27362102.md
rename to content/docs/latest/user/hiveaws-hivings3nremotely_27362102.md
diff --git a/content/docs/latest/hiveclient_27362101.md b/content/docs/latest/user/hiveclient_27362101.md
similarity index 100%
rename from content/docs/latest/hiveclient_27362101.md
rename to content/docs/latest/user/hiveclient_27362101.md
diff --git a/content/docs/latest/hivecounters_67636835.md b/content/docs/latest/user/hivecounters_67636835.md
similarity index 100%
rename from content/docs/latest/hivecounters_67636835.md
rename to content/docs/latest/user/hivecounters_67636835.md
diff --git a/content/docs/latest/hiveserver2-clients_30758725.md b/content/docs/latest/user/hiveserver2-clients_30758725.md
similarity index 100%
rename from content/docs/latest/hiveserver2-clients_30758725.md
rename to content/docs/latest/user/hiveserver2-clients_30758725.md
diff --git a/content/docs/latest/hiveserver2-overview_65147648.md b/content/docs/latest/user/hiveserver2-overview_65147648.md
similarity index 100%
rename from content/docs/latest/hiveserver2-overview_65147648.md
rename to content/docs/latest/user/hiveserver2-overview_65147648.md
diff --git a/content/docs/latest/jdbc-storage-handler_95651916.md b/content/docs/latest/user/jdbc-storage-handler_95651916.md
similarity index 100%
rename from content/docs/latest/jdbc-storage-handler_95651916.md
rename to content/docs/latest/user/jdbc-storage-handler_95651916.md
diff --git a/content/docs/latest/kudu-integration_133631955.md b/content/docs/latest/user/kudu-integration_133631955.md
similarity index 100%
rename from content/docs/latest/kudu-integration_133631955.md
rename to content/docs/latest/user/kudu-integration_133631955.md
diff --git a/content/docs/latest/materialized-views-in-hive_283118346.md b/content/docs/latest/user/materialized-views-in-hive_283118346.md
similarity index 100%
rename from content/docs/latest/materialized-views-in-hive_283118346.md
rename to content/docs/latest/user/materialized-views-in-hive_283118346.md
diff --git a/content/docs/latest/multidelimitserde_46631999.md b/content/docs/latest/user/multidelimitserde_46631999.md
similarity index 100%
rename from content/docs/latest/multidelimitserde_46631999.md
rename to content/docs/latest/user/multidelimitserde_46631999.md
diff --git a/content/docs/latest/parquet_38570914.md b/content/docs/latest/user/parquet_38570914.md
similarity index 100%
rename from content/docs/latest/parquet_38570914.md
rename to content/docs/latest/user/parquet_38570914.md
diff --git a/content/docs/latest/permission-inheritance-in-hive_48203008.md b/content/docs/latest/user/permission-inheritance-in-hive_48203008.md
similarity index 100%
rename from content/docs/latest/permission-inheritance-in-hive_48203008.md
rename to content/docs/latest/user/permission-inheritance-in-hive_48203008.md
diff --git a/content/docs/latest/query-reexecution_87298873.md b/content/docs/latest/user/query-reexecution_87298873.md
similarity index 100%
rename from content/docs/latest/query-reexecution_87298873.md
rename to content/docs/latest/user/query-reexecution_87298873.md
diff --git a/content/docs/latest/rcfile_58851803.md b/content/docs/latest/user/rcfile_58851803.md
similarity index 100%
rename from content/docs/latest/rcfile_58851803.md
rename to content/docs/latest/user/rcfile_58851803.md
diff --git a/content/docs/latest/rcfilecat_30748712.md b/content/docs/latest/user/rcfilecat_30748712.md
similarity index 100%
rename from content/docs/latest/rcfilecat_30748712.md
rename to content/docs/latest/user/rcfilecat_30748712.md
diff --git a/content/docs/latest/rebalance-compaction_240884502.md b/content/docs/latest/user/rebalance-compaction_240884502.md
similarity index 100%
rename from content/docs/latest/rebalance-compaction_240884502.md
rename to content/docs/latest/user/rebalance-compaction_240884502.md
diff --git a/content/docs/latest/replacing-the-implementation-of-hive-cli-using-beeline_61311909.md b/content/docs/latest/user/replacing-the-implementation-of-hive-cli-using-beeline_61311909.md
similarity index 100%
rename from content/docs/latest/replacing-the-implementation-of-hive-cli-using-beeline_61311909.md
rename to content/docs/latest/user/replacing-the-implementation-of-hive-cli-using-beeline_61311909.md
diff --git a/content/docs/latest/serde_27362059.md b/content/docs/latest/user/serde_27362059.md
similarity index 100%
rename from content/docs/latest/serde_27362059.md
rename to content/docs/latest/user/serde_27362059.md
diff --git a/content/docs/latest/starrocks-integration_272927528.md b/content/docs/latest/user/starrocks-integration_272927528.md
similarity index 100%
rename from content/docs/latest/starrocks-integration_272927528.md
rename to content/docs/latest/user/starrocks-integration_272927528.md
diff --git a/content/docs/latest/storage-based-authorization-in-the-metastore-server_45876440.md b/content/docs/latest/user/storage-based-authorization-in-the-metastore-server_45876440.md
similarity index 100%
rename from content/docs/latest/storage-based-authorization-in-the-metastore-server_45876440.md
rename to content/docs/latest/user/storage-based-authorization-in-the-metastore-server_45876440.md
diff --git a/content/docs/latest/streaming-data-ingest-v2_85477610.md b/content/docs/latest/user/streaming-data-ingest-v2_85477610.md
similarity index 100%
rename from content/docs/latest/streaming-data-ingest-v2_85477610.md
rename to content/docs/latest/user/streaming-data-ingest-v2_85477610.md
diff --git a/content/docs/latest/streaming-data-ingest_40509746.md b/content/docs/latest/user/streaming-data-ingest_40509746.md
similarity index 100%
rename from content/docs/latest/streaming-data-ingest_40509746.md
rename to content/docs/latest/user/streaming-data-ingest_40509746.md
diff --git a/content/docs/latest/teradatabinaryserde_89068127.md b/content/docs/latest/user/teradatabinaryserde_89068127.md
similarity index 100%
rename from content/docs/latest/teradatabinaryserde_89068127.md
rename to content/docs/latest/user/teradatabinaryserde_89068127.md
diff --git a/content/docs/latest/transitivity-on-predicate-pushdown_27823388.md b/content/docs/latest/user/transitivity-on-predicate-pushdown_27823388.md
similarity index 100%
rename from content/docs/latest/transitivity-on-predicate-pushdown_27823388.md
rename to content/docs/latest/user/transitivity-on-predicate-pushdown_27823388.md
diff --git a/content/docs/latest/tutorial_27362061.md b/content/docs/latest/user/tutorial_27362061.md
similarity index 100%
rename from content/docs/latest/tutorial_27362061.md
rename to content/docs/latest/user/tutorial_27362061.md
diff --git a/content/docs/latest/union-optimization_29688910.md b/content/docs/latest/user/union-optimization_29688910.md
similarity index 100%
rename from content/docs/latest/union-optimization_29688910.md
rename to content/docs/latest/user/union-optimization_29688910.md
diff --git a/content/docs/latest/user-faq_27362095.md b/content/docs/latest/user/user-faq_27362095.md
similarity index 100%
rename from content/docs/latest/user-faq_27362095.md
rename to content/docs/latest/user/user-faq_27362095.md
diff --git a/content/docs/latest/using-tidb-as-the-hive-metastore-database_158872426.md b/content/docs/latest/user/using-tidb-as-the-hive-metastore-database_158872426.md
similarity index 100%
rename from content/docs/latest/using-tidb-as-the-hive-metastore-database_158872426.md
rename to content/docs/latest/user/using-tidb-as-the-hive-metastore-database_158872426.md
diff --git a/content/docs/latest/userguide_27362066.md b/content/docs/latest/userguide_27362066.md
deleted file mode 100644
index 9d73549..0000000
--- a/content/docs/latest/userguide_27362066.md
+++ /dev/null
@@ -1,151 +0,0 @@
----
-title: "Apache Hive : UserGuide"
-date: 2024-12-12
----
-
-# Apache Hive : UserGuide
-
-NOTE: This page is deprecated and merged into [GettingStarted]({{< ref "gettingstarted_27362090" >}}).
-
-# User Guide
-
-The query language specification is available at [LanguageManual]({{< ref "languagemanual_27362030" >}}). Also see, [GettingStarted]({{< ref "gettingstarted_27362090" >}}) for setup instructions.
-
-## Supported Features
-
-## Usage Examples
-
-### Creating tables
-
-#### MovieLens User Ratings
-
-```
-CREATE TABLE u_data (
-  userid INT,
-  movieid INT,
-  rating INT,
-  unixtime STRING)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '\t'
-STORED AS TEXTFILE;
-
-```
-
-#### Apache Access Log Tables
-
-```
-add jar ../build/contrib/hive_contrib.jar;
-
-CREATE TABLE apachelog (
-  host STRING,
-  identity STRING,
-  user STRING,
-  time STRING,
-  request STRING,
-  status STRING,
-  size STRING,
-  referer STRING,
-  agent STRING)
-ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
-WITH SERDEPROPERTIES (
-  "input.regex" = "([^]*) ([^]*) ([^]*) (-|\\[^\\]*\\]) ([^ \"]*|\"[^\"]*\") (-|[0-9]*) (-|[0-9]*)(?: ([^ \"]*|\"[^\"]*\") ([^ \"]*|\"[^\"]*\"))?",
-  "output.format.string" = "%1$s %2$s %3$s %4$s %5$s %6$s %7$s %8$s %9$s"
-)
-STORED AS TEXTFILE;
-
-```
-
-#### Control Separated Tables
-
-```
-CREATE TABLE mylog (
-name STRING, language STRING, groups ARRAY<STRING>, entities MAP<INT, STRING>)
-ROW FORMAT DELIMITED
-  FIELDS TERMINATED BY '\001'
-  COLLECTION ITEMS TERMINATED BY '\002'
-  MAP KEYS TERMINATED BY '\003'
-STORED AS TEXTFILE;
-
-```
-
-### Loading tables
-
-#### MovieLens User Ratings
-
-Download and extract the data:
-
-```
-wget http://www.grouplens.org/system/files/ml-data.tar+0.gz
-tar xvzf ml-data.tar+0.gz
-
-```
-
-Load it in:
-
-```
-LOAD DATA LOCAL INPATH 'ml-data/u.data'
-OVERWRITE INTO TABLE u_data;
-
-```
-
-### Running queries
-
-#### MovieLens User Ratings
-
-```
-SELECT COUNT(1) FROM u_data;
-
-```
-
-### Running custom map/reduce jobs
-
-#### MovieLens User Ratings
-
-Create weekday_mapper.py:
-
-```
-import sys
-import datetime
-
-for line in sys.stdin:
-  line = line.strip()
-  userid, movieid, rating, unixtime = line.split('\t')
-  weekday = datetime.datetime.fromtimestamp(float(unixtime)).isoweekday()
-  print '\t'.join([userid, movieid, rating, str(weekday)])
-
-```
-
-Use the mapper script:
-
-```
-CREATE TABLE u_data_new (
-  userid INT,
-  movieid INT,
-  rating INT,
-  weekday INT)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '\t';
-
-INSERT OVERWRITE TABLE u_data_new
-SELECT
-  TRANSFORM (userid, movieid, rating, unixtime)
-  USING 'python weekday_mapper.py'
-  AS (userid, movieid, rating, weekday)
-FROM u_data;
-
-SELECT weekday, COUNT(1)
-FROM u_data_new
-GROUP BY weekday;
-
-```
-
-**Note: due to a bug in the parser, you must run the "INSERT OVERWRITE" query on a single line**
-
-### Using sampling
-
-## Known Issues/Bugs
-
- 
-
- 
-
diff --git a/content/docs/latest/webhcat/_index.md b/content/docs/latest/webhcat/_index.md
new file mode 100644
index 0000000..4f2bd0e
--- /dev/null
+++ b/content/docs/latest/webhcat/_index.md
@@ -0,0 +1,4 @@
+---
+title: "WebHCat (Templeton) Manual"
+date: 2025-07-24
+---
diff --git a/content/docs/latest/webhcat-configure_34015738.md b/content/docs/latest/webhcat/webhcat-configure_34015738.md
similarity index 97%
rename from content/docs/latest/webhcat-configure_34015738.md
rename to content/docs/latest/webhcat/webhcat-configure_34015738.md
index dac9e17..38bb6a7 100644
--- a/content/docs/latest/webhcat-configure_34015738.md
+++ b/content/docs/latest/webhcat/webhcat-configure_34015738.md
@@ -103,7 +103,7 @@ Previous: [Installation]({{< ref "webhcat-installwebhcat_34015585" >}})
 
 Hive configuration: [Configuring Hive]({{< ref "adminmanual-configuration_27362070" >}}), [Hive Configuration Properties](https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties), [Thrift Server Setup]({{< ref "#thrift-server-setup" >}})
 
-General: [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-installwebhcat_34015585.md b/content/docs/latest/webhcat/webhcat-installwebhcat_34015585.md
similarity index 98%
rename from content/docs/latest/webhcat-installwebhcat_34015585.md
rename to content/docs/latest/webhcat/webhcat-installwebhcat_34015585.md
index bcdbaf9..de21d2a 100644
--- a/content/docs/latest/webhcat-installwebhcat_34015585.md
+++ b/content/docs/latest/webhcat/webhcat-installwebhcat_34015585.md
@@ -171,7 +171,7 @@ Previous: [Using WebHCat]({{< ref "webhcat-usingwebhcat_34015492" >}})
 Hive installation: [Installing Hive]({{< ref "adminmanual-installation_27362077" >}})  
  HCatalog installation: [Installation from Tarball]({{< ref "hcatalog-installhcat_34013403" >}})
 
-General: [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-allddl_34016001.md b/content/docs/latest/webhcat/webhcat-reference-allddl_34016001.md
similarity index 94%
rename from content/docs/latest/webhcat-reference-allddl_34016001.md
rename to content/docs/latest/webhcat/webhcat-reference-allddl_34016001.md
index cf57cd5..694ab27 100644
--- a/content/docs/latest/webhcat-reference-allddl_34016001.md
+++ b/content/docs/latest/webhcat/webhcat-reference-allddl_34016001.md
@@ -45,9 +45,3 @@ Previous: [GET version]({{< ref "webhcat-reference-version_34015986" >}}) Next:
 
 HCatalog DDL commands: [HCatalog DDL]({{< ref "#hcatalog-ddl" >}}) Hive DDL commands: [Hive Data Definition Language]({{< ref "languagemanual-ddl_27362034" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat (Templeton) Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Home]({{< ref "home_27362069" >}})
-
- 
-
- 
-
diff --git a/content/docs/latest/webhcat-reference-ddl_34015990.md b/content/docs/latest/webhcat/webhcat-reference-ddl_34015990.md
similarity index 88%
rename from content/docs/latest/webhcat-reference-ddl_34015990.md
rename to content/docs/latest/webhcat/webhcat-reference-ddl_34015990.md
index c179e9e..04665df 100644
--- a/content/docs/latest/webhcat-reference-ddl_34015990.md
+++ b/content/docs/latest/webhcat/webhcat-reference-ddl_34015990.md
@@ -88,7 +88,7 @@ In [Hive 0.13.0](https://issues.apache.org/jira/browse/HIVE-6576) onward, user.n
 Previous: [GET version/hadoop]({{< ref "webhcat-reference-versionhadoop_44303410" >}})  
  Next: [GET ddl/database]({{< ref "webhcat-reference-getdbs_34016238" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-deletedb_34016281.md b/content/docs/latest/webhcat/webhcat-reference-deletedb_34016281.md
similarity index 83%
rename from content/docs/latest/webhcat-reference-deletedb_34016281.md
rename to content/docs/latest/webhcat/webhcat-reference-deletedb_34016281.md
index 1bcd0f5..6b03f41 100644
--- a/content/docs/latest/webhcat-reference-deletedb_34016281.md
+++ b/content/docs/latest/webhcat/webhcat-reference-deletedb_34016281.md
@@ -71,7 +71,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [PUT ddl/database/:db]({{< ref "webhcat-reference-putdb_34016273" >}}) Next: [GET ddl/database/:db/table]({{< ref "webhcat-reference-gettables_34016290" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-deletejob_34017204.md b/content/docs/latest/webhcat/webhcat-reference-deletejob_34017204.md
similarity index 93%
rename from content/docs/latest/webhcat-reference-deletejob_34017204.md
rename to content/docs/latest/webhcat/webhcat-reference-deletejob_34017204.md
index 04910c6..da4e3e8 100644
--- a/content/docs/latest/webhcat-reference-deletejob_34017204.md
+++ b/content/docs/latest/webhcat/webhcat-reference-deletejob_34017204.md
@@ -107,7 +107,7 @@ The job is not immediately deleted, therefore the information returned may not r
 Previous: [GET queue/:jobid]({{< ref "webhcat-reference-jobinfo_34017194" >}})  
  Next: [GET jobs]({{< ref "webhcat-reference-jobs_34835057" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
 Replaced in Hive 0.12.0 by: [DELETE jobs/:jobid]({{< ref "webhcat-reference-deletejobid_34835045" >}})
 
diff --git a/content/docs/latest/webhcat-reference-deletejobid_34835045.md b/content/docs/latest/webhcat/webhcat-reference-deletejobid_34835045.md
similarity index 93%
rename from content/docs/latest/webhcat-reference-deletejobid_34835045.md
rename to content/docs/latest/webhcat/webhcat-reference-deletejobid_34835045.md
index 8c81636..1e388d0 100644
--- a/content/docs/latest/webhcat-reference-deletejobid_34835045.md
+++ b/content/docs/latest/webhcat/webhcat-reference-deletejobid_34835045.md
@@ -101,7 +101,7 @@ The job is not immediately deleted, therefore the information returned may not r
 **Navigation Links**
 Previous: [GET jobs/:jobid]({{< ref "webhcat-reference-job_34835065" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
 Replaces deprecated resource: [DELETE queue/:jobid]({{< ref "webhcat-reference-deletejob_34017204" >}})
 
diff --git a/content/docs/latest/webhcat-reference-deletepartition_34016611.md b/content/docs/latest/webhcat/webhcat-reference-deletepartition_34016611.md
similarity index 83%
rename from content/docs/latest/webhcat-reference-deletepartition_34016611.md
rename to content/docs/latest/webhcat/webhcat-reference-deletepartition_34016611.md
index 01b488e..5e44196 100644
--- a/content/docs/latest/webhcat-reference-deletepartition_34016611.md
+++ b/content/docs/latest/webhcat/webhcat-reference-deletepartition_34016611.md
@@ -62,7 +62,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [PUT ddl/database/:db/table/:table/partition/:partition]({{< ref "webhcat-reference-putpartition_34016600" >}}) Next: [GET ddl/database/:db/table/:table/column]({{< ref "webhcat-reference-getcolumns_34016970" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-deletetable_34016561.md b/content/docs/latest/webhcat/webhcat-reference-deletetable_34016561.md
similarity index 80%
rename from content/docs/latest/webhcat-reference-deletetable_34016561.md
rename to content/docs/latest/webhcat/webhcat-reference-deletetable_34016561.md
index 8b9a78a..6518ffd 100644
--- a/content/docs/latest/webhcat-reference-deletetable_34016561.md
+++ b/content/docs/latest/webhcat/webhcat-reference-deletetable_34016561.md
@@ -58,7 +58,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [POST ddl/database/:db/table/:table]({{< ref "webhcat-reference-posttable_34016548" >}}) Next: [PUT ddl/database/:db/table/:existingtable/like/:newtable]({{< ref "webhcat-reference-puttablelike_34016572" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-getcolumn_34016979.md b/content/docs/latest/webhcat/webhcat-reference-getcolumn_34016979.md
similarity index 80%
rename from content/docs/latest/webhcat-reference-getcolumn_34016979.md
rename to content/docs/latest/webhcat/webhcat-reference-getcolumn_34016979.md
index 1b6fcd8..63a382a 100644
--- a/content/docs/latest/webhcat-reference-getcolumn_34016979.md
+++ b/content/docs/latest/webhcat/webhcat-reference-getcolumn_34016979.md
@@ -62,7 +62,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [GET ddl/database/:db/table/:table/column]({{< ref "webhcat-reference-getcolumns_34016970" >}}) Next: [PUT ddl/database/:db/table/:table/column/:column]({{< ref "webhcat-reference-putcolumn_34016987" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-getcolumns_34016970.md b/content/docs/latest/webhcat/webhcat-reference-getcolumns_34016970.md
similarity index 81%
rename from content/docs/latest/webhcat-reference-getcolumns_34016970.md
rename to content/docs/latest/webhcat/webhcat-reference-getcolumns_34016970.md
index 135fdbd..79b0c7a 100644
--- a/content/docs/latest/webhcat-reference-getcolumns_34016970.md
+++ b/content/docs/latest/webhcat/webhcat-reference-getcolumns_34016970.md
@@ -75,7 +75,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [DELETE ddl/database/:db/table/:table/partition/:partition]({{< ref "webhcat-reference-deletepartition_34016611" >}}) Next: [GET ddl/database/:db/table/:table/column/:column]({{< ref "webhcat-reference-getcolumn_34016979" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-getdb_34016250.md b/content/docs/latest/webhcat/webhcat-reference-getdb_34016250.md
similarity index 79%
rename from content/docs/latest/webhcat-reference-getdb_34016250.md
rename to content/docs/latest/webhcat/webhcat-reference-getdb_34016250.md
index 0f196a6..880821c 100644
--- a/content/docs/latest/webhcat-reference-getdb_34016250.md
+++ b/content/docs/latest/webhcat/webhcat-reference-getdb_34016250.md
@@ -68,7 +68,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [GET ddl/database]({{< ref "webhcat-reference-getdbs_34016238" >}}) Next: [PUT ddl/database/:db]({{< ref "webhcat-reference-putdb_34016273" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-getdbs_34016238.md b/content/docs/latest/webhcat/webhcat-reference-getdbs_34016238.md
similarity index 74%
rename from content/docs/latest/webhcat-reference-getdbs_34016238.md
rename to content/docs/latest/webhcat/webhcat-reference-getdbs_34016238.md
index c75824d..715788e 100644
--- a/content/docs/latest/webhcat-reference-getdbs_34016238.md
+++ b/content/docs/latest/webhcat/webhcat-reference-getdbs_34016238.md
@@ -56,7 +56,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 Previous: [POST ddl]({{< ref "webhcat-reference-ddl_34015990" >}})   
  Next: [GET ddl/database/:db]({{< ref "webhcat-reference-getdb_34016250" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-getpartition_34016592.md b/content/docs/latest/webhcat/webhcat-reference-getpartition_34016592.md
similarity index 87%
rename from content/docs/latest/webhcat-reference-getpartition_34016592.md
rename to content/docs/latest/webhcat/webhcat-reference-getpartition_34016592.md
index a73cb4b..ee64ff5 100644
--- a/content/docs/latest/webhcat-reference-getpartition_34016592.md
+++ b/content/docs/latest/webhcat/webhcat-reference-getpartition_34016592.md
@@ -92,7 +92,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [GET ddl/database/:db/table/:table/partition]({{< ref "webhcat-reference-getpartitions_34016583" >}}) Next: [PUT ddl/database/:db/table/:table/partition/:partition]({{< ref "webhcat-reference-putpartition_34016600" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-getpartitions_34016583.md b/content/docs/latest/webhcat/webhcat-reference-getpartitions_34016583.md
similarity index 81%
rename from content/docs/latest/webhcat-reference-getpartitions_34016583.md
rename to content/docs/latest/webhcat/webhcat-reference-getpartitions_34016583.md
index 2985e23..8f2e9f4 100644
--- a/content/docs/latest/webhcat-reference-getpartitions_34016583.md
+++ b/content/docs/latest/webhcat/webhcat-reference-getpartitions_34016583.md
@@ -71,7 +71,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [PUT ddl/database/:db/table/:existingtable/like/:newtable]({{< ref "webhcat-reference-puttablelike_34016572" >}}) Next: [GET ddl/database/:db/table/:table/partition/:partition]({{< ref "webhcat-reference-getpartition_34016592" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-getproperties_34016995.md b/content/docs/latest/webhcat/webhcat-reference-getproperties_34016995.md
similarity index 82%
rename from content/docs/latest/webhcat-reference-getproperties_34016995.md
rename to content/docs/latest/webhcat/webhcat-reference-getproperties_34016995.md
index cb8ea99..728a22a 100644
--- a/content/docs/latest/webhcat-reference-getproperties_34016995.md
+++ b/content/docs/latest/webhcat/webhcat-reference-getproperties_34016995.md
@@ -67,7 +67,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [PUT ddl/database/:db/table/:table/column/:column]({{< ref "webhcat-reference-putcolumn_34016987" >}}) Next: [GET ddl/database/:db/table/:table/property/:property]({{< ref "webhcat-reference-getproperty_34017004" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-getproperty_34017004.md b/content/docs/latest/webhcat/webhcat-reference-getproperty_34017004.md
similarity index 81%
rename from content/docs/latest/webhcat-reference-getproperty_34017004.md
rename to content/docs/latest/webhcat/webhcat-reference-getproperty_34017004.md
index 8d1af52..da76fcc 100644
--- a/content/docs/latest/webhcat-reference-getproperty_34017004.md
+++ b/content/docs/latest/webhcat/webhcat-reference-getproperty_34017004.md
@@ -72,7 +72,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [GET ddl/database/:db/table/:table/property]({{< ref "webhcat-reference-getproperties_34016995" >}}) Next: [PUT ddl/database/:db/table/:table/property/:property]({{< ref "webhcat-reference-putproperty_34017012" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-gettable_34016519.md b/content/docs/latest/webhcat/webhcat-reference-gettable_34016519.md
similarity index 89%
rename from content/docs/latest/webhcat-reference-gettable_34016519.md
rename to content/docs/latest/webhcat/webhcat-reference-gettable_34016519.md
index 98f96bf..6c7dc8a 100644
--- a/content/docs/latest/webhcat-reference-gettable_34016519.md
+++ b/content/docs/latest/webhcat/webhcat-reference-gettable_34016519.md
@@ -135,7 +135,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [GET ddl/database/:db/table]({{< ref "webhcat-reference-gettables_34016290" >}}) Next: [PUT ddl/database/:db/table/:table]({{< ref "webhcat-reference-puttable_34016540" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-gettables_34016290.md b/content/docs/latest/webhcat/webhcat-reference-gettables_34016290.md
similarity index 88%
rename from content/docs/latest/webhcat-reference-gettables_34016290.md
rename to content/docs/latest/webhcat/webhcat-reference-gettables_34016290.md
index c2c3f52..ceec98b 100644
--- a/content/docs/latest/webhcat-reference-gettables_34016290.md
+++ b/content/docs/latest/webhcat/webhcat-reference-gettables_34016290.md
@@ -89,7 +89,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [DELETE ddl/database/:db]({{< ref "webhcat-reference-deletedb_34016281" >}}) Next: [GET ddl/database/:db/table/:table]({{< ref "webhcat-reference-gettable_34016519" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-hive_34017180.md b/content/docs/latest/webhcat/webhcat-reference-hive_34017180.md
similarity index 93%
rename from content/docs/latest/webhcat-reference-hive_34017180.md
rename to content/docs/latest/webhcat/webhcat-reference-hive_34017180.md
index e2e5ed1..e52922f 100644
--- a/content/docs/latest/webhcat-reference-hive_34017180.md
+++ b/content/docs/latest/webhcat/webhcat-reference-hive_34017180.md
@@ -92,7 +92,7 @@ Found 2 items
 Previous: [POST pig]({{< ref "webhcat-reference-pig_34017169" >}})  
  Next: [GET queue]({{< ref "webhcat-reference-jobids_34017187" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-job_34835065.md b/content/docs/latest/webhcat/webhcat-reference-job_34835065.md
similarity index 93%
rename from content/docs/latest/webhcat-reference-job_34835065.md
rename to content/docs/latest/webhcat/webhcat-reference-job_34835065.md
index 6557f81..51cab89 100644
--- a/content/docs/latest/webhcat-reference-job_34835065.md
+++ b/content/docs/latest/webhcat/webhcat-reference-job_34835065.md
@@ -108,7 +108,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 Previous: [GET jobs]({{< ref "webhcat-reference-jobs_34835057" >}})  
  Next: [DELETE jobs/:jobid]({{< ref "webhcat-reference-deletejobid_34835045" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
 Replaces deprecated resource: [GET queue/:jobid]({{< ref "webhcat-reference-jobinfo_34017194" >}})
 
diff --git a/content/docs/latest/webhcat-reference-jobids_34017187.md b/content/docs/latest/webhcat/webhcat-reference-jobids_34017187.md
similarity index 87%
rename from content/docs/latest/webhcat-reference-jobids_34017187.md
rename to content/docs/latest/webhcat/webhcat-reference-jobids_34017187.md
index d9f9133..455d4b0 100644
--- a/content/docs/latest/webhcat-reference-jobids_34017187.md
+++ b/content/docs/latest/webhcat/webhcat-reference-jobids_34017187.md
@@ -61,7 +61,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also accepted.
 Previous: [POST hive]({{< ref "webhcat-reference-hive_34017180" >}})  
  Next: [GET queue/:jobid]({{< ref "webhcat-reference-jobinfo_34017194" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
 Replaced in Hive 0.12.0 by: [GET jobs]({{< ref "webhcat-reference-jobs_34835057" >}})
 
diff --git a/content/docs/latest/webhcat-reference-jobinfo_34017194.md b/content/docs/latest/webhcat/webhcat-reference-jobinfo_34017194.md
similarity index 95%
rename from content/docs/latest/webhcat-reference-jobinfo_34017194.md
rename to content/docs/latest/webhcat/webhcat-reference-jobinfo_34017194.md
index 9fe4797..5fdd24c 100644
--- a/content/docs/latest/webhcat-reference-jobinfo_34017194.md
+++ b/content/docs/latest/webhcat/webhcat-reference-jobinfo_34017194.md
@@ -158,7 +158,7 @@ Starting in Hive release 0.12.0, `GET queue/:jobid` returns user arguments as we
 Previous: [GET queue]({{< ref "webhcat-reference-jobids_34017187" >}})  
  Next: [DELETE queue/:jobid]({{< ref "webhcat-reference-deletejob_34017204" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
 Replaced in Hive 0.12.0 by: [GET jobs/:jobid]({{< ref "webhcat-reference-job_34835065" >}})
 
diff --git a/content/docs/latest/webhcat-reference-jobs_34835057.md b/content/docs/latest/webhcat/webhcat-reference-jobs_34835057.md
similarity index 95%
rename from content/docs/latest/webhcat-reference-jobs_34835057.md
rename to content/docs/latest/webhcat/webhcat-reference-jobs_34835057.md
index 09b212a..d49ffba 100644
--- a/content/docs/latest/webhcat-reference-jobs_34835057.md
+++ b/content/docs/latest/webhcat/webhcat-reference-jobs_34835057.md
@@ -145,7 +145,7 @@ In release 0.12.0 the first line of JSON output for the fields parameter gives t
 Previous: [DELETE queue/:jobid]({{< ref "webhcat-reference-deletejob_34017204" >}})  
  Next: [GET jobs/:jobid]({{< ref "webhcat-reference-job_34835065" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
 Replaces deprecated resource: [GET queue]({{< ref "webhcat-reference-jobids_34017187" >}})
 
diff --git a/content/docs/latest/webhcat-reference-mapreducejar_34017030.md b/content/docs/latest/webhcat/webhcat-reference-mapreducejar_34017030.md
similarity index 94%
rename from content/docs/latest/webhcat-reference-mapreducejar_34017030.md
rename to content/docs/latest/webhcat/webhcat-reference-mapreducejar_34017030.md
index 850bbb9..6bec09c 100644
--- a/content/docs/latest/webhcat-reference-mapreducejar_34017030.md
+++ b/content/docs/latest/webhcat/webhcat-reference-mapreducejar_34017030.md
@@ -95,7 +95,7 @@ In [Hive 0.13.0](https://issues.apache.org/jira/browse/HIVE-6576) onward, user.n
 Previous: [POST mapreduce/streaming]({{< ref "webhcat-reference-mapreducestream_34017023" >}})  
  Next: [POST pig]({{< ref "webhcat-reference-pig_34017169" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-mapreducestream_34017023.md b/content/docs/latest/webhcat/webhcat-reference-mapreducestream_34017023.md
similarity index 94%
rename from content/docs/latest/webhcat-reference-mapreducestream_34017023.md
rename to content/docs/latest/webhcat/webhcat-reference-mapreducestream_34017023.md
index 85adcaf..8c2d0c1 100644
--- a/content/docs/latest/webhcat-reference-mapreducestream_34017023.md
+++ b/content/docs/latest/webhcat/webhcat-reference-mapreducestream_34017023.md
@@ -115,7 +115,7 @@ drwxr-xr-x   - ctdean supergroup          0 2011-11-11 13:26 /user/ctdean/mycoun
 Previous: [PUT ddl/database/:db/table/:table/property/:property]({{< ref "webhcat-reference-putproperty_34017012" >}})  
  Next: [POST mapreduce/jar]({{< ref "webhcat-reference-mapreducejar_34017030" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-pig_34017169.md b/content/docs/latest/webhcat/webhcat-reference-pig_34017169.md
similarity index 94%
rename from content/docs/latest/webhcat-reference-pig_34017169.md
rename to content/docs/latest/webhcat/webhcat-reference-pig_34017169.md
index 928aafb..601fa4f 100644
--- a/content/docs/latest/webhcat-reference-pig_34017169.md
+++ b/content/docs/latest/webhcat/webhcat-reference-pig_34017169.md
@@ -92,7 +92,7 @@ In [Hive 0.13.0](https://issues.apache.org/jira/browse/HIVE-6576) onward, user.n
 Previous: [POST mapreduce/jar]({{< ref "webhcat-reference-mapreducejar_34017030" >}})  
  Next: [POST hive]({{< ref "webhcat-reference-hive_34017180" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-posttable_34016548.md b/content/docs/latest/webhcat/webhcat-reference-posttable_34016548.md
similarity index 84%
rename from content/docs/latest/webhcat-reference-posttable_34016548.md
rename to content/docs/latest/webhcat/webhcat-reference-posttable_34016548.md
index 1c757d2..6ea81e9 100644
--- a/content/docs/latest/webhcat-reference-posttable_34016548.md
+++ b/content/docs/latest/webhcat/webhcat-reference-posttable_34016548.md
@@ -76,7 +76,7 @@ In [Hive 0.13.0](https://issues.apache.org/jira/browse/HIVE-6576) onward, user.n
 Previous: [PUT ddl/database/:db/table/:table]({{< ref "webhcat-reference-puttable_34016540" >}})  
  Next: [DELETE ddl/database/:db/table/:table]({{< ref "webhcat-reference-deletetable_34016561" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-putcolumn_34016987.md b/content/docs/latest/webhcat/webhcat-reference-putcolumn_34016987.md
similarity index 82%
rename from content/docs/latest/webhcat-reference-putcolumn_34016987.md
rename to content/docs/latest/webhcat/webhcat-reference-putcolumn_34016987.md
index 3663f78..a5c5c0a 100644
--- a/content/docs/latest/webhcat-reference-putcolumn_34016987.md
+++ b/content/docs/latest/webhcat/webhcat-reference-putcolumn_34016987.md
@@ -65,7 +65,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [GET ddl/database/:db/table/:table/column/:column]({{< ref "webhcat-reference-getcolumn_34016979" >}}) Next: [GET ddl/database/:db/table/:table/property]({{< ref "webhcat-reference-getproperties_34016995" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-putdb_34016273.md b/content/docs/latest/webhcat/webhcat-reference-putdb_34016273.md
similarity index 80%
rename from content/docs/latest/webhcat-reference-putdb_34016273.md
rename to content/docs/latest/webhcat/webhcat-reference-putdb_34016273.md
index a355f54..dafbbad 100644
--- a/content/docs/latest/webhcat-reference-putdb_34016273.md
+++ b/content/docs/latest/webhcat/webhcat-reference-putdb_34016273.md
@@ -61,7 +61,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [GET ddl/database/:db]({{< ref "webhcat-reference-getdb_34016250" >}}) Next: [DELETE ddl/database/:db]({{< ref "webhcat-reference-deletedb_34016281" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-putpartition_34016600.md b/content/docs/latest/webhcat/webhcat-reference-putpartition_34016600.md
similarity index 84%
rename from content/docs/latest/webhcat-reference-putpartition_34016600.md
rename to content/docs/latest/webhcat/webhcat-reference-putpartition_34016600.md
index 40e3247..149cf19 100644
--- a/content/docs/latest/webhcat-reference-putpartition_34016600.md
+++ b/content/docs/latest/webhcat/webhcat-reference-putpartition_34016600.md
@@ -63,7 +63,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [GET ddl/database/:db/table/:table/partition/:partition]({{< ref "webhcat-reference-getpartition_34016592" >}}) Next: [DELETE ddl/database/:db/table/:table/partition/:partition]({{< ref "webhcat-reference-deletepartition_34016611" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-putproperty_34017012.md b/content/docs/latest/webhcat/webhcat-reference-putproperty_34017012.md
similarity index 82%
rename from content/docs/latest/webhcat-reference-putproperty_34017012.md
rename to content/docs/latest/webhcat/webhcat-reference-putproperty_34017012.md
index ca93a0a..3963097 100644
--- a/content/docs/latest/webhcat-reference-putproperty_34017012.md
+++ b/content/docs/latest/webhcat/webhcat-reference-putproperty_34017012.md
@@ -62,7 +62,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [GET ddl/database/:db/table/:table/property/:property]({{< ref "webhcat-reference-getproperty_34017004" >}}) Next: [POST mapreduce/streaming]({{< ref "webhcat-reference-mapreducestream_34017023" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-puttable_34016540.md b/content/docs/latest/webhcat/webhcat-reference-puttable_34016540.md
similarity index 93%
rename from content/docs/latest/webhcat-reference-puttable_34016540.md
rename to content/docs/latest/webhcat/webhcat-reference-puttable_34016540.md
index 6d83016..989088a 100644
--- a/content/docs/latest/webhcat-reference-puttable_34016540.md
+++ b/content/docs/latest/webhcat/webhcat-reference-puttable_34016540.md
@@ -125,7 +125,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [GET ddl/database/:db/table/:table]({{< ref "webhcat-reference-gettable_34016519" >}}) Next: [POST ddl/database/:db/table/:table]({{< ref "webhcat-reference-posttable_34016548" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-puttablelike_34016572.md b/content/docs/latest/webhcat/webhcat-reference-puttablelike_34016572.md
similarity index 83%
rename from content/docs/latest/webhcat-reference-puttablelike_34016572.md
rename to content/docs/latest/webhcat/webhcat-reference-puttablelike_34016572.md
index 6259c92..2062948 100644
--- a/content/docs/latest/webhcat-reference-puttablelike_34016572.md
+++ b/content/docs/latest/webhcat/webhcat-reference-puttablelike_34016572.md
@@ -62,7 +62,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 **Navigation Links**
 Previous: [DELETE ddl/database/:db/table/:table]({{< ref "webhcat-reference-deletetable_34016561" >}}) Next: [GET ddl/database/:db/table/:table/partition]({{< ref "webhcat-reference-getpartitions_34016583" >}})
 
-General: [DDL Resources]({{< ref "webhcat-reference-allddl_34016001" >}}) – [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-responsetypes_34015937.md b/content/docs/latest/webhcat/webhcat-reference-responsetypes_34015937.md
similarity index 80%
rename from content/docs/latest/webhcat-reference-responsetypes_34015937.md
rename to content/docs/latest/webhcat/webhcat-reference-responsetypes_34015937.md
index 6e15246..782478a 100644
--- a/content/docs/latest/webhcat-reference-responsetypes_34015937.md
+++ b/content/docs/latest/webhcat/webhcat-reference-responsetypes_34015937.md
@@ -64,7 +64,7 @@ The [standard parameters]({{< ref "#standard-parameters" >}}) are also supported
 Previous: [Reference: WebHCat Resources]({{< ref "webhcat-reference_34015762" >}})   
 Next: [GET status]({{< ref "webhcat-reference-status_34015941" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-status_34015941.md b/content/docs/latest/webhcat/webhcat-reference-status_34015941.md
similarity index 77%
rename from content/docs/latest/webhcat-reference-status_34015941.md
rename to content/docs/latest/webhcat/webhcat-reference-status_34015941.md
index 8413434..3c013a3 100644
--- a/content/docs/latest/webhcat-reference-status_34015941.md
+++ b/content/docs/latest/webhcat/webhcat-reference-status_34015941.md
@@ -50,7 +50,7 @@ Only the [standard parameters]({{< ref "#standard-parameters" >}}) are accepted.
 **Navigation Links**
 Previous: [Response Types (GET :version)]({{< ref "webhcat-reference-responsetypes_34015937" >}})Next: [GET version]({{< ref "webhcat-reference-version_34015986" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-version_34015986.md b/content/docs/latest/webhcat/webhcat-reference-version_34015986.md
similarity index 76%
rename from content/docs/latest/webhcat-reference-version_34015986.md
rename to content/docs/latest/webhcat/webhcat-reference-version_34015986.md
index d68dd61..b2cb0b4 100644
--- a/content/docs/latest/webhcat-reference-version_34015986.md
+++ b/content/docs/latest/webhcat/webhcat-reference-version_34015986.md
@@ -51,7 +51,7 @@ Only the [standard parameters]({{< ref "#standard-parameters" >}}) are accepted.
 Previous: [GET status]({{< ref "webhcat-reference-status_34015941" >}})  
  Next: [GET version/hive]({{< ref "webhcat-reference-versionhive_44303406" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-reference-versionhadoop_44303410.md b/content/docs/latest/webhcat/webhcat-reference-versionhadoop_44303410.md
similarity index 82%
rename from content/docs/latest/webhcat-reference-versionhadoop_44303410.md
rename to content/docs/latest/webhcat/webhcat-reference-versionhadoop_44303410.md
index 28dbdcc..7be68c9 100644
--- a/content/docs/latest/webhcat-reference-versionhadoop_44303410.md
+++ b/content/docs/latest/webhcat/webhcat-reference-versionhadoop_44303410.md
@@ -55,7 +55,7 @@ Returns the Hadoop version.
 Previous: [GET version/hive]({{< ref "webhcat-reference-versionhive_44303406" >}})  
 Next: [POST ddl]({{< ref "webhcat-reference-ddl_34015990" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
 Replaces deprecated resource: [GET queue]({{< ref "webhcat-reference-jobids_34017187" >}})
 
diff --git a/content/docs/latest/webhcat-reference-versionhive_44303406.md b/content/docs/latest/webhcat/webhcat-reference-versionhive_44303406.md
similarity index 80%
rename from content/docs/latest/webhcat-reference-versionhive_44303406.md
rename to content/docs/latest/webhcat/webhcat-reference-versionhive_44303406.md
index 8130a6f..4e1530e 100644
--- a/content/docs/latest/webhcat-reference-versionhive_44303406.md
+++ b/content/docs/latest/webhcat/webhcat-reference-versionhive_44303406.md
@@ -55,7 +55,7 @@ Returns the Hive version.
 Previous: [GET version]({{< ref "webhcat-reference-version_34015986" >}})  
 Next: [GET version/hadoop]({{< ref "webhcat-reference-versionhadoop_44303410" >}})
 
-General: [WebHCat Reference]({{< ref "webhcat-reference_34015762" >}}) – [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
 Replaces deprecated resource: [GET queue]({{< ref "webhcat-reference-jobids_34017187" >}})
 
diff --git a/content/docs/latest/webhcat-reference_34015762.md b/content/docs/latest/webhcat/webhcat-reference_34015762.md
similarity index 96%
rename from content/docs/latest/webhcat-reference_34015762.md
rename to content/docs/latest/webhcat/webhcat-reference_34015762.md
index 85f7535..2224ca2 100644
--- a/content/docs/latest/webhcat-reference_34015762.md
+++ b/content/docs/latest/webhcat/webhcat-reference_34015762.md
@@ -58,7 +58,7 @@ Overview of DDL resources: [WebHCat Reference: DDL]({{< ref "webhcat-reference-a
  HCatalog DDL commands: [HCatalog DDL]({{< ref "#hcatalog-ddl" >}})   
  Hive DDL commands: [Hive Data Definition Language]({{< ref "languagemanual-ddl_27362034" >}})
 
-General: [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/webhcat-usingwebhcat_34015492.md b/content/docs/latest/webhcat/webhcat-usingwebhcat_34015492.md
similarity index 96%
rename from content/docs/latest/webhcat-usingwebhcat_34015492.md
rename to content/docs/latest/webhcat/webhcat-usingwebhcat_34015492.md
index 825e9f8..1b9e54b 100644
--- a/content/docs/latest/webhcat-usingwebhcat_34015492.md
+++ b/content/docs/latest/webhcat/webhcat-usingwebhcat_34015492.md
@@ -121,7 +121,7 @@ The original work to add REST APIs to HCatalog was called Templeton. For backwar
 **Navigation Links**
 Next: [WebHCat Installation]({{< ref "webhcat-installwebhcat_34015585" >}})
 
-General: [WebHCat Manual]({{< ref "webhcat_33299069" >}}) – [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
 ## Attachments:
 
diff --git a/content/docs/latest/webhcat_33299069.md b/content/docs/latest/webhcat/webhcat_33299069.md
similarity index 80%
rename from content/docs/latest/webhcat_33299069.md
rename to content/docs/latest/webhcat/webhcat_33299069.md
index de11f9b..32a235a 100644
--- a/content/docs/latest/webhcat_33299069.md
+++ b/content/docs/latest/webhcat/webhcat_33299069.md
@@ -17,7 +17,7 @@ See the [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) for general HCatalog
 **Navigation Links**
 Next: [Using WebHCat]({{< ref "webhcat-usingwebhcat_34015492" >}})
 
-General: [HCatalog Manual]({{< ref "hcatalog_33299065" >}}) – [Hive Wiki Home]({{< ref "home_27362069" >}}) – [Hive Project Site](http://hive.apache.org/)
+
 
  
 
diff --git a/content/docs/latest/poweredby_27362055.md b/content/general/poweredby.md
similarity index 100%
rename from content/docs/latest/poweredby_27362055.md
rename to content/general/poweredby.md
diff --git a/themes/hive/layouts/partials/menu.html b/themes/hive/layouts/partials/menu.html
index 360efde..9353122 100644
--- a/themes/hive/layouts/partials/menu.html
+++ b/themes/hive/layouts/partials/menu.html
@@ -51,6 +51,7 @@
                         <ul class="dropdown-menu" aria-labelledby="navbarDropdown">
                             <li><a class="dropdown-item" href="{{ .Site.Params.navbar.license2 }}">License</a></li>
                             <li><a class="dropdown-item" href="{{.Site.BaseURL}}{{ .Site.Params.navbar.privacyPolicy }}">Privacy Policy</a></li>
+                            <li><a class="dropdown-item" href="{{ .Site.Params.navbar.poweredby }}">Powered by</a></li>
                         </ul>
                     </li>
 
@@ -78,7 +79,8 @@
                         <ul class="dropdown-menu" aria-labelledby="navbarDropdown">
                             <li><a class="dropdown-item" href="{{ .Site.Params.navbar.committer }}">Becoming A Committer</a></li>
                             <li><a class="dropdown-item" href="{{ .Site.Params.navbar.contribute }}">How To Contribute</a></li>
-                            <li><a class="dropdown-item" href="{{ .Site.Params.navbar.resourcesForDev }}">Resources for Contributors</a></li>
+                            <li><a class="dropdown-item" href="{{ .Site.Params.navbar.resourcesForDev }}">Resources</a></li>
+                            <li><a class="dropdown-item" href="{{ .Site.Params.navbar.meetings }}">Meetings</a></li>
                             <li><a class="dropdown-item" href="{{.Site.BaseURL}}{{ .Site.Params.navbar.mailinglists }}">Mailing Lists</a></li>
                             <li><a class="dropdown-item" href="{{.Site.BaseURL}}{{ .Site.Params.navbar.issueTracking }}">Issue Tracking</a></li>
                             <li><a class="dropdown-item" href="{{.Site.BaseURL}}{{ .Site.Params.navbar.people }}">People</a></li>
diff --git a/themes/hive/static/attachments/OuterJoinBehavior.html b/themes/hive/static/attachments/OuterJoinBehavior.html
new file mode 100644
index 0000000..bcfd8f2
--- /dev/null
+++ b/themes/hive/static/attachments/OuterJoinBehavior.html
@@ -0,0 +1,535 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
+<head>
+<title>Hive Outer Join Behavior</title>
+<!-- 2013-11-27 Wed 15:42 -->
+<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
+<meta name="generator" content="Org-mode"/>
+<meta name="author" content="Harish Butani"/>
+<style type="text/css">
+ <!--/*--><![CDATA[/*><!--*/
+  .title  { text-align: center; }
+  .todo   { font-family: monospace; color: red; }
+  .done   { color: green; }
+  .tag    { background-color: #eee; font-family: monospace;
+            padding: 2px; font-size: 80%; font-weight: normal; }
+  .timestamp { color: #bebebe; }
+  .timestamp-kwd { color: #5f9ea0; }
+  .right  { margin-left: auto; margin-right: 0px;  text-align: right; }
+  .left   { margin-left: 0px;  margin-right: auto; text-align: left; }
+  .center { margin-left: auto; margin-right: auto; text-align: center; }
+  .underline { text-decoration: underline; }
+  #postamble p, #preamble p { font-size: 90%; margin: .2em; }
+  p.verse { margin-left: 3%; }
+  pre {
+    border: 1px solid #ccc;
+    box-shadow: 3px 3px 3px #eee;
+    padding: 8pt;
+    font-family: monospace;
+    overflow: auto;
+    margin: 1.2em;
+  }
+  pre.src {
+    position: relative;
+    overflow: visible;
+    padding-top: 1.2em;
+  }
+  pre.src:before {
+    display: none;
+    position: absolute;
+    background-color: white;
+    top: -10px;
+    right: 10px;
+    padding: 3px;
+    border: 1px solid black;
+  }
+  pre.src:hover:before { display: inline;}
+  pre.src-sh:before    { content: 'sh'; }
+  pre.src-bash:before  { content: 'sh'; }
+  pre.src-emacs-lisp:before { content: 'Emacs Lisp'; }
+  pre.src-R:before     { content: 'R'; }
+  pre.src-perl:before  { content: 'Perl'; }
+  pre.src-java:before  { content: 'Java'; }
+  pre.src-sql:before   { content: 'SQL'; }
+
+  table { border-collapse:collapse; }
+  td, th { vertical-align:top;  }
+  th.right  { text-align: center;  }
+  th.left   { text-align: center;   }
+  th.center { text-align: center; }
+  td.right  { text-align: right;  }
+  td.left   { text-align: left;   }
+  td.center { text-align: center; }
+  dt { font-weight: bold; }
+  .footpara:nth-child(2) { display: inline; }
+  .footpara { display: block; }
+  .footdef  { margin-bottom: 1em; }
+  .figure { padding: 1em; }
+  .figure p { text-align: center; }
+  .inlinetask {
+    padding: 10px;
+    border: 2px solid gray;
+    margin: 10px;
+    background: #ffffcc;
+  }
+  #org-div-home-and-up
+   { text-align: right; font-size: 70%; white-space: nowrap; }
+  textarea { overflow-x: auto; }
+  .linenr { font-size: smaller }
+  .code-highlighted { background-color: #ffff00; }
+  .org-info-js_info-navigation { border-style: none; }
+  #org-info-js_console-label
+    { font-size: 10px; font-weight: bold; white-space: nowrap; }
+  .org-info-js_search-highlight
+    { background-color: #ffff00; color: #000000; font-weight: bold; }
+  /*]]>*/-->
+</style>
+<script type="text/javascript">
+/*
+@licstart  The following is the entire license notice for the
+JavaScript code in this tag.
+
+Copyright (C) 2012  Free Software Foundation, Inc.
+
+The JavaScript code in this tag is free software: you can
+redistribute it and/or modify it under the terms of the GNU
+General Public License (GNU GPL) as published by the Free Software
+Foundation, either version 3 of the License, or (at your option)
+any later version.  The code is distributed WITHOUT ANY WARRANTY;
+without even the implied warranty of MERCHANTABILITY or FITNESS
+FOR A PARTICULAR PURPOSE.  See the GNU GPL for more details.
+
+As additional permission under GNU GPL version 3 section 7, you
+may distribute non-source (e.g., minimized or compacted) forms of
+that code without the copy of the GNU GPL normally required by
+section 4, provided you include this license notice and a URL
+through which recipients can access the Corresponding Source.
+
+
+@licend  The above is the entire license notice
+for the JavaScript code in this tag.
+*/
+<!--/*--><![CDATA[/*><!--*/
+ function CodeHighlightOn(elem, id)
+ {
+   var target = document.getElementById(id);
+   if(null != target) {
+     elem.cacheClassElem = elem.className;
+     elem.cacheClassTarget = target.className;
+     target.className = "code-highlighted";
+     elem.className   = "code-highlighted";
+   }
+ }
+ function CodeHighlightOff(elem, id)
+ {
+   var target = document.getElementById(id);
+   if(elem.cacheClassElem)
+     elem.className = elem.cacheClassElem;
+   if(elem.cacheClassTarget)
+     target.className = elem.cacheClassTarget;
+ }
+/*]]>*///-->
+</script>
+</head>
+<body>
+<div id="content">
+<h1 class="title">Hive Outer Join Behavior</h1>
+
+<div id="outline-container-sec-1" class="outline-2">
+<h2 id="sec-1"><span class="section-number-2">1</span> Definitions:</h2>
+<div class="outline-text-2" id="text-1">
+<p>
+This based on writeup of <a href="http://www.ibm.com/developerworks/data/library/techarticle/purcell/0112purcell.html">DB2 Outer Join behavior</a>.
+</p>
+
+<dl class="org-dl">
+<dt> Preserved Row table </dt><dd>In an Outer Join this is the table that must
+return all rows. So for left outer joins this is the <i>Left</i>
+table, for right outer joins, it is the <i>Right</i> table, and for
+full outer both tables are <i>Preserved Row</i> tables.
+</dd>
+<dt> Null Supplying tables </dt><dd>this is the table that can that has nulls
+filled in for its columns. In the non full outer case, this is
+the other table in the Join. For full outer both tables are also
+<i>Null Supplying</i> tables.
+</dd>
+<dt> During Join predicate </dt><dd>these are predicates that are in the Join
+<b>On</b> clause. For e.g. 'R1 join R2 on R1.x = 5'. The predicate
+'R1.x = 5' is a <i>During Join predicate</i>
+</dd>
+<dt> After Join predicate </dt><dd>these are predicates that are in the Where
+clause. 
+</dd>
+</dl>
+</div>
+</div>
+<div id="outline-container-sec-2" class="outline-2">
+<h2 id="sec-2"><span class="section-number-2">2</span> Predicate Pushdown Rules</h2>
+<div class="outline-text-2" id="text-2">
+<p>
+The logic can be summarized by these 2 rules:
+</p>
+<ol class="org-ol">
+<li><b>During Join Predicates</b> cannot be pushed past <b>Preserved Row tables</b>.
+</li>
+<li><b>After Join Predicates</b> cannot be pushed past <b>Null Supplying
+tables</b>.
+</li>
+</ol>
+
+<p>
+This captured in the following table:
+</p>
+
+<table border="2" cellspacing="0" cellpadding="6" rules="groups" frame="hsides">
+
+
+<colgroup>
+<col class="left"/>
+
+<col class="left"/>
+
+<col class="left"/>
+</colgroup>
+<thead>
+<tr>
+<th scope="col" class="left">&#xa0;</th>
+<th scope="col" class="left">Preserved Row Table</th>
+<th scope="col" class="left">Null Supplying Table</th>
+</tr>
+</thead>
+<tbody>
+<tr>
+<td class="left">Join</td>
+<td class="left">Case J1:</td>
+<td class="left">Case J2:</td>
+</tr>
+
+<tr>
+<td class="left">Predicate</td>
+<td class="left">Not Pushed</td>
+<td class="left">Pushed</td>
+</tr>
+</tbody>
+<tbody>
+<tr>
+<td class="left">Where</td>
+<td class="left">Case W1:</td>
+<td class="left">Case W2:</td>
+</tr>
+
+<tr>
+<td class="left">Predicate</td>
+<td class="left">Pushed</td>
+<td class="left">Not Pushed</td>
+</tr>
+</tbody>
+</table>
+</div>
+
+<div id="outline-container-sec-2-1" class="outline-3">
+<h3 id="sec-2-1"><span class="section-number-3">2.1</span> Hive implementation</h3>
+<div class="outline-text-3" id="text-2-1">
+<p>
+Hive enforces these Rules by:
+</p>
+<dl class="org-dl">
+<dt> Rule 1 </dt><dd>During <b>QBJoinTree</b> construction in Plan Gen, the parse
+Join Condition logic applies this rule.
+</dd>
+<dt> Rule 2 </dt><dd>During <b>JoinPPD</b> (Join Predicate Pushdown) the get
+Qualified Alias logic applies this rule.
+</dd>
+</dl>
+</div>
+</div>
+</div>
+<div id="outline-container-sec-3" class="outline-2">
+<h2 id="sec-3"><span class="section-number-2">3</span> Examples</h2>
+<div class="outline-text-2" id="text-3">
+<p>
+Given Src(Key String, Value String) the following Left outer Join
+examples show that Hive has the correct behavior.
+</p>
+</div>
+
+<div id="outline-container-sec-3-1" class="outline-3">
+<h3 id="sec-3-1"><span class="section-number-3">3.1</span> Case J1: Join Predicate on Preserved Row table</h3>
+<div class="outline-text-3" id="text-3-1">
+<div class="org-src-container">
+
+<pre class="src src-sql">explain 
+select s1.key, s2.key 
+from src s1 left join src s2 on s1.key &gt; '2';
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -&gt; Map Operator Tree:
+	s1
+	  TableScan
+	    alias: s1
+	    Reduce Output Operator
+	      sort order:
+	      tag: 0
+	      value expressions:
+		    expr: key
+		    type: string
+	s2
+	  TableScan
+	    alias: s2
+	    Reduce Output Operator
+	      sort order:
+	      tag: 1
+	      value expressions:
+		    expr: key
+		    type: string
+      Reduce Operator Tree:
+	Join Operator
+	  condition map:
+	       Left Outer Join0 to 1
+	  condition expressions:
+	    0 {VALUE._col0}
+	    1 {VALUE._col0}
+	  filter predicates:
+	    0 {(VALUE._col0 &gt; '2')}
+	    1
+	  handleSkewJoin: false
+	  outputColumnNames: _col0, _col4
+	  Select Operator
+	    expressions:
+		  expr: _col0
+		  type: string
+		  expr: _col4
+		  type: string
+	    outputColumnNames: _col0, _col1
+	    File Output Operator
+	      compressed: false
+	      GlobalTableId: 0
+	      table:
+		  input format: org.apache.hadoop.mapred.TextInputFormat
+		  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+		  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+</pre>
+</div>
+</div>
+</div>
+<div id="outline-container-sec-3-2" class="outline-3">
+<h3 id="sec-3-2"><span class="section-number-3">3.2</span> Case J2: Join Predicate on Null Supplying table</h3>
+<div class="outline-text-3" id="text-3-2">
+<div class="org-src-container">
+
+<pre class="src src-sql">explain 
+select s1.key, s2.key 
+from src s1 left join src s2 on s2.key &gt; '2';
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -&gt; Map Operator Tree:
+	s1
+	  TableScan
+	    alias: s1
+	    Reduce Output Operator
+	      sort order:
+	      tag: 0
+	      value expressions:
+		    expr: key
+		    type: string
+	s2
+	  TableScan
+	    alias: s2
+	    Filter Operator
+	      predicate:
+		  expr: (key &gt; '2')
+		  type: boolean
+	      Reduce Output Operator
+		sort order:
+		tag: 1
+		value expressions:
+		      expr: key
+		      type: string
+      Reduce Operator Tree:
+	Join Operator
+	  condition map:
+	       Left Outer Join0 to 1
+	  condition expressions:
+	    0 {VALUE._col0}
+	    1 {VALUE._col0}
+	  handleSkewJoin: false
+	  outputColumnNames: _col0, _col4
+	  Select Operator
+	    expressions:
+		  expr: _col0
+		  type: string
+		  expr: _col4
+		  type: string
+	    outputColumnNames: _col0, _col1
+	    File Output Operator
+	      compressed: false
+	      GlobalTableId: 0
+	      table:
+		  input format: org.apache.hadoop.mapred.TextInputFormat
+		  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+		  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+</pre>
+</div>
+</div>
+</div>
+<div id="outline-container-sec-3-3" class="outline-3">
+<h3 id="sec-3-3"><span class="section-number-3">3.3</span> Case W1: Where Predicate on Preserved Row table</h3>
+<div class="outline-text-3" id="text-3-3">
+<div class="org-src-container">
+
+<pre class="src src-sql">explain 
+select s1.key, s2.key 
+from src s1 left join src s2 
+where s1.key &gt; '2';
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -&gt; Map Operator Tree:
+	s1
+	  TableScan
+	    alias: s1
+	    Filter Operator
+	      predicate:
+		  expr: (key &gt; '2')
+		  type: boolean
+	      Reduce Output Operator
+		sort order:
+		tag: 0
+		value expressions:
+		      expr: key
+		      type: string
+	s2
+	  TableScan
+	    alias: s2
+	    Reduce Output Operator
+	      sort order:
+	      tag: 1
+	      value expressions:
+		    expr: key
+		    type: string
+      Reduce Operator Tree:
+	Join Operator
+	  condition map:
+	       Left Outer Join0 to 1
+	  condition expressions:
+	    0 {VALUE._col0}
+	    1 {VALUE._col0}
+	  handleSkewJoin: false
+	  outputColumnNames: _col0, _col4
+	  Select Operator
+	    expressions:
+		  expr: _col0
+		  type: string
+		  expr: _col4
+		  type: string
+	    outputColumnNames: _col0, _col1
+	    File Output Operator
+	      compressed: false
+	      GlobalTableId: 0
+	      table:
+		  input format: org.apache.hadoop.mapred.TextInputFormat
+		  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+		  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+</pre>
+</div>
+</div>
+</div>
+<div id="outline-container-sec-3-4" class="outline-3">
+<h3 id="sec-3-4"><span class="section-number-3">3.4</span> Case W2: Where Predicate on Null Supplying table</h3>
+<div class="outline-text-3" id="text-3-4">
+<div class="org-src-container">
+
+<pre class="src src-sql">explain
+select s1.key, s2.key 
+from src s1 left join src s2 
+where s2.key &gt; '2';
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -&gt; Map Operator Tree:
+	s1
+	  TableScan
+	    alias: s1
+	    Reduce Output Operator
+	      sort order:
+	      tag: 0
+	      value expressions:
+		    expr: key
+		    type: string
+	s2
+	  TableScan
+	    alias: s2
+	    Reduce Output Operator
+	      sort order:
+	      tag: 1
+	      value expressions:
+		    expr: key
+		    type: string
+      Reduce Operator Tree:
+	Join Operator
+	  condition map:
+	       Left Outer Join0 to 1
+	  condition expressions:
+	    0 {VALUE._col0}
+	    1 {VALUE._col0}
+	  handleSkewJoin: false
+	  outputColumnNames: _col0, _col4
+	  Filter Operator
+	    predicate:
+		expr: (_col4 &gt; '2')
+		type: boolean
+	    Select Operator
+	      expressions:
+		    expr: _col0
+		    type: string
+		    expr: _col4
+		    type: string
+	      outputColumnNames: _col0, _col1
+	      File Output Operator
+		compressed: false
+		GlobalTableId: 0
+		table:
+		    input format: org.apache.hadoop.mapred.TextInputFormat
+		    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+		    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+</pre>
+</div>
+</div>
+</div>
+</div>
+</div>
+<div id="postamble" class="status">
+<p class="author">Author: Harish Butani</p>
+<p class="date">Created: 2013-11-27 Wed 15:42</p>
+<p class="creator"><a href="http://www.gnu.org/software/emacs/">Emacs</a> 24.3.1 (<a href="http://orgmode.org">Org</a> mode 8.0.3)</p>
+<p class="xhtml-validation"><a href="http://validator.w3.org/check?uri=referer">Validate XHTML 1.0</a></p>
+</div>
+</body>
+</html>