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
hive_script
Description: Binary data
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
