Minor Description
when i enter below query, (in TPC-DS q75)
SELECT [...] FROM [...] WHERE [...] AND CAST(curr_yr.sales_cnt AS DECIMAL(17,2))/CAST(prev_yr.sales_cnt AS DECIMAL(17,2))<0.9 [...] ORDER BY [...];
tsql gives me this error message
ERROR: No error message
in worker-log, error log is written
2015-08-16 14:27:15,087 ERROR org.apache.tajo.worker.TaskImpl: INT8 value cannot be casted to NUMERIC org.apache.tajo.exception.InvalidCastException: INT8 value cannot be casted to NUMERIC at org.apache.tajo.datum.DatumFactory.cast(DatumFactory.java:465) at org.apache.tajo.plan.expr.CastEval.eval(CastEval.java:79) at org.apache.tajo.plan.expr.BinaryEval.eval(BinaryEval.java:123) at org.apache.tajo.plan.expr.BinaryEval.eval(BinaryEval.java:123) at org.apache.tajo.engine.planner.physical.SelectionExec.next(SelectionExec.java:54) at org.apache.tajo.engine.planner.physical.ExternalSortExec.sortAndStoreAllChunks(ExternalSortExec.java:204) at org.apache.tajo.engine.planner.physical.ExternalSortExec.next(ExternalSortExec.java:275) at org.apache.tajo.engine.planner.physical.LimitExec.next(LimitExec.java:41) at org.apache.tajo.engine.planner.physical.RangeShuffleFileWriteExec.next(RangeShuffleFileWriteExec.java:103) at org.apache.tajo.worker.TaskImpl.run(TaskImpl.java:403) at org.apache.tajo.worker.TaskContainer.run(TaskContainer.java:65) 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) 2015-08-16 14:27:15,089 INFO org.apache.tajo.worker.TaskAttemptContext: Query status of ta_1439697678280_0005_000003_000000_00 is changed to TA_FAILED 2015-08-16 14:27:15,112 INFO org.apache.tajo.worker.TaskImpl: ta_1439697678280_0005_000003_000000_00 completed. Worker's task counter - total:1, succeeded: 0, killed: 0, failed: 1 2015-08-16 14:27:15,112 ERROR org.apache.tajo.querymaster.TaskAttempt: ta_1439697678280_0005_000003_000000_00 FROM dkhwangbo >> INT8 value cannot be casted to NUMERIC