Hi All, As per the offline discussion with Maninda, after changing the port offset to another value rather than zero, it shouldn't change the port for WSO2BAM_CASSANDRA_DATASOURCE in bam-datasource.xml in BAM 2.5.0. with that change setup is working properly
Thanks On Wed, Oct 22, 2014 at 1:55 PM, Lakshman Udayakantha <[email protected]> wrote: > Hi All, > > I am trying to integrate BAM 2.5.0 with APIM 1.8.0. I followed > https://docs.wso2.com/display/AM170/Publishing+API+Runtime+Statistics to > do this. After I configured BAM and started it, got the following exception > and can’t publish the data. anyone has any idea about this error? > > > [2014-10-22 13:42:00,008] INFO > {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Running > script executor task for script am_stats_analyzer. [Wed Oct 22 13:42:00 > GMT+05:30 2014] > > Hive history > file=/Users/lakshman/Documents/wso2_products/BAM/wso2bam-2.5.0/tmp/hive/root-querylogs/hive_job_log_lakshman_201410221342_1864185710.txt > > 2014-10-22 13:42:00.943 java[15403:9407] Unable to load realm info from > SCDynamicStore > > [2014-10-22 13:42:01,367] ERROR > {org.apache.hadoop.hive.cassandra.CassandraProxyClient} - Error while > trying to connect to cassandra host:localhost > > org.apache.hadoop.hive.cassandra.CassandraException: unable to connect to > server > > at > org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:65) > > at > org.apache.hadoop.hive.cassandra.CassandraClientHolder.<init>(CassandraClientHolder.java:40) > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.createConnection(CassandraProxyClient.java:200) > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:226) > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:142) > > at > org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:219) > > at > org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:284) > > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396) > > at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) > > 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:129) > > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:62) > > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) > > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) > > 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.executeHiveQuery(HiveExecutorServiceImpl.java:578) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) > > 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:695) > > Caused by: org.apache.thrift.transport.TTransportException: > java.net.ConnectException: Connection refused > > at org.apache.thrift.transport.TSocket.open(TSocket.java:183) > > at > org.apache.thrift.transport.TFramedTransport.open(TFramedTransport.java:81) > > at > org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:63) > > ... 25 more > > Caused by: java.net.ConnectException: Connection refused > > at java.net.PlainSocketImpl.socketConnect(Native Method) > > at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:382) > > at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:241) > > at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:228) > > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:431) > > at java.net.Socket.connect(Socket.java:527) > > at org.apache.thrift.transport.TSocket.open(TSocket.java:178) > > ... 27 more > > FAILED: Error in metadata: java.lang.NullPointerException > > [2014-10-22 13:42:01,370] ERROR {org.apache.hadoop.hive.ql.exec.Task} - > FAILED: Error in metadata: java.lang.NullPointerException > > org.apache.hadoop.hive.ql.metadata.HiveException: > java.lang.NullPointerException > > 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:129) > > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:62) > > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) > > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) > > 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.executeHiveQuery(HiveExecutorServiceImpl.java:578) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) > > 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:695) > > Caused by: java.lang.NullPointerException > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:242) > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:142) > > at > org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:219) > > at > org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:284) > > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396) > > at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) > > ... 17 more > > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > [2014-10-22 13:42:01,371] ERROR {org.apache.hadoop.hive.ql.Driver} - > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > [2014-10-22 13:42:01,381] 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:578) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) > > 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:695) > > [2014-10-22 13:42:01,382] ERROR > {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Error while > executing script : am_stats_analyzer > > 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:115) > > 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:695) > > [2014-10-22 13:44:00,003] INFO > {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Running > script executor task for script am_stats_analyzer. [Wed Oct 22 13:44:00 > GMT+05:30 2014] > > Hive history > file=/Users/lakshman/Documents/wso2_products/BAM/wso2bam-2.5.0/tmp/hive/root-querylogs/hive_job_log_lakshman_201410221342_967516897.txt > > [2014-10-22 13:44:00,054] ERROR > {org.apache.hadoop.hive.cassandra.CassandraProxyClient} - Error while > trying to connect to cassandra host:localhost > > org.apache.hadoop.hive.cassandra.CassandraException: unable to connect to > server > > at > org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:65) > > at > org.apache.hadoop.hive.cassandra.CassandraClientHolder.<init>(CassandraClientHolder.java:40) > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.createConnection(CassandraProxyClient.java:200) > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:226) > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:142) > > at > org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:219) > > at > org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:284) > > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396) > > at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) > > 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:129) > > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:62) > > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) > > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) > > 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.executeHiveQuery(HiveExecutorServiceImpl.java:578) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) > > 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:695) > > Caused by: org.apache.thrift.transport.TTransportException: > java.net.ConnectException: Connection refused > > at org.apache.thrift.transport.TSocket.open(TSocket.java:183) > > at > org.apache.thrift.transport.TFramedTransport.open(TFramedTransport.java:81) > > at > org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:63) > > ... 25 more > > Caused by: java.net.ConnectException: Connection refused > > at java.net.PlainSocketImpl.socketConnect(Native Method) > > at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:382) > > at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:241) > > at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:228) > > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:431) > > at java.net.Socket.connect(Socket.java:527) > > at org.apache.thrift.transport.TSocket.open(TSocket.java:178) > > ... 27 more > > FAILED: Error in metadata: java.lang.NullPointerException > > [2014-10-22 13:44:00,056] ERROR {org.apache.hadoop.hive.ql.exec.Task} - > FAILED: Error in metadata: java.lang.NullPointerException > > org.apache.hadoop.hive.ql.metadata.HiveException: > java.lang.NullPointerException > > 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:129) > > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:62) > > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) > > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) > > 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.executeHiveQuery(HiveExecutorServiceImpl.java:578) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) > > 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:695) > > Caused by: java.lang.NullPointerException > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:242) > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:142) > > at > org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:219) > > at > org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:284) > > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396) > > at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) > > ... 17 more > > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > [2014-10-22 13:44:00,056] ERROR {org.apache.hadoop.hive.ql.Driver} - > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > [2014-10-22 13:44:00,057] 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:578) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) > > 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:695) > > [2014-10-22 13:44:00,058] ERROR > {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Error while > executing script : am_stats_analyzer > > 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:115) > > 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:695) > > [2014-10-22 13:46:00,001] INFO > {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Running > script executor task for script am_stats_analyzer. [Wed Oct 22 13:46:00 > GMT+05:30 2014] > > Hive history > file=/Users/lakshman/Documents/wso2_products/BAM/wso2bam-2.5.0/tmp/hive/root-querylogs/hive_job_log_lakshman_201410221342_776696658.txt > > [2014-10-22 13:46:00,041] ERROR > {org.apache.hadoop.hive.cassandra.CassandraProxyClient} - Error while > trying to connect to cassandra host:localhost > > org.apache.hadoop.hive.cassandra.CassandraException: unable to connect to > server > > at > org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:65) > > at > org.apache.hadoop.hive.cassandra.CassandraClientHolder.<init>(CassandraClientHolder.java:40) > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.createConnection(CassandraProxyClient.java:200) > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:226) > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:142) > > at > org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:219) > > at > org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:284) > > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396) > > at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) > > 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:129) > > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:62) > > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) > > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) > > 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.executeHiveQuery(HiveExecutorServiceImpl.java:578) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) > > 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:695) > > Caused by: org.apache.thrift.transport.TTransportException: > java.net.ConnectException: Connection refused > > at org.apache.thrift.transport.TSocket.open(TSocket.java:183) > > at > org.apache.thrift.transport.TFramedTransport.open(TFramedTransport.java:81) > > at > org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:63) > > ... 25 more > > Caused by: java.net.ConnectException: Connection refused > > at java.net.PlainSocketImpl.socketConnect(Native Method) > > at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:382) > > at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:241) > > at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:228) > > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:431) > > at java.net.Socket.connect(Socket.java:527) > > at org.apache.thrift.transport.TSocket.open(TSocket.java:178) > > ... 27 more > > FAILED: Error in metadata: java.lang.NullPointerException > > [2014-10-22 13:46:00,042] ERROR {org.apache.hadoop.hive.ql.exec.Task} - > FAILED: Error in metadata: java.lang.NullPointerException > > org.apache.hadoop.hive.ql.metadata.HiveException: > java.lang.NullPointerException > > 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:129) > > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:62) > > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1351) > > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1126) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:934) > > 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.executeHiveQuery(HiveExecutorServiceImpl.java:578) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) > > 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:695) > > Caused by: java.lang.NullPointerException > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:242) > > at > org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:142) > > at > org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:219) > > at > org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:284) > > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396) > > at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540) > > ... 17 more > > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > [2014-10-22 13:46:00,042] ERROR {org.apache.hadoop.hive.ql.Driver} - > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > [2014-10-22 13:46:00,042] 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:578) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:286) > > at > org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:189) > > 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:695) > > [2014-10-22 13:46:00,043] ERROR > {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Error while > executing script : am_stats_analyzer > > 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:115) > > 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:695) > > Thanks > -- > Lakshman Udayakantha > WSO2 Inc. www.wso2.com > lean.enterprise.middleware > Mobile: *0711241005* > > -- Lakshman Udayakantha WSO2 Inc. www.wso2.com lean.enterprise.middleware Mobile: *0711241005*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
