[google-cloud-sql-discuss] Trying to query a weak field in a subquery

I'm trying to execute the following query in #PLX with no success.

set sql_dialect GoogleSQL

SELECT  

EventId.*,

FROM 

youtube.youtube_weblog.3daysago yt

WHERE EXISTS(

SELECT *

FROM yt.(GWSLogEntryProto_weak_fields_pkg.YouTubeExtension).interaction_logging.client_data.spotlight_story_data.has_scene as spd

  WHERE spd IS NOT NULL

)

I get the following error: 

Error: Expecting [)], but found '.' (line 8, column 9) Error: Expecting [EOF], but found '.' (line 8, column 9) Error: (line 4, column 1) Error: Error auto-detecting query engine. Error: DREMEL: Syntax error: Unexpected keyword FROM Error: DREMEL: Error parsing script sql. Error: TENZING: Error parsing script sql. Error: F1: Syntax error: Unexpected keyword FROM

I'm really not sure how to reference a weak field from within a sub query. I've tried every combination of back ticks I can think of but it always seems to fail. Am I making an obvious mistake?

Thanks!

Jamieson

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6287954a-bdb8-4113-b2af-0a32598c5591%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.