select * from test.student1;
select * from test.student2;
set hive.support.quoted.identifiers=none;
select t.*
from
(
select
student1.`(name1)?+.+`,
student2.name1
from student1
join student2
on student1.id = student2.id
)t
;
结论:就是正常的列名