Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-5039

View:Timestamp cannot query Data:Long in GMT+8 TimeZone Env

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.29.0, 1.30.0
    • None
    • core, jdbc-driver

    Description

      When I have a row like :

      ts:TimeStamp channel:String pv:Long
      1647187200000 ios 10

       

      while 1647187200000 is a timestamp in TimeZone of "GMT+8",the datetime is "2022-03-14 00:00:00"

      but you can not query the data using a sql like :

      ```sql

      select * from table where ts='2022-03-14 00:00:00';

      select * from table where ts<'2022-03-14 00:00:01' and  ts>'2022-03-13 23:59:59'  and channel='ios';

      ```

      it is like the jdbc-fether will filter the data when match the timestampString,while the timestamp String looks like '2022-03-13 16:00:00' or '2022-03-14 08:00:00'

       

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              itxiangkui itxiangkui
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: