MySQL Query Equivalent In JDBC Static

Elastic Stack Logstash
1

hello, I have a query in MySQL and I was wondering what would the equal query in JDBC static with parameters be.
Here's my query:

select name from my_table where inet_aton('1.1.1.1') between ip_from and 
ip_to limit 1;

All columns are VARCHAR. Does JDBC support INET_ATON? If not, what can I use instead?
Thanks in advance!

2

Have you actually tried running this query using the jdbc_static plugin?
It may work just fine since the interpretation of the SQL is done by the server and not the jdbc client.

3

As noted in another version of this question, MySQL supports INET_ATON, so it can probably be used in the loader, but Derby does not, so it cannot be used in the lookup.

1 Like
4

I had to handle it using a bit of coding in ruby.

5

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