User Tools

Site Tools


supp:influxdb:start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
supp:influxdb:start [2019/07/09 07:21] – [Download and install NOAA sample data] adminsupp:influxdb:start [2019/07/09 15:09] (current) – [Common Commands] admin
Line 22: Line 22:
     * tag set     * tag set
   * retention policy   * retention policy
 +
 +
 +For relational database users:
 +
 +tags are like key attributes inducing index creation. The only attribute type for tags is string. Fields are not indexed but can be of four different types: float, integer, string, Boolean.
 +
 + 
 +
 +
 +
  
  
Line 42: Line 52:
  
 https://docs.influxdata.com/influxdb/v1.7/query_language/data_exploration/ https://docs.influxdata.com/influxdb/v1.7/query_language/data_exploration/
 +
 +
 +===== Common Commands =====
 +
 +<code>
 +
 +show databases
 +
 +use NOAA_water_database
 +
 +show measurements
 +
 +SELECT COUNT("water_level") FROM h2o_feet
 +
 +SELECT * FROM h2o_feet LIMIT 5
 +
 +show series
 +
 +show tag keys
 +
 +show field keys
 +
 +
 +
 +create database bla
 +
 +use bla
 +
 +show measurements
 +
 +drop database bla
 +
 +</code>
  
supp/influxdb/start.1562656916.txt.gz · Last modified: 2019/07/09 07:21 by admin