drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4918) Adding 2 dates results in AssertionError: Multiple functions with best cost found
Date Mon, 03 Oct 2016 09:30:20 GMT

    [ https://issues.apache.org/jira/browse/DRILL-4918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15541977#comment-15541977
] 

Khurram Faraaz commented on DRILL-4918:
---------------------------------------

Postgres returns an error

{nodormat}
postgres=# select current_date + current_date from (values(1)) as foo;
ERROR:  operator does not exist: date + date
LINE 1: select current_date + current_date from (values(1)) as foo;
{noformat}

Drill returns an assertion with a not so easy to understand error message, on Drill 1.9.0
{noformat}
0: jdbc:drill:schema=dfs.tmp> select current_date + current_date from (values(1)) as foo;
Error: SYSTEM ERROR: AssertionError: Internal error: Conversion to relational algebra failed
to preserve datatypes:
validated type:
RecordType(TIMESTAMP(0) NOT NULL EXPR$0) NOT NULL
converted type:
RecordType(DATE NOT NULL EXPR$0) NOT NULL
rel:
LogicalProject(EXPR$0=[DATETIME_PLUS(CURRENT_DATE, CURRENT_DATE)])
  LogicalValues(tuples=[[{ 1 }]])



[Error Id: 8cbbf21b-2c97-4332-b26e-d92648efa688 on centos-01.qa.lab:31010] (state=,code=0)
{noformat}

> Adding 2 dates results in AssertionError: Multiple functions with best cost found
> ---------------------------------------------------------------------------------
>
>                 Key: DRILL-4918
>                 URL: https://issues.apache.org/jira/browse/DRILL-4918
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Data Types, Functions - Drill
>            Reporter: Rahul Challapalli
>         Attachments: error.log
>
>
> git.commit.id.abbrev=2295715
> The below query fails
> {code}
> select l_commitdate+l_receiptdate from cp.`tpch/lineitem.parquet`;
> Error: SYSTEM ERROR: AssertionError: Multiple functions with best cost found
> Fragment 0:0
> [Error Id: 983983bd-73e3-45c8-a377-e7022a5899c7 on qa-node182.qa.lab:31010] (state=,code=0)
> {code}
> The more likely scenario is that this operation is not supported. Atleast we should throw
a proper error message. I attached the error from the logs



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message