Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - org.apache.hadoop.ipc.RemoteException(java.io.IOException: java.io.IOException


Copy link to this message
-
Re: org.apache.hadoop.ipc.RemoteException(java.io.IOException: java.io.IOException
Raihan Jamal 2012-10-03, 21:19
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 <[EMAIL PROTECTED]> 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*
>
>