Viewing 15 posts - 1 through 15 (of 109 total)
Grant,
This is a perfect response.
I would say that I can get typical industry queries from LeetCode, Hackerrank, StrataSearch
June 6, 2022 at 10:11 pm
Hi Frederico,
Those are some great links, thanks
As regards your code, I'm getting the following errors:
1 Incorrect syntax near the keyword 'as'. 28 48
2 Incorrect syntax near the keyword 'with'. If...
June 5, 2022 at 9:01 pm
frederico,
Thanks for sticking with me on this.
I guess I want to get the full parsing.
Can you help with that?
June 5, 2022 at 6:57 pm
Hi Frederico
I was looking at the converted sql in a bit more detail and it looks like it didn't work.
See the attachffed.
Can you help me
June 5, 2022 at 6:37 pm
Hi All,
Thanks for helping me with this.
I managed to get what I need using the following site
June 5, 2022 at 2:26 pm
Hi Community
I just realised the file wasn't attached.
June 4, 2022 at 7:48 pm
Hi Jeff,
Thanks for sticking with me on this.
Just a couple of things:
Can you provide the answers to the...
March 12, 2022 at 9:12 pm
Eirikur, you're in the right ball park,
In typical pyspark I could do the following:
.withColumn("LAST_MODIFICATION_DT", to_timestamp(concat(col('LAST_MOD_DATE'), lit(' '), col('LAST_MOD_TIME')), 'yyyyMMdd HHmmss'))
But I'm not sure how to add that to sparkSQL.
I'm going...
March 12, 2022 at 10:41 am
So,
I managed to get the first half of the code to work in sparkSQL as follows:
select CAST(LAST_MOD_DATE AS STRING) AS expr1 from DmWo
I then try and get...
March 12, 2022 at 9:57 am
Basically, I think I need to find a way of achieving the result without the CONVERT function
March 12, 2022 at 9:36 am
Jeff,
As regards the CONVERT function, you make an excellent point. I use a dialect of T-SQL called sparkSQL (which comes from the world of Apache Spark.
I am trying to convert...
March 12, 2022 at 9:27 am
Is the CONVERT function absolutely necessary?
I've looked at a few CAST examples, and none of them actually include the CONVERT function
March 11, 2022 at 7:58 pm
Actually, there is no problem with it. I'm just being a numbty this Friday.
Thanks
March 11, 2022 at 7:44 pm
Hi Scott/Jeff
Thanks again for reaching out.
I've been revisiting your modification, and I'm not entirely sure how its going to work. Did you forget to add Last_Modification_DT?
CAST(LAST_MOD_DATE AS...
March 11, 2022 at 7:18 pm
This really works, thanks Jeff
March 10, 2022 at 12:27 pm
Viewing 15 posts - 1 through 15 (of 109 total)