Hi Jagath, you have to drop the related table. Please refer to [1]. http://stackoverflow.com/questions/22968243/wso2-bam-documentation
Hasanthi Dissanayake Software Engineer | WSO2 E: [email protected] <[email protected]> M :0718407133| http://wso2.com <http://wso2.com/> On Fri, Feb 13, 2015 at 11:31 AM, Jagath Sisirakumara Ariyarathne < [email protected]> wrote: > 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
