2012 1:59 PM
To: user@hive.apache.org; bejoy...@yahoo.com
Subject: Re: Loading data into data_dim table
Thanks for your help :)
it's data has been loaded fine now,
select * from dim_date;
76622020-12-22 00:00:00.000 20204 12 3 52 13
4 357 83
> *Date: *Wed, 25 Jul 2012 17:10:09 +0530
> *To: *
> *ReplyTo: *user@hive.apache.org
> *Subject: *Re: Loading data into data_dim table
>
> Thanks for the reply.
>
> I have tried the with delimited fields terminated by '|' and delimited
> fields terminated by ',
prabhu k
Date: Wed, 25 Jul 2012 17:10:09
To:
Reply-To: user@hive.apache.org
Subject: Re: Loading data into data_dim table
Thanks for the reply.
I have tried the with delimited fields terminated by '|' and delimited
fields terminated by ',' while selecting the table bot
>> Sent from handheld, please excuse typos.
>> --
>> *From: *prabhu k
>> *Date: *Wed, 25 Jul 2012 16:05:42 +0530
>> *To: *
>> *ReplyTo: *user@hive.apache.org
>> *Subject: *Loading data into data_dim table
>>
>> Hi Us
---
> *From: * prabhu k
> *Date: *Wed, 25 Jul 2012 16:05:42 +0530
> *To: *
> *ReplyTo: * user@hive.apache.org
> *Subject: *Loading data into data_dim table
>
> Hi Users,
>
>
> I have created dim_date table like below. table created successfully and i
> then lo
:05:42
To:
Reply-To: user@hive.apache.org
Subject: Loading data into data_dim table
Hi Users,
I have created dim_date table like below. table created successfully and i
then load the data into the dim_date table
while i am selecting the table, getting null values.my input file is
time.csv
Hi Users,
I have created dim_date table like below. table created successfully and i
then load the data into the dim_date table
while i am selecting the table, getting null values.my input file is
time.csv file
hive> create table dim_date(DateId int,ddate string,Year int,Quarter
int,Month_Numbe
