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

query problem for iotdb filter

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.9.0
    • None

    Description

      When querying a timeseries that does not exist, iotdb shows different behavior for SQL with or without filter.
      After starting a new iotdb instance, The following steps in iotdb-client below could reproduce the problem.
      Step 1: set storage group to root.demo
      Step 2: CREATE TIMESERIES root.demo.ZT31 WITH DATATYPE=INT64, ENCODING=RLE
      Step 3:insert into root.demo(timestamp,ZT31) values(1,1)
      when using sql:
      1.select ZT1 from root.demo
      iotdb-client responds with message "Msg: Execute statement error: do not select any existing series"
      2.select ZT1,ZT31 from root.demo
      iotdb-client responds with
      -----------------------------------------------+

      Time root.demo.ZT31

      -----------------------------------------------+

      1970-01-01T08:00:00.001+08:00 1

      -----------------------------------------------+
      3.select ZT1,ZT31 from root.demo where ZT1>0
      iotdb-client responds with message "Msg: Execute statement error: Index: 0, Size: 0"

      Timeseries ZT1 does not exist in condition 2 and condition 3. However, without using ZT1 as filter to query multiple sensors(at least one exists), iotdb could respond with datapoints. When using ZT1 as filter, the returned msg confused users.

      In my opinion, both condition 2 and 3 should respond with message "Msg: Execute statement error: do not select any existing series". Or condition 2 responds with datapoints, condition 3 responds with "Msg: Execute statement error: do not select any existing series".

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              gwmh18 EJTTianyu
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.5h
                  0.5h