Create Table Like — PUT ddl/database/:db/table/:existingtable/like/:newtable
Description
Create a new HCatalog table like an existing one.
URL
http://
www.myserver.com/templeton/v1/ddl/database/
:db/table/
:existingtable/like/
:newtable
Parameters
Name |
Description |
Required? |
Default |
---|---|---|---|
:db |
The database name |
Required |
None |
:existingtable |
The existing table name |
Required |
None |
:newtable |
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 |
location |
The HDFS path |
Optional |
None |
The standard parameters are also supported.
Results
Name |
Description |
---|---|
table |
The new table name |
database |
The database name |
Example
Curl Command
% curl -s -X PUT -HContent-type:application/json -d {} \ 'http://localhost:50111/templeton/v1/ddl/database/default/table/test_table/like/test_table_2?user.name=ctdean'
JSON Output
{ "table": "test_table_2", "database": "default" }
Previous: DELETE ddl/database/:db/table/:table
Next: GET ddl/database/:db/table/:table/partition
General: DDL Resources – WebHCat Reference – WebHCat Manual – HCatalog Manual – Hive Wiki Home – Hive Project Site
Old version of this document (HCatalog 0.5.0): PUT ddl/database/:db/table/:existingtable/like/:newtable