RE: order by date

2012-03-13 Thread Tucker, Matt
: 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 order by dateColName

Re: order by date

2012-03-13 Thread Keith Wiley
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 functions. I just haven't found a concrete example of how these two issues are brought together. Ordering

Re: order by date

2012-03-13 Thread Mark Grover
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 functions in HiveQL because I hadn't found any

RE: order by date

2012-03-13 Thread Tucker, Matt
...@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 HiveQL because I hadn't