boomballa opened a new issue #14967:
URL: https://github.com/apache/superset/issues/14967
The statement to build a table is：
CREATE TABLE test.dwd_mid_app_ctr_readtime_info_local
(
...
...
...
`rectime` DateTime,
`createTime` DateTime DEFAULT now()
)
ENGINE =
ReplicatedMergeTree('/clickhouse/tables/shard01/table_dwd_mid_app_ctr_readtime_info_local',
'table_dwd_mid_app_ctr_readtime_info_local_r1')
PARTITION BY (toYYYYMMDD(rectime), toHour(rectime))
ORDER BY (dev, rectime)
SETTINGS index_granularity = 8192;
Use the client to query clickhouse, the result is:
Use superset SQL Lab to query clickhouse, the result is:
I personally understand that this is due to the time zone issue that causes
the time field to be formatted as utc?
I tried to modify config.py and change.
But it still didn't work. Please remind me how I should modify the time zone
setting of superset to make the time consistent with the clickhouse server.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
