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

Cast to timestamps on Druid time column leads to an exception

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

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

      Description

      The following query fail due to a formatting issue.

      SELECT CAST(`ssb_druid_100`.`__time` AS TIMESTAMP) AS `x_time`,
      . . . . . . . . . . . . . . . .>   SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok`
      . . . . . . . . . . . . . . . .> FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100`
      . . . . . . . . . . . . . . . .> GROUP BY CAST(`ssb_druid_100`.`__time` AS TIMESTAMP);
      

      Exception

       
      Error: java.io.IOException: java.lang.NumberFormatException: For input string: "1991-12-31 19:00:00" (state=,code=0)
      

      Jesus Camacho Rodriguez maybe this is fixed by your upcoming patches.

        Attachments

        1. HIVE-19675.patch
          9 kB
          Slim Bouguerra
        2. HIVE-19675.5.patch
          38 kB
          Slim Bouguerra
        3. HIVE-19675.4.patch
          10 kB
          Ashutosh Chauhan
        4. HIVE-19675.3.patch
          10 kB
          Ashutosh Chauhan
        5. HIVE-19675.2.patch
          9 kB
          Slim Bouguerra

        Issue Links

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              bslim Slim Bouguerra Assign to me
              Reporter:
              bslim Slim Bouguerra

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment