JDBC Limit equivalent?

[rojin]

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.

[stephenb (Stephen Brown)]

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

See here

SELECT | Elasticsearch Guide [8.11] | Elastic

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.)

[rojin]

None of them worked for my query.

JDBC - SQL Query Issue

Hi! I have a database in MySQL and I want to fetch some info based on IP addresses I get from my client logs. There are ip_from(VARCHAR 50), ip_to(VARCHAR 50), ip_from_int(INT 10), and ip_to_int(INT 10) plus a name(VARCHAR 255) column in my desired table. I have written the filter as below and I want to fetch the name if the IP address is between ip_from and ip_to. But it keeps telling me that it cannot recognize INET_ATON as a function in JDBC. Is there a way I can get my result? the "clientip"…

[stephenb (Stephen Brown)]

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.

[rojin]

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