[TAJO-1765] INT8 value cannot be casted to NUMERIC

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.11.0
• Component/s: Benchmark
• Labels: sql
• Assignee: Unassigned
• Reporter: Dongkyu Hwangbo
• Created: 16/Aug/15 05:43
• Updated: 16/Aug/15 05:43

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