如果是Hivesql,则如下:
select * from table_xxx where info not rlike '[\\u4e00-\\u9fa5]'
如果是在Shell终端调用,则如下:
hive -e "select * from table_xxx where info not rlike '[\\\u4e00-\\\u9fa5]'"
如果是Hivesql,则如下:
select * from table_xxx where info not rlike '[\\u4e00-\\u9fa5]'
如果是在Shell终端调用,则如下:
hive -e "select * from table_xxx where info not rlike '[\\\u4e00-\\\u9fa5]'"