Hi Deva, If you couldn't add this date column, you can define a Hive view over it, adding the column virtually (maybe with substr function). Then use this view as the fact table in Kylin cube.
2018-07-30 4:08 GMT+08:00 deva namaste <[email protected]>: > Hello friends, Any idea? Thanks > > On Fri, Jul 27, 2018 at 3:58 PM, deva namaste <[email protected]> wrote: > >> Hello, >> >> I do have fact table with date column where dates are in this format >> "YYYY-MM-DD" ( e.g. 2016-01-01). The same fact table is joined with date >> dimension table same format column (and the other columns are year_no, >> qtr_no, month_no, etc). >> >> My new data in fact table is coming in "2016-01-01 16:45:00" format (15 >> mins intervals). >> >> How can I handle this situation? I do not want to have all detailed >> level intervals in Date dimension since it will add lots of data. >> >> Any idea you would recommend? >> (fact table format "YYYY-MM-DD HH24:MI:SS" will not be joined with >> dimension table "YYYY-MM-DD" ) >> >> Thanks >> > > -- Best regards, Shaofeng Shi 史少锋
