How to set alias data type?

[Shaozhong SHI]

select 'Total' as Total generate result that set Total as a column name
with unknown type
When trying to cast
select 'Total' as Total:: text

It simply does not work.

Regards,

David