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 (res.next()) {
System.out.println(res.getString(1));
}
...
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.