Hive描述分区以显示分区URL [英] Hive describe partitions to show partition url

问题描述

我知道有

  decribe formatted table_name; 
  

向您显示表格格式。
有没有办法获得有关分区的更多信息？

  show partitions table_name; 
  

我看到Hive语言手册有这个

  DESCRIBE [EXTENDED | FORMATTED] [db_name。] table_name PARTITION partition_spec 
  

我想查看所有分区以及存放数据的hdfs或s3中的url。 显示分区：
$ b $ p $显示分区表名

为了显示物理存储分区的位置：
$ b

描述格式化的dbname.tablename分区（name = value）

我不知道创建输出的内置方式（分区，路径），但可以使用这两个命令和一些grep / awk来构建它，或者无论如何。

I know that there is

decribe formatted table_name;

that shows you the table format. Is there a way to get a more information about partitions apart from

show partitions table_name;

I saw that Hive language manual has this

DESCRIBE [EXTENDED|FORMATTED] [db_name.]table_name PARTITION partition_spec

I would like to view all the partitions along with the url in hdfs or s3 where the data is stored.

解决方案

To show partitions:

show partitions table_name

To show where a partition is physically stored:

describe formatted dbname.tablename partition (name=value)

I don't know of a built-in way to create an output that is (partition, path) but you can build it using these two commands and some grep/awk or whatever.

这篇关于Hive描述分区以显示分区URL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！