Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-11049

Order by clause contains cast expr execute failed after 'SimplifyCastExprRule' rewrite

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 4.1.0
    • Impala 4.1.0
    • Frontend
    • None
    • ghx-label-12

    Description

      When add new rewrite rule 'SimplifyCastExprRule' in IMPALA-10836, this query will execute failed:

      explain
      SELECT month(to_timestamp(cast(d_date_sk AS string),'yyyy-MM-dd')) aa
      FROM date_dim
      GROUP BY month(to_timestamp(cast(d_date_sk AS string),'yyyy-MM-dd'))
      ORDER BY month(to_timestamp(cast(d_date_sk AS string),'yyyy-MM-dd')) LIMIT 10;
      

      The exception is:

      ERROR: AnalysisException: No matching function with signature: to_timestamp(INT, STRING).
      

      Attachments

        Issue Links

          Activity

            People

              skyyws Sheng Wang
              skyyws Sheng Wang
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: