Re: RANK/DENSE_RANK on KYLIN

Sorry forget the group by and sum().. SELECT CST_KEY, sum(AMT) FROM FCT group by CST_KEY ORDER BY 2 DESC On Sat, Apr 9, 2016 at 2:16 PM, Li Yang wrote: > Isn't it the same as below? > > SELECT CST_KEY, AMT > FROM FCT > ORDER BY AMT DESC > > On Fri, Apr 8, 2016 at 11:29 AM,

Re: RANK/DENSE_RANK on KYLIN

Isn't it the same as below? SELECT CST_KEY, AMT FROM FCT ORDER BY AMT DESC On Fri, Apr 8, 2016 at 11:29 AM, hongbin ma wrote: > it's not working for kylin > > On Thu, Apr 7, 2016 at 12:51 AM, sdangi wrote: > > > Does Kylin support these analytic

Re: RANK/DENSE_RANK on KYLIN

it's not working for kylin On Thu, Apr 7, 2016 at 12:51 AM, sdangi wrote: > Does Kylin support these analytic functions? > > I'm hitting into an issue while running this. Works ok on hive. > > SELECT CST_KEY, AMT, > RANK() OVER( ORDER BY AMT DESC) > FROM FCT > > Message:

RANK/DENSE_RANK on KYLIN

Does Kylin support these analytic functions? I'm hitting into an issue while running this. Works ok on hive. SELECT CST_KEY, AMT, RANK() OVER( ORDER BY AMT DESC) FROM FCT Message: Error while executing SQL "SELECT CST_KEY, AMT, RANK() OVER( ORDER BY AMT DESC) FROM TXN_FCT_ORC LIMIT 5":