Just before this exception, there should be some log saying "Dictionary value samples: “; Could you please find and paste that log msg?
On 3/19/15, 1:12 PM, "dong wang" <[email protected]> wrote: >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 >>
