Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

TSocket read 0 bytes error in Hive

avatar
New Contributor

When I m trying to run a query in Hive I get the error "TSocket read 0 bytes". Could you please help me out? We are using Cloudera 5.4.2 from our end. 

 

Sometime I get the error "Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=dfb50d53-725f-4730-9db2-9c2f5e1dd0cd]" for the same query.

 

This is the sample query that we are running 

 

select
distinct
d.vbeln as erp_invoice_number,
b.posnr as erp_invoice_line_number,
a.zzovhdrinv as bill_number,
c.zzoviteminv as bill_line_item_number,
e.land1 as country,
NULL as product_code,
NULL as product_name,
case when e.land1='BR'
then cast(round((b.ZZKZWL1*b.kursk),2) as decimal(20,2))
else cast(round((b.KZWI2*b.kursk),2) as decimal(20,2))
end as list_price_local_currency,
e.waers as local_currency,
NULL as list_price_global_currency,
NULL as global_currency,
cast(round(((b.netwr+b.mwsbp)*b.kursk),2) as decimal(20,2)) as payable_amount_local_currency,
NULL as payable_amount_global_currency,
from_unixtime(unix_timestamp()) as edl_created_date,
'SAP BtB' as ERP_NAME
from
ovfa_stg.btb_VBAK a,
ovfa_stg.btb_VBRP b,
ovfa_stg.btb_VBAP c,
ovfa_stg.btb_VBRK d,
ovfa_stg.btb_T001 e
where
a.VBELN=b.AUBEL
and c.VBELN = b.AUBEL
and c.POSNR = b.AUPOS
and d.VBELN=b.VBELN
and d.BUKRS=e.BUKRS

 

Who agreed with this topic