select id, v1
from table
union all
select id, v2
from table
union all
select id, v3
from table

insert into table result_table select Id, v1 as value from orig_table;
insert into table result_table select Id, v2 as value from orig_table;
insert into table result_table select Id, v3 as value from orig_table;
select Id,value from result_table;

或者

select Id, value 
       from orig_table LATERAL VIEW explode(array(v1,v2,v3)) orig_table_alias AS value;