I am looking for something for analytics, I am interested in column storage specifically on something that supports compression. At this point I guess data can fit in one machine, so clustering would be desirable, but not mandatory.
Redis was designed specifically for web analytics. Not exactly what you asked for, but you might find it highly useful nonetheless.
>> http://code.google.com/p/redis/
Check out InfoBright. It has a free version that has most features you're going to need. There are some bugs, but they're working through them pretty quickly.