网站建设资讯

NEWS

网站建设资讯

HiveCLI的命令都是怎样的

Hive CLI的命令都是怎样的,针对这个问题,这篇文章详细介绍了相对应的分析和解答,希望可以帮助更多想解决这个问题的小伙伴找到更简单易行的方法。

创新互联是一家集网站建设,米林企业网站建设,米林品牌网站建设,网站定制,米林网站建设报价,网络营销,网络优化,米林网站推广为一体的创新建站企业,帮助传统企业提升企业形象加强企业竞争力。可充分满足这一群体相比中小企业更为丰富、高端、多元的互联网需求。同时我们时刻保持专业、时尚、前沿,时刻以成就客户成长自我,坚持不断学习、思考、沉淀、净化自己,让我们为更多的企业打造出实用型网站。

这些命令可以直接cli或者beeline里面执行。

quit 
exit

Use quit or exit to leave the interactive shell.

reset

Resets the configuration to the default values (as of Hive 0.10: see HIVE-3202). Any configuration parameters that were set using the set command or -hiveconf parameter in hive commandline will get reset to default value.

Note that this does not apply to configuration parameters that were set in set command using the "hiveconf:" prefix for the key name (for historic reasons).

set =

Sets the value of a particular configuration variable (key). 
Note: If you misspell the variable name, the CLI will not show an error.

set

Prints a list of configuration variables that are overridden by the user or Hive.

set -v

Prints all Hadoop and Hive configuration variables.

add FILE[S]
add JAR[S]
add ARCHIVE[S] *

Adds one or more files, jars, or archives to the list of resources in the distributed cache. See Hive Resources for more information.

add FILE[S]
add JAR[S] 
add ARCHIVE[S] *
As of Hive 1.2.0, adds one or more files, jars or archives to the list of resources in the distributed cache using anIvy URL of the form ivy://group:module:version?query_string. See Hive Resources for more information.

list FILE[S] 
list JAR[S] 
list ARCHIVE[S]

Lists the resources already added to the distributed cache. See Hive Resources for more information.

list FILE[S]
list JAR[S]
list ARCHIVE[S] *

Checks whether the given resources are already added to the distributed cache or not. See Hive Resources for more information.

delete FILE[S]
delete JAR[S]
delete ARCHIVE[S] *

Removes the resource(s) from the distributed cache.

delete FILE[S]
delete JAR[S]
delete ARCHIVE[S] *
As of Hive 1.2.0, removes the resource(s) which were added using the from the distributed cache. See Hive Resources for more information.

!

Executes a shell command from the Hive shell.

dfs

Executes a dfs command from the Hive shell.

Executes a Hive query and prints results to standard output.

source FILE

Executes a script file inside the CLI.

compile `` AS GROOVY NAMED

This allows inline Groovy code to be compiled and be used as a UDF (as of Hive 0.13.0). For a usage example, see Nov. 2013 Hive Contributors Meetup Presentations – Using Dynamic Compilation with Hive.

Sample Usage:

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

关于Hive CLI的命令都是怎样的问题的解答就分享到这里了,希望以上内容可以对大家有一定的帮助,如果你还有很多疑惑没有解开,可以关注创新互联行业资讯频道了解更多相关知识。


网页题目:HiveCLI的命令都是怎样的
本文路径:http://njwzjz.com/article/ieiice.html