| { |
| "paragraphs": [ |
| { |
| "title": "Set IoTDB Schema", |
| "text": "%iotdb\n\nSET STORAGE GROUP TO root.ln.wf01.wt01;\nCREATE TIMESERIES root.ln.wf01.wt01.status WITH DATATYPE=BOOLEAN, ENCODING=PLAIN;\nCREATE TIMESERIES root.ln.wf01.wt01.temperature WITH DATATYPE=FLOAT, ENCODING=PLAIN;\nCREATE TIMESERIES root.ln.wf01.wt01.hardware WITH DATATYPE=INT32, ENCODING=PLAIN;\n\n", |
| "user": "anonymous", |
| "dateUpdated": "2020-11-24T17:01:35+0800", |
| "config": { |
| "colWidth": 6, |
| "fontSize": 9, |
| "enabled": true, |
| "results": {}, |
| "editorSetting": { |
| "language": "sql", |
| "editOnDblClick": false, |
| "completionKey": "TAB" |
| }, |
| "title": true, |
| "lineNumbers": true, |
| "editorMode": "ace/mode/sql" |
| }, |
| "settings": { |
| "params": {}, |
| "forms": {} |
| }, |
| "results": { |
| "code": "SUCCESS", |
| "msg": [ |
| { |
| "type": "TEXT", |
| "data": "Sql executed." |
| } |
| ] |
| }, |
| "apps": [], |
| "runtimeInfos": {}, |
| "progressUpdateIntervalMs": 500, |
| "jobName": "paragraph_1606199112249_2061310279", |
| "id": "paragraph_1606199112249_2061310279", |
| "dateCreated": "2020-11-24T14:25:12+0800", |
| "dateStarted": "2020-11-24T17:01:35+0800", |
| "dateFinished": "2020-11-24T17:01:35+0800", |
| "status": "FINISHED", |
| "focus": true, |
| "$$hashKey": "object:407" |
| }, |
| { |
| "title": "Insert Time Series", |
| "text": "INSERT INTO root.ln.wf01.wt01 (timestamp, temperature, status, hardware)\nVALUES (1, 1.1, false, 4);\nINSERT INTO root.ln.wf01.wt01 (timestamp, temperature, status, hardware)\nVALUES (2, 3.2, true, 3);\nINSERT INTO root.ln.wf01.wt01 (timestamp, temperature, status, hardware)\nVALUES (3, 2.3, false, 2);\nINSERT INTO root.ln.wf01.wt01 (timestamp, temperature, status, hardware)\nVALUES (4, 4.4, false, 1);\nINSERT INTO root.ln.wf01.wt01 (timestamp, temperature, status, hardware)\nVALUES (5, 3.5, false, 0);", |
| "user": "anonymous", |
| "dateUpdated": "2020-11-24T17:01:38+0800", |
| "config": { |
| "colWidth": 6, |
| "fontSize": 9, |
| "enabled": true, |
| "results": {}, |
| "editorSetting": { |
| "language": "sql", |
| "editOnDblClick": false, |
| "completionKey": "TAB" |
| }, |
| "title": true, |
| "lineNumbers": true, |
| "editorMode": "ace/mode/sql" |
| }, |
| "settings": { |
| "params": {}, |
| "forms": {} |
| }, |
| "results": { |
| "code": "SUCCESS", |
| "msg": [ |
| { |
| "type": "TEXT", |
| "data": "Sql executed." |
| } |
| ] |
| }, |
| "apps": [], |
| "runtimeInfos": {}, |
| "progressUpdateIntervalMs": 500, |
| "jobName": "paragraph_1606199645491_331600654", |
| "id": "paragraph_1606199645491_331600654", |
| "dateCreated": "2020-11-24T14:34:05+0800", |
| "dateStarted": "2020-11-24T17:01:38+0800", |
| "dateFinished": "2020-11-24T17:01:38+0800", |
| "status": "FINISHED", |
| "$$hashKey": "object:408" |
| }, |
| { |
| "title": "Query: Table", |
| "text": "SELECT *\nFROM root.ln.wf01.wt01\nWHERE time >= 1\n\tAND time <= 6;", |
| "user": "anonymous", |
| "dateUpdated": "2020-11-24T17:01:40+0800", |
| "config": { |
| "colWidth": 6, |
| "fontSize": 9, |
| "enabled": true, |
| "results": { |
| "0": { |
| "graph": { |
| "mode": "table", |
| "height": 300, |
| "optionOpen": false, |
| "setting": { |
| "table": { |
| "tableGridState": { |
| "columns": [ |
| { |
| "name": "Time0", |
| "visible": true, |
| "width": 150, |
| "sort": {}, |
| "filters": [ |
| {} |
| ], |
| "pinned": "" |
| }, |
| { |
| "name": "root.ln.wf01.wt01.temperature1", |
| "visible": true, |
| "width": 290, |
| "sort": {}, |
| "filters": [ |
| {} |
| ], |
| "pinned": "" |
| }, |
| { |
| "name": "root.ln.wf01.wt01.status2", |
| "visible": true, |
| "width": "*", |
| "sort": {}, |
| "filters": [ |
| {} |
| ], |
| "pinned": "" |
| }, |
| { |
| "name": "root.ln.wf01.wt01.hardware3", |
| "visible": true, |
| "width": "*", |
| "sort": {}, |
| "filters": [ |
| {} |
| ], |
| "pinned": "" |
| } |
| ], |
| "scrollFocus": {}, |
| "selection": [], |
| "grouping": { |
| "grouping": [], |
| "aggregations": [], |
| "rowExpandedStates": {} |
| }, |
| "treeView": {}, |
| "pagination": { |
| "paginationCurrentPage": 1, |
| "paginationPageSize": 250 |
| } |
| }, |
| "tableColumnTypeState": { |
| "names": { |
| "Time": "string", |
| "root.ln.wf01.wt01.temperature": "string", |
| "root.ln.wf01.wt01.status": "string", |
| "root.ln.wf01.wt01.hardware": "string" |
| }, |
| "updated": false |
| }, |
| "tableOptionSpecHash": "[{\"name\":\"useFilter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable filter for columns\"},{\"name\":\"showPagination\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable pagination for better navigation\"},{\"name\":\"showAggregationFooter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable a footer for displaying aggregated values\"}]", |
| "tableOptionValue": { |
| "useFilter": false, |
| "showPagination": false, |
| "showAggregationFooter": false |
| }, |
| "updated": false, |
| "initialized": false |
| } |
| }, |
| "commonSetting": {} |
| } |
| } |
| }, |
| "editorSetting": { |
| "language": "sql", |
| "editOnDblClick": false, |
| "completionKey": "TAB" |
| }, |
| "editorHide": false, |
| "title": true, |
| "lineNumbers": true, |
| "editorMode": "ace/mode/sql" |
| }, |
| "settings": { |
| "params": {}, |
| "forms": {} |
| }, |
| "results": { |
| "code": "SUCCESS", |
| "msg": [ |
| { |
| "type": "TABLE", |
| "data": "Time\troot.ln.wf01.wt01.temperature\troot.ln.wf01.wt01.status\troot.ln.wf01.wt01.hardware\n1\t1.1\tfalse\t4\n2\t3.2\ttrue\t3\n3\t2.3\tfalse\t2\n4\t4.4\tfalse\t1\n5\t3.5\tfalse\t0" |
| } |
| ] |
| }, |
| "apps": [], |
| "runtimeInfos": {}, |
| "progressUpdateIntervalMs": 500, |
| "jobName": "paragraph_1605787967187_651066788", |
| "id": "paragraph_1605787967187_651066788", |
| "dateCreated": "2020-11-19T20:12:47+0800", |
| "dateStarted": "2020-11-24T17:01:40+0800", |
| "dateFinished": "2020-11-24T17:01:40+0800", |
| "status": "FINISHED", |
| "$$hashKey": "object:409" |
| }, |
| { |
| "title": "Query: Line Chart", |
| "text": "SELECT *\nFROM root.ln.wf01.wt01\nWHERE time >= 1\n\tAND time <= 6;", |
| "user": "anonymous", |
| "dateUpdated": "2020-11-24T17:01:42+0800", |
| "config": { |
| "colWidth": 6, |
| "fontSize": 9, |
| "enabled": true, |
| "results": { |
| "0": { |
| "graph": { |
| "mode": "lineChart", |
| "height": 300, |
| "optionOpen": false, |
| "setting": { |
| "table": { |
| "tableGridState": {}, |
| "tableColumnTypeState": { |
| "names": { |
| "Time": "string", |
| "root.ln.wf01.wt01.status": "string" |
| }, |
| "updated": false |
| }, |
| "tableOptionSpecHash": "[{\"name\":\"useFilter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable filter for columns\"},{\"name\":\"showPagination\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable pagination for better navigation\"},{\"name\":\"showAggregationFooter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable a footer for displaying aggregated values\"}]", |
| "tableOptionValue": { |
| "useFilter": false, |
| "showPagination": false, |
| "showAggregationFooter": false |
| }, |
| "updated": false, |
| "initialized": false |
| }, |
| "lineChart": { |
| "rotate": { |
| "degree": "-45" |
| }, |
| "xLabelStatus": "default" |
| }, |
| "stackedAreaChart": { |
| "rotate": { |
| "degree": "-45" |
| }, |
| "xLabelStatus": "default" |
| }, |
| "pieChart": {}, |
| "multiBarChart": { |
| "rotate": { |
| "degree": "-45" |
| }, |
| "xLabelStatus": "default" |
| } |
| }, |
| "commonSetting": {}, |
| "keys": [ |
| { |
| "name": "Time", |
| "index": 0, |
| "aggr": "sum" |
| } |
| ], |
| "groups": [], |
| "values": [ |
| { |
| "name": "root.ln.wf01.wt01.temperature", |
| "index": 1, |
| "aggr": "sum" |
| }, |
| { |
| "name": "root.ln.wf01.wt01.hardware", |
| "index": 3, |
| "aggr": "sum" |
| } |
| ] |
| }, |
| "helium": {} |
| } |
| }, |
| "editorSetting": { |
| "language": "sql", |
| "editOnDblClick": false, |
| "completionKey": "TAB" |
| }, |
| "editorHide": false, |
| "title": true, |
| "lineNumbers": true, |
| "editorMode": "ace/mode/sql" |
| }, |
| "settings": { |
| "params": {}, |
| "forms": {} |
| }, |
| "results": { |
| "code": "SUCCESS", |
| "msg": [ |
| { |
| "type": "TABLE", |
| "data": "Time\troot.ln.wf01.wt01.temperature\troot.ln.wf01.wt01.status\troot.ln.wf01.wt01.hardware\n1\t1.1\tfalse\t4\n2\t3.2\ttrue\t3\n3\t2.3\tfalse\t2\n4\t4.4\tfalse\t1\n5\t3.5\tfalse\t0" |
| } |
| ] |
| }, |
| "apps": [], |
| "runtimeInfos": {}, |
| "progressUpdateIntervalMs": 500, |
| "jobName": "paragraph_1606200407155_1025230441", |
| "id": "paragraph_1606200407155_1025230441", |
| "dateCreated": "2020-11-24T14:46:47+0800", |
| "dateStarted": "2020-11-24T17:01:42+0800", |
| "dateFinished": "2020-11-24T17:01:42+0800", |
| "status": "FINISHED", |
| "$$hashKey": "object:410" |
| }, |
| { |
| "text": "", |
| "user": "anonymous", |
| "dateUpdated": "2020-11-24T14:24:43+0800", |
| "config": { |
| "colWidth": 12, |
| "fontSize": 9, |
| "enabled": true, |
| "results": {}, |
| "editorSetting": { |
| "language": "sql", |
| "editOnDblClick": false, |
| "completionKey": "TAB" |
| }, |
| "editorMode": "ace/mode/sql" |
| }, |
| "settings": { |
| "params": {}, |
| "forms": {} |
| }, |
| "apps": [], |
| "runtimeInfos": {}, |
| "progressUpdateIntervalMs": 500, |
| "jobName": "paragraph_1605787989076_1398743633", |
| "id": "paragraph_1605787989076_1398743633", |
| "dateCreated": "2020-11-19T20:13:09+0800", |
| "status": "READY", |
| "$$hashKey": "object:411" |
| } |
| ], |
| "name": "IoTDB-Zeppelin-Demo", |
| "id": "2FRZ8D72H", |
| "defaultInterpreterGroup": "iotdb", |
| "version": "0.9.0-preview2", |
| "noteParams": {}, |
| "noteForms": {}, |
| "angularObjects": {}, |
| "config": { |
| "isZeppelinNotebookCronEnable": false, |
| "looknfeel": "default", |
| "personalizedMode": "false" |
| }, |
| "info": {}, |
| "path": "/IoTDB-Zeppelin-Demo" |
| } |