hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From CHEBARO Abdallah <Abdallah.CHEB...@murex.com>
Subject RE: Hive columns
Date Thu, 04 Sep 2014 13:24:19 GMT
thanks

From: Nitin Pawar [mailto:nitinpawar432@gmail.com]
Sent: Thursday, September 04, 2014 4:23 PM
To: user@hive.apache.org
Subject: Re: Hive columns

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<mailto:Abdallah.CHEBARO@murex.com>>
wrote:
Can you please specify what this means?

From: Nitin Pawar [mailto:nitinpawar432@gmail.com<mailto:nitinpawar432@gmail.com>]
Sent: Thursday, September 04, 2014 4:00 PM
To: user@hive.apache.org<mailto: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<mailto: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
*******************************

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.
Mime
View raw message