You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by pandees waran <pa...@gmail.com> on 2013/08/19 04:58:19 UTC

LAG throws exceptions

Hi,

I am executing the below query using lag in 0.11 in Amazon EMR cluster.

SELECT
      id  ,
      MARKET_ID,
      city,
      product_id,
      SALE_DAY,
      isbn,
      seller_ID,
      currency,
      lag(quantity,1,0) over (partition by
isbn,ID,MARKET_ID,city,seller_ID,currency order by SALE_DAY)  AS
start_quantity
    FROM test_table

This simple query ended with below exceptions:

Exception in thread "Thread-758" java.lang.ClassFormatError:
org/apache/hadoop/mapred/TaskLogServlet
        at org.apache.hadoop.hive.shims.Hadoop20SShims.getTaskAttemptLogUrl(Hadoop20SShims.java:49)
        at org.apache.hadoop.hive.ql.exec.JobDebugger$TaskInfoGrabber.getTaskInfos(JobDebugger.java:190)
        at org.apache.hadoop.hive.ql.exec.JobDebugger$TaskInfoGrabber.run(JobDebugger.java:146)
        at java.lang.Thread.run(Thread.java:724)
Counters:
FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask

Any thoughts on this? Please let me know, if i am doing something wrong.
-- 
Thanks,
Pandeeswaran

Re: LAG throws exceptions

Posted by Nitin Pawar <ni...@gmail.com>.
Can you fetch the logs from jobtracker url and use pastebin to provide log?

This is client side error, the actual error is on job page


On Mon, Aug 19, 2013 at 8:28 AM, pandees waran <pa...@gmail.com> wrote:

> Hi,
>
> I am executing the below query using lag in 0.11 in Amazon EMR cluster.
>
> SELECT
>       id  ,
>       MARKET_ID,
>       city,
>       product_id,
>       SALE_DAY,
>       isbn,
>       seller_ID,
>       currency,
>       lag(quantity,1,0) over (partition by
> isbn,ID,MARKET_ID,city,seller_ID,currency order by SALE_DAY)  AS
> start_quantity
>     FROM test_table
>
> This simple query ended with below exceptions:
>
> Exception in thread "Thread-758" java.lang.ClassFormatError:
> org/apache/hadoop/mapred/TaskLogServlet
>         at
> org.apache.hadoop.hive.shims.Hadoop20SShims.getTaskAttemptLogUrl(Hadoop20SShims.java:49)
>         at
> org.apache.hadoop.hive.ql.exec.JobDebugger$TaskInfoGrabber.getTaskInfos(JobDebugger.java:190)
>         at
> org.apache.hadoop.hive.ql.exec.JobDebugger$TaskInfoGrabber.run(JobDebugger.java:146)
>         at java.lang.Thread.run(Thread.java:724)
> Counters:
> FAILED: Execution Error, return code 2 from
> org.apache.hadoop.hive.ql.exec.MapRedTask
>
> Any thoughts on this? Please let me know, if i am doing something wrong.
> --
> Thanks,
> Pandeeswaran
>



-- 
Nitin Pawar