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

Cast to timestamps on Druid time column leads to an exception

    XMLWordPrintableJSON

Details

    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)
      

      jcamachorodriguez maybe this is fixed by your upcoming patches.

      Attachments

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

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: