Hive function to replace comma in column value

Question

I have a hive table which has String column having value as 12,345. Is there any way hive function which can remove comma during insertion in this hive table ?

score 5 · Accepted Answer · answered Jul 01 '14 at 08:34

You can use regexp_replace(string INITIAL_STRING, string PATTERN, string REPLACEMENT) which is a function in Hive.

So if you are moving the data from a table that contains the comma to a new table you will use :
insert into table NEW select regexp_replace(commaColumn,',','') from OLD;

score 0 · Answer 2 · edited May 23 '17 at 10:30

0

Hive does have split function. which can be used here. split and concat to achieve the desired result You may refer this question. Does Hive have a String split function?

edited May 23 '17 at 10:30

Community

1
1

answered Jul 01 '14 at 07:32

Harikrishnan Ck

920
1
11
12

Hive function to replace comma in column value

2 Answers2

Linked