Hi, Thanks, will have a look.
On Tue, Jan 6, 2015 at 3:55 PM, Sinthuja Ragendran <[email protected]> wrote: > > > On Tue, Jan 6, 2015 at 3:50 PM, Chamin Nalinda <[email protected]> wrote: > >> Hi, >> >> here's the exception trace logged in console. >> >> >> =================================================================== >> >> Hive history >> file=/home/coolck/BAM/wso2bam-2.4.1/tmp/hive/wso2-querylogs/hive_job_log_coolck_201501061533_1882921802.txt >> [2015-01-06 15:50:08,852] ERROR {hive.ql.metadata.Hive} - >> NoSuchObjectException(message:default.AuditBase table not found) >> at >> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$17.run(HiveMetaStore.java:1227) >> at >> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$17.run(HiveMetaStore.java:1222) >> at >> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.executeWithRetry(HiveMetaStore.java:360) >> at >> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:1222) >> at >> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:734) >> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:901) >> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:843) >> at org.apache.hadoop.hive.ql.exec.DDLTask.dropTable(DDLTask.java:3127) >> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:250) >> 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:577) >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:287) >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:190) >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) >> at java.util.concurrent.FutureTask.run(FutureTask.java:166) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:701) >> >> OK >> [2015-01-06 15:50:08,861] ERROR {hive.ql.metadata.Hive} - >> NoSuchObjectException(message:default.AuthAdminLogs table not found) >> at >> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$17.run(HiveMetaStore.java:1227) >> at >> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$17.run(HiveMetaStore.java:1222) >> at >> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.executeWithRetry(HiveMetaStore.java:360) >> at >> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:1222) >> at >> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:734) >> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:901) >> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:843) >> at org.apache.hadoop.hive.ql.exec.DDLTask.dropTable(DDLTask.java:3127) >> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:250) >> 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:577) >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:287) >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:190) >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) >> at java.util.concurrent.FutureTask.run(FutureTask.java:166) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:701) >> >> OK >> [2015-01-06 15:50:08,913] 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:57) >> at >> org.apache.hadoop.hive.cassandra.CassandraClientHolder.<init>(CassandraClientHolder.java:37) >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.createConnection(CassandraProxyClient.java:181) >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:207) >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:144) >> at >> org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:198) >> at >> org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:262) >> 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:577) >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:287) >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:190) >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) >> at java.util.concurrent.FutureTask.run(FutureTask.java:166) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:701) >> 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:54) >> ... 25 more >> Caused by: java.net.ConnectException: Connection refused >> at java.net.PlainSocketImpl.socketConnect(Native Method) >> at >> java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327) >> at >> java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193) >> at >> java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180) >> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:385) >> at java.net.Socket.connect(Socket.java:546) >> at org.apache.thrift.transport.TSocket.open(TSocket.java:178) >> ... 27 more >> > > The above shows that, BAM is unable to connect to cassandra node, please > check the connection details that you have provided in > WSO2BAM_CASSANDRA_DATASOURCE, and use the valid connection details. > > Thanks, > Sinthuja. > > FAILED: Error in metadata: java.lang.NullPointerException >> [2015-01-06 15:50:08,914] 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:577) >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:287) >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:190) >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) >> at java.util.concurrent.FutureTask.run(FutureTask.java:166) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:701) >> Caused by: java.lang.NullPointerException >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:223) >> at >> org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:144) >> at >> org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:198) >> at >> org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:262) >> 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 >> [2015-01-06 15:50:08,915] ERROR {org.apache.hadoop.hive.ql.Driver} - >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.DDLTask >> [2015-01-06 15:50:08,915] 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:577) >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:287) >> at >> org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl$ScriptCallable.call(HiveExecutorServiceImpl.java:190) >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) >> at java.util.concurrent.FutureTask.run(FutureTask.java:166) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:701) >> [2015-01-06 15:50:08,924] 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 1 from org.apache.hadoop.hive.ql.exec.DDLTask >> org.wso2.carbon.analytics.hive.stub.HiveExecutionServiceHiveExecutionException: >> HiveExecutionServiceHiveExecutionException >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >> at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >> at java.lang.reflect.Constructor.newInstance(Constructor.java:534) >> at java.lang.Class.newInstance(Class.java:374) >> at >> org.wso2.carbon.analytics.hive.stub.HiveExecutionServiceStub.executeHiveScript(HiveExecutionServiceStub.java:216) >> at >> org.wso2.carbon.analytics.hive.ui.client.HiveExecutionClient.executeScript(HiveExecutionClient.java:66) >> at >> org.apache.jsp.hive_002dexplorer.queryresults_jsp._jspService(org.apache.jsp.hive_002dexplorer.queryresults_jsp:92) >> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:403) >> at >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:492) >> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:378) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at org.wso2.carbon.ui.JspServlet.service(JspServlet.java:155) >> at org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:80) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPathServletAdaptor.java:37) >> at >> org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749) >> at >> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605) >> at >> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544) >> at >> org.eclipse.equinox.http.servlet.internal.RequestDispatcherAdaptor.include(RequestDispatcherAdaptor.java:37) >> at >> org.eclipse.equinox.http.helper.ContextPathServletAdaptor$RequestDispatcherAdaptor.include(ContextPathServletAdaptor.java:369) >> at >> org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:1015) >> at >> org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:700) >> at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:622) >> at org.apache.tiles.jsp.context.JspUtil.doInclude(JspUtil.java:87) >> at >> org.apache.tiles.jsp.context.JspTilesRequestContext.include(JspTilesRequestContext.java:88) >> at >> org.apache.tiles.jsp.context.JspTilesRequestContext.dispatch(JspTilesRequestContext.java:82) >> at >> org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:465) >> at >> org.apache.tiles.jsp.taglib.InsertAttributeTag.render(InsertAttributeTag.java:140) >> at >> org.apache.tiles.jsp.taglib.InsertAttributeTag.render(InsertAttributeTag.java:117) >> at >> org.apache.tiles.jsp.taglib.RenderTagSupport.execute(RenderTagSupport.java:171) >> at >> org.apache.tiles.jsp.taglib.RoleSecurityTagSupport.doEndTag(RoleSecurityTagSupport.java:75) >> at >> org.apache.tiles.jsp.taglib.ContainerTagSupport.doEndTag(ContainerTagSupport.java:80) >> at >> org.apache.jsp.admin.layout.template_jsp._jspx_meth_tiles_insertAttribute_7(org.apache.jsp.admin.layout.template_jsp:603) >> at >> org.apache.jsp.admin.layout.template_jsp._jspService(org.apache.jsp.admin.layout.template_jsp:335) >> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:403) >> at >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:492) >> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:378) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at org.wso2.carbon.ui.JspServlet.service(JspServlet.java:155) >> at org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:80) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPathServletAdaptor.java:37) >> at >> org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749) >> at >> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487) >> at >> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412) >> at >> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339) >> at >> org.eclipse.equinox.http.servlet.internal.RequestDispatcherAdaptor.forward(RequestDispatcherAdaptor.java:30) >> at >> org.eclipse.equinox.http.helper.ContextPathServletAdaptor$RequestDispatcherAdaptor.forward(ContextPathServletAdaptor.java:362) >> at >> org.apache.tiles.servlet.context.ServletTilesRequestContext.forward(ServletTilesRequestContext.java:198) >> at >> org.apache.tiles.servlet.context.ServletTilesRequestContext.dispatch(ServletTilesRequestContext.java:185) >> at >> org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:419) >> at >> org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:370) >> at org.wso2.carbon.ui.action.ActionHelper.render(ActionHelper.java:52) >> at org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:101) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPathServletAdaptor.java:37) >> at >> org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.wso2.carbon.tomcat.ext.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:61) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:178) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonTomcatValve$1.invoke(CarbonTomcatValve.java:47) >> at >> org.wso2.carbon.webapp.mgt.TenantLazyLoaderValve.invoke(TenantLazyLoaderValve.java:56) >> at >> org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:141) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:156) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:52) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) >> at >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:701) >> >> >> On Tue, Jan 6, 2015 at 3:45 PM, Sinthuja Ragendran <[email protected]> >> wrote: >> >>> Please send the full exception trace logged in the console. >>> >>> Thanks, >>> Sinthuja. >>> >>> On Tue, Jan 6, 2015 at 3:42 PM, Chamin Nalinda <[email protected]> wrote: >>> >>>> Hi all, >>>> >>>> I get following error while trying to execute hive query below. >>>> >>>> error >>>> >>>> *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 >>>> >>>> >>>> ======================= >>>> >>>> Hive query >>>> >>>> DROP TABLE AuditBase; >>>> DROP TABLE AuthAdminLogs; >>>> >>>> CREATE EXTERNAL TABLE IF NOT EXISTS AuditBase >>>> (mesid STRING, timestampstr BIGINT, payload_message STRING, >>>> payload_priority STRING) >>>> STORED BY 'org.apache.hadoop.hive.cassandra.CassandraStorageHandler' >>>> WITH SERDEPROPERTIES ("wso2.carbon.datasource.name" = >>>> "WSO2BAM_CASSANDRA_DATASOURCE", >>>> "cassandra.cf.name" = "log_0_IS_2014_10_30", >>>> "cassandra.columns.mapping" = ":key, Timestamp, >>>> payload_message,payload_priority"); >>>> >>>> CREATE EXTERNAL TABLE IF NOT EXISTS AuthAdminLogs(messageid STRING, >>>> timestampstr STRING, username STRING, remotehost STRING, response STRING) >>>> STORED BY >>>> 'org.wso2.carbon.hadoop.hive.jdbc.storage.JDBCStorageHandler' >>>> TBLPROPERTIES ( >>>> 'wso2.carbon.datasource.name'='WSO2BAM_MYSQL_DATASOURCE', >>>> 'hive.jdbc.update.on.duplicate' = 'true' , >>>> 'hive.jdbc.primary.key.fields' = 'messageid' , >>>> 'hive.jdbc.table.create.query' = >>>> 'CREATE TABLE AuthAdminLoginDetails (messageid VARCHAR(100) NOT NULL >>>> PRIMARY KEY, Timestampstr VARCHAR(100), UserName VARCHAR(100) >>>> , RemoteHost VARCHAR(20), Response VARCHAR(20))'); >>>> >>>> insert overwrite table AuthAdminLogs >>>> select mesid, from_unixtime(cast(timestampstr/1000 as BIGINT), >>>> 'yyyy-MM-dd HH:mm:ss'), >>>> split(payload_message,"#")[1],split(payload_message,"#")[2],split(payload_message,"#")[4] >>>> from AuditBase where split(payload_message,"#")[0]="AuthenticationAdmin"; >>>> >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> *Chamin Nalinda* >>>> >>>> Intern - Engineering >>>> WSO2 Inc. http://www.wso2.com >>>> lean.enterprise.middleware >>>> >>>> Mobile: (+94) 77 241 66 04 >>>> Linkedin: https://www.linkedin.com/in/chaminnalinda >>>> Web: http://www.ckreativity.com >>>> Blog: http://techspiro.blogspot.com/ >>>> >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> [email protected] >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> *Sinthuja Rajendran* >>> Senior Software Engineer <http://wso2.com/> >>> WSO2, Inc.:http://wso2.com >>> >>> Blog: http://sinthu-rajan.blogspot.com/ >>> Mobile: +94774273955 >>> >>> >>> >> >> >> -- >> *Chamin Nalinda* >> >> Intern - Engineering >> WSO2 Inc. http://www.wso2.com >> lean.enterprise.middleware >> >> Mobile: (+94) 77 241 66 04 >> Linkedin: https://www.linkedin.com/in/chaminnalinda >> Web: http://www.ckreativity.com >> Blog: http://techspiro.blogspot.com/ >> >> > > > -- > *Sinthuja Rajendran* > Senior Software Engineer <http://wso2.com/> > WSO2, Inc.:http://wso2.com > > Blog: http://sinthu-rajan.blogspot.com/ > Mobile: +94774273955 > > > -- *Chamin Nalinda* Intern - Engineering WSO2 Inc. http://www.wso2.com lean.enterprise.middleware Mobile: (+94) 77 241 66 04 Linkedin: https://www.linkedin.com/in/chaminnalinda Web: http://www.ckreativity.com Blog: http://techspiro.blogspot.com/
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
