Did you install v0.9.0 on your MapR cluster? I suspect there's a bug in theinteraction between the two. I'm not sure which version of Hive is thelatest shipped with MapR.

I just tried your example in an older MapR M5 virtual machine instance thatcame with Hive v0.7.1. It worked correctly. I then repeated the experimentin Hive v0.9.0 on a generic Apache Hadoop setup I have in another VM. Italso worked correctly. (I don't have Hive v0.9.0 available in the MapR VM.)