01-06-2016 01:04 PM
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
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
and c.VBELN = b.AUBEL
and c.POSNR = b.AUPOS