列表表— GET ddl/database /：db/table
Description
列出 HCatalog 数据库中的表。
URL
http:// * www.myserver.com * /templeton/v1/ddl/database/ *：db * /table
Parameters
| Name | Description | Required? | Default |
|---|---|---|---|
| :db | 数据库名称 | Required | None |
| like | 仅列出名称与指定模式匹配的表 | Optional | “ *”(列出所有表) |
standard parameters也受支持。
Results
| Name | Description |
|---|---|
| tables | 表名列表 |
| database | 数据库名称 |
Example
Curl Command
% curl -s 'http://localhost:50111/templeton/v1/ddl/database/default/table?user.name=ctdean&like=m*'
JSON Output
{
"tables": [
"my_table",
"my_table_2",
"my_table_3"
],
"database": "default"
}
JSON 输出(错误)
{
"errorDetail": "
org.apache.hadoop.hive.ql.metadata.HiveException: ERROR: The database defaultsd does not exist.
at org.apache.hadoop.hive.ql.exec.DDLTask.switchDatabase(DDLTask.java:3122)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:224)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:134)
at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1332)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1123)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:931)
at org.apache.hcatalog.cli.HCatDriver.run(HCatDriver.java:42)
at org.apache.hcatalog.cli.HCatCli.processCmd(HCatCli.java:247)
at org.apache.hcatalog.cli.HCatCli.processLine(HCatCli.java:203)
at org.apache.hcatalog.cli.HCatCli.main(HCatCli.java:162)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
",
"error": "FAILED: Error in metadata: ERROR: The database defaultsd does not exist.",
"errorCode": 500,
"database": "defaultsd"
}
Navigation Links
上一个：DELETE ddl/database/:db下一个：GET ddl/database/:db/table/:table
一般：DDL Resources – WebHCat Reference – WebHCat Manual – HCatalog Manual – Hive Wiki 主页 – Hive 项目 site