Member since
05-06-2021
1
Post
0
Kudos Received
0
Solutions
05-06-2021
02:01 AM
I got a column in my Hive SQL table where values are seperated by comma (,) for each cell. Some values in this string are duplicated which I want to remove. Here is an example of my data: data: --------------- test, test1, test,test1 --------------- rest,rest1,rest1,rest --------------- chest,nest,lest,gest --------------- The result should replace any duplicates: --------------- test,test1 --------------- rest,rest1 --------------- chest,nest,lest,gest --------------- I want to remove duplicates. Could anyone help me with this issue? Thank you
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Impala