Hi Team,
I am unable to run the below command and it is giving me a parse error. Can any one point out the issue with the code:
Hi,
From the error , it looks like there is no space between the brackets and the "in" keyword after the where clause. Can you please try again see if you facing the same error.
Hi still getting the same error after putting spaces for in
Hi @KalingaSena ,
I created a dummy dataset on delta lake and ran a similar query like yours (almost with the same structure). And I am getting the output as expected without any failure. Please see below attached cell.
Although the 'in' keyword can or cannot have space , the error you are getting suggests its mostly syntax related. The only difference in our code is , you are probably reading an externa table from ADLS whereas I am not. If you happen to resolve your issue then pls share here.
.png){kind=link}