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

Some Vectorized String CONCAT expressions result in runtime error Vectorization: Unsuported vector output type: StringGroup

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 0.14.1
    • 1.0.0
    • Vectorization
    • None

    Description

      SELECT CONCAT(CONCAT(CONCAT('Quarter ',CAST(CAST((MONTH(dt) - 1) / 3 + 1 AS INT) AS STRING)),'-'),CAST(YEAR(dt) AS STRING)) AS `field`
          FROM vectortab2korc 
          GROUP BY CONCAT(CONCAT(CONCAT('Quarter ',CAST(CAST((MONTH(dt) - 1) / 3 + 1 AS INT) AS STRING)),'-'),CAST(YEAR(dt) AS STRING))
          LIMIT 50;
      

      Attachments

        1. HIVE-8886.01.patch
          25 kB
          Matt McCline
        2. HIVE-8886.02.patch
          25 kB
          Matt McCline
        3. HIVE-8886.03.patch
          25 kB
          Matt McCline

        Issue Links

          Activity

            People

              mmccline Matt McCline
              mmccline Matt McCline
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: