for DEFAULT.TEST.MYDATE, select count(distinct(mydate)) from test, returns 533, which represents all the days till now for kylin_intermediate_*.MYDATE, select count(distinct())) from kylin_intermediate_*, returns 517, which indicates the first segment of the cube, and the segment contains 517 days' data
2015-03-19 1:20 GMT+08:00 hongbin ma <[email protected]>: > can you use hive to get the distinct count values in DEFAULT.TEST.MYDATE > and kylin_intermediate_*.MYDATE? > > On Wed, Mar 18, 2015 at 6:05 AM, dong wang <[email protected]> wrote: > > > 1, in Hive, my_date is indeeded DATE type, it means which day the records > > belong to > > 2, it is certain that the pattern for this column "mydate" is > "yyyy-MM-dd", > > no "HH", "MM", "SS" at all for my_date > > 3, for the kylin_intermediate_* table, I'm sure the data for the column > is > > like "2015-03-17" > > > > > > -- > Regards, > > *Bin Mahone | 马洪宾* > Apache Kylin: http://kylin.io > Github: https://github.com/binmahone >
