hive退格键不能删除文字_使用Hive删除特殊字符

最新推荐文章于 2023-05-12 10:09:22 发布

夏斯乐

最新推荐文章于 2023-05-12 10:09:22 发布

阅读量107

点赞数

文章标签： hive退格键不能删除文字

本文链接：https://blog.csdn.net/weixin_29351351/article/details/111887346

版权

I have data stored in Cassandra 1.2 as shown below. There is special character under sValue - highlighted as bold. How can I use hive function to remove this ?

---------------------------------+--------------------------------------+--------------------------+----------------------+----------------------+------------------------+---------------------------+--------------------------------+---------------------

2014-06-25 00:00:00-0400 | 2014-06-25 08:31:23-0400 | 2014-06-25 08:31:23-0400 | 06-25-2014 | 8 | 31 | lable | /t1/t2/100/200/11/99 | 2743326591.03\x00

解决方案

You can use regexp_replace() function.