Hi Thusitha,
I also tried the same sample. I got below errors in the started BAM
console. But I got the output as mentioned in the documentation.
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
[2015-02-11 14:26:45,034] ERROR {org.apache.hadoop.hive.ql.Driver} -
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
[2015-02-11 14:26:45,035] ERROR
{org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl} - Error
executing query: Query returned non-zero code: 9, cause: FAILED: Execution
Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED:
Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
at
org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189)
at
org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.executeHiveQuery(HiveExecutorServiceImpl.java:599)
at
org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:304)
at
org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:192)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
[2015-02-11 14:26:45,035] 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 1 from org.apache.hadoop.hive.ql.exec.DDLTask
java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED:
Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
at
org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189)
at
org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.executeHiveQuery(HiveExecutorServiceImpl.java:599)
at
org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:304)
at
org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:192)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
[2015-02-11 14:26:45,036] ERROR
{org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Error while
executing script : registry_activity_script
org.wso2.carbon.analytics.hive.exception.HiveExecutionException: Error
while executing Hive script.Query returned non-zero code: 9, cause: FAILED:
Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
at
org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl.execute(HiveExecutorServiceImpl.java:117)
at
org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask.execute(HiveScriptExecutorTask.java:70)
at
org.wso2.carbon.ntask.core.impl.TaskQuartzJobAdapter.execute(TaskQuartzJobAdapter.java:67)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Hasanthi Dissanayake
Software Engineer | WSO2
E: [email protected] <[email protected]>
M :0718407133| http://wso2.com <http://wso2.com/>
On Wed, Feb 11, 2015 at 9:39 AM, Thusitha Thilina Dayaratne <
[email protected]> wrote:
> Hi All,
>
> I'm trying to run the Statistics collector sample in the GReg[1]. I
> started the BAM and Deployed the KPI_Registry_Activity.tbox
> <https://docs.wso2.com/download/attachments/22185080/KPI_Registry_Activity.tbox?version=1&modificationDate=1350347592000&api=v2>
> .
> Then the following exception getting throw continuously.
>
> Job running in-process (local Hadoop)
> Hadoop job information for null: number of mappers: 0; number of reducers:
> 0
> 2015-02-11 09:32:02,789 null map = 0%, reduce = 0%
> 2015-02-11 09:32:05,791 null map = 100%, reduce = 0%
> Warning: generateAlternativeSeed
> *java.io.UTFDataFormatException: encoded string too long: 68777 bytes*
> at java.io.DataOutputStream.writeUTF(DataOutputStream.java:364)
> at java.io.DataOutputStream.writeUTF(DataOutputStream.java:323)
> at org.h2.util.MathUtils.generateAlternativeSeed(MathUtils.java:137)
> at org.h2.util.MathUtils.getSecureRandom(MathUtils.java:89)
> at org.h2.util.MathUtils.secureRandomBytes(MathUtils.java:383)
> at org.h2.store.FileLock.setUniqueId(FileLock.java:290)
> at org.h2.store.FileLock.lockFile(FileLock.java:320)
> at org.h2.store.FileLock.lock(FileLock.java:129)
> at org.h2.engine.Database.open(Database.java:523)
> at org.h2.engine.Database.openDatabase(Database.java:207)
> at org.h2.engine.Database.<init>(Database.java:202)
> at org.h2.engine.Engine.openSession(Engine.java:56)
> at org.h2.engine.Engine.openSession(Engine.java:146)
> at org.h2.engine.Engine.getSession(Engine.java:125)
> at org.h2.engine.Session.createSession(Session.java:122)
> at
> org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:241)
> at org.h2.engine.SessionRemote.createSession(SessionRemote.java:219)
> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:111)
> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:95)
> at org.h2.Driver.connect(Driver.java:73)
> at java.sql.DriverManager.getConnection(DriverManager.java:579)
> at java.sql.DriverManager.getConnection(DriverManager.java:221)
> at
> org.wso2.carbon.hadoop.hive.jdbc.storage.db.DBManager.createConnection(DBManager.java:73)
> at
> org.wso2.carbon.hadoop.hive.jdbc.storage.db.DBManager.createConnection(DBManager.java:85)
> at
> org.wso2.carbon.hadoop.hive.jdbc.storage.JDBCDataOutputFormat.getHiveRecordWriter(JDBCDataOutputFormat.java:48)
> at
> org.apache.hadoop.hive.ql.io.HiveFileFormatUtils.getRecordWriter(HiveFileFormatUtils.java:236)
> at
> org.apache.hadoop.hive.ql.io.HiveFileFormatUtils.getHiveRecordWriter(HiveFileFormatUtils.java:224)
> at
> org.apache.hadoop.hive.ql.exec.FileSinkOperator.createBucketFiles(FileSinkOperator.java:478)
> at
> org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:710)
> at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:553)
> at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:562)
> at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:562)
> at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:562)
> at org.apache.hadoop.hive.ql.exec.ExecReducer.close(ExecReducer.java:304)
> at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:528)
> at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:419)
> at org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:257)
>
> What is the reason for this? Is there any fix for this?
> [1] -
> https://docs.wso2.com/display/Governance460/Statistics+Collector+Sample
>
> Thanks and Regards
> --
> Thusitha Dayaratne
> Software Engineer | WSO2 Inc
>
> Email [email protected]
> Mobile +94712756809
> Blog alokayasoya.blogspot.com
>
>
> _______________________________________________
> Dev mailing list
> [email protected]
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
