Facing transport exception in hive

[#1]

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

[#2]

@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

[#3]

@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

[#4 · Accepted solution]

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.