compact older partitions?

2015-08-30 Thread Eric Friedman
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

Re: Re: sql mapjoin very slow

2015-08-30 Thread r7raul1...@163.com
Yes , I am accidentally joining on a Double. keys: 0 UDFToDouble(nav_tcdt) (type: double) 1 UDFToDouble(site_categ_id) (type: double) 2 UDFToDouble(site_categ_id) (type: double) 3 UDFToDouble(mg_brand_id) (type: double)