Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1182

Decimal has an issue when used in case statement where the else expression contains a literal

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: Execution - Data Types
    • Labels:
      None

      Description

      git.commit.id.abbrev=e5c2da0

      The below query fails with an Assertion Error:

      select
      case
      when l_linestatus = 'Success' then l_extendedprice
      else 0
      end
      from lineitem;

      The source 'lineitem' is a view on top of a txt file. While creating the view when we change the type of l_extendedprice from decimal to double, this issue goes away. Below is the original view definition:

      create view lineitem as select cast(columns[0] as int) l_orderkey, cast(columns[1] as int) l_partkey, cast(columns[2] as int) l_suppkey, cast(columns[3] as int) l_linenumber, cast(columns[4] as decimal) l_quantity, cast(columns[5] as decimal) l_extendedprice, cast(columns[6] as decimal) l_discount, cast(columns[7] as decimal) l_tax, columns[8] l_returnflag, columns[9] l_linestatus, cast(columns[10] as date) l_shipdate, cast(columns[11] as date) l_commitdate, cast(columns[12] as date) l_receiptdate, columns[13] l_shipinstruct, columns[14] l_shipmode, columns[15] l_comment from `lineitem.tbl`;

      I also attached the log file along with the source data. Let me know if you have any questions

        Attachments

        1. error.log
          3 kB
          Rahul Kumar Challapalli
        2. lineitem.tbl
          3 kB
          Rahul Kumar Challapalli

          Activity

            People

            • Assignee:
              mehant Mehant Baid
              Reporter:
              rkins Rahul Kumar Challapalli
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: