Re: NiFi <-> PrestoDB - Header is too large

[da...@effilab.com, da...@effilab.com]

PrestoDB issue opened by my colleague:
https://github.com/prestodb/presto/issues/11110

Fix will be pushed in PrestoDB JDBC driver.

On 2018/07/23 08:53:21, David Dumas <da...@effilab.com> wrote: 
> Hello everyone,
> 
> 
> We're having an issue with NiFi 1.7.1 and PrestoDB using JDBC 0.206, we are
> performing an SQL statement multiple times, after multiple tries we have
> the folowing error:
> 
> *NiFi logs*
> 
> Caused by: java.lang.RuntimeException: Error starting query at
> http://192.168.1.18:8080/v1/statement returned an invalid response:
> JsonResponse{statusCode=431, statusMessage=Request Header Fields Too Large,
> headers={connection=[close], content-length=[74],
> content-type=[text/html;charset=iso-8859-1]},
> hasValue=false} [Error: <h1>Bad Message 431</h1><pre>reason: Request Header
> Fields Too Large</pre>]
>     at com.facebook.presto.jdbc.internal.client.StatementClientV1.
> requestFailedException(StatementClientV1.java:436)
>     at com.facebook.presto.jdbc.internal.client.StatementClientV1.<init>(
> StatementClientV1.java:132)
>     at com.facebook.presto.jdbc.internal.client.StatementClientFactory.
> newStatementClient(StatementClientFactory.java:24)
>     at com.facebook.presto.jdbc.QueryExecutor.startQuery(
> QueryExecutor.java:46)
>     at com.facebook.presto.jdbc.PrestoConnection.startQuery(
> PrestoConnection.java:682)
>     at com.facebook.presto.jdbc.PrestoStatement.internalExecute(
> PrestoStatement.java:237)
>     ... 17 common frames omitted
> 
> *PrestoDB coordinator logs*
> 
> WARN    http-worker-485915    org.eclipse.jetty.http.HttpParser    Header
> is too large 8193>8192
> 
> [image: logo]
> *David Dumas* | DevOps engineer
> david@effilab.com
> 01 46 09 31 90
> 204 Rond Point du Pont-de-Sèvres,
> 92100 Boulogne-Billancourt
> [image: website] <http://www.effilab.com/> [image: Facebook]
> <https://facebook.com/Effilab> [image: Twitter]
> <https://twitter.com/Effilab> [image: LinkedIn]
> <https://www.linkedin.com/company/effilab-agency>
>