| drop table aa; | |
| create table aa ( test STRING ) | |
| ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' | |
| WITH SERDEPROPERTIES ("input.regex" = "(.*)", "output.format.string" = "$1s"); | |
| alter table aa set serdeproperties ("input.regex" = "[^\\](.*)", "output.format.string" = "$1s"); | |