Not able to execute below SQL query in databricks notebook because of Pare error

[KalingaSena]

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:

[BkP]

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. 

[KalingaSena]

Hi still getting the same error after putting spaces for in

[BkP]

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.