hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sarfraz Ramay <sarfraz.ra...@gmail.com>
Subject Re: Column selection in Hive
Date Tue, 01 Jul 2014 10:27:05 GMT
Hi,

A workaround could be to create a table with all the columns and then drop
the columns you don't need. Hope it helps.

Regards,
Sarfraz Rasheed Ramay (DIT)
Dublin, Ireland.


On Tue, Jul 1, 2014 at 5:20 AM, Szehon Ho <szehon@cloudera.com> wrote:

> 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