Re: Question regarding topN measure on string column

Thanks for the help. The description and query you provided makes sense. On Sun, Apr 2, 2017 at 8:04 PM, ShaoFeng Shi wrote: > The sample SQL missed product_name in group by, it should be: > > select city, product_name, sum(1) as occurancy from fact_table where city > in

Re: Question regarding topN measure on string column

The sample SQL missed product_name in group by, it should be: select city, product_name, sum(1) as occurancy from fact_table where city in ("abc") group by city, product_name order by occurancy desc limit 100; To get a better understanding of TopN, please check

Re: Question regarding topN measure on string column

Kylin TopN's "sum|order by" supports two options a) a numeric column, b) constant 1. The option b) can match your requirement in my understanding. You just need define "product_name" as the "group by" column in TopN, and constant 1 as the "sum|order by" column; dont' forget to use "city" as

Re: Question regarding topN measure on string column

group by SUM, or group by COUNT is reasonable and supported. There is no order by name alphabetical support. 2017-03-31 20:16 GMT+08:00 hongbin ma : > ​hi, > > i believe it's not supported. besides, how do you define "order" on string? > I don't think it's a reasonable

Re: Question regarding topN measure on string column

​hi, i believe it's not supported. besides, how do you define "order" on string? I don't think it's a reasonable requirement -- Regards, *Bin Mahone | 马洪宾*

Question regarding topN measure on string column

Hi, I am using kylin 1.6 and trying to define a topN measure on string column (in SUM | ORDER BY field), which is giving me Number format exception. I understand that kylin is expecting a numeric column to do sum operation on it. But, I just wanted to ask that is there any way to define topN on