Sorry for that. I used JDBC and Kylin Web to test the sql query for streaming cube, but the records came from JDBC and Kylin Web are incorrect. All of theses records' date are earlier than my PC date(8 hours).
I found that records came from Kylin server are incorrected when I did query by remote debug. I guess something wrong when Kylin parsed messages from kafka, maybe the default time parser class didn't took the timezone into consideration? I'm not sure. Another probelm is the segments' start/end time displayed on Kylin Web, also earlier than my PC date. I checked the cube's json data storaged in HBase, and I found that these segments' start/end timestamp(transfromed in to date manually) are same with my PC date. If there any probelm when Kylin web tranform the segments' timestamp into date in new streaming cube?