hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "皮皮" <wang.aj...@qq.com>
Subject 回复: How to create table like other databases' table?
Date Thu, 26 May 2011 04:52:43 GMT
But a and b  are not in same database...
..


 
------------------ 原始邮件 ------------------
发件人: "������"<warwithin@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.ajing@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.
Mime
View raw message