[ 
https://issues.apache.org/jira/browse/KNOX-2205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17026423#comment-17026423
 ] 

Larry McCay edited comment on KNOX-2205 at 1/30/20 4:53 AM:
------------------------------------------------------------

Seems that adding  ;http.header.Connection=close to the end of the connect 
string has helped but I also made a code change.
I'll try without the code change and lookup exactly what that header is doing.

So, It looks like setting Connection to close on the client is indicating that 
the connection should be closed by the server. This is less than ideal but 
performance seems to be pretty acceptable in my testing so far.


was (Author: lmccay):
Seems that adding  ;http.header.Connection=close to the end of the connect 
string has helped but I also made a code change.
I'll try without the code change and lookup exactly what that header is doing.

> KnoxLine Connection timesout too quickly with Hive
> --------------------------------------------------
>
>                 Key: KNOX-2205
>                 URL: https://issues.apache.org/jira/browse/KNOX-2205
>             Project: Apache Knox
>          Issue Type: Improvement
>          Components: KnoxShell
>            Reporter: Larry McCay
>            Assignee: Larry McCay
>            Priority: Major
>             Fix For: 1.4.0
>
>
> {code:java}
> knoxline> select * from logs
> select * from logs
> +----------------+----------------+----------------+----------------+----------------+----------------+----------------+
> | logs.column1 | logs.column2 | logs.column3 | logs.column4 | logs.column5 | 
> logs.column6 | logs.column7 |
> +----------------+----------------+----------------+----------------+----------------+----------------+----------------+
> | value1 | value2 | value3 | value4 | value5 | value6 | value7 |
> +----------------+----------------+----------------+----------------+----------------+----------------+----------------+
> Rows: 1
> knoxline> 
> knoxline> show tables
> show tables
> SQL Exception encountered... org.apache.thrift.transport.TTransportException: 
> org.apache.http.NoHttpResponseException: 
> cdp-retail-1-3-dataeng-master0.cdp-reta.svbr-nqvp.int.cldr.work:443 failed to 
> respond
> knoxline> show tables
> show tables
> +------------+
> | tab_name |
> +------------+
> | logs |
> +------------+
> Rows: 1
> knoxline>
> {code}
> Retrying the query reestablishes the connection but we need to avoid that.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to