convert below Hive QL into spark program $-$

select distinct a

$.$

branch

$\_$

number,

$$ b

$.$

post

$\_$

code,

$$ case when a

$.$

location

$\_$

format is NULL and a

$.$

location

$\_$

type like "Petrol

$-$

Filling

$-$

Station" then "Petrol"

$$ when a

$.$

location

$\_$

format is NULL and a

$.$

legacy

$\_$

format

$\_$

code like

$"$

PH

$"$

$$then "Pharmacy"

$$ else a

$.$

location

$\_$

format end as store

$\_$

format

$\_$

description

$$ from channels

$\_$

reporting.vw

$\_$

channels

$\_$

locations a

inner join

$$

$($

select distinct location

$\_$

id

$,$

$$post

$\_$

code from location.location

$$ LATERAL VIEW INLINE

$($

array

$($

address

$)$

$)$

$$post

$\_$

code

$$ where lifecycle

$\_$

status like "Trading"

$$

$)$

$$b

$-$

$-$

$$limit is for testing

on a

$.$

location

$\_$

id

$=$

b

$.$

location

$\_$

id

where

a

$.$

lifecycle

$\_$

status like "Trading"

and a

$.$

country

$\_$

code like

$"$

GB

$"$

;