cube-js / cube-js/cube

set CUBEJS_DEFAULT_TIMEZONE not work when querying hive table via doris

Open
#10,211 1 comment 0 reactions 0 assignees View on GitHub
configuration driver:hive question
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

**Problem**
I have a hive table using UTC+8 timezone, using appache doris hive catalog to query it, so I set CUBEJS_DEFAULT_TIMEZONE = Asia/Shanghai. It works properly querying doris internal table and return UTC+8 timezone dateformat, but error querying hive table. errors logs show like Cannot open /xxx/xxx/xxx/+00:00, and I found that have one sql execution : SET time_zone='+00:00'. So my question is that cube why not execute SET time_zone='+08:00', cube always transform date format to target timezone after querying data using UTC ?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.