If you are trying to sort first name by asc and lname by desc, it does not make sense since the fname and lname are related columns that is even if we succeed in sorting both columns differently, the names are going to change for example, If we have a name Elena Gilbert, her surname might change which defeats the logic.
Here is the commands for sorting in fname acsending order :
create table emp_script (EmpId Int, Fname String, Lname String) row format delimited fields terminated by ",";
load data inpath "emp.txt" into table emp_sript;
INSERT OVERWRITE LOCAL DIRECTORY '/user/edureka_425640/emp_script_output' SELECT * from emp_script ORDER BY Fname