Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

Facing transport exception in hive

Expert Contributor

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

 

 

1 ACCEPTED SOLUTION

Expert Contributor

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.

View solution in original post

3 REPLIES 3

Guru
@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

Expert Contributor

@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

 

 

Expert Contributor

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.