hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From venkatesh b <venkateshmailingl...@gmail.com>
Subject Re: How to create new table like existing with an extra column in single query.
Date Tue, 11 Aug 2015 05:39:42 GMT
Thanks Adam.

As mentioned we have a need that in a single query it should be done, since
ours is an automated query generation and no manual interactions are done.

We need a query like

*Create table if not exists newTable like oldTable, newColumn datatype*

*Without copying data from oldTable. *


On Monday, August 10, 2015, LaStrange, Adam <Adam.LaStrange@sig.com> wrote:

> How about:
>
>
>
> create table XXX like YYY;
>
> alter table XXX add columns (new_column int);
>
>
>
> *From:* venkatesh b [mailto:venkateshmailinglist@gmail.com
> <javascript:_e(%7B%7D,'cvml','venkateshmailinglist@gmail.com');>]
> *Sent:* Monday, August 10, 2015 9:28 AM
> *To:* Wangwenli
> *Cc:* user
> *Subject:* Re: How to create new table like existing with an extra column
> in single query.
>
>
>
> Thanks Wenli for quick reply.
>
>
>
> Yes, we have a requirement exactly the same which you mentioned.
>
>
>
> I have tried the query which you provided but got an error saying that
>
> "Invalid column reference for newColumn possible columns are ......"
>
>
>
>
>
>
>
> Thanks
>
> Venkatesh
>
> On Monday, August 10, 2015, Wangwenli <wangwenli@huawei.com
> <javascript:_e(%7B%7D,'cvml','wangwenli@huawei.com');>> wrote:
>
> something like this?
>
> create table newTable as select oldTable.*, newCol1,newCol2 from oldTable;
>
>
> ------------------------------
>
> wenli
>
> Regards
>
>
>
> *From:* venkatesh b
>
> *Date:* 2015-08-10 20:54
>
> *To:* user
>
> *Subject:* How to create new table like existing with an extra column in
> single query.
>
> Hello,
>
>
>
> In hive we got a need that we need to create a new table like the old
> table with an extra column at run time. This must be done in a single
> query. No second query with alter table statement.
>
>
>
> Query like:
>
>
>
> Create table new_table like old_table , new_column datatype;
>
>
>
> Please help me out, searched in many forums but not found the solution.
>
> Please inform me if any other information is needed.
>
>
>
> Thanks & Regards
>
> Venkatesh
>
>
> ------------------------------
>
> IMPORTANT: The information contained in this email and/or its attachments
> is confidential. If you are not the intended recipient, please notify the
> sender immediately by reply and immediately delete this message and all its
> attachments. Any review, use, reproduction, disclosure or dissemination of
> this message or any attachment by an unintended recipient is strictly
> prohibited. Neither this message nor any attachment is intended as or
> should be construed as an offer, solicitation or recommendation to buy or
> sell any security or other financial instrument. Neither the sender, his or
> her employer nor any of their respective affiliates makes any warranties as
> to the completeness or accuracy of any of the information contained herein
> or that this message or any of its attachments is free of viruses.
>

Mime
View raw message