question Facing transport exception in hive in Support Questions

Facing transport exception in hive

Manus — Wed, 18 Mar 2020 13:46:34 GMT

Hi All,

I have implement almost 300 lines of hive query. The query template is as below.

Insert into targetTable
Select
col1,col2...........cols
.
.
.
.
(Almost 300 lines in select query with lots of case when statemnet)
From source table

My observation is that it works without giving any error in apache zeppeline. But when i trying to execute it through beeline it's failing with transport exception response code 500.

Other observation,when i remove few number of columns from select query in that also it works fine.

I do not understand why query is failing ?

I need to know the reason behind failure?

Thanks in advance

Re: Facing transport exception in hive

EricL — Wed, 18 Mar 2020 23:01:51 GMT

@Manus ,

Can you please share the error from Beeline and HS2 log? Without them, it is difficult to see what is going on.

Cheers
Eric

Re: Facing transport exception in hive

Manus — Thu, 19 Mar 2020 06:02:15 GMT

@EricL

Thanks for your reply. I am getting below error in hiveserver log.

10:20:02 START Executing current statement for: 'SCIP_Test_Env' [Hive]
10:20:03 FAILED [SELECT - 0 rows, 0.574 secs] [Code: 0, SQL State: 08S01] org.apache.hive.org.apache.thrift.transport.TTransportException: HTTP Response code: 500

Re: Facing transport exception in hive

Manus — Thu, 19 Mar 2020 10:18:17 GMT

Initially , My query was not converted in one line.Due to which i was facing syntax error in beeline itself.
I converted complete big query into one line and working now.