Re: How to create table like other databases' table?

[김영우]

Hi,

Hive supports 'CREATE TABLE ... LIKE ...' statement. so you can create a
table like following:

CREATE TABLE test2 LIKE test1;

Syntax:

CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name
  LIKE existing_table_name
  [LOCATION hdfs_path]

For more details, See http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL

Regards,

- Youngwoo

<http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL>
2011/5/26 皮皮 <wang.aj...@qq.com>

> Hi ,all.
>     How to create table like other database's  table ? e.g. i create table
> a in test1 , and then I want create table b in test2, that  have a  same
>  shema  with table a in test1.
>    Thanks.
>
>
>