Resolved the issue by adding mysql library jar path in to
<property><name>hive.aux.jars.path</name> in
repository/conf/advanced/hive-site.xml.
On Tue, Jun 3, 2014 at 11:35 AM, Dinesh Bandara <dine...@wso2.com> wrote:
> Hi
>
> Please find the attached hive script.
>
> Thanks,
>
>
> On Tue, Jun 3, 2014 at 11:24 AM, Gihan Anuruddha <gi...@wso2.com> wrote:
>
>> This might be due to sql error. Please check your sql statement
>> separately.
>>
>>
>> On Tue, Jun 3, 2014 at 11:19 AM, Inosh Goonewardena <in...@wso2.com>
>> wrote:
>>
>>> Hi Dinesh,
>>>
>>> Can you attach your hive script?
>>>
>>>
>>> On Tue, Jun 3, 2014 at 11:09 AM, Dinesh Bandara <dine...@wso2.com>
>>> wrote:
>>>
>>>> Hi ,
>>>>
>>>> When ruining the hive script following error occurred,
>>>>
>>>> TID: [0] [BAM] [2014-06-02 10:56:42,269] WARN
>>>> {org.apache.hadoop.mapred.
>>>> JobClient} - Use GenericOptionsParser for parsing the arguments.
>>>> Applications should implement Tool for the same.
>>>> {org.apache.hadoop.mapred.JobClient}
>>>> TID: [0] [BAM] [2014-06-02 10:57:21,125] ERROR
>>>> {org.apache.hadoop.hive.ql.exec.Task} - Ended Job = job_201406021038_0008
>>>> with errors {org.apache.hadoop.hive.ql.exec.Task}
>>>> TID: [0] [BAM] [2014-06-02 10:57:21,126] ERROR
>>>> {org.apache.hadoop.hive.ql.exec.Task} - Error during job, obtaining
>>>> debugging information... {org.apache.hadoop.hive.ql.exec.Task}
>>>> TID: [0] [BAM] [2014-06-02 10:57:21,134] ERROR
>>>> {org.apache.hadoop.hive.ql.exec.Task} - Examining task ID:
>>>> task_201406021038_0008_m_000003 (and more) from job job_201406021038_0008
>>>> {org.apache.hadoop.hive.ql.exec.Task}
>>>> TID: [0] [BAM] [2014-06-02 10:57:21,136] ERROR
>>>> {org.apache.hadoop.hive.ql.exec.Task} - Unable to find job tracker info
>>>> port. {org.apache.hadoop.hive.ql.exec.Task}
>>>> TID: [0] [BAM] [2014-06-02 10:57:21,155] ERROR
>>>> {org.apache.hadoop.hive.ql.Driver} - FAILED: Execution Error, return code
>>>> 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
>>>> {org.apache.hadoop.hive.ql.Driver}
>>>> TID: [0] [BAM] [2014-06-02 10:57:21,156] ERROR
>>>> {org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl} - Error
>>>> while executing Hive script.
>>>> Query returned non-zero code: 9, cause: FAILED: Execution Error, return
>>>> code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
>>>> {org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl}
>>>> java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED:
>>>> Execution Error, return code 2 from
>>>> org.apache.hadoop.hive.ql.exec.MapRedTask
>>>> at
>>>> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189)
>>>> at
>>>> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.executeHiveQuery(HiveExecutorServiceImpl.java:569)
>>>> at
>>>> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:282)
>>>> at
>>>> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189)
>>>> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>>>> at
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>>>> at
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>>>> at java.lang.Thread.run(Thread.java:745)
>>>> TID: [0] [BAM] [2014-06-02 10:57:21,168] ERROR
>>>> {org.wso2.carbon.analytics.hive.ui.client.HiveExecutionClient} - Error
>>>> while executing Hive script.Query returned non-zero code: 9, cause: FAILED:
>>>> Execution Error, return code 2 from
>>>> org.apache.hadoop.hive.ql.exec.MapRedTask
>>>> {org.wso2.carbon.analytics.hive.ui.client.HiveExecutionClient}
>>>> org.wso2.carbon.analytics.hive.stub.HiveExecutionServiceHiveExecutionException:
>>>> HiveExecutionServiceHiveExecutionException
>>>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>>>> Method)
>>>>
>>>> Any Idea on how to solve this?
>>>> Thanks
>>>>
>>>> --
>>>> *Dinesh Bandara*
>>>> Software Engineer
>>>> WSO2 Inc.; http://wso2.com
>>>> lean.enterprise.middleware
>>>>
>>>>
>>>> _______________________________________________
>>>> Dev mailing list
>>>> Dev@wso2.org
>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>>
>>>>
>>>
>>>
>>> --
>>> Regards,
>>>
>>> Inosh Goonewardena
>>> Associate Technical Lead- WSO2 Inc.
>>> Mobile: +94779966317
>>>
>>> _______________________________________________
>>> Dev mailing list
>>> Dev@wso2.org
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>>
>>
>> --
>> W.G. Gihan Anuruddha
>> Senior Software Engineer | WSO2, Inc.
>> M: +94772272595
>>
>
>
>
> --
> *Dinesh Bandara*
> Software Engineer
> WSO2 Inc.; http://wso2.com
> lean.enterprise.middleware
>
>
--
*Dinesh Bandara*
Software Engineer
WSO2 Inc.; http://wso2.com
lean.enterprise.middleware
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
