Re: Column selection in Hive

[Szehon Ho <sz...@cloudera.com>]

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"
>

Re: Column selection in Hive

[Lefty Leverenz <le...@gmail.com>]

Here's the wikidoc for dropping columns with ALTER TABLE ... REPLACE
COLUMNS:  Add/Replace Columns
<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Add/ReplaceColumns>.
 But you'd still have to list 190 columns, so CTAS would be more direct.
AFAIK, HiveQL doesn't have syntax for DROP COLUMN.


-- Lefty


On Tue, Jul 1, 2014 at 6:27 AM, Sarfraz Ramay <sa...@gmail.com>
wrote:

> 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 <sz...@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"
>>>
>>
>>
>

Re: Column selection in Hive

[Sarfraz Ramay <sa...@gmail.com>]

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 <sz...@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"
>>
>
>