https://community.cloudera.com/t5/Support-Questions/mismatched-input-AS-expecting-RIGHT-PAREN-in-Pig/m-p/191398#M153483 <P>Hi,</P><P>I want to fetch url ,methods and class from the below line using Pig Script:</P><BLOCKQUOTE>Mapped "{[/aLog/transaction],methods=[POST],produces=[application/vnd.app.v1+json || application/json]}" onto public org.springframework.http.ResponseEntity&lt;java.lang.Object&gt; com.fhlb.user.controller.rest.ALogService.aTransactionDetails(com.fhlb.user.beans.TansactionReportRequest,javax.servlet.http.HttpServletRequest) throws com.fhlb.commons.CustomException,java.io.FileNotFoundException</BLOCKQUOTE><P>Here is my Pig Script :</P><PRE>extract = FOREACH logs_entry GENERATE FLATTEN(REGEX_EXTRACT_ALL(logmessage,'^(Mapped)\\"(\\{+(\\[+([^/].*)+\\]),methods=(\\[+([A-Z].*)+\\]),produces=(\\[+([^ ].*)+\\])+\\}\\)"\\s+(\\S+)\\s+(\\S+)\\s+(\\S+)\\s+(throws)\\s+(.*) AS (t1:chararray,url:chararray,type:chararray,produces:chararray,t2:chararray,t3:chararray,classes:chararray,throw:chararray,exception:chararray);</PRE><P>But I got below error :</P><BLOCKQUOTE>ERROR 1200: &lt;line 9, column 229&gt; mismatched input 'AS' expecting RIGHT_PAREN </BLOCKQUOTE><P>I am not good at regex so please help me to find out the solution.</P><P>Thanks,</P> Thu, 22 Mar 2018 20:29:36 GMT priyal 2018-03-22T20:29:36Z