Hi,
I'm trying to configure BAM to work with ESB. I was able to successfully
connect ESB 403 to work with BAM201. Cassandra explorer worked fine too.
Then, I added 'Service Stats Monitoring Toolbox' via ui. And then, I went
to *“Main” tab --> “Manage” menu --> “Analytics” --> “List”, and executed
the default hive script '*service_stats_306*'. But when I did this, I got
the following exception. I didn't configure any db/hadoop/hive. Does it
need any? *
*ERROR: 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*
osgi> [2012-11-25 12:27:00,022] INFO
{org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Running
script executor task for script service_stats_306. [Sun Nov 25 12:27:00 PST
2012]
Hive history file=/tmp/kasun/hive_job_log_kasun_201211251227_2115407573.txt
FAILED: Error in metadata: MetaException(message:Unable to connect to the
server org.apache.hadoop.hive.cassandra.CassandraException: unable to
connect to server)
[2012-11-25 12:27:00,166] ERROR {org.apache.hadoop.hive.ql.exec.Task} -
FAILED: Error in metadata: MetaException(message:Unable to connect to the
server org.apache.hadoop.hive.cassandra.CassandraException: unable to
connect to server)
org.apache.hadoop.hive.ql.metadata.HiveException:
MetaException(message:Unable to connect to the server
org.apache.hadoop.hive.cassandra.CassandraException: unable to connect to
server)
at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:546)
at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3479)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:225)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:133)
at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1334)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1125)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:933)
at
org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:201)
at
org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187)
at
org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:325)
at
org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:225)
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:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: MetaException(message:Unable to connect to the server
org.apache.hadoop.hive.cassandra.CassandraException: unable to connect to
server)
at
org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:118)
at
org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:168)
at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:397)
at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540)
... 16 more
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
[2012-11-25 12:27:00,167] ERROR {org.apache.hadoop.hive.ql.Driver} -
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
[2012-11-25 12:27:00,169] 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.call(HiveExecutorServiceImpl.java:325)
at
org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:225)
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:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[2012-11-25 12:27:00,170] ERROR
{org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Error while
executing script : service_stats_306
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:110)
at
org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask.execute(HiveScriptExecutorTask.java:60)
at
org.wso2.carbon.ntask.core.impl.TaskQuartzJobAdapter.execute(TaskQuartzJobAdapter.java:56)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
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:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
--
*Kasun Gajasinghe*
Software Engineer;
Development Technologies Team, WSO2 Inc.; http://wso2.com ,
*email: **kasung AT spamfree wso2.com** cell: **+94 (77) 678-0813*
*linked-in: *http://lk.linkedin.com/in/gajasinghe*
*
*blog: **http://blog.kasunbg.org* <http://blog.kasunbg.org>*
twitter: **http://twitter.com/kasunbg* <http://twitter.com/kasunbg>*
*
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
