machbase-neo
Tutorials
HTTP
Create and drop table

Create and drop table

Reference

Please refer to the reference doc for understanding what is the Tag Tables

Create tag table without statistics

REQUEST 

curl -o - http://127.0.0.1:5654/db/query \
    --data-urlencode \
    "q=create tag table if not exists EXAMPLE (name varchar(40) primary key, time datetime basetime, value double)"

RESPONSE 

{"success":true,"reason":"success","elapse":"92.489922ms"}

Create tag table with tag statistics

REQUEST 

curl -o - http://127.0.0.1:5654/db/query \
    --data-urlencode \
    "q=create tag table if not exists EXAMPLE (name varchar(40) primary key, time datetime basetime, value double summarized)"

RESPONSE 

{"success":true,"reason":"success","elapse":"92.489922ms"}
📢

Note The keyword “summarized” refers to the automatic generation of statistics on the internal tag data structure when data is entered into the corresponding tag table. For more detailed information, please refer to the link below. Tag Statistics

Drop table 

curl -o - http://127.0.0.1:5654/db/query \
    --data-urlencode "q=drop table EXAMPLE"
Last updated on
Insert table