Are you running BAM with an offset? If so to connect to embedded Cassandra within the script you will need to change the default port specified in Hive CREATE TABLE for Cassandra column family in the Hive script.
Regards Buddhika On Mon, Nov 26, 2012 at 2:15 AM, Kasun Gajasinghe <[email protected]> wrote: > 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
