> [btw from my experience support for handling dates in hive is extremely > weak, and code becomes heavily convoluted to do it properly] >
That's the first thing I noticed -- lack of native date format. However, if you mange the zero-padding while importing the data, storing dates as strings works just fine. I would recommend that instead of jumping hoops each time you need to run a query. Saurabh. -- http://nandz.blogspot.com http://foodieforlife.blogspot.com
