{"id":986,"date":"2021-08-02T16:34:56","date_gmt":"2021-08-02T08:34:56","guid":{"rendered":"https:\/\/blog.humh.cn\/?p=986"},"modified":"2022-05-30T11:11:11","modified_gmt":"2022-05-30T03:11:11","slug":"influxdb-cli%e6%93%8d%e4%bd%9c%e6%8c%87%e5%8d%97","status":"publish","type":"post","link":"https:\/\/blog.humh.cn\/?p=986","title":{"rendered":"InfluxDB CLI\u64cd\u4f5c\u6307\u5357"},"content":{"rendered":"\n

\u603b\u7ed3\u4e0binfluxdb cli\u64cd\u4f5c\u65b9\u5f0f\u7684\u5185\u5bb9\u3002<\/p><\/blockquote>\n\n\n\n

$ influxd version\nInfluxDB v1.4.2 (git: 1.4 6d2685d1738277a1c2672fc58df7994627769be6)<\/pre>\n\n\n\n
\u672c\u6587\u5185\u5bb9\u5747\u662f\u57fa\u4e8eInfluxDB v1.4.2\u7248\u672c\u8fdb\u884c\u5b9e\u8df5\u7684\uff01<\/p>\n\n\n\n
\n\n\n\n
\u8fde\u63a5influxdb<\/h2>\n\n\n\n
$ influx -precision rfc3339<\/pre>\n\n\n\n
\u6307\u5b9atime\u65f6\u95f4\u6233\u5c55\u793a\u5f62\u5f0fRFC3339<\/strong><\/p>\n\n\n\n
influxdb\u67e5\u8be2\u6570\u636e\u5e93<\/h2>\n\n\n\n
show databases<\/code><\/p>\n\n\n\n
> show databases;\nname: databases\nname\n----\n_internal\nvisualize\nvisualize_day\nvisualize_minutes<\/pre>\n\n\n\n
influxdb\u4f7f\u7528\u67d0\u4e2a\u5e93<\/h2>\n\n\n\n
use <database_name><\/code><\/p>\n\n\n\n
> use visualize_minutes;\nUsing database visualize_minutes<\/pre>\n\n\n\n
\u6307\u5b9a\u5f53\u524d\u4f7f\u7528\u5e93\u7684\u76ee\u7684\u662f\u4e3a\u4e86\u4fdd\u8bc1\u540e\u7eedmeasurement\uff08\u8868\uff09\u7684\u64cd\u4f5c\uff0c\u5f53\u7136\u53ef\u4ee5\u4e0d\u6307\u5b9a\uff0c\u5982\u5728select\u540e\u8ddf\u6761\u4ef6on\u6307\u5b9a\u5e93\u540d\uff0c\u4e5f\u53ef\u4ee5\uff0c\u4e0d\u6307\u5b9a\u7684\u8bdd\uff0c\u9ed8\u8ba4\u5f53\u524duse\u6307\u5b9a\u7684\u5e93\u3002\u5982\u679c\u5c31\u67d0\u4e00\u5e93\u5185\u64cd\u4f5c\uff0c\u5efa\u8bae\u6700\u597d\u6307\u5b9a\u3002<\/p>\n\n\n\n
influxdb\u67e5\u770bmeasurements<\/h2>\n\n\n\n
show measurements<\/code><\/p>\n\n\n\n
\u5217\u51fa\u5f53\u524d\u5e93\uff08\u672ause\u6307\u5b9a\u60c5\u51b5\u4e0b\uff0c\u9ed8\u8ba4\u5e93\uff09\u4e0b\u7684\u6240\u6709measurement\uff08\u8868\uff09\u3002<\/p>\n\n\n\n
> show measurements;\nname: measurements\nname\n----\nvideo\nuser\ndevice<\/pre>\n\n\n\n
\u5220\u9664\u6307\u5b9ameasurement<\/h2>\n\n\n\n
\u5220\u9664\u5f53\u524d\u5e93\u4e2d\u7684\u67d0\u4e2ameasurement\uff1adrop measurement <measurement_name><\/code><\/p>\n\n\n\n
\u5982\u5220\u9664\u5f53\u524d\u5e93\u4e2dtest\u8868\uff1a<\/p>\n\n\n\n
> show measurements;\nname: measurements\nname\n----\ntest\nvideo\n> drop measurement test;\n> show measurements;\nname: measurements\nname\n----\nvideo<\/pre>\n\n\n\n
\u67e5\u770b\u67d0\u4e2ameasurement\u5176\u6240\u6709field key<\/h2>\n\n\n\n
show field keys from <measurement_name><\/code><\/p>\n\n\n\n
\u5982\u4e0b\uff0c\u67e5\u770btest\u8868\u7684\u6240\u6709field key\u6709\u54ea\u4e9b\uff1a<\/p>\n\n\n\n
> show field keys from test;\nname: test\nfieldKey fieldType\n-------- ---------\nage      integer\nsex      string<\/pre>\n\n\n\n
\u67e5\u770b\u67d0\u4e2ameasurement\u5176\u6240\u6709tag key<\/h2>\n\n\n\n
show tag keys from <measurement_name><\/code><\/p>\n\n\n\n
\u5982\u4e0b\uff0c\u67e5\u770btest\u8868\u7684\u6240\u6709tag key\u6709\u54ea\u4e9b\uff1a<\/p>\n\n\n\n
> show tag keys from test;\nname: test\ntagKey\n------\nsource<\/pre>\n\n\n\n
influxdb\u63d2\u5165\u6570\u636e<\/h2>\n\n\n\n
  • \u57fa\u672c\u8bed\u6cd5\u6a21\u677f\uff1ainsert + measurement + \",\" + tag=value,tag=value + \" \" + field=value,field=value<\/code><\/li>
  • tag\u4e0etag\u4e4b\u95f4\u7528\u9017\u53f7\u5206\u9694\uff1bfield\u4e0efield\u4e4b\u95f4\u7528\u9017\u53f7\u5206\u9694\uff1b<\/li>
  • tag\u4e0efield\u4e4b\u95f4\u7528\u7a7a\u683c\u5206\u9694\uff1b<\/li>
  • tag\u90fd\u662fstring\u7c7b\u578b\uff0c\u4e0d\u9700\u8981\u5f15\u53f7\u5c06value\u5305\u88f9\uff1b<\/li>
  • field\u5982\u679c\u662fstring\u7c7b\u578b\uff0c\u9700\u8981\u52a0\u5f15\u53f7\u3002\u5982\u679c\u662f\u5176\u4ed6\u7c7b\u578b\uff0c\u4e5f\u9700\u8981\u663e\u793a\u6307\u5b9a\uff0c\u5982\u679c\u4e0d\u6307\u5b9a\uff0c\u5219\u9ed8\u8ba4integer\uff1b\u5177\u4f53\u7c7b\u578b\u8bf4\u660e\uff0c\u89c1\u4e0b\u6587\u3002<\/li>
  • \u53ef\u4ee5\u7701\u7565\u4e0d\u63d2\u5165\u67d0\u4e2atag\u5b57\u6bb5\u503c\u6216field\u5b57\u6bb5\u503c\u3002<\/li><\/ul>\n\n\n\n
    \u5f53measurement\u4e0d\u5b58\u5728\u7684\u65f6\u5019\uff0c\u6211\u4eec\u63d2\u5165\u4e00\u6761\u6570\u636e\u65f6\uff0c\u4f1a\u521b\u5efa\u8fd9\u4e2ameasurement\u3002<\/p>\n\n\n\n
    > show measurements;\nname: measurements\nname\n----\nvideo\nuser\ndevice\n> insert test,source=5 age=24i,sex=\"man\",money=100;\n> show measurements;\nname: measurements\nname\n----\ndevice\ntest\nuser\nvideo<\/pre>\n\n\n\n
    \u53ef\u4ee5\u770b\u5230\uff0c\u4e00\u5f00\u59cb\u6ca1\u6709test\u8868\uff0c\u5f53\u63d2\u5165\u4e00\u6761\u6570\u636e\u540e\uff0c\u751f\u6210\u4e86test\u8868\u3002<\/p>\n\n\n\n
    influxdb field\u652f\u6301\u56db\u79cd\u6570\u636e\u7c7b\u578b\uff1a<\/p>\n\n\n\n
    \u7c7b\u578b<\/strong><\/td>\u65b9\u5f0f<\/strong><\/td>\u5b9e\u4f8b<\/strong><\/td><\/tr>
    float<\/td>\u6570\u5b57<\/td>money=100<\/td><\/tr>
    integer<\/td>\u6570\u5b57i<\/td>age=24i<\/td><\/tr>
    boolean<\/td>true\/false<\/td>student=false<\/td><\/tr>
    string<\/td>“” \u6216 ”<\/td>sex=”man”<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \u67e5\u770b\u521a\u521a\u521b\u5efa\u7684test\u8868field keys<\/p>\n\n\n\n
    > show field keys from test;\nname: test\nfieldKey fieldType\n-------- ---------\nage      integer\nmoney    float\nsex      string\n> select * from test;\nname: test\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5<\/pre>\n\n\n\n
    \u5982\u679cfield\u7684\u503c\u7c7b\u578b\u4e3astring\uff0c\u4f46\u5374\u6ca1\u6709\u5e26\u5f15\u53f7\uff0c\u5219\u4f1a\u62a5\u9519\uff0c\u5982\u4e0b\u8fd9\u91ccsex=man<\/code>\uff0cman\u662fstring\u7c7b\u578b\u503c\u3002<\/p>\n\n\n\n
    > insert test,source=\"5\" age=24i,sex=man,money=100\nERR: {\"error\":\"unable to parse 'test,source=\"5\" age=24i,sex=man,money=100': invalid boolean\"}<\/pre>\n\n\n\n
    \u9700\u8981\u6ce8\u610f\uff01tag\u53ea\u6709string\u7c7b\u578b\uff0c\u6240\u4ee5\u4e0d\u7528\u5e26\u5f15\u53f7\uff0c\u5982\u679c\u5e26\u4e86\u5f15\u53f7\uff0c\u5219\u8ba4\u4e3a\u5f15\u53f7\u4e5f\u662f\u503c\u7684\u4e00\u90e8\u5206\uff0c\u9700\u8981\u7279\u522b\u6ce8\u610f\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n
    > insert test,source=\"5\" age=24i,sex=\"man\",money=100\n> select * from test;\nname: test\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5\n1627889906757120835 24  100   man \"5\"<\/pre>\n\n\n\n
    \u6307\u5b9a\u65f6\u95f4\u6233<\/h3>\n\n\n\n
    \u5f53\u5199\u5165\u6570\u636e\u4e0d\u6307\u5b9a\u65f6\u95f4\u65f6\uff0c\u4f1a\u81ea\u52a8\u7528\u5f53\u524d\u65f6\u95f4\u6765\u8865\u9f50\u3002\u5982\u679c\u9700\u8981\u6307\u5b9a\u65f6\u95f4\uff0c\u5728\u6700\u540e\u9762\u6dfb\u52a0\u4e0a\u5373\u53ef\uff0c\u6ce8\u610f\u65f6\u95f4\u4e3a\u4e16\u754c\u65f6ns\uff08\u7eb3\u79d2\uff09<\/p>\n\n\n\n
    > insert test,source=6 age=25i,sex=\"man\",money=100 1627890150830158873\n> select * from test;\nname: test\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5\n1627889906757120835 24  100   man \"5\"\n1627890150830158873 25  100   man 6<\/pre>\n\n\n\n
    \u53ef\u4ee5\u7701\u7565\u63d2\u5165\u67d0\u4e2atag\u5b57\u6bb5\u503c\u6216field\u5b57\u6bb5\u503c<\/h3>\n\n\n\n
    \u4e0d\u663e\u793a\u6307\u5b9a\u5bf9\u5e94\u5b57\u6bb5\u5373\u53ef\uff0c\u5982\u8fd9\u91cc\u4e0d\u6307\u5b9asource tag\uff0c\u4e14\u4e0d\u6307\u5b9asex field\u3002<\/p>\n\n\n\n
    > insert test age=25i,money=100 1627890150830158873\n> select * from test;\nname: test\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5\n1627889906757120835 24  100   man \"5\"\n1627890150830158873 25  100\n1627890150830158873 25  100   man 6<\/pre>\n\n\n\n
    \u5173\u4e8einsert\u7684\u7279\u522b\u8bf4\u660e<\/h3>\n\n\n\n
    1\u3001\u5fc5\u987b\u4e25\u683c\u6309\u7167insert\u6a21\u677f\u683c\u5f0f<\/h4>\n\n\n\n
    \u6ce8\u610f\u7a7a\u683c\u4ee5\u53ca\u2018,\u2019\uff0c\u5fc5\u987b\u4e25\u683c\u6309\u7167\u4e0a\u9762\u58f0\u660e\u7684\u6a21\u677f\u683c\u5f0f\u3002\u5982\u4e0b\uff0c\u8868\u540dtest\u548ctag \u201csource\u201d\u4e4b\u95f4\u591a\u5199\u4e86\u7a7a\u683c\uff0c\u5219\u6267\u884c\u9519\u8bef\u3002<\/p>\n\n\n\n
    > insert test, source=8 age=26,money=110,sex=\"\"\nERR: {\"error\":\"unable to parse 'test, source=8 age=26,money=110,sex=\"\"': missing tag key\"}<\/pre>\n\n\n\n
    2\u3001\u9634\u5dee\u9633\u9519\u7684insert<\/h4>\n\n\n\n
    \u5982\u679c\u6ca1\u6709\u6309\u7167insert\u6a21\u677f\u987a\u5e8f\u90a3\u6837\u4e66\u5199\uff0c\u4f1a\u9020\u6210\u610f\u60f3\u4e0d\u5230\u7684\u7ed3\u679c\u3002\u5982\u4e0b\uff1a
    \u5b9e\u9645\uff0c\u662f\u60f3\u8981\u63d2\u5165\u4e00\u6761tag\uff1asource=7\uff0c\u4e14field\uff1aage=26i\uff0c\u4f46\u786e\u662f\u8fd9\u6837\u5199\u7684<\/p>\n\n\n\n
    > insert test source=8,age=26i\n> select * from test;\nname: test\ntime                age money sex source source_1\n----                --- ----- --- ------ --------\n1627886526606090135 24  100   man        5\n1627889906757120835 24  100   man        \"5\"\n1627890150830158873 25  100   man        6\n1627890150830158873 26  110\n1627890150830158873 25  110              7\n1627892081122296401 26            8<\/pre>\n\n\n\n
    \u4f60\u53ef\u80fd\u4f1a\u7eb3\u95f7\u4e0a\u9762select\u7684\u7ed3\u679c\uff0c\u4e3a\u4ec0\u4e48\u4f1a\u6709\u4e00\u4e2asource_1\uff1f\uff1f\u4e0d\u59a8\u63d2\u5165\u540e\uff0c\u518d\u6765\u770b\u4e0btest\u8868\u7684tag keys\u548cfield keys\u3002<\/p>\n\n\n\n
    > show tag keys from test;\nname: test\ntagKey\n------\nsource\n> show field keys from test;\nname: test\nfieldKey fieldType\n-------- ---------\nage      integer\nmoney    float\nsex      string\nsource   float<\/pre>\n\n\n\n
    \u5176\u5b9einsert test source=8,age=26i<\/code> \u8fd9\u53e5\u610f\u601d\u662f\u63d2\u5165\u4e00\u6761\u8bb0\u5f55\uff0c\u6307\u5b9a\u4e24\u4e2afiled key\uff1asource\u4e3a8\uff0c\u540c\u65f6age\u4e3a26i\uff0ctime\u4e3a\u5f53\u524d\u65f6\u95f4\u7684\u6570\u636e\u3002\u6240\u4ee5\u5728\u539f\u6709\u8868\u7684\u57fa\u7840\u4e0a\uff0c\u53c8\u521b\u5efa\u4e86\u4e00\u4e2a\u201csource\u201d field\u3002\u4f46select *<\/code>\u7684\u65f6\u5019\uff0c\u662f\u5c06\u6240\u6709field\u548ctag\u4e00\u5e76\u5c55\u793a\uff0c\u56e0\u4e3a\u540c\u65f6\u5b58\u5728\u547d\u540d\u4e3a\u201csource\u201d\u7684field\u548ctag\uff0c\u6240\u4ee5select *<\/code>\u7684\u65f6\u5019\u5c31\u505a\u4e86\u517c\u5bb9\u5904\u7406\uff0c_\u6570\u5b57<\/strong>\u7684\u8fd9\u79cd\u65b9\u5f0f\u5c55\u793a\uff01\u8fd9\u91cc\u8981\u53ea\u60f3\u5c55\u793asource tag\u548c\u5176\u4ed6field\uff0c\u53ef\u4ee5\u6307\u660e\u547d\u540d\u51b2\u7a81\u5b57\u6bb5\u7684key\u7c7b\u578b\uff0c\u662ftag\u8fd8\u662ffield\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n
    > select age,money,sex,source::tag from test;\nname: test\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5\n1627889906757120835 24  100   man \"5\"\n1627890150830158873 25  100   man 6\n1627890150830158873 26  110\n1627890150830158873 25  110       7\n1627892081122296401 26<\/pre>\n\n\n\n
    \u5173\u4e8eselect\u8bed\u6cd5\u53ef\u4ee5\u8be6\u89c1\u4e0b\u6587\u3002<\/p>\n\n\n\n
    \u4e0a\u9762\u8fd9\u4e2a\u4f8b\u5b50\u8bf4\u660e\uff0c\u5728\u7f16\u5199insert\u7684\u65f6\u5019\uff0c\u4e00\u5b9a\u8981\u4e25\u683c\u6309\u7167\u6a21\u677f\u89c4\u8303\u6765\u5199\uff01<\/p>\n\n\n\n
    3\u3001\u63d2\u5165\u65b0\u6570\u636e\uff0cfield key\u65b0\u503c\u7c7b\u578b\u4e0e\u539f\u59cb\u7c7b\u578b\u4e0d\u4e00\u81f4\uff0c\u5219\u4f1a\u62a5\u9519\u3002<\/h4>\n\n\n\n
    test\u8868\u7684\u201cage\u201d field_key\u672c\u6765\u662finteger\u7c7b\u578b\uff0c\u4f46\u4e0b\u9762\u4e24\u4e2ainsert\u5374\u63d2\u5165\u7684\u662f\u975einteger\u7c7b\u578b\u7684\u201cage\u201d\u3002<\/p>\n\n\n\n
    > insert test age=26,money=110,sex=\"\" 1627890150830158873\nERR: {\"error\":\"partial write: field type conflict: input field \"age\" on measurement \"test\" is type float, already exists as type integer dropped=1\"}\n\n> insert test age=\"26\",money=110,sex=\"\" 1627890150830158873\nERR: {\"error\":\"partial write: field type conflict: input field \"age\" on measurement \"test\" is type string, already exists as type integer dropped=1\"}<\/pre>\n\n\n\n
    \u66f4\u65b0\u67d0\u6761\u6570\u636e\u8bb0\u5f55<\/h2>\n\n\n\n
    influxdb\u4e0d\u652f\u6301\u50cfmysql\u7b49\u6570\u636e\u5e93\u90a3\u79cdupdate\uff0c\u4f46\u53ef\u4ee5\u901a\u8fc7\u91cd\u590d\u63d2\u5165\u7684\u903b\u8f91\uff0c\u5bf9\u503c\u7684\u8986\u5199\uff0c\u6765\u5b9e\u73b0\u66f4\u65b0\u3002
    \u4f46\u9700\u6ce8\u610f\uff0c\u5f53\u9700\u8981\u66f4\u65b0\u66f4\u65b0\u67d0\u4e2afield key\u503c\u65f6\uff0c\u9700\u8981\u4fdd\u8bc1tag key\u548ctime\u65f6\u95f4\u6233\u4fdd\u6301\u4e0d\u53d8\uff0c\u8fd9\u6837influxdb\u624d\u77e5\u9053\u662f\u5728\u540c\u4e00\u4e2a\u7ef4\u5ea6\u7684\u66f4\u65b0\u64cd\u4f5c\uff0c\u5426\u5219\u5c06\u53d8\u6210\u63d2\u5165\u4e00\u6761\u65b0\u7684\u6570\u636e\u3002\u5b9e\u8df5\u5982\u4e0b\uff1a
    \u6211\u60f3\u5bf9time=1627890150830158873\u4e14source\u4e3a\u7a7a\u7684\u8fd9\u6761\u8bb0\u5f55\uff0c\u66f4\u65b0\u5176money\u5b57\u6bb5100\u4e3a110\u3002<\/p>\n\n\n\n
    > select * from test;\nname: test\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5\n1627889906757120835 24  100   man \"5\"\n1627890150830158873 25  100\n1627890150830158873 25  100   man 6\n> insert test age=25i,money=110 1627890150830158873\n> select * from test;\nname: test\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5\n1627889906757120835 24  100   man \"5\"\n1627890150830158873 25  110\n1627890150830158873 25  100   man 6\n\n> insert test age=25i,money=110,sex=\"\" 1627890150830158873\n> select * from test;\nname: test\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5\n1627889906757120835 24  100   man \"5\"\n1627890150830158873 25  110\n1627890150830158873 25  100   man 6\n\n> insert test,source=7 age=25i,money=110,sex=\"\" 1627890150830158873\n> select * from test;\nname: test\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5\n1627889906757120835 24  100   man \"5\"\n1627890150830158873 25  100   man 6\n1627890150830158873 25  110\n1627890150830158873 25  110       7\n\n> insert test age=26i,money=110,sex=\"\" 1627890150830158873\n> select * from test;\nname: test\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5\n1627889906757120835 24  100   man \"5\"\n1627890150830158873 25  100   man 6\n1627890150830158873 26  110\n1627890150830158873 25  110       7<\/pre>\n\n\n\n
    insert test age=25i,money=110,sex=\"\" 1627890150830158873<\/code>\u548cinsert test age=25i,money=110 1627890150830158873<\/code>\u662f\u7b49\u4ef7\u7684\uff0c\u90fd\u662f\u6307\u5b9asex\u4e3a””\uff0c\u503c\u4e3a\u7a7a\uff0c\u7701\u7565\u5b57\u6bb5\u5373\u9ed8\u8ba4\u503c\uff0cstring\u9ed8\u8ba4\u7a7a\uff0c\u6240\u4ee5\u7b49\u4ef7\u3002\u540c\u65f6\u548cinsert test age=26i,money=110,sex=\"\" 1627890150830158873<\/code>\u8fd9\u4e09\u6761\u8bed\u53e5\u90fd\u662f\u6307\u5411\u540c\u4e00\u6761\u8bb0\u5f55\uff0c\u56e0\u4e3a\u90fd\u662f\u6307\u5b9a\u4e86source\u7a7a\u4e14\u65f6\u95f4\u6233time\u4e3a1627890150830158873\u3002\u4f46\u5982\u679c\u6307\u5b9asource=7\uff0c\u5373insert test,source=7 age=25i,money=110,sex=\"\" 1627890150830158873<\/code>\u5c31\u662f\u63d2\u5165\u4e00\u6761\u65b0\u6570\u636e\u4e86\uff0c\u548c\u539f\u6765source\u4e3a\u7a7a\uff0c\u5e76\u4e0d\u662f\u4e00\u4e2a\u7ef4\u5ea6\uff0c\u540c\u65f6\u8868\u4e2d\u539f\u672c\u5e76\u4e0d\u5b58\u5728source=7\u4e14time=1627890150830158873\u7684\u6570\u636e\uff0c\u6240\u4ee5\u4e0d\u4f1a\u66f4\u65b0\u65e7\u6570\u636e\u3002<\/p>\n\n\n\n
    select\u67e5\u8be2<\/h2>\n\n\n\n
    \u73b0\u8868\u5982\u4e0b<\/p>\n\n\n\n
    > insert test,source=2 age=24i,sex=\"man\",source=\"a\"\n> select * from test;\nname: test\ntime                age sex source source_1\n----                --- --- ------ --------\n1627898618544625549 24  man a      2\n> show tag keys from test;\nname: test\ntagKey\n------\nsource\n> show field keys from test;\nname: test\nfieldKey fieldType\n-------- ---------\nage      integer\nsex      string\nsource   string<\/pre>\n\n\n\n
    \u57fa\u672cselect<\/h3>\n\n\n\n
    select\u6240\u6709field\u548ctag key<\/h4>\n\n\n\n
    select *<\/code><\/p>\n\n\n\n
    > select * from test;\nname: test\ntime                age sex source source_1\n----                --- --- ------ --------\n1627898618544625549 24  man a      2<\/pre>\n\n\n\n
    \u6ce8\u610f\uff0c\u5982\u679c\u5b58\u5728\u547d\u540d\u51b2\u7a81\u7684\u5b57\u6bb5\uff0cselect *<\/code>\u7684\u65f6\u5019\u4f1a\u6309\u4e0b\u5212\u7ebf\u6570\u5b57\u5904\u7406\u3002<\/p>\n\n\n\n
    select\u6240\u6709field<\/h4>\n\n\n\n
    select *::field<\/code><\/p>\n\n\n\n
    > select *::field from test;\nname: test\ntime                age sex source\n----                --- --- ------\n1627898618544625549 24  man a<\/pre>\n\n\n\n
    \u4e0d\u652f\u6301select\u6240\u6709tag\uff0c\u5373select *::tag<\/code>\u6ca1\u6709\u6548\u679c\uff01\uff01<\/h4>\n\n\n\n
    > select *::tag from test;\n><\/pre>\n\n\n\n
    \u67e5\u8be2\u90e8\u5206field\u5b57\u6bb5<\/h4>\n\n\n\n
    select \"<field_key>\",\"<field_key>\"<\/code>\u6216\u663e\u793a\u5e26field\u5173\u952e\u5b57select \"<field_key>\"::field,<field_key>\"::field<\/code><\/p>\n\n\n\n
    > select sex,age,source from test;\nname: test\ntime                sex age source\n----                --- --- ------\n1627898618544625549 man 24  a\n> select sex::field,age::field,source::field from test;\nname: test\ntime                sex age source\n----                --- --- ------\n1627898618544625549 man 24  a<\/pre>\n\n\n\n
    \u67e5\u8be2\u6307\u5b9afield\u6216tag<\/h4>\n\n\n\n
    select \"<field_key>\"::field,\"<tag_key>\"::tag<\/code><\/p>\n\n\n\n
    > select sex::field,age::field,source::tag from test;\nname: test\ntime                sex age source\n----                --- --- ------\n1627898618544625549 man 24  2<\/pre>\n\n\n\n
    \u8fd9\u79cd\u65b9\u5f0f\uff0c\u5c24\u5176\u5728field\u548ctag\u5b58\u5728\u547d\u540d\u51b2\u7a81\u7684\u8868\u4e2d\u67e5\u8be2\u5176tag\u65f6\uff0c\u53d7\u7528\u3002<\/p>\n\n\n\n
    \u5220\u9664measurement\u4e2d\u7684\u5217<\/h2>\n\n\n\n
    influxdb\u6682\u4e0d\u652f\u6301\u5220\u9664\u67d0\u4e00\u5217\uff0c\u4f46\u53ef\u4ee5\u901a\u8fc7select into<\/code>\u4e34\u65f6\u4e2d\u95f4\u8868\u7684\u65b9\u5f0f\uff0c\u5c06\u4e0d\u9700\u8981\u5220\u9664\u7684\u5217\u5bfc\u51fa\u4e34\u65f6\u8868\uff0c\u7136\u540e\u5c06\u5220\u9664\u539f\u8868\uff0c\u5728\u5c06\u4e34\u65f6\u8868\u5199\u51fa\u5230\u201c\u539f\u8868\u540d\u201d\u7684\u8868\u3002<\/p>\n\n\n\n
    \u73b0\u5728\u6709\u8fd9\u4e48\u4e00\u4e2a\u8868<\/p>\n\n\n\n
    > select * from test;\nname: test\ntime                age money sex source source_1\n----                --- ----- --- ------ --------\n1627886526606090135 24  100   man        5\n1627889906757120835 24  100   man        \"5\"\n1627890150830158873 25  100   man        6\n1627890150830158873 26  110\n1627890150830158873 25  110              7\n1627892081122296401 26            8\n> show tag keys from test;\nname: test\ntagKey\n------\nsource\n> show field keys from test;\nname: test\nfieldKey fieldType\n-------- ---------\nage      integer\nmoney    float\nsex      string\nsource   float<\/pre>\n\n\n\n
    \u6211\u60f3\u5220\u9664field\uff1asource\uff0c\u8fd9\u4e2a\u662f\u9634\u5dee\u9633\u9519\u521b\u5efa\u51fa\u6765\u7684\u9519\u8bef\u5b57\u6bb5\u3002\u4e8e\u662f\uff0c\u8fd9\u91cc\u8fc7\u6ee4\u6389field \u201csource\u201d\uff0c\u663e\u793a\u6307\u5b9atag \u201csource\u201d\uff0c\u4e2d\u95f4\u4e34\u65f6\u8868\u4e3a\u201ctmp\u201d\u3002<\/p>\n\n\n\n
    > select age,money,sex,source::tag into tmp from test;\nname: result\ntime written\n---- -------\n0    6\n> select * from tmp;\nname: tmp\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5\n1627889906757120835 24  100   man \"5\"\n1627890150830158873 25  110       7\n1627892081122296401 26<\/pre>\n\n\n\n
    \u770b\u4f3c\u7ed3\u679c\u53ef\u4ee5\u4e86\uff0c\u4f46\u5b9e\u9645\u5b58\u5728\u95ee\u9898\uff0cschema\u5b58\u5728\u95ee\u9898\u3002<\/p>\n\n\n\n
    > show tag keys from tmp;\n> show field keys from tmp;\nname: tmp\nfieldKey fieldType\n-------- ---------\nage      integer\nmoney    float\nsex      string\nsource   string<\/pre>\n\n\n\n
    \u76f4\u63a5select into<\/code>\uff0cinfluxdb\u4f1a\u8ba4\u4e3aselect\u7684\u5b57\u6bb5\u90fd\u4f5c\u4e3afield\u5199\u5165\u4e34\u65f6\u8868\u3002\u800c\u6211\u4eec\u60f3\u8981\u7684\u662f\uff0c\u201csource\u201d\u4f5c\u4e3atag key\u3002<\/p>\n\n\n\n
    \u5982\u679c\u9700\u8981\u5c06\u539f\u59cb\u8868\u7684tag key\u4fdd\u6301\u4e0d\u53d8\u5199\u5165\u4e34\u65f6\u8868\uff0c\u5219\u9700\u8981group by\u914d\u5408\u5b8c\u6210\u3002<\/strong>\u53ef\u4ee5group by\u540e\u8ddf\u9700\u8981\u4fdd\u6301\u4e0d\u53d8\u7684tag key\uff0c\u8fd9\u91cc\u56e0\u4e3a\u6211\u4eec\u539f\u59cb\u8868\u53ea\u6709\u4e00\u4e2atag key\uff0c\u5c31\u662f\u201csource\u201d\uff0c\u6240\u4ee5\u53ef\u4ee5\u76f4\u63a5group by *<\/code>\uff0c\u5f53\u7136\u4e5f\u53ef\u4ee5group by source<\/code>\uff08\u5173\u4e8eselect group by\u7684\u8bed\u6cd5\u53ef\u4ee5\u53c2\u8003select\u8bed\u6cd5<\/strong><\/em>\u7ae0\u8282\uff09\u3002\u5177\u4f53\u5982\u4e0b\uff1a<\/p>\n\n\n\n
    > select age,money,sex into tmp from test group by *;\nname: result\ntime written\n---- -------\n0    6\n\n> select * from tmp;\nname: tmp\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5\n1627889906757120835 24  100   man \"5\"\n1627890150830158873 25  100   man 6\n1627890150830158873 26  110\n1627890150830158873 25  110       7\n1627892081122296401 26\n> show field keys from tmp;\nname: tmp\nfieldKey fieldType\n-------- ---------\nage      integer\nmoney    float\nsex      string\n> show tag keys from test;\nname: test\ntagKey\n------\nsource\n\n> drop measurement test;\n> select *::field into test from tmp group by *;\nname: result\ntime written\n---- -------\n0    6\n> select * from test;\nname: test\ntime                age money sex source\n----                --- ----- --- ------\n1627886526606090135 24  100   man 5\n1627889906757120835 24  100   man \"5\"\n1627890150830158873 25  100   man 6\n1627890150830158873 26  110\n1627890150830158873 25  110       7\n1627892081122296401 26\n> show tag keys from test;\nname: test\ntagKey\n------\nsource\n> show field keys from test;\nname: test\nfieldKey fieldType\n-------- ---------\nage      integer\nmoney    float\nsex      string\n\n> drop measurement tmp;<\/pre>\n\n\n\n
    \u6ce8\u610f\uff0cselect into from group by<\/code>\u7684\u65f6\u5019\uff0cselect\u7684\u5185\u5bb9\u4e0d\u8981\u518d\u5199tag key\uff0c\u5426\u5219\u4f1a\u51b2\u7a81\u3002\u5982\u4e0b\uff1a<\/p>\n\n\n\n
    > select age,money,sex,source::tag into tmp from test group by *;\nname: result\ntime written\n---- -------\n0    6\n> select * from tmp;\nname: tmp\ntime                age money sex source source_1\n----                --- ----- --- ------ --------\n1627886526606090135 24  100   man 5      5\n1627889906757120835 24  100   man \"5\"    \"5\"\n1627890150830158873 25  100   man 6      6\n1627890150830158873 26  110\n1627890150830158873 25  110       7      7\n1627892081122296401 26\n> show field keys from tmp;\nname: tmp\nfieldKey fieldType\n-------- ---------\nage      integer\nmoney    float\nsex      string\nsource   string\n> show tag keys from test;\nname: test\ntagKey\n------\nsource<\/pre>\n\n\n\n
    \u5f53\u7136\uff0c\u5982\u679c\u4f60\u8981\u5220\u9664\u7684\u5217\u5305\u542b\u4e86tag\uff0c\u5373\u8981\u4fdd\u6301\u7684\u5217\u4ec5\u4e3afield\uff0c\u5219\u4e0d\u7528group by\uff0c\u76f4\u63a5select into<\/code>\u3002<\/p>\n\n\n\n
    \n\n\n\n
    \u672c\u6587\u53c2\u8003<\/h4>\n\n\n\n