hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Szehon Ho <sze...@cloudera.com>
Subject Re: Column selection in Hive
Date Tue, 01 Jul 2014 04:20:57 GMT
Why dont you just use CTAS (Create table as select), putting the 190
columns in the select part?  I guess you're maybe asking for any way to not
have to type all the columns, but I'm not aware of any.

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTableAsSelect(CTAS)



On Mon, Jun 30, 2014 at 2:54 AM, Chhaya Vishwakarma <
Chhaya.Vishwakarma@lntinfotech.com> wrote:

>  Hi
>
>
>
>
>
> I have a Customer table with 200 columns I want to create another table
> from Customer table which should have only 190 columns.
>
> How can i skip few columns in hive from base table?
>
>
>
> Regards,
>
> Chhaya Vishwakarma
>
>
>
> ------------------------------
> The contents of this e-mail and any attachment(s) may contain confidential
> or privileged information for the intended recipient(s). Unintended
> recipients are prohibited from taking action on the basis of information in
> this e-mail and using or disseminating the information, and must notify the
> sender and delete it from their system. L&T Infotech will not accept
> responsibility or liability for the accuracy or completeness of, or the
> presence of any virus or disabling code in this e-mail"
>

Mime
View raw message