---------- 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 苗元君
