NOT ABLE TO FILTER QUERY RESULTS

[kashu94]

I have a movies dataset, and as we can clearly see that there's a person with a person_id=7 .... But I'm not able to filter that result when I do this - 

and this is happening with other queries as well .... please help

[glilienfield · Accepted solution]

Are you sure that 'id' is an integer?  If you imported it and did not use toInteger(), it will be a string. Try using:

where p.person_id='7'

[kashu94]

thanks, that worked