Dongkyu Hwangbo created TAJO-1765:
-------------------------------------
Summary: INT8 value cannot be casted to NUMERIC
Key: TAJO-1765
URL: https://issues.apache.org/jira/browse/TAJO-1765
Project: Tajo
Issue Type: Bug
Components: Benchmark
Affects Versions: 0.11.0
Reporter: Dongkyu Hwangbo
Priority: Minor
when i enter below query, (in TPC-DS q75)
{code:SQL}
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 [...];
{code}
tsql gives me this error message
{noformat}
ERROR: No error message
{noformat}
in worker-log, error log is written
{noformat}
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
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
