hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Swearingen <>
Subject Re: Newbie - Hive Tutorial question, what format is the sample data file in?
Date Sat, 01 Sep 2012 15:47:22 GMT
Thanks!  I found it odd that someone would go to all this trouble
creating a nice tutorial and then leave it to the user to write data
generation code. Strange. Thanks again

Sent from my iPhone

On Sep 1, 2012, at 11:33 AM, Edward Capriolo <> wrote:

> It is up to the user to decide what that INT means in this case. This
> tutorial was created very early on. Since then hive has added support
> for timestamp type which has a clear meaning.
> On Sat, Sep 1, 2012 at 10:33 AM, David Swearingen <> wrote:
>> Thanks. Still not clear to me what a time field is as an INT:
>> milleseconds since the epoch?  That was my question.
>> Sent from my iPhone
>> On Sep 1, 2012, at 9:37 AM, Edward Capriolo <> wrote:
>>> I do not think their is a sample file. You can tell the format by
>>> create table statement.
>>> COMMENT 'This is the staging page view table'
>>>   LOCATION '/user/data/staging/page_view';
>>> 12 is a '\n' and 44 is a ','. Since the format is TEXTFILE integers
>>> are serialized into strings.
>>> On Sat, Sep 1, 2012 at 7:52 AM, David Swearingen <>
>>>> I'm going through the tutorial at
>>>> .  It's not clear to me what
>>>> exact format of the log file would be for the sample queries described eg
>>>>  I can't
>>>> find a link to download such a file and while I'd be happy to construct one
>>>> myself it's not clear to me what a viewTime of type INT would look like
>>>> exactly.  Perhaps the file conforms to standard web server logfile formats
>>>> however there are I believe a couple of variants on that format.
>>>> Am I missing something?  Thanks.

View raw message