Hive Query to sort data

Question

I have a simple table employee (id int, fname string, lname string) with data. I am trying to sort the data fname by asc order and lname by desc order into the local file location /home/cert/problem5/solution.sql so that executing 

hive -f solution.sql 

should provide the output. Please advise how to accomplish this?

Answer 1

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

To know more, It's recommended to join Big Data Online Course today.