This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

backslash in hive regexp_replace function?

Joseph Hwang
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I try to replace backslash(\) to slash(/) of string "L\F\W\A\5\LFWA55MATRQ647N.csv" in Hive regexp_replace function with java.
The result string I want is "L/F/W/A/5/LFWA55MATRQ647N.csv"

This is source

String sql = "select trim(regexp_replace(filename,'\', '/')) from table";
res = stmt.executeQuery(sql);
while ( {
using JDBC.But the result string is like below

/L/\/F/\/W/\/A/\/5/\/L/F/W/A/5/5/M/A/T/R/Q/6/4/7/N/./c/s/v/ / / / / / / / / / / /

Any advice will be appreciated.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic