kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jay Miao <>
Subject Fwd: max or min won't work in where condition
Date Wed, 03 Aug 2016 09:20:12 GMT
---------- Forwarded message ----------
From: Jay Miao <>
Date: 2016-08-03 16:43 GMT+08:00
Subject: max or min won't work in where condition

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

View raw message