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");