iotdb icon indicating copy to clipboard operation
iotdb copied to clipboard

当时序不存在的时候能否直接返回空

Open Haze-Lan opened this issue 3 years ago • 3 comments

IoTDB> select variable,number,save,value from root.product.1_data.57 where time >=1664146800000 and time <=1664153923031 and variable in ( 'Location') order by time asc Msg: 411: Error occurred in query process: Unknown time series root.product.1_data.57.variable in where clause

因为设备未报数据过来所以 表内是没有数据的,如果要过滤某个值就会报错,这里能不能处理成跟time一样 没有值就返回为空

Haze-Lan avatar Sep 26 '22 09:09 Haze-Lan

@JackieTien97

HTHou avatar Sep 26 '22 10:09 HTHou

Hi, this is your first issue in IoTDB project. Thanks for your report. Welcome to join the community!

github-actions[bot] avatar Sep 26 '22 14:09 github-actions[bot]

IMO, it is different between "no data" and "no schema".. Users may need to do some other action when they meet the latter case.

jixuan1989 avatar Oct 01 '22 03:10 jixuan1989

Thanks for reporting, we will optimize this https://issues.apache.org/jira/browse/IOTDB-4576

qiaojialin avatar Oct 06 '22 08:10 qiaojialin

Has implemented in this PR.

Wei-hao-Li avatar Nov 09 '22 09:11 Wei-hao-Li