Hi Jagath, Did you follow the below step? "If you run the Hive scripts before changing the default Cassandra port according to the BAM port offset, you keep getting an exception. To overcome this, add the following line at the beginning of the Hive script and rerun. drop table <hive_cassandra_table_name>"
Thanks and Regards, Hasanthi Dissanayake Software Engineer | WSO2 E: [email protected] <[email protected]> M :0718407133| http://wso2.com <http://wso2.com/> On Fri, Feb 13, 2015 at 10:59 AM, Jagath Sisirakumara Ariyarathne < [email protected]> wrote: > Hi, > > BAM console gives below error when I started BAM for the sample [1]. > > FAILED: Execution Error, return code 2 from > org.apache.hadoop.hive.ql.exec.MapRedTask > [2015-02-13 10:35:03,733] ERROR {org.apache.hadoop.hive.ql.Driver} - > FAILED: Execution Error, return code 2 from > org.apache.hadoop.hive.ql.exec.MapRedTask > [2015-02-13 10:35:03,734] ERROR > {org.wso2.carbon.analytics.hive.impl.HiveExecutorServiceImpl} - Error > executing query: Query returned non-zero code: 9, cause: FAILED: Execution > Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask > java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: > Execution Error, return code 2 from > org.apache.hadoop.hive.ql.exec.MapRedTask > 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.run(FutureTask.java:262) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > [2015-02-13 10:35:03,735] 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 2 from org.apache.hadoop.hive.ql.exec.MapRedTask > java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: > Execution Error, return code 2 from > org.apache.hadoop.hive.ql.exec.MapRedTask > 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.run(FutureTask.java:262) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > [2015-02-13 10:35:03,735] ERROR > {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Error while > executing script : phone_retail_store_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 2 from > org.apache.hadoop.hive.ql.exec.MapRedTask > 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:471) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > > Is there any missing configuration or script which cause this error? > > [1] - https://docs.wso2.com/display/AM180/Generating+Billing+Data > > -- > Jagath Ariyarathne > Technical Lead > WSO2 Inc. http://wso2.com/ > Email: [email protected] > Mob : +94 77 386 7048 > > > _______________________________________________ > 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
