what is your kylin version ? On Fri, Jan 18, 2019 at 9:43 AM 雒智 <[email protected]> wrote:
> > 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 ？ > > > > > > > > > > > > > > > > > > > >
