Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: The Cloudera Community will undergo maintenance on Saturday, August 17 at 12:00am PDT. See more info here.

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

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

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

2 REPLIES 2

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

Explorer
Me too

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

Explorer

I'm getting this too.  Anyone figure it out?