Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-19796

Push Down TRUNC Fn to Druid Storage Handler

    XMLWordPrintableJSON

    Details

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

      Description

      Push down Queries with TRUNC date function such as

      SELECT SUM((`ssb_druid_100`.`discounted_price` * `ssb_druid_100`.`net_revenue`)) AS `sum_calculation_4998925219892510720_ok`,
        CAST(TRUNC(CAST(`ssb_druid_100`.`__time` AS TIMESTAMP),'MM') AS DATE) AS `tmn___time_ok`
      FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100`
      GROUP BY CAST(TRUNC(CAST(`ssb_druid_100`.`__time` AS TIMESTAMP),'MM') AS DATE)
      

        Attachments

        1. HIVE-19796.patch
          51 kB
          Slim Bouguerra

          Activity

            People

            • Assignee:
              bslim Slim Bouguerra
              Reporter:
              bslim Slim Bouguerra
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: