Spark hive can not choose some columns in target table flexibly, when running insert into.

insert into tableA select ... from tableB;

insert into gja_test_spark select * from gja_test;
insert into gja_test_spark(key, value, other) select key, value, other from gja_test;
insert into gja_test_spark(key, value) select value, other from gja_test;
insert into gja_test_spark(key, other) select value, other from gja_test;
insert into gja_test_spark(value, other) select value, other from gja_test;