Skip to main content
Manus
Gold ⭐️
March 18, 2020
Solved

Facing transport exception in hive

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

 

 

Manus
ManusAnswer
Gold ⭐️
March 19, 2020

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.

3 replies

EricL
Platinum ⭐️⭐️
Platinum ⭐️⭐️
March 18, 2020
@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
Translate
Manus
ManusAuthor
Gold ⭐️
March 19, 2020

@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

 

 

Translate
Manus
ManusAuthorAnswer
Gold ⭐️
March 19, 2020

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.

Translate