Uploaded image for project: 'Apache IoTDB'
  1. Apache IoTDB
  2. IOTDB-6224

Fix group by month in non-ms precision and mixed unit

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • None
    • Core/Query

    Description

      bug1: group by month are not correct in non-ms time precision;

      repeat steps:

      • config time_precision as `ns` 
      • insert into root.test(time,s1) values (1,1)
      • select count(s1) from root.test group by ([2023-01-01, 2027-01-01), 1mo)

      analytic & design doc: https://apache-iotdb.feishu.cn/docx/TNBPd8nZUoDsJMxjdOncOUkcnVA#Q8MhdMrGmolJsCxLCljcuPtznRh

       

      bug2: group by month are not correct when use mixed unit time duration.

      repeat steps:

      • insert into root.test(time,s1) values (1,1)
      • select count(s1) from root.test group by ([2023-01-01, 2027-01-01), 1mo1d1s)

      Attachments

        Issue Links

          Activity

            People

              Weihao Li 李伟豪
              Weihao Li 李伟豪
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: