hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 김영우 <warwit...@gmail.com>
Subject Re: 回复: How to create table like other databases' table?
Date Thu, 26 May 2011 05:16:23 GMT
Hive does support a cross-database query.

For e.g.,

hive> create database test;
OK
Time taken: 0.456 seconds
hive> use test;
OK
Time taken: 0.065 seconds
hive> create table test1 (a string);
OK
Time taken: 0.145 seconds
hive> use default;
OK
Time taken: 0.059 seconds
hive> create table test2 like test.test1;
OK
Time taken: 0.162 seconds
hive> describe extended test2;
OK
a string
...

Tested on Hive trunk.

HTH,

- Youngwoo


2011/5/26 皮皮 <wang.ajing@qq.com>

> 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
>
> <http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL>
> 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