Differences

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

--- supp:influxdb:start [2019/07/09 07:13] – [Download and install NOAA sample data] admin
+++ supp:influxdb:start [2019/07/09 15:09] (current) – [Common Commands] admin
@@ Line 22: / Line 22: @@
     * tag set
   * 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 30: / Line 40: @@
 <code bash create_and_fill_NOAA_water_db.sh>
-influx -precision rfc3339
+# rb: 2019-07-09
+# BASH shell script,
+# copied from https://docs.influxdata.com/influxdb/v1.7/query_language/data_download/
+# open influx
+influx -precision rfc3339 -execute
+</code>
+===== Data Exploration, Select =====
+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>