Welcome to the Cloudera Community

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

Who agreed with this topic

Got error when execute a complex query in hue or by jdbc(impala1.3)

avatar
Explorer

error messages are changing, sometimes get error "

Couldn't open transport for xxxxxxx.com:22000(connect() failed: Connection refused)

",

sometimes get error:"Could not connect to szxhd001-rhl.huawei.com:21050",

 

sometimes get error:"Bad status for request 1622: TGetOperationStatusResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0), operationState=5, errorMessage=None, sqlState=None, errorCode=None)"

 

sql:

 

select
u_id,
max(m.level_2) appName,
max(m.module_1) module,
max(m.task_create_date) task_create_date,
max(m.params) params,
max(m.event_message) message,
max(m.server_name) server_name,
max(m.app_version) appVersion,
max(m.app_name_todo) appNameTodo

from
meap.event_log m
where
m.create_date_p >= to_date('2014-01-01')
and m.create_date_p <= to_date('2014-12-12')
and m.site_id_p ='xxxx'
group by m.u_id
order by m.u_id desc limit 100

Who agreed with this topic