The majority has upgraded to v1.5, which means the support of older versions like v1.2 & v1.3 is very limited. And your question is not an easy one.
Please consider upgrade. Yang On Wed, Aug 3, 2016 at 5:20 PM, Jay Miao <[email protected]> wrote: > > ---------- Forwarded message ---------- > From: Jay Miao <[email protected]> > Date: 2016-08-03 16:43 GMT+08:00 > Subject: max or min won't work in where condition > To: [email protected] > > > Hi, > My kylin version 1.2 > > My hive table is : > time int (the timestamp) > a string > b string > c string > > My cube dimension is : > normal time > normal a > normal b > normal c > > In mesures, I set: > MAX column time > Min column time > > Aggregation Groups is : > time , a, b, c > > Row key is : > time, a,b,c > > When I execute SQL: > > > > > *select a,b,c, min(time),max(time) from table_namewhere time>=1464710400 > and timel<1469980800group by a,b,c;* > > I got a null result. > > Why CANNOT get the max and min value in every group ? > > > -- > > Jay Miao 苗元君 > > > > -- > > Jay Miao 苗元君 >
