Hi, Guowp Maybe the following wiki helps you. Hive supports cube after Hive-0.10.0 https://cwiki.apache.org/confluence/display/Hive/Enhanced+Aggregation,+Cube,+Grouping+and+Rollup
Cheers, Zhuoluo (Clark) Yang 2013/5/30 guowp <gu...@asiainfo-linkage.com> > Sorry ,the cobe is “cube”, the mistake was hanppening by my careless > > > > 发件人: guowp [mailto:gu...@asiainfo-linkage.com] > 发送时间: 2013年5月30日 11:43 > 收件人: 'dev@hive.apache.org' > 主题: ask for "cobe" > > > > Hi sir， I am the developer of AsiainfoLinkage , the sql “select … … > group by cube (colum1,colum2),colum3” used by oracle, > > but in the hive,we only use the hsql “ select … … group by > colum1,colum2,colum3 with cube” 。 > > I wan to know: > > 1. Whether the hive will support the cube like “group by cube (colum1, > colum2),colum3” > > 2. If the hive will support ,the plan ? which version will it work . > > > > Thanks , With best wishes . > > By Guowp , Asiainfo Linkage > > > > > > > > > >
