set CUBEJS_DEFAULT_TIMEZONE not work when querying hive table via doris
Open
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
Assessment
This issue has not been assessed yet.