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

Drill allows to use decimal zero precision in CAST function for CTAS

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.14.0
    • Fix Version/s: 1.14.0
    • Component/s: None
    • Labels:

      Description

      I can run query with casting data for decimal with zero precision in SELECT statement

      select cast(1111.05 as decimal(0,5));
      
      +-------------+
      | EXPR$0      |
      +-------------+
      | 1111.05000  |
      +-------------+
      

      Also I can use this query for CTAS

      create table dfs.tmp.`zero_pr` as select cast(1111.05 as decimal(0,5));
      
      +----------+---------------------------+
      | Fragment | Number of records written |
      +----------+---------------------------+
      | 0_0      | 1                         |
      +----------+---------------------------+
      

      But when I try to select data from this table, I get an error:

      create table dfs.tmp.`zero_pr` as select cast(1111.05 as decimal(0,5));
      
      Error: SYSTEM ERROR: IllegalArgumentException: Invalid DECIMAL precision: 0 [Error Id: 2e320f55-aa65-4127-82be-6256e0744bdc on maprhost:31010] (state=,code=0)

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              volodymyr Vova Vysotskyi
              Reporter:
              denysord88 Denys Ordynskiy
              Reviewer:
              Arina Ielchiieva

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment