Skip to content

set CUBEJS_DEFAULT_TIMEZONE not work when querying hive table via doris #10211

@WUDehong

Description

@WUDehong

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 ?

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionThe issue is a question. Please use Stack Overflow for questions.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions