- 8463 Views
- 3 replies
- 4 kudos
to_utc_timestamp is subtracting a different time delta and from_utc_timestamp is not adding the same delta.
My session timezone is Australia/Sydneyif i run the below query my expectation is first column and third column should show the same value. But it is not working as expected for 1753-01-01 00:00:00 timestamp.spark.conf.set("spark.sql.session.timeZone...
- 8463 Views
- 3 replies
- 4 kudos
- 4 kudos
Hi @Rahul Lalwani​ (Customer)​,In Interactive cluster spark.sql.datetime.java8API.enabled is disabled when we enable spark.sql.datetime.java8API.enabled to true , we can see crt values for 1753-01-01 as well.The reason for enabling the above config ...
- 4 kudos
- 5246 Views
- 2 replies
- 2 kudos
Resolved! "Photon ran out of memory" while when trying to get the unique Id from sql query
I am trying to get all unique id from sql query and I always run out of memoryselect concat_ws(';',view.MATNR,view.WERKS) from hive_metastore.dqaas.temp_view as view join hive_metastore.dqaas.t_dqaas_marc as marc on marc.MATNR = view.MATNR where view...
- 5246 Views
- 2 replies
- 2 kudos
- 2 kudos
Hi @Anil Kumar Chauhan​ We haven't heard from you since the last response from @Werner Stinckens​ . Kindly share the information with us, and in return, we will provide you with the necessary solution.Thanks and Regards
- 2 kudos