I have below string in my DDL file and i want to remove the last
DDL has the
) character in many places, but I want to remove only in below place indicated.
.. `event_sts` string, `rsn_code` string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' ESCAPED BY '\\\\') <----- here STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
I tried using sed but somehow it's not working.
note: I have many DDLs with same requirement so the occurrence of '(' is not static.