On this page
描述分区-GET ddl/database /:db/table /:table/partition /:partition
Description
在 HCatalog 表中描述单个分区。
URL
http:// * www.myserver.com * /templeton/v1/ddl/database/ *:db * /table/ *:table * /partition/ *:partition *
Parameters
| Name | Description | Required? | Default |
|---|---|---|---|
| :db | 数据库名称 | Required | None |
| :table | 表名 | Required | None |
| :partition | 分区名称 col_name ='value'列表。请注意正确编码 http 的引用,例如 country =%27algeria%27. | Required | None |
standard parameters也受支持。
Results
| Name | Description |
|---|---|
| database | 数据库名称 |
| table | 表名 |
| partition | 分区名称 |
| partitioned | 如果表已分区,则为 True |
| location | 桌子的位置 |
| outputFormat | Output format |
| columns | 列名称,类型和 Comments 的列表 |
| owner | 所有者的用户名 |
| partitionColumns | 分区列列表 |
| inputFormat | Input format |
Example
Curl Command
% curl -s \
'http://localhost:50111/templeton/v1/ddl/database/default/table/mytest/partition/country=%27US%27?user.name=ctdean'
JSON Output
{
"partitioned": true,
"location": "hdfs://ip-10-77-6-151.ec2.internal:8020/apps/hive/warehouse/mytest/loc1",
"outputFormat": "org.apache.hadoop.hive.ql.io.RCFileOutputFormat",
"columns": [
{
"name": "i",
"type": "int"
},
{
"name": "j",
"type": "bigint"
},
{
"name": "ip",
"comment": "IP Address of the User",
"type": "string"
}
],
"owner": "rachel",
"partitionColumns": [
{
"name": "country",
"type": "string"
}
],
"inputFormat": "org.apache.hadoop.hive.ql.io.RCFileInputFormat",
"database": "default",
"table": "mytest",
"partition": "country='US'"
}
Navigation Links
上一个:GET ddl/database/:db/table/:table/partition下一个:PUT ddl/database/:db/table/:table/partition/:partition
一般:DDL Resources – WebHCat Reference – WebHCat Manual – HCatalog Manual – Hive Wiki 主页 – Hive 项目 site