set hive.mapred.mode=nonstrict;
drop table macro_testing;
CREATE TABLE macro_testing(a int, b int, c int);

insert into table macro_testing values (1,2,3);
insert into table macro_testing values (4,5,6);

create temporary macro math_square(x int) x*x;
create temporary macro math_add(x int) x+x;

select math_square(a), math_square(b),factorial(a), factorial(b), math_add(a), math_add(b),int(c) from macro_testing order by int(c);