Apache Hive : WebHCat Reference GetColumns

List Columns — GET ddl/database/:db/table/:table/column

• List Columns — GET ddl/database/:db/table/:table/column
  • Description
  • URL
  • Parameters
  • Results
  • Example
    • Curl Command
    • JSON Output

Description

List the columns in an HCatalog table.

URL

http://www.myserver.com/templeton/v1/ddl/database/:db/table/:table/column

Parameters

Name	Description	Required?	Default
:db	The database name	Required	None
:table	The table name	Required	None

The standard parameters are also supported.

Results

Name	Description
columns	A list of column names and types
database	The database name
table	The table name

Example

Curl Command

% curl -s 'http://localhost:50111/templeton/v1/ddl/database/default/table/my\_table/column?user.name=ctdean'

JSON Output

{
 "columns": [
   {
     "name": "id",
     "type": "bigint"
   },
   {
     "name": "user",
     "comment": "The user name",
     "type": "string"
   },
   {
     "name": "my\_p",
     "type": "string"
   },
   {
     "name": "my\_q",
     "type": "string"
   }
 ],
 "database": "default",
 "table": "my\_table"
}

Navigation Links Previous: DELETE ddl/database/:db/table/:table/partition/:partition Next: GET ddl/database/:db/table/:table/column/:column

General: DDL Resources – WebHCat Reference – WebHCat Manual – HCatalog Manual – Hive Wiki Home – Hive Project Site