[ https://issues.apache.org/jira/browse/KYLIN-3397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16501495#comment-16501495 ]
praveenece edited comment on KYLIN-3397 at 6/5/18 8:52 AM: ----------------------------------------------------------- Hi Chen, i give you one example whenever i hit query against CUBE means the data updated in System Cube table GMT Timezone format. ex: Cube Name-KYLIN_HIVE_METRICS_QUERY_CUBE_QA kday_date=2018-06-04 kday_time=06:30:00(*GMT based*) GMT+5.30=12:00:00 Now am going to build System Cube segment wise.whether i want to give(From and Todate)*GMT+5.30* format or *GMT* format? because i changed GMT+5.30 format in kylin.properties. was (Author: praveenece): Hi Chen, i give you one example whenever i hit query against CUBE means the data updated in System Cube table GMT Timezone format. ex: Cube Name-KYLIN_HIVE_METRICS_QUERY_CUBE_QA kday_date-2018-06-04 kdat_time=06:30:00(*GMT based*) GMT+5.30=12:00:00 Now am going to build System Cube segment wise.whether i want to give(From and Todate)*GMT+5.30* format or *GMT* format? because i changed GMT+5.30 format in kylin.properties. > Kylin UI Timestemp(GMT) issue > ----------------------------- > > Key: KYLIN-3397 > URL: https://issues.apache.org/jira/browse/KYLIN-3397 > Project: Kylin > Issue Type: Bug > Components: Web > Reporter: praveenece > Assignee: Zhixiong Chen > Priority: Major > > > Kylin Version 2.3.1 > In Kylin React-the Data has inserted into System Cube table based on GMT > format,but the user > Changed option GMT to GMT+5.30 in kylin UI (Kylin.properties). > when we build segment wise in System Cube(Kylin UI).the system has generated > select statement in first step of build,its > taken internally GMT+5.30 format not for GMT. > below i given generated select query from First step of Create Intermediate > Flat Hive Table(log) > SELECT x,y,z > FROM KYLIN.HIVE_METRICS_QUERY_CUBE_QA as HIVE_METRICS_QUERY_CUBE_QA > WHERE 1=1 AND (((HIVE_METRICS_QUERY_CUBE_QA.KDAY_DATE = '2018-06-01' AND > HIVE_METRICS_QUERY_CUBE_QA.KDAY_TIME >= '17:10:00') > OR (HIVE_METRICS_QUERY_CUBE_QA.KDAY_DATE > '2018-06-01')) > AND ((HIVE_METRICS_QUERY_CUBE_QA.KDAY_DATE = '2018-06-04' AND > HIVE_METRICS_QUERY_CUBE_QA.KDAY_TIME < '16:27:00') > OR (HIVE_METRICS_QUERY_CUBE_QA.KDAY_DATE < '2018-06-04'))) > > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)