回复： How to create table like other databases' table?

[皮皮]

But a and b  are not in same database...
..


 
------------------ 原始邮件 ------------------
发件人: "������"<warwit...@gmail.com>;
发送时间: 2011年5月26日(星期四) 中午11:48
收件人: "user"<user@hive.apache.org>; 

主题: 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



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.