Run a hive table with a list in where clause and store it in dataframe

i have a hive table "tb", list ("a","b","c") my requirement is to

hive query should run for each element of list

val append (all values in list/array/df)= hc.sql(s"""select col1 from tb where col not in ("$list.toString)")""").collect().tolist 

preferable output in dataframe

table values

col1  col2  col3 
----------------
ab    cd    a
fgcd  defr  b

output should be like

output col

ab
fgcd