Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " "(" "( "" at line 1, column 35.
Was expecting one of:
<EOF>
"INTO" ...
"FROM" ...
"WHERE" ...
"FOR" ...
"GROUP" ...
"HAVING" ...
"START" ...
"CONNECT" ...
";" ...
"," ...
"," ...
"INTO" ...
"FROM" ...
"WHERE" ...
"START" ...
"CONNECT" ...
"GROUP" ...
"HAVING" ...
"FOR" ...
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:15112)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:14968)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:90)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:52)
... 47 more
Using APPROXIMATE in redshift queries as defined here:
https://docs.aws.amazon.com/redshift/latest/dg/r_APPROXIMATE_PERCENTILE_DISC.html
https://docs.aws.amazon.com/redshift/latest/dg/r_COUNT.html
caused this exception to be thrown: