Hi Kylin' cube only has aggregated data, so try some aggregations in SQL like min/max etc.
FYI: http://kylin.apache.org/docs/gettingstarted/faq.html (Why I got an error when running a “select * “ query?) 雒智 <l854434...@163.com> 于2019年1月18日周五 上午1:43写道: > > hello : > My dimension table has a column named pub_time whose type > is timestamp,Execute the SQL below will get a incorrect result. > > > SELECT > PUB_TIME > FROM MANKE_DW.BIBI_SEASON_WATCH_FACT as BIBI_SEASON_WATCH_FACT > INNER JOIN BIBI_SEASON_DIM > ON BIBI_SEASON_WATCH_FACT.SEASON_SK = BIBI_SEASON_DIM.SEASON_SK > where date_sk=304 order by pub_time desc; > > > the desc result is > > > > the asc result is > > > I must change the sql for correct result: > > SELECT > PUB_TIME > FROM MANKE_DW.BIBI_SEASON_WATCH_FACT as BIBI_SEASON_WATCH_FACT > INNER JOIN (select season_sk,badge,copyright,isfinish,title,cast(pub_time > as date) pub_time from MANKE_DW.BIBI_SEASON_DIM) as BIBI_SEASON_DIM > ON BIBI_SEASON_WATCH_FACT.SEASON_SK = BIBI_SEASON_DIM.SEASON_SK > where date_sk=304 order by pub_time desc; > > the desc reslut is > > > the asc result is > > > Note: the incorrect result only appear in join query。 Is is > a bug ? > > > > > > > > > > > > > > > > > > > > -- Regards! Aron Tao