mysql - removing time overlap from single table group by catagory1 catagory2 -

hive preferred or sql remove time overlap

catagory1 catagory2 timestart time_end   1                4:00     5:00 1                2:30     4:30 1                3:30     5:00 1                5:00     7:00 1                8:00     9:00 2                4:00     5:00 1         b        4:00     5:00 

removing time overlap single table group catagory1 catagory2

result looks

catagory1 catagory2 timestart time_end   1                4:00        5:00 1                5:00        7:00 1                8:00        9:00 2                4:00        5:00 1         b        4:00        5:00