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

Implicit casting not working with abs(...) function

    XMLWordPrintableJSON

Details

    Description

      git commit # : 9878170d082a58af08b0b7b75494a76546d73580

      The below queries succeed :

       select min(columns[0]) from dfs.`/drill/testdata/lineitem.tbl`;
      select abs(columns[0] + 1) from dfs.`/drill/testdata/lineitem.tbl`;
      

      However the below query fails

      select abs(columns[0]) from dfs.`/drill/testdata/lineitem.tbl`;
      Error: SYSTEM ERROR: SchemaChangeException: Failure while trying to materialize incoming schema.  Errors:
       
      Error in expression at index -1.  Error: Missing function implementation: [castTINYINT(VARCHAR-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--..
      
      Fragment 0:0
      
      [Error Id: 53714c5d-34e0-4518-bd14-b7774f60847e on qa-node190.qa.lab:31010] (state=,code=0)
      

      Any reason why implicit casting is not working in the above case? I attached the logs and the data file.

      Attachments

        1. error.log
          10 kB
          Rahul Kumar Challapalli
        2. lineitem.tbl
          104 kB
          Rahul Kumar Challapalli

        Activity

          People

            Unassigned Unassigned
            rkins Rahul Kumar Challapalli
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: