Re: need help with hive session getting killed

[Anup]

I am doing insert overwrite so results of query are getting written to an 
external table stored in parquet.

Which the properties should I set and Can I set those in query ?

Thanks 


> On Sep 20, 2016, at 8:27 AM, Jörn Franke  wrote:
> 
> Increase timeout or let the result of the query be written in a dedicated 
> table.
> 
>> On 20 Sep 2016, at 16:57, anup ahire  wrote:
>> 
>> 
>> 
>> 
>> Hello,
>> 
>> I am using hive-jdbc-1.2.1 to run a query. Query runs around an hour and 
>> eventually completes.
>> But my hive session terminats before I can get results from completed query 
>> and job fails.
>> java.sql.SQLException: org.apache.http.NoHttpResponseException: The target 
>> server failed to respond
>> 
>> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:296) 
>> ~[hive-jdbc-1.2.1.jar!/:1.2.1]
>> 
>> What is the best way to address this ?
>> 
>> 
>> 
>> Thanks ,
>> 
>> Anup
>> 
>> 

Re: need help with hive session getting killed

[Jörn Franke]

Increase timeout or let the result of the query be written in a dedicated table.

> On 20 Sep 2016, at 16:57, anup ahire  wrote:
> 
> 
> 
> 
> Hello,
> 
> I am using hive-jdbc-1.2.1 to run a query. Query runs around an hour and 
> eventually completes.
> But my hive session terminats before I can get results from completed query 
> and job fails.
> java.sql.SQLException: org.apache.http.NoHttpResponseException: The target 
> server failed to respond
> 
> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:296) 
> ~[hive-jdbc-1.2.1.jar!/:1.2.1]
> 
> What is the best way to address this ?
> 
> 
> 
> Thanks ,
> 
> Anup
> 
>