hive replace,如何使用反映HIVE的替换字符串？

I want to replace a string from "\7" to "\1", my input file like this:

a\7b\7c\7

my other table FIELDS TERMINATED BY '\001', so I must replace "\7" to "\1".

I tried

select regexp_replace(value, "\\u0007", "\\u0001") from test_tbl where dbs="test" and dt=20131130;

but it doesn't work.

And I wrote a php script like this:

$strCmd = "hive -e 'select regexp_replace(value, \"\\u0007\", \"\1\") from test_tbl where dbs=\"test\" and dt=20131130;' > tmp";

exec($strCmd);

but it return some error.

解决方案

I solved it with "transform" method and I wrote a simple php script that contains str_replace. But I found another issus, see here.

Thanks all guys helped me.