Hello All,
I am getting a weird issue while using where and group by together, while querying influx from JAVA
Query is -
Query query = select(status).distinct().from(DATABASE,MEASUREMENT)
.where(eq(deviceid,1234))
.and(eq(devicerange,459))
.groupBy(“host_name”);
Error:
java.net.SocketException: Software caused connection abort: recv failed
at java.net.SocketInputStream.socketRead0(Native Method) ~[na:1.8.0_261]
at java.net.SocketInputStream.socketRead(Unknown Source) ~[na:1.8.0_261]
at java.net.SocketInputStream.read(Unknown Source) ~[na:1.8.0_261]
at java.net.SocketInputStream.read(Unknown Source) ~[na:1.8.0_261]
at okio.InputStreamSource.read(Okio.kt:102) ~[okio-2.2.2.jar:na]
at okio.AsyncTimeout$source$1.read(AsyncTimeout.kt:159) ~[okio-2.2.2.jar:na]
at okio.RealBufferedSource.indexOf(RealBufferedSource.kt:349) ~[okio-2.2.2.jar:na]
at okio.RealBufferedSource.readUtf8LineStrict(RealBufferedSource.kt:222) ~[okio-2.2.2.jar:na]
If i update the query and remove the group by, it return the result, but we need the group by clause.
Please guide on same
