HiveQl commands for filtering

0
votes

enter image description here

This what I think it's idk. Priority in q1 is attribute same goes to machine in q2.

how to add the part of priority in the command base on the questions. q1

SELECT COUNT (DISTINCT job_id, task_index) as Total
FROM task_events_ex
WHERE event_type = 1;

q2

SELECT COUNT(DISTINCT job_id, task_index) as Total
FROM task_events_ex
WHERE event_type =1;

Is there any command to find top 10 or something in hive? q3

SELECT cpu_request + memory_request + disk_space_request
FROM task_events_ex;

How to correct the above? Anyone can correct me on this?

sqlhadoophivehiveql