CREATE clauses
CREATE
statements partially support TABLE
and INDEX
.
IMPORTANT:
CREATE
statements, including TABLE
and INDEX
, are not supported by the Influx database parser. Only explicit schema can be managed or modified using client API. For more information, see https://docs.influxdata.com/influxdb/cloud/admin/buckets/bucket-schema/.Examples
CREATE UNIQUE INDEX Table_Index ON Table1 (Column1)
CREATE INDEX IF NOT EXISTS Table_Index ON Table1 (Column1)
CREATE TABLE TempTable AS SELECT Column1 FROM MyTable WHERE Column1 > 5
CREATE TEMPORARY TABLE TempTable AS SELECT Column1 FROM MyTable WHERE Column1 > 5
Provide Feedback