spark sql lateral view unresolved attribute exception

[weoccc]

Hi,

It seems LATERVAL VIEW explode column named 'some_col' can't be resolved if
expressed in subquery. Any idea why ?

SELECT `fc_clickq`.`some_col` FROM ( SELECT *  FROM fc_clickq LATERAL VIEW
explode(`overlap`) ltr_table_3 AS `some_col`) fc_clickq ;

org.apache.spark.sql.catalyst.errors.package$TreeNodeException: Unresolved
attributes: 'fc_clickq.some_col, tree:

'Project ['fc_clickq.some_col]

 Subquery fc_clickq

  Project [......,`some_col`#180]

   Generate explode(overlap#170), true, false, Some(ltr_table_3)

    MetastoreRelation default, fc_clickq, None

Thx a lot,

Weide