Hi Hasanthi, I changed the offset as the first step. But let me try with that.
What is the location of the script i should edit? Thanks. On Fri, Feb 13, 2015 at 11:25 AM, Hasanthi Purnima Dissanayake < [email protected]> wrote: > 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 >> >> > -- 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
