JSqlParser icon indicating copy to clipboard operation
JSqlParser copied to clipboard

Redshift APPROXIMATE not supported

Open frankfarrell opened this issue 7 years ago • 0 comments

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:

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

frankfarrell avatar Jan 19 '18 11:01 frankfarrell