将 "stored as "和 "location "这两行调换一下，根据手册的规定，它们必须按照特定的顺序进行。

create table exploderesults 
stored as textfile
location '/user/cloudera/sometest'
as
select id,ph as phone, ct as city from explodetest
lateral view explode(phone)p as ph
lateral view explode(city)c as ct;

如果你想指定一个定界符。

create table exploderesults 
row format delimited fields terminated by ','
stored as textfile
location '/user/cloudera/sometest'
as
select id,ph as phone, ct as city from explodetest
lateral view explode(phone)p as ph
lateral view explode(city)c as ct;