hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raihan Jamal <jamalrai...@gmail.com>
Subject Re: org.apache.hadoop.ipc.RemoteException(java.io.IOException: java.io.IOException
Date Wed, 03 Oct 2012 21:19:11 GMT
Can anyone help me out here? What does the below error means? And this is
the query I am using-

*SELECT cguid,*
* event_item,*
* event_timestamp,*
* event_site_id*
*FROM (*
* SELECT event.app_payload ['n'] AS cguid,*
* event.app_payload ['itm'] AS event_item,*
* max(event.event_timestamp) AS event_timestamp,*
* event.site_id AS event_site_id*
* FROM soj_session_container a LATERAL VIEW explode(a.events) t AS event*
* WHERE a.dt = '20120917'*
* AND event.app_payload ['n'] IS NOT NULL*
* AND instr(event.app_payload ['itm'], '%') = 0*
* AND event.app_payload ['itm'] IS NOT NULL*
* AND (*
* event.page_type_id = '4340'*
* OR event.page_type_id = '2047675'*
* )*
* GROUP BY event.app_payload ['n'],*
* event.site_id,*
* event.app_payload ['itm']*
* ORDER BY cguid,*
* event_timestamp DESC*
* ) m*
*LEFT OUTER JOIN (*
* SELECT event.app_payload ['n'] AS changed_cguid*
* FROM soj_session_container a LATERAL VIEW explode(a.events) t AS event*
* WHERE a.dt = '20120918'*
* AND unix_timestamp(SojTimestampToDate(event.event_timestamp), 'yyyy/MM/dd
HH:mm:ss') >= unix_timestamp('2012/09/18 00:00:00', 'yyyy/MM/dd HH:mm:ss')*
* AND unix_timestamp(SojTimestampToDate(event.event_timestamp), 'yyyy/MM/dd
HH:mm:ss') <= unix_timestamp('2012/09/18 02:00:00', 'yyyy/MM/dd HH:mm:ss')*
* ) n ON m.cguid = n.changed_cguid*
*WHERE n.changed_cguid IS NULL*



*Raihan Jamal*



On Wed, Oct 3, 2012 at 11:05 AM, Raihan Jamal <jamalraihan@gmail.com> wrote:

> I am running a Hive query and I am getting this exception below-
>
> *Job Submission failed with exception
> 'org.apache.hadoop.ipc.RemoteException(java.io.IOException:
> java.io.IOException: The number of tasks for this job 2072020 exceeds the
> configured limit 200000*
>
> I am not sure what does this error means? Can anyone help me out here?
>
>
>
> *Raihan Jamal*
>
>

Mime
View raw message