I think you would prefer to write SQL like "where partitionCol > ''2017-01-12 04:00:00", instead of "where partitionCol > 1484236798000", right?
2017-01-20 16:00 GMT+08:00 ShaoFeng Shi <[email protected]>: > Hi Wu xin, > > It is okay to use the unix time as the "tsColumn" in a Streaming cube; > Then Kylin will parse the value to get the date/time in YYYY-MM-DD or > YYYY-MM-DD HH:MM:SS format; While for the Cube "partition column", it > always need be a valid Date or Timestamp value, not epoch time in > miliseconds; > > 2017-01-20 14:22 GMT+08:00 Mario Copperfield <[email protected]>: > >> I think it might make a confuse, because we usually define timestamp as >> an unix timestamp such as “1484236798000" >> >> On 20 Jan 2017, 13:25 +0800, ShaoFeng Shi <[email protected]>, >> wrote: >> > "When i use timestamp as partition col, it occurs exception as follow:"; >> > >> > Please aware that "1484236798000" isn't a timestamp value. Should use >> the "MINUTE_START" or "HOUR_START" as the cube partition column, which are >> real timestamp. >> > >> > > 2017-01-20 10:38 GMT+08:00 Mario Copperfield <[email protected]>: >> > > > Additionally, the stack log is in the following picture. >> > > > >> > > > On 20 Jan 2017, 10:27 +0800, Mario Copperfield < >> [email protected]>, wrote: >> > > > > I’m sorry i don’t found the property “tsParser”, did you mean >> that “Parser Name”? >> > > > > >> > > > > The following picture is my configure. >> > > > > >> > > > > I change a little codes so that it can work but i found that the >> master branch has changed the class “UpdateCubeInfoAfterBuildStep” so much >> that I did not pull request. >> > > > > >> > > > > This is what my change: >> > > > > https://github.com/xwhfcenter/kylin/commit/3e13bf244b8238710 >> 7b5b445ae9946daf919cf54 >> > > > > >> > > > > >> > > > > On 19 Jan 2017, 22:31 +0800, ShaoFeng Shi <[email protected]>, >> wrote: >> > > > > > Kylin's DefaultTimeParser will parse the long typed timestamp >> value >> > > > > > like "1484236798000", >> > > > > > so in this case you don't need specify "tsParser". >> > > > > > >> > > > > > 2017-01-19 22:18 GMT+08:00 <[email protected]>: >> > > > > > >> > > > > > > I'll check tomorrow >> > > > > > > >> > > > > > > Sent from Alto >> > > > > > > On Thursday, January 19, 2017 at 22:10 ShaoFeng Shi < >> > > > > > > [email protected]> wrote: >> > > > > > > Hi, >> > > > > > > >> > > > > > > Could you provide the stack trace? Besdies, did you specifiy >> the "tsParser" >> > > > > > > property when define the table? if yes, what's the value? >> > > > > > > >> > > > > > > 2017-01-19 21:45 GMT+08:00 Li Yang : >> > > > > > > >> > > > > > > > Deserves a JIRA I think. >> > > > > > > > >> > > > > > > > Cheers >> > > > > > > > Yang >> > > > > > > > >> > > > > > > > On Mon, Jan 16, 2017 at 2:34 PM, Copperfield wrote: >> > > > > > > > >> > > > >> > > > > > > > > When i use timestamp as partition col, it occurs >> exception as follow: >> > > > > > > > > java.text.ParseException: Unparseable date: >> "1484236798000" does not >> > > > > > > > match >> > > > > > > > > (\p{Nd}++)\Q-\E(\p{Nd}++)\Q-\E(\p{Nd}++)\Q >> > > > > > > > > \E(\p{Nd}++)\Q:\E(\p{Nd}++)\Q:\E(\p{Nd}++) >> > > > > > > > > my kylin version is 1.6.0 >> > > > > > > > > >> > > > > > > > > -- >> > > > > > > > > View this message in context: >> http://apache-kylin.74782.x6. >> > > > > > > > > nabble.com/Streaming-Build-Tim >> estamp-parse-error-tp6952.html >> > > > > > > > > Sent from the Apache Kylin mailing list archive at >> Nabble.com. >> > > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > > >> > > > > > > >> > > > > > > -- >> > > > > > > Best regards, >> > > > > > > >> > > > > > > Shaofeng Shi 史少锋 >> > > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > -- >> > > > > > Best regards, >> > > > > > >> > > > > > Shaofeng Shi 史少锋 >> > >> > >> > >> > -- >> > Best regards, >> > >> > Shaofeng Shi 史少锋 >> > >> > > > > -- > Best regards, > > Shaofeng Shi 史少锋 > > -- Best regards, Shaofeng Shi 史少锋
