Hello, I have a table partitioned by year/month/day/hour/minute, where minute is a 10 minute slice. Each minute slice gets about 1GB.
I'd like to rollup the older partitions by hour. I've seen this done via MapReduce (the resulting partition has __HIVE_DEFAULT_PARTITION__ in the minute 'space'), but can't seem to find a way to accomplish this from hive. Can someone please suggest an approach?