extraneous input '*' expecting ...

ErrorCode

ParameterInvalid

ErrorMessage

extraneous input 'limit' expecting

Error description

The SQL input contains extra information, which is expected to be a specific symbol.

Cause

• Your input is incorrect and does not comply with the Query statement | Analysis statement syntax of Simple Log Service. The input may contain only an SQL analysis statement, without a pipe (|) or query statement before the analysis statement. Simple Log Service provides the combined query and analysis capabilities on log data. The query capability is similar to a search engine, and the analysis capability is similar to SQL. In the [Query statement | Analysis statement] self-developed syntax of Simple Log Service, a pipe (|) is used to combine the query and analysis capabilities. You can use the query statement before the pipe (|) to query the feature data that you need, and then use the analysis statement (standard SQL) after the pipe (|) to perform multi-dimensional statistical analysis on the queried valid data.
• Incorrect syntax or symbols are entered in the SQL statements.

Solution

• Check whether the input statements are valid by referring to the description of the Query statement | Analysis statement syntax of Simple Log Service.
• • If the error persists, check whether the SQL statements contain extra symbols or syntax errors.We recommend that you use an online SQL check tool to locate and fix the error.