hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: SELECT specific data
Date Wed, 30 Jul 2014 09:36:42 GMT
sorry hit send too soon ..
I mean without creating intermediate tables, in hive you can process the
file directly


On Wed, Jul 30, 2014 at 3:06 PM, Nitin Pawar <nitinpawar432@gmail.com>
wrote:

> With hive, without creating a table with full data, you can do
> intermediate processing like select only few columns and write into another
> table,
>
> If this is something one time then you can take a look at awk or cut
> commands in linux and generate those files only.
>
>
> On Wed, Jul 30, 2014 at 2:49 PM, CHEBARO Abdallah <
> Abdallah.CHEBARO@murex.com> wrote:
>
>>  I am only using Hive and hadoop, nothing more.
>>
>>
>>
>> *From:* Devopam Mittra [mailto:devopam@gmail.com]
>> *Sent:* Wednesday, July 30, 2014 12:15 PM
>>
>> *To:* user@hive.apache.org
>> *Subject:* Re: SELECT specific data
>>
>>
>>
>> Are you using any tool to load data ? If yes, then the ETL tool will
>> provide you such options.
>>
>> If not, then please explore unix file processing/external table route.
>>
>>
>>
>> On Wed, Jul 30, 2014 at 2:09 PM, CHEBARO Abdallah <
>> Abdallah.CHEBARO@murex.com> wrote:
>>
>> Hello,
>>
>>
>>
>> Thank you for your reply.
>>
>>
>>
>> Consider we have data divided into 5 columns (col1, col2, col3, col4,
>> col5).
>>
>> So I can’t load directly col1, col3 and col5?
>>
>> If I can’t do it directly, can you provide me with an alternate solution?
>>
>>
>>
>> Thank you.
>>
>>
>>
>> *From:* Nitin Pawar [mailto:nitinpawar432@gmail.com]
>> *Sent:* Wednesday, July 30, 2014 11:37 AM
>> *To:* user@hive.apache.org
>> *Subject:* Re: SELECT specific data
>>
>>
>>
>> you mean just by writing query then I think no.
>>
>>
>>
>> But if you want to read only first 3 columns of the data then it would
>> work with just a single table and load data into
>>
>>
>>
>> On Wed, Jul 30, 2014 at 1:47 PM, CHEBARO Abdallah <
>> Abdallah.CHEBARO@murex.com> wrote:
>>
>> Hello,
>>
>>
>>
>> I am interested in selecting specific data from a source and loading it
>> to a table. For example, if I have 5 columns in my dataset, I want to load
>> 3 columns of it. Is it possible to do it without create a second table?
>>
>>
>>
>> Thank you
>>
>> *******************************
>>
>> This e-mail contains information for the intended recipient only. It may
>> contain proprietary material or confidential information. If you are not
>> the intended recipient you are not authorised to distribute, copy or use
>> this e-mail or any attachment to it. Murex cannot guarantee that it is
>> virus free and accepts no responsibility for any loss or damage arising
>> from its use. If you have received this e-mail in error please notify
>> immediately the sender and delete the original email received, any
>> attachments and all copies from your system.
>>
>>
>>
>>
>>
>> --
>> Nitin Pawar
>>
>> *******************************
>>
>> This e-mail contains information for the intended recipient only. It may
>> contain proprietary material or confidential information. If you are not
>> the intended recipient you are not authorised to distribute, copy or use
>> this e-mail or any attachment to it. Murex cannot guarantee that it is
>> virus free and accepts no responsibility for any loss or damage arising
>> from its use. If you have received this e-mail in error please notify
>> immediately the sender and delete the original email received, any
>> attachments and all copies from your system.
>>
>>
>>
>>
>>
>> --
>> Devopam Mittra
>> Life and Relations are not binary
>>
>> *******************************
>>
>> This e-mail contains information for the intended recipient only. It may
>> contain proprietary material or confidential information. If you are not
>> the intended recipient you are not authorised to distribute, copy or use
>> this e-mail or any attachment to it. Murex cannot guarantee that it is
>> virus free and accepts no responsibility for any loss or damage arising
>> from its use. If you have received this e-mail in error please notify
>> immediately the sender and delete the original email received, any
>> attachments and all copies from your system.
>>
>
>
>
> --
> Nitin Pawar
>



-- 
Nitin Pawar

Mime
View raw message