Thanks for all the feedback on this. I'll take a look at all the suggestions I
received.
Cheers!
Keith Wiley kwi...@keithwiley.com keithwiley.commusic.keithwiley.com
"Yet mark his perfect self-contentm
ley [mailto:kwi...@keithwiley.com]
Sent: Tuesday, March 13, 2012 1:47 PM
To: user@hive.apache.org
Subject: Re: order by date
I see how I misled you, sorry. I wasn't implying that my csv data is cleanly
represented in -MM-dd format. I was just asking syntactically how to use
date functions in Hiv
Okay, what are the differences and similarities with use a date function for
the same purpose? Is there a reason to go one route or the other?
On Mar 13, 2012, at 11:29 , Mark Grover wrote:
> Hi Keith,
> You should also consider writing you own UDF that takes in the date in
> "American" format
l Message -
From: "Keith Wiley"
To: user@hive.apache.org
Sent: Tuesday, March 13, 2012 1:47:12 PM
Subject: Re: order by date
I see how I misled you, sorry. I wasn't implying that my csv data is cleanly
represented in -MM-dd format. I was just asking syntactically how to use
date
I see how I misled you, sorry. I wasn't implying that my csv data is cleanly
represented in -MM-dd format. I was just asking syntactically how to use
date functions in HiveQL because I hadn't found any examples and I used
-MM-dd in my example. The dates in my csv tables are often in "
he date functions in hive take arguments in string format, with a few
functions that will translate between unix timestamps and datetime strings.
Matt Tucker
-Original Message-
From: Keith Wiley [mailto:kwi...@keithwiley.com]
Sent: Tuesday, March 13, 2012 1:01 PM
To: user@hive.apache.org
S
> From: Keith Wiley [mailto:kwi...@keithwiley.com]
> Sent: Tuesday, March 13, 2012 12:45 PM
> To: user@hive.apache.org
> Subject: order by date
>
> I realize that hive doesn't have a date type for the columns and I realize
> that hive *does* have various date funct
rg
Subject: order by date
I realize that hive doesn't have a date type for the columns and I realize that
hive *does* have various date functions. I just haven't found a concrete
example of how these two issues are brought together. Ordering the results of
a sql query is done by adding &
I realize that hive doesn't have a date type for the columns and I realize that
hive *does* have various date functions. I just haven't found a concrete
example of how these two issues are brought together. Ordering the results of
a sql query is done by adding "order by dateColName" to the que
