You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "yuqi (Jira)" <ji...@apache.org> on 2020/09/27 12:34:00 UTC
[jira] [Created] (IOTDB-920) Disable insert values thats only
contains time/timestamp column
yuqi created IOTDB-920:
--------------------------
Summary: Disable insert values thats only contains time/timestamp column
Key: IOTDB-920
URL: https://issues.apache.org/jira/browse/IOTDB-920
Project: Apache IoTDB
Issue Type: Improvement
Reporter: yuqi
Currently, It's OK to insert values as the following
{code:sql}
// Some comments here
INSERT INTO root.ln.wf01.wt01(timestamp,status) values(10000,true);
{code}
However, if we insert values only contains the time/timestamp columns, though there is no error information, however, we can never query it
{code:sql}
// Some comments here
INSERT INTO root.ln.wf01.wt01(timestamp,status) values(10000,true);
IoTDB> INSERT INTO root.ln.wf01.wt01(timestamp) values(20000);
Msg: The statement is executed successfully.
IoTDB> INSERT INTO root.ln.wf01.wt01(timestamp) values(30000);
Msg: The statement is executed successfully.
IoTDB> select * from root.ln.wf01.wt01;
+-----------------------------+------------------------+-----------------------------+
| Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature|
+-----------------------------+------------------------+-----------------------------+
|1970-01-01T08:00:00.100+08:00| true| null|
|1970-01-01T08:00:00.200+08:00| false| 20.71|
|1970-01-01T08:00:00.300+08:00| false| 0.0|
|1970-01-01T08:00:00.400+08:00| false| 0.0|
|1970-01-01T08:00:00.600+08:00| false| 0.07|
|1970-01-01T08:00:00.700+08:00| false| 0.0615|
|1970-01-01T08:00:00.800+08:00| false| 0.0611|
|1970-01-01T08:00:10.000+08:00| true| null|
+-----------------------------+------------------------+-----------------------------+
Total line number = 8
It costs 3.909s
{code}
So, I suggest we should explicitly prohibit inserting values that only contains time/timestamp values
--
This message was sent by Atlassian Jira
(v8.3.4#803005)