hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: Hive columns
Date Thu, 04 Sep 2014 13:22:45 GMT
it means you will need to define atleast one column in hive or build your
fileformat which can handle reading the files and giving data back to hive

when i say atleast one column, by default hive uses "\n" as record
terminator that means you can define an entire row as a column and then
process it the way you want
this is just a suggestion and it would be really tedious to keep the
mapping.

Instead I would suggest use pig to create proper tables from these files
and then use hive to do more deeper analytics


On Thu, Sep 4, 2014 at 6:35 PM, CHEBARO Abdallah <Abdallah.CHEBARO@murex.com
> wrote:

>  Can you please specify what this means?
>
>
>
> *From:* Nitin Pawar [mailto:nitinpawar432@gmail.com]
> *Sent:* Thursday, September 04, 2014 4:00 PM
> *To:* user@hive.apache.org
> *Subject:* Re: Hive columns
>
>
>
> If those are text files you can create the table with single column and
> then process them line by line
>
>
>
> On Thu, Sep 4, 2014 at 6:13 PM, CHEBARO Abdallah <
> Abdallah.CHEBARO@murex.com> wrote:
>
> Hello,
>
>
>
> Is it possible to create an external table without specifying the columns?
>
>
>
> In fact, I am creating an external table that points to a directory that
> contains 3 text file, and each text file has different number of columns.
>
>
>
> Thanks
>
> *******************************
>
> 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.
>



-- 
Nitin Pawar

Mime
View raw message