Create Table — PUT ddl/database/:db/table/:table

Table of Contents

Description

Create a new HCatalog table. For more information, please refer to the Hive documentation for CREATE TABLE.

...

Name	Description	Required?	Default
:db	The database name.	Required	None
:table	The new table name.	Required	None
group	The user group to use when creating a table.	Optional	None
permissions	The permissions string to use when creating a table.	Optional	None
external	Allows you to specify a location so that Hive does not use the default location for this table.	Optional	false
ifNotExists	If true, you will not receive an error if the table already exists.	Optional	false
comment	Comment for the table.	Optional	None
columns	A list of column descriptions, including name, type, and an optional comment.	Optional	None
partitionedBy	A list of column descriptions used to partition the table. Like the columns parameter this is a list of name, type, and comment fields.	Optional	None
clusteredBy	An object describing how to cluster the table including the parameters columnNames, sortedBy, and numberOfBuckets. The sortedBy parameter includes the parameters columnName and order (ASC for ascending or DESC for descending). For further information please refer to the examples below or to the Hive documentation.	Optional	None
format	Storage format description including parameters for rowFormat, storedAs, and storedBy. For further information please refer to the examples below or to the Hive documentation.	Optional	None
location	The HDFS path.	Optional	None
tableProperties	A list of table property names and values (key/value pairs).	Optional	None

The standard parameters are also supported.

...

Panel