missing 'JOIN' at 'apply'(line 1, pos 109)

Question

I'm trying to use STRING_SPLIT function in my Azure 10.4 LTS (includes Apache Spark 3.2.1, Scala 2.12) to separate comma separated value So I wrote following SQL code %sql

select EmpPhoneNo, Split.value  
from EmpPhone as Emp 
Cross apply STRING_SPLIT(EmpPhoneNo,',') as Split 

I got error message saying

ParseException: missing 'JOIN' at 'apply'(line 1, pos 116)

Can you please help me to resolve the issue?