JDBC Limit equivalent?

Hi! I was wondering what would be the equivalent of the limit in JDBC static? it does not accept the limit 10 in my query string.

LIMIT is part of the syntax, perhaps I am confused.

See here

If the LIMIT or TOP is specified (cannot use both in the same query), the SELECT statement only returns a subset of the result rows. (See LIMIT Clause and TOP clause below.)

1 Like

None of them worked for my query.

Please do not open multiple threads on the same topic, this seems the same / related to the other topic.

The answer I gave above is for querying Elasticsearch with SQL but it seems that you're trying to use the JDBC connector in logstash.

1 Like

Yes, and I have issues getting my data using the connector.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.