blob: fad194d016ec9c260bb03c837fd2416c4c35c97b [file] [log] [blame]
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");