question Re: How to set default time zone/local time for SparkSql on Hue Sessions. in Support Questions

How to set default time zone/local time for SparkSql on Hue Sessions.

Bartlomiej — Tue, 21 Apr 2026 06:29:06 GMT

Hello

I am struggling to set the time zone for the sessions on Spark Sql while submitting the query over the HUE.Maybe somebody already has this problem and know how to solve it - I would be grateful for the help.

So far I checked that:

on pyspak session running on linux the time zone is the one i want :

spark.conf.get("spark.sql.session.timeZone")
'Europe/Warsaw'

However then i submit the TIMESTAMP on HUE running query against SparkSql I got the UTC Time Stamp.

SELECT TIMESTAMP 'now';

1	2024-07-02T06:01:06Z

the UTC TIME

I have also added the variable to the spark-defaults.conf file like spark.sql.session.timeZone=Europe/Warsaw

But after restarting Spark3 and Hue nothing has changed.

Thank you for your help in advance.

Regards,

Bart

Re: How to set default time zone/local time for SparkSql on Hue Sessions.

tj2007 — Wed, 03 Jul 2024 09:54:29 GMT

Hello @Bartlomiej,

You can change the timezone for Hue using the steps below:

Log in to Clouder Manager as an Administrator.
Go to Clusters > Hue > Configuration > Time Zone and set a desired value.
The default value is America/Los_Angeles. You can refer to https://timezonedb.com/time-zones for information on the timezones.
Click Save Changes.
Restart the Hue service.

Let me know if this helps.

Cheers!

Re: How to set default time zone/local time for SparkSql on Hue Sessions.

Bartlomiej — Wed, 03 Jul 2024 10:06:26 GMT

Hello

Thank you for this hint. However I have already check that configuration and it was already Europe/Warsaw so the one diesired.

There must be somewhere some other place to specify this i think.

Re: How to set default time zone/local time for SparkSql on Hue Sessions.

Bartlomiej — Thu, 04 Jul 2024 13:46:50 GMT

I think teh time zone has nothing to do with CURRENT_TIMESTAMP () finally. As teh actually need is to use the CURRENT_TIMESTAMP () or TIMESTAMP 'now' and have the local time as default time of that function in Spark SQL while running the query over the HUE.

Now these function are giving the time 2 h late with means in UTC format and I would like to have by default 2h later or EUROPE/Berlin time for example

Re: How to set default time zone/local time for SparkSql on Hue Sessions.

RangaReddy — Wed, 10 Jul 2024 06:18:48 GMT

Issue looks like you are hitting CDPD-66940 jira and try to upgrade your CDS3 parcel to latest and it will resolve your issue.

Re: How to set default time zone/local time for SparkSql on Hue Sessions.

DianaTorres — Tue, 16 Jul 2024 00:20:48 GMT

@Bartlomiej Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.

Thanks.

Re: How to set default time zone/local time for SparkSql on Hue Sessions.

Bartlomiej — Tue, 08 Oct 2024 10:57:12 GMT

Yes , upgrading spark to newest SPARK version SPARK3-3.3.2.3.3.7190.5-2-1.p0.54391297 - fixed the issue