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';       TIMESTAMP '2024-07-02 08:01:06.157849' My current time     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   ... View more

Dear Friends The concerned Cloudera Services are:  Spark 3 , Livy for Spark 3, Hue After I have added Spark SQL interpreter in Hue I am struggling  to get more than 1000 rows results once querying  the DB. Do you know what parameter should be used to change the default quantity. I Already tried to use : spark.livy.sql.max-result CM --> Livy for Spark3 --> Search for "Livy for Spark 3 Client Advanced Configuration Snippet (Safety Valve) for livy3-conf/livy-client.conf" and add the above parameter with value. spark.livy.sql.max-result=2000 However after restarting the concerns services - nothing has changed.  Hereunder you can see what is all about: I would like to change this limitation to e.g. 5000. But not sure on what mentioned services this should be adjusted on. I really appreciate your help in this. Thank you ... View more