Hi,
I am not sure if you were writing pseudo-code or real one but there were
few issues in the sql.
I have reproduced you example in the Spark REPL and all worked as
expected and result is the one you need
Please see below full code:
## *Spark 3.0.0*
>>> a = spark.read.csv("tab1", sep="|"
Hi Team,
i want to update a col3 in table 1 if col1 from table2 is less than col1 in
table1 and update each record in table 1.I 'am not getting the correct
output.
Table 1:
col1|col2|col3
2020-11-17T20:50:57.777+|1|null
Table 2:
col1|col2|col3
2020-11-17T21:19:06.508+|1|win
2020-11-17T20
