连接 Hive 的四种方法

系统管理员 2023-07-10 08:28 36阅读 0赞

**Table of Contents**

Running Hive

Hive CLI

Hive命令行选项

例子

shell 命令

Sample Usage:

HiveServer2 and Beeline

Beeline Hive Commands

Beeline Command Options

HCatalog

HCatalog CLI

HCatalog DDL

WebHCat (Templeton)

URL Format

WebHCat Resources

--------------------

# Running Hive #

*  Hive CLI

$HIVE\_HOME/bin/hive(连接命令)

*  HiveServer2 and Beeline

$HIVE\_HOME/bin/hiveserver2（h2的启动命令）

$HIVE\_HOME/bin/beeline -u jdbc:hive2://$H2\_HOST:$H2\_PORT(连接命令)

*  HCatalog

$HIVE\_HOME/bin/hcat -e "show tables;"(双引号内放sql)

*  WebHCat (Templeton)

# Hive CLI #

## Hive命令行选项 ##

"`hive -H`" or "`hive --help`" 获取帮助，如下：

usage: hive
 -d,--define <key=value> 应用于 Hive 命令的变量替换。 e.g. -d A=B or --define A=B
 -e <quoted-query-string> 命令行 SQL 语句
 -f <filename> SQL文件
 -H,--help Print help information
 -h <hostname> 连接到远程主机上的Hive服务器
 --hiveconf <property=value> 使用给定属性的值
 --hivevar <key=value> 变量替换应用到Hive
 commands. e.g. --hivevar A=B
 -i <filename> 初始化SQL文件
 -p <port> 在端口号上连接到Hive服务器
 -S,--silent 交互式shell中的静默模式
 -v,--verbose 详细模式(回显执行到控制台的SQL)

## 例子 ##

* 从命令行运行查询的示例
 
 > $HIVE_HOME/bin/hive -e 'select a.col from tab1 a'
 * 设置hive配置变量的例子
 
 > $HIVE_HOME/bin/hive -e 'select a.col from tab1 a' --hiveconf hive.exec.scratchdir=/home/my/hive_scratch --hiveconf mapred.reduce.tasks=32
 * 使用静默模式将数据从查询转储到文件的示例
 
 > $HIVE_HOME/bin/hive -S -e 'select a.col from tab1 a' > a.txt
 * 从本地磁盘以非交互方式运行脚本的示例
 
 > $HIVE_HOME/bin/hive -f /home/my/hive-script.sql
 * 从Hadoop支持的文件系统中以非交互方式运行脚本的示例 (starting in [Hive 0.14][])
 
 > $HIVE_HOME/bin/hive -f hdfs://<namenode>:<port>/hive-script.sql
 > $HIVE_HOME/bin/hive -f s3://mys3bucket/s3-script.sql 
 * 在进入交互模式之前运行初始化脚本的例子
 
 > $HIVE_HOME/bin/hive -i /home/my/hive-init.sql

## shell 命令 ##

<table> 
 <tbody> 
 <tr> 
 <td style="width:287px;"> quit exit </td> 
 <td style="width:617px;"> Use quit or exit to leave the interactive shell. </td> 
 </tr> 
 <tr> 
 <td style="width:287px;"> reset </td> 
 <td style="width:617px;"> 将配置重置为默认值 (as of Hive 0.10: see <a href="https://issues.apache.org/jira/browse/HIVE-3202" rel="nofollow">HIVE-3202</a>). </td> 
 </tr> 
 <tr> 
 <td style="width:287px;"> set &lt;key&gt;=&lt;value&gt; </td> 
 <td style="width:617px;"> 设置特定配置变量的值(key). Note: 如果您拼错了变量名，CLI将不会显示错误。 </td> 
 </tr> 
 <tr> 
 <td style="width:287px;"> set </td> 
 <td style="width:617px;">打印用户或Hive覆盖的配置变量列表。</td> 
 </tr> 
 <tr> 
 <td style="width:287px;"> set -v </td> 
 <td style="width:617px;">打印所有Hadoop和Hive配置变量。</td> 
 </tr> 
 <tr> 
 <td style="width:287px;"> add FILE[S] &lt;filepath&gt; &lt;filepath&gt;* add JAR[S] &lt;filepath&gt; &lt;filepath&gt;* add ARCHIVE[S] &lt;filepath&gt; &lt;filepath&gt;* </td> 
 <td style="width:617px;"> 将一个或多个文件、jar或归档文件添加到分布式缓存中的资源列表中。See <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli#LanguageManualCli-HiveResources" rel="nofollow">Hive Resources</a> below for more information. </td> 
 </tr> 
 <tr> 
 <td colspan="1" style="width:287px;">add FILE[S] &lt;ivyurl&gt; &lt;ivyurl&gt;* add JAR[S] &lt;ivyurl&gt; &lt;ivyurl&gt;* add ARCHIVE[S] &lt;ivyurl&gt; &lt;ivyurl&gt;*</td> 
 <td colspan="1" style="width:617px;">从Hive 1.2.0开始，使用Ivy://group:module:version?query_string形式的Ivy URL将一个或多个文件、jar或归档文件添加到分布式缓存中的资源列表中。See <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli#LanguageManualCli-HiveResources" rel="nofollow">Hive Resources</a> below for more information.</td> 
 </tr> 
 <tr> 
 <td style="width:287px;"> list FILE[S] list JAR[S] list ARCHIVE[S] </td> 
 <td style="width:617px;"> 列出已经添加到分布式缓存的资源。See <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli#LanguageManualCli-HiveResources" rel="nofollow">Hive Resources</a> below for more information. </td> 
 </tr> 
 <tr> 
 <td style="width:287px;"> list FILE[S] &lt;filepath&gt;* list JAR[S] &lt;filepath&gt;* list ARCHIVE[S] &lt;filepath&gt;* </td> 
 <td style="width:617px;"> 检查给定的资源是否已经添加到分布式缓存中。See <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli#LanguageManualCli-HiveResources" rel="nofollow">Hive Resources</a> below for more information. </td> 
 </tr> 
 <tr> 
 <td style="width:287px;"> delete FILE[S] &lt;filepath&gt;* delete JAR[S] &lt;filepath&gt;* delete ARCHIVE[S] &lt;filepath&gt;* </td> 
 <td style="width:617px;">从分布式缓存中删除资源。</td> 
 </tr> 
 <tr> 
 <td colspan="1" style="width:287px;">delete FILE[S] &lt;ivyurl&gt; &lt;ivyurl&gt;* delete JAR[S] &lt;ivyurl&gt; &lt;ivyurl&gt;* delete ARCHIVE[S] &lt;ivyurl&gt; &lt;ivyurl&gt;*</td> 
 <td colspan="1" style="width:617px;"> 从Hive 1.2.0开始，从分布式缓存中删除使用&lt;ivyurl&gt;添加的资源。See <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli#LanguageManualCli-HiveResources" rel="nofollow">Hive Resources</a> below for more information. </td> 
 </tr> 
 <tr> 
 <td style="width:287px;"> ! &lt;command&gt; </td> 
 <td style="width:617px;">从Hive shell执行shell命令。</td> 
 </tr> 
 <tr> 
 <td style="width:287px;"> dfs &lt;dfs command&gt; </td> 
 <td style="width:617px;">从Hive shell执行dfs命令。</td> 
 </tr> 
 <tr> 
 <td style="width:287px;"> &lt;query string&gt; </td> 
 <td style="width:617px;">执行Hive查询并将结果打印到标准输出。</td> 
 </tr> 
 <tr> 
 <td style="width:287px;"> source &lt;filepath&gt; </td> 
 <td style="width:617px;">在CLI中执行脚本文件。</td> 
 </tr> 
 </tbody> 
</table>

##  Sample Usage: ##

>     hive> set mapred.reduce.tasks=32;
>       hive> set;
>       hive> select a.* from tab1;
>       hive> !ls;
>       hive> dfs -ls;

原文：[https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli][https_cwiki.apache.org_confluence_display_Hive_LanguageManual_Cli]

# HiveServer2 and Beeline #

HiveServer2 (在Hive 0.11中引入)有自己的CLI，称为 Beeline，它是一个基于 SQLLine 的 JDBC 客户机。由于 HiveServer2 的新开发，Hive CLI 将很快被弃用，取而代之的是 Beeline (Hive -10511)。

## Beeline Hive Commands ##

<table> 
 <tbody> 
 <tr> 
 <td style="width:238px;"> reset </td> 
 <td style="width:666px;">配置重置为默认值。</td> 
 </tr> 
 <tr> 
 <td colspan="1" style="width:238px;">reset &lt;key&gt;</td> 
 <td colspan="1" style="width:666px;"> 将特定配置变量(键)的值重置为默认值。 Note: 如果您拼错了变量名，则Beeline将不会显示错误。 </td> 
 </tr> 
 <tr> 
 <td style="width:238px;"> set &lt;key&gt;=&lt;value&gt; </td> 
 <td style="width:666px;"> 设置特定配置变量(键)的值。 Note: 如果您拼错了变量名，则Beeline将不会显示错误。 </td> 
 </tr> 
 <tr> 
 <td style="width:238px;"> set </td> 
 <td style="width:666px;">打印用户或Hive覆盖的配置变量列表。</td> 
 </tr> 
 <tr> 
 <td style="width:238px;"> set -v </td> 
 <td style="width:666px;">打印所有Hadoop和Hive配置变量。</td> 
 </tr> 
 <tr> 
 <td style="width:238px;"> add FILE[S] &lt;filepath&gt; &lt;filepath&gt;* add JAR[S] &lt;filepath&gt; &lt;filepath&gt;* add ARCHIVE[S] &lt;filepath&gt; &lt;filepath&gt;* </td> 
 <td style="width:666px;"> 将一个或多个文件、jar或归档文件添加到分布式缓存中的资源列表中。See <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli#LanguageManualCli-HiveResources" rel="nofollow">Hive Resources</a> for more information. </td> 
 </tr> 
 <tr> 
 <td colspan="1" style="width:238px;">add FILE[S] &lt;ivyurl&gt; &lt;ivyurl&gt;*&nbsp; add JAR[S]&nbsp;&lt;ivyurl&gt; &lt;ivyurl&gt;*&nbsp; add ARCHIVE[S] &lt;ivyurl&gt; &lt;ivyurl&gt;*</td> 
 <td colspan="1" style="width:666px;">从Hive 1.2.0开始，使用Ivy://group:module:version?query_string形式的Ivy URL将一个或多个文件、jar或归档文件添加到分布式缓存中的资源列表中。&nbsp;See&nbsp;<a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli#LanguageManualCli-HiveResources" rel="nofollow">Hive Resources</a> for more information.</td> 
 </tr> 
 <tr> 
 <td style="width:238px;"> list FILE[S] list JAR[S] list ARCHIVE[S] </td> 
 <td style="width:666px;"> 列出已经添加到分布式缓存的资源。 See <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli#LanguageManualCli-HiveResources" rel="nofollow">Hive Resources</a> for more information. (As of Hive 0.14.0: <a href="https://issues.apache.org/jira/browse/HIVE-7592" rel="nofollow">HIVE-7592</a>). </td> 
 </tr> 
 <tr> 
 <td style="width:238px;"> list FILE[S] &lt;filepath&gt;* list JAR[S] &lt;filepath&gt;* list ARCHIVE[S] &lt;filepath&gt;* </td> 
 <td style="width:666px;"> 检查给定的资源是否已经添加到分布式缓存中。See <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli#LanguageManualCli-HiveResources" rel="nofollow">Hive Resources</a> for more information. </td> 
 </tr> 
 <tr> 
 <td style="width:238px;"> delete FILE[S] &lt;filepath&gt;* delete JAR[S] &lt;filepath&gt;* delete ARCHIVE[S] &lt;filepath&gt;* </td> 
 <td style="width:666px;">从分布式缓存中删除资源。</td> 
 </tr> 
 <tr> 
 <td colspan="1" style="width:238px;">delete FILE[S] &lt;ivyurl&gt; &lt;ivyurl&gt;*&nbsp; delete JAR[S] &lt;ivyurl&gt; &lt;ivyurl&gt;*&nbsp; delete ARCHIVE[S] &lt;ivyurl&gt; &lt;ivyurl&gt;*</td> 
 <td colspan="1" style="width:666px;"> 从Hive 1.2.0开始，从分布式缓存中删除使用&lt;ivyurl&gt;添加的资源。See&nbsp;<a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli#LanguageManualCli-HiveResources" rel="nofollow">Hive Resources</a> for more information. </td> 
 </tr> 
 <tr> 
 <td colspan="1" style="width:238px;">reload</td> 
 <td colspan="1" style="width:666px;">使HiveServer2知道配置参数hive.reloadable.aux.jars指定的路径中的任何jar更改。路径(不需要重新启动HiveServer2)。更改可以是添加、删除或更新jar文件。</td> 
 </tr> 
 <tr> 
 <td style="width:238px;"> dfs &lt;dfs command&gt; </td> 
 <td style="width:666px;">执行dfs命令。</td> 
 </tr> 
 <tr> 
 <td style="width:238px;"> &lt;query string&gt; </td> 
 <td style="width:666px;">执行Hive查询并将结果打印到标准输出。</td> 
 </tr> 
 </tbody> 
</table>

## Beeline Command Options ##

<table> 
 <tbody> 
 <tr> 
 <td> -u &lt;database URL&gt; </td> 
 <td> 要连接的JDBC URL。如果需要，应该使用URL编码对参数值中的特殊字符进行编码。 Usage: <code> beeline -u </code>db_URL&nbsp; </td> 
 </tr> 
 <tr> 
 <td> -r </td> 
 <td> 重新连接到最后使用的URL(如果用户以前使用过!连接到一个URL并使用!保存到一个直线。)属性文件)。 Usage: <code> beeline -r</code> Version: 2.1.0 (<a href="https://issues.apache.org/jira/browse/HIVE-13670" rel="nofollow">HIVE-13670</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1"> -n &lt;username&gt; </td> 
 <td colspan="1"> 要连接的用户名。 Usage: <code> beeline -n </code>valid_user </td> 
 </tr> 
 <tr> 
 <td> -p &lt;password&gt; </td> 
 <td> 连接的密码 Usage: <code> beeline -p </code>valid_password Optional password mode: 启动Hive 2.2.0 (Hive -13589) -p选项的参数是可选的。Usage : beeline -p [valid_password] 如果在-p之后没有提供密码，则在启动连接时，Beeline将提示输入密码。当提供密码时，Beeline会在没有提示的情况下启动连接。 </td> 
 </tr> 
 <tr> 
 <td> -d &lt;driver class&gt; </td> 
 <td> 要使用的驱动程序类。 Usage: <code> beeline -d </code>driver_class </td> 
 </tr> 
 <tr> 
 <td> -e &lt;query&gt; </td> 
 <td> 应该执行的查询。双引号或单引号括住查询字符串。可以多次指定此选项。 Usage: <code> beeline -e "</code>query_string" 支持在一个SQL语句中运行多个由分号分隔的SQL语句query_string: 1.2.0 (<a href="https://issues.apache.org/jira/browse/HIVE-9877" rel="nofollow">HIVE-9877</a>) Bug fix (null pointer exception): 0.13.0 (<a href="https://issues.apache.org/jira/browse/HIVE-5765" rel="nofollow">HIVE-5765</a>) Bug fix (--headerInterval not honored): 0.14.0 (<a href="https://issues.apache.org/jira/browse/HIVE-7647" rel="nofollow">HIVE-7647</a>) Bug fix (running <code>-e</code> in background): 1.3.0 and 2.0.0 (<a href="https://issues.apache.org/jira/browse/HIVE-6758" rel="nofollow">HIVE-6758</a>); <a href="https://issues.apache.org/jira/browse/HIVE-6758?focusedCommentId=13954968&amp;page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13954968" rel="nofollow">workaround available</a> for earlier versions&nbsp; </td> 
 </tr> 
 <tr> 
 <td colspan="1">-f &lt;file&gt;</td> 
 <td colspan="1"> 应该执行的脚本文件。 Usage: <code> beeline -f </code>filepath Version: 0.12.0 (<a href="https://issues.apache.org/jira/browse/HIVE-4268" rel="nofollow">HIVE-4268</a>) Note: 如果脚本包含选项卡，则在版本0.12.0中查询编译失败。 This bug is fixed in version 0.13.0 (<a href="https://issues.apache.org/jira/browse/HIVE-6359" rel="nofollow">HIVE-6359</a>). Bug fix (running <code>-f</code> in background): 1.3.0 and 2.0.0 (<a href="https://issues.apache.org/jira/browse/HIVE-6758" rel="nofollow">HIVE-6758</a>); <a href="https://issues.apache.org/jira/browse/HIVE-6758?focusedCommentId=13954968&amp;page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13954968" rel="nofollow">workaround available</a> for earlier versions&nbsp; </td> 
 </tr> 
 <tr> 
 <td colspan="1">-i (or) --init &lt;file or files&gt;</td> 
 <td colspan="1"> 初始化的init文件 Usage: <code> beeline -i /tmp/initfile</code> Single file: Version: 0.14.0 (<a href="https://issues.apache.org/jira/browse/HIVE-6561" rel="nofollow">HIVE-6561</a>) Multiple files: Version: 2.1.0 (<a href="https://issues.apache.org/jira/browse/HIVE-11336" rel="nofollow">HIVE-11336</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">-w (or) --password-file &lt;password file&gt;</td> 
 <td colspan="1"> 要从中读取密码的密码文件。 Version: 1.2.0 (<a href="https://issues.apache.org/jira/browse/HIVE-7175" rel="nofollow">HIVE-7175</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">-a (or) --authType &lt;auth type&gt;</td> 
 <td colspan="1"> 作为验证属性传递给jdbc的验证类型 Version: 0.13.0 (<a href="https://issues.apache.org/jira/browse/HIVE-5155" rel="nofollow">HIVE-5155</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">--property-file &lt;file&gt;</td> 
 <td colspan="1"> 从其中读取配置属性的文件 Usage: <code> beeline --property-file /tmp/a</code> Version: 2.2.0 (<a href="https://issues.apache.org/jira/browse/HIVE-13964" rel="nofollow">HIVE-13964</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">--hiveconf property=value</td> 
 <td colspan="1"> 使用给定配置属性的值。在hiv .conf.restricted目录下的属性。无法使用hiveconf重置列表(see <a href="https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-RestrictedListandWhitelist" rel="nofollow">Restricted List and Whitelist</a>). Usage: <code> beeline --hiveconf </code>prop1<code>=</code>value1 Version: 0.13.0 (<a href="https://issues.apache.org/jira/browse/HIVE-6173" rel="nofollow">HIVE-6173</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">--hivevar name=value</td> 
 <td colspan="1"> Hive变量名和值。这是一个特定于组的设置，可以在会话级别设置变量，并在Hive命令或查询中引用。 Usage: <code> beeline --hivevar </code>var1<code>=</code>value1 </td> 
 </tr> 
 <tr> 
 <td colspan="1">--color=[true/false]</td> 
 <td colspan="1"> 控制颜色是否用于显示。默认的是false. Usage: <code> beeline --color=true</code> (Not supported for Separated-Value Output formats. See <a href="https://issues.apache.org/jira/browse/HIVE-9770" rel="nofollow">HIVE-9770</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">--showHeader=[true/false]</td> 
 <td colspan="1"> 在查询结果中显示列名(true)或不显示列名(false)。Default is true. Usage: <code> beeline --showHeader=false</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--headerInterval=ROWS</td> 
 <td colspan="1"> 当outputformat为表时，以行数为单位重新显示列标题的时间间隔。Default is 100. Usage: <code> beeline --headerInterval=50</code> (不支持分离值输出格式。 See <a href="https://issues.apache.org/jira/browse/HIVE-9770" rel="nofollow">HIVE-9770</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">--fastConnect=[true/false]</td> 
 <td colspan="1"> 连接时，跳过为HiveQL语句的制表完成而构建所有表和列的列表(true)或构建列表(false)。 Default is true. Usage: <code> beeline --fastConnect=false</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--autoCommit=[true/false]</td> 
 <td colspan="1"> 启用/禁用自动事务提交。Default is false. Usage: <code> beeline --autoCommit=true</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--verbose=[true/false]</td> 
 <td colspan="1"> 显示详细的错误消息和调试信息(true)或不显示(false)。Default is false. Usage: <code> beeline --verbose=true</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--showWarnings=[true/false]</td> 
 <td colspan="1"> 显示在发出HiveQL命令后在连接上报告的警告。Default is false. Usage: <code> beeline --showWarnings=true</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--showDbInPrompt=[true/false]</td> 
 <td colspan="1"> 在提示中显示当前数据库名称。Default is false. Usage: <code> beeline --showDbInPrompt=true</code> Version: 2.2.0 (<a href="https://issues.apache.org/jira/browse/HIVE-14123" rel="nofollow">HIVE-14123</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">--showNestedErrs=[true/false]</td> 
 <td colspan="1"> 显示嵌套的错误。Default is false. Usage: <code> beeline --showNestedErrs=true</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--numberFormat=[pattern]</td> 
 <td colspan="1"> 使用DecimalFormat模式格式化数字。Format numbers using a <a href="http://docs.oracle.com/javase/7/docs/api/java/text/DecimalFormat.html" rel="nofollow">DecimalFormat</a> pattern. Usage: <code> beeline --numberFormat="#,###,##0.00"</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--force=[true/false]</td> 
 <td colspan="1"> 即使在出现错误(true)或不继续(false)后仍继续运行脚本。Default is false. Usage: <code> beeline--force=true</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--maxWidth=MAXWIDTH</td> 
 <td colspan="1"> 当outputformat为表时，截断数据之前显示的最大宽度(以字符为单位)。默认是查询终端当前宽度，然后回落到80。 Usage: <code> beeline --maxWidth=150</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--maxColumnWidth=MAXCOLWIDTH</td> 
 <td colspan="1"> 当outputformat为表时，以字符为单位的最大列宽度。Default is 50 in Hive version 2.2.0+ (see <a href="https://issues.apache.org/jira/browse/HIVE-14135" rel="nofollow">HIVE-14135</a>) or 15 in earlier versions. Usage: <code> beeline --maxColumnWidth=25</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--silent=[true/false]</td> 
 <td colspan="1"> 减少显示的信息量(true)或不显示信息量(false)。它还停止显示HiveServer2 (Hive 0.14及以后)和HiveQL命令(Hive 1.2.0及以后)查询的日志消息。Default is false. Usage: <code> beeline --silent=true</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--autosave=[true/false]</td> 
 <td colspan="1"> 自动保存首选项(true)或不自动保存(false)。 Default is false. Usage: <code> beeline --autosave=true</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--outputformat=[table/vertical/csv/tsv/dsv/csv2/tsv2]</td> 
 <td colspan="1"> 结果显示的格式模式。Default is table. See <a href="https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-Separated-ValueOutputFormats" rel="nofollow">Separated-Value Output Formats</a> below for description of recommended sv options. Usage: <code> beeline --outputformat=tsv</code> Version: dsv/csv2/tsv2 added in 0.14.0 (<a href="https://issues.apache.org/jira/browse/HIVE-8615" rel="nofollow">HIVE-8615</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">--truncateTable=[true/false]</td> 
 <td colspan="1"> 如果为真，则在控制台中的表列超过控制台长度时截断它。 Version: 0.14.0 (<a href="https://issues.apache.org/jira/browse/HIVE-6928" rel="nofollow">HIVE-6928</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">--delimiterForDSV=&nbsp;DELIMITER</td> 
 <td colspan="1"> 分隔符用于分隔符分隔值的输出格式。Default is '|' character. Version: 0.14.0 (<a href="https://issues.apache.org/jira/browse/HIVE-7390" rel="nofollow">HIVE-7390</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">--isolation=LEVEL</td> 
 <td colspan="1"> 将事务隔离级别设置为TRANSACTION_READ_COMMITTED TRANSACTION_SERIALIZABLE。 See the "Field Detail" section in the Java <a href="http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html" rel="nofollow">Connection</a> documentation. Usage: <code> beeline --isolation=TRANSACTION_SERIALIZABLE</code> </td> 
 </tr> 
 <tr> 
 <td colspan="1">--nullemptystring=[true/false]</td> 
 <td colspan="1"> 使用打印null的历史行为作为空字符串(true)或使用打印null的当前行为作为空字符串(false)。Default is false. Usage: <code> beeline --nullemptystring=false</code> Version: 0.13.0 (<a href="https://issues.apache.org/jira/browse/HIVE-4485" rel="nofollow">HIVE-4485</a>) </td> 
 </tr> 
 <tr> 
 <td> --incremental=[true/false] </td> 
 <td>从Hive 2.3开始默认为true，之前默认为false。当设置为false时，将在显示前获取并缓冲整个结果集，从而获得最佳的显示列大小。当设置为true时，结果行在获取时立即显示，从而降低了延迟和内存使用量，但需要额外的显示列填充。如果在客户端遇到OutOfMemory(因为获取的结果集很大)，建议使用incremental=true。</td> 
 </tr> 
 <tr> 
 <td colspan="1">--incrementalBufferRows=NUMROWS</td> 
 <td colspan="1"> 在stdout上打印行时要缓冲的行数， defaults to 1000; only applicable if <code>--incremental=true</code> and <code>--outputformat=table</code> Usage: <code>beeline --incrementalBufferRows=1000</code> Version: 2.3.0 (<a href="https://issues.apache.org/jira/browse/HIVE-14170" rel="nofollow">HIVE-14170</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">--maxHistoryRows=NUMROWS</td> 
 <td colspan="1"> 要存储直线历史记录的最大行数。 Version: 2.3.0 (<a href="https://issues.apache.org/jira/browse/HIVE-15166" rel="nofollow">HIVE-15166</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">--delimiter=;</td> 
 <td colspan="1"> 为用Beeline编写的查询设置分隔符。允许使用多字符分隔符，但不允许使用引号、斜杠和——。默认为; Usage: <code>beeline --delimiter=$$</code> Version: 3.0.0 (<a href="https://issues.apache.org/jira/browse/HIVE-10865" rel="nofollow">HIVE-10865</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1">--convertBinaryArrayToString=[true/false]</td> 
 <td colspan="1"> 以字符串或字节数组的形式显示二进制列数据。 Usage: <code>beeline --convertBinaryArrayToString=true</code> Version: 3.0.0 (<a href="https://issues.apache.org/jira/browse/HIVE-14786" rel="nofollow">HIVE-14786</a>) </td> 
 </tr> 
 <tr> 
 <td colspan="1"> --help </td> 
 <td colspan="1"> 显示使用信息。 Usage: <code> beeline --help</code> </td> 
 </tr> 
 </tbody> 
</table>

原文：[https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients\#HiveServer2Clients-BeelineCommands][https_cwiki.apache.org_confluence_display_Hive_HiveServer2_Clients_HiveServer2Clients-BeelineCommands]

# HCatalog #

许多 hcat 命令可以作为 hive 命令使用，包括所有 HCatalog DDL 命令。Hive CLI 包含一些在 HCatalog CLI 中不可用的命令。注意这些差异：

*  表组和权限设置的“hcat -g”和“hcat -p”仅在HCatalog CLI中可用。
 *  hcat使用-p标志表示权限，而hive使用它来指定端口号。
 *  hcat使用没有空格的-D标志来定义key=value对，而hive使用-D或——define with a space (also——hivevar)。
    
     *  For example, "`hcat -DA=B`" versus "`hive -d A=B`".
 *  没有任何标志的hcat打印帮助消息，但hive使用-H标志或--help。

HCatalog CLI

<table> 
 <tbody> 
 <tr> 
 <td style="width:54px;"> -g </td> 
 <td style="width:340px;"> <code>hcat -g mygroup ...</code> </td> 
 <td style="width:510px;">告诉HCatalog需要创建的表必须具有组“mygroup”。</td> 
 </tr> 
 <tr> 
 <td style="width:54px;"> -p </td> 
 <td style="width:340px;"> <code>hcat -p rwxr-xr-x ...</code> </td> 
 <td style="width:510px;">告诉HCatalog需要创建的表必须具有权限“rwxr-xr-x”。</td> 
 </tr> 
 <tr> 
 <td style="width:54px;"> -f </td> 
 <td style="width:340px;"> <code>hcat -f myscript.hcatalog ...</code> </td> 
 <td style="width:510px;">告诉HCatalog那个myscript。hcatalog是一个包含要执行的DDL命令的文件。</td> 
 </tr> 
 <tr> 
 <td style="width:54px;"> -e </td> 
 <td style="width:340px;"> <code>hcat -e 'create table mytable(a int);' ...</code> </td> 
 <td style="width:510px;">告诉HCatalog将下列字符串视为DDL命令并执行它。</td> 
 </tr> 
 <tr> 
 <td style="width:54px;"> -D </td> 
 <td style="width:340px;"> <code>hcat -D</code>key<code>=</code>value <code>...</code> </td> 
 <td style="width:510px;">将键值对作为Java系统属性传递给HCatalog。</td> 
 </tr> 
 <tr> 
 <td style="width:54px;"> &nbsp; </td> 
 <td style="width:340px;"> <code>hcat</code> </td> 
 <td style="width:510px;">打印使用信息。</td> 
 </tr> 
 </tbody> 
</table>

## HCatalog DDL ##

<table> 
 <tbody> 
 <tr> 
 <td> DDL Command </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+DDL" rel="nofollow">ddl (POST)</a> </td> 
 <td>执行HCatalog DDL命令。</td> 
 </tr> 
 <tr> 
 <td> Database </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetDBs" rel="nofollow">ddl/database (GET)</a> </td> 
 <td>HCatalog数据库列表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetDB" rel="nofollow">ddl/database/:db (GET)</a> </td> 
 <td>描述一个HCatalog数据库。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PutDB" rel="nofollow">ddl/database/:db (PUT)</a> </td> 
 <td>创建一个HCatalog数据库。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+DeleteDB" rel="nofollow">ddl/database/:db (DELETE)</a> </td> 
 <td>删除(删除)一个HCatalog数据库。</td> 
 </tr> 
 <tr> 
 <td> Table </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetTables" rel="nofollow">ddl/database/:db/table (GET)</a> </td> 
 <td>列出HCatalog数据库中的表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetTable" rel="nofollow">ddl/database/:db/table/:table (GET)</a> </td> 
 <td>描述一个HCatalog表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PutTable" rel="nofollow">ddl/database/:db/table/:table (PUT)</a> </td> 
 <td>创建一个新的HCatalog表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PostTable" rel="nofollow">ddl/database/:db/table/:table (POST)</a> </td> 
 <td>重命名HCatalog表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+DeleteTable" rel="nofollow">ddl/database/:db/table/:table (DELETE)</a> </td> 
 <td>删除(删除)一个HCatalog表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PutTableLike" rel="nofollow">ddl/database/:db/table/:existingtable/like/:newtable (PUT)</a> </td> 
 <td>创建与现有表类似的新HCatalog表。</td> 
 </tr> 
 <tr> 
 <td> Partition </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetPartitions" rel="nofollow">ddl/database/:db/table/:table/partition (GET)</a> </td> 
 <td>列出HCatalog表中的所有分区。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetPartition" rel="nofollow">ddl/database/:db/table/:table/partition/:partition (GET)</a> </td> 
 <td>描述HCatalog表中的单个分区。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PutPartition" rel="nofollow">ddl/database/:db/table/:table/partition/:partition (PUT)</a> </td> 
 <td>在HCatalog表中创建一个分区。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+DeletePartition" rel="nofollow">ddl/database/:db/table/:table/partition/:partition (DELETE)</a> </td> 
 <td>删除(删除)HCatalog表中的一个分区。</td> 
 </tr> 
 <tr> 
 <td> Column </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetColumns" rel="nofollow">ddl/database/:db/table/:table/column (GET)</a> </td> 
 <td>列出HCatalog表中的列。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetColumn" rel="nofollow">ddl/database/:db/table/:table/column/:column (GET)</a> </td> 
 <td>描述HCatalog表中的单个列。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PutColumn" rel="nofollow">ddl/database/:db/table/:table/column/:column (PUT)</a> </td> 
 <td>在HCatalog表中创建一个列。</td> 
 </tr> 
 <tr> 
 <td> Property </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetProperties" rel="nofollow">ddl/database/:db/table/:table/property (GET)</a> </td> 
 <td>表属性列表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetProperty" rel="nofollow">ddl/database/:db/table/:table/property/:property (GET)</a> </td> 
 <td>返回单个表属性的值。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PutProperty" rel="nofollow">ddl/database/:db/table/:table/property/:property (PUT)</a> </td> 
 <td>设置表属性。</td> 
 </tr> 
 </tbody> 
</table>

原文：[https://cwiki.apache.org/confluence/display/Hive/HCatalog+CLI\#HCatalogCLI-CommandLineInterface][https_cwiki.apache.org_confluence_display_Hive_HCatalog_CLI_HCatalogCLI-CommandLineInterface]

# WebHCat (Templeton) #

描述了以前称为Templeton的HCatalog REST API，即WebHCat。

如下图所示，开发人员通过HTTP请求从应用程序内部访问Hadoop MapReduce(或YARN)、Pig、Hive和HCatalog DDL。此API使用的数据和代码在HDFS中进行维护。HCatalog DDL命令在被请求时直接执行。MapReduce、Pig和Hive作业由WebHCat (Templeton)服务器放置在队列中，可以根据需要监视进程或停止。开发人员在HDFS中指定应该将Pig、Hive和MapReduce结果放置到其中的位置。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pwZl85NDA4MTA2NTM4NDI_size_16_color_FFFFFF_t_70][]

## URL Format ##

使用以下URL格式访问HCatalog的REST资源：

> `http://`*yourserver*`/templeton/v1/`*resource*

其中“yourserver”替换为您的服务器名，“resource”替换为HCatalog资源名。

例如，要检查服务器是否正在运行，你可以访问以下网址：

> `ht``tp://www.myserver.com/templeton/v1/status`

## WebHCat Resources ##

<table> 
 <tbody> 
 <tr> 
 <td> General </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+ResponseTypes" rel="nofollow">:version (GET)</a> </td> 
 <td>返回支持的响应类型列表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+Status" rel="nofollow">status (GET)</a> </td> 
 <td>返回WebHCat服务器状态。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+Version" rel="nofollow">version (GET)</a> </td> 
 <td>返回支持的版本和当前版本的列表。</td> 
 </tr> 
 <tr> 
 <td colspan="1">&nbsp;</td> 
 <td colspan="1"><a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+VersionHive" rel="nofollow">version/hive (GET)</a></td> 
 <td colspan="1">返回正在运行的Hive版本。 (Added in Hive 0.13.0.)</td> 
 </tr> 
 <tr> 
 <td colspan="1">&nbsp;</td> 
 <td colspan="1"><a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+VersionHadoop" rel="nofollow">version/hadoop (GET)</a></td> 
 <td colspan="1">返回运行的Hadoop版本。 (Added in Hive 0.13.0.)</td> 
 </tr> 
 <tr> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+AllDDL" rel="nofollow">DDL</a> </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+DDL" rel="nofollow">ddl (POST)</a> </td> 
 <td>执行HCatalog DDL命令。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetDBs" rel="nofollow">ddl/database (GET)</a> </td> 
 <td>HCatalog数据库列表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetDB" rel="nofollow">ddl/database/:db (GET)</a> </td> 
 <td>描述一个HCatalog数据库。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PutDB" rel="nofollow">ddl/database/:db (PUT)</a> </td> 
 <td>创建一个HCatalog数据库。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+DeleteDB" rel="nofollow">ddl/database/:db (DELETE)</a> </td> 
 <td>删除(删除)一个HCatalog数据库。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetTables" rel="nofollow">ddl/database/:db/table (GET)</a> </td> 
 <td>列出HCatalog数据库中的表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetTable" rel="nofollow">ddl/database/:db/table/:table (GET)</a> </td> 
 <td>描述一个HCatalog表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PutTable" rel="nofollow">ddl/database/:db/table/:table (PUT)</a> </td> 
 <td>创建一个新的HCatalog表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PostTable" rel="nofollow">ddl/database/:db/table/:table (POST)</a> </td> 
 <td>重命名HCatalog表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+DeleteTable" rel="nofollow">ddl/database/:db/table/:table (DELETE)</a> </td> 
 <td>删除(删除)一个HCatalog表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PutTableLike" rel="nofollow">ddl/database/:db/table/:existingtable/like/:newtable (PUT)</a> </td> 
 <td>创建与现有表类似的新HCatalog表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetPartitions" rel="nofollow">ddl/database/:db/table/:table/partition (GET)</a> </td> 
 <td>列出HCatalog表中的所有分区。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetPartition" rel="nofollow">ddl/database/:db/table/:table/partition/:partition (GET)</a> </td> 
 <td>描述HCatalog表中的单个分区。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PutPartition" rel="nofollow">ddl/database/:db/table/:table/partition/:partition (PUT)</a> </td> 
 <td>在HCatalog表中创建一个分区。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+DeletePartition" rel="nofollow">ddl/database/:db/table/:table/partition/:partition (DELETE)</a> </td> 
 <td>删除(删除)HCatalog表中的一个分区。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetColumns" rel="nofollow">ddl/database/:db/table/:table/column (GET)</a> </td> 
 <td>列出HCatalog表中的列。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetColumn" rel="nofollow">ddl/database/:db/table/:table/column/:column (GET)</a> </td> 
 <td>描述HCatalog表中的单个列。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PutColumn" rel="nofollow">ddl/database/:db/table/:table/column/:column (PUT)</a> </td> 
 <td>在HCatalog表中创建一个列。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetProperties" rel="nofollow">ddl/database/:db/table/:table/property (GET)</a> </td> 
 <td>表属性列表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+GetProperty" rel="nofollow">ddl/database/:db/table/:table/property/:property (GET)</a> </td> 
 <td>返回单个表属性的值。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+PutProperty" rel="nofollow">ddl/database/:db/table/:table/property/:property (PUT)</a> </td> 
 <td>设置表属性。</td> 
 </tr> 
 <tr> 
 <td> MapReduce </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+MapReduceStream" rel="nofollow">mapreduce/streaming (POST)</a> </td> 
 <td>创建并排队Hadoop流MapReduce作业。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+MapReduceJar" rel="nofollow">mapreduce/jar (POST)</a> </td> 
 <td>创建和排队标准的Hadoop MapReduce作业。</td> 
 </tr> 
 <tr> 
 <td> Pig </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+Pig" rel="nofollow">pig (POST)</a> </td> 
 <td>创建并排列Pig作业。</td> 
 </tr> 
 <tr> 
 <td> Hive </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+Hive" rel="nofollow">hive (POST)</a> </td> 
 <td>运行Hive查询和命令。</td> 
 </tr> 
 <tr> 
 <td> Queue (deprecated in Hive 0.12, removed in Hive 0.14) </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+JobIDs" rel="nofollow">queue (GET)</a> </td> 
 <td> 返回所有作业id的列表。 (Removed in Hive 0.14.0.) </td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+JobInfo" rel="nofollow">queue/:jobid (GET)</a> </td> 
 <td> 返回给定ID的作业的状态。(Removed in Hive 0.14.0.) </td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+DeleteJob" rel="nofollow">queue/:jobid (DELETE)</a> </td> 
 <td> 根据作业的ID杀死它。 (Removed in Hive 0.14.0.) </td> 
 </tr> 
 <tr> 
 <td> Jobs (Hive 0.12 and later) </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+Jobs" rel="nofollow">jobs (GET)</a> </td> 
 <td>返回所有作业id的列表。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+Job" rel="nofollow">jobs/:jobid (GET)</a> </td> 
 <td>返回给定ID的作业的状态。</td> 
 </tr> 
 <tr> 
 <td> &nbsp; </td> 
 <td> <a href="https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+DeleteJobID" rel="nofollow">jobs/:jobid (DELETE)</a> </td> 
 <td>根据作业的ID杀死它。</td> 
 </tr> 
 </tbody> 
</table>

原文：[https://cwiki.apache.org/confluence/display/Hive/WebHCat+UsingWebHCat\#WebHCatUsingWebHCat-URLFormat][https_cwiki.apache.org_confluence_display_Hive_WebHCat_UsingWebHCat_WebHCatUsingWebHCat-URLFormat]

原文地址：[https://cwiki.apache.org/confluence/display/Hive/GettingStarted\#GettingStarted-RunningHive][https_cwiki.apache.org_confluence_display_Hive_GettingStarted_GettingStarted-RunningHive]

[Hive 0.14]: https://issues.apache.org/jira/browse/HIVE-7136
[https_cwiki.apache.org_confluence_display_Hive_LanguageManual_Cli]: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli
[https_cwiki.apache.org_confluence_display_Hive_HiveServer2_Clients_HiveServer2Clients-BeelineCommands]: https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-BeelineCommands
[https_cwiki.apache.org_confluence_display_Hive_HCatalog_CLI_HCatalogCLI-CommandLineInterface]: https://cwiki.apache.org/confluence/display/Hive/HCatalog+CLI#HCatalogCLI-CommandLineInterface
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pwZl85NDA4MTA2NTM4NDI_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200302114509743.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pwZl85NDA4MTA2NTM4NDI=,size_16,color_FFFFFF,t_70
[https_cwiki.apache.org_confluence_display_Hive_WebHCat_UsingWebHCat_WebHCatUsingWebHCat-URLFormat]: https://cwiki.apache.org/confluence/display/Hive/WebHCat+UsingWebHCat#WebHCatUsingWebHCat-URLFormat
[https_cwiki.apache.org_confluence_display_Hive_GettingStarted_GettingStarted-RunningHive]: https://cwiki.apache.org/confluence/display/Hive/GettingStarted#GettingStarted-RunningHive