* WIP sql join statement
* WIP SQL joins
* added join type descriptions and examples
* Apply suggestions from code review
Co-authored-by: Jason Stirnaman <jstirnaman@influxdata.com>
* add info about fully-qualified references in joins
* Apply suggestions from code review
Co-authored-by: Jason Stirnaman <jstirnaman@influxdata.com>
* port sql join reference to serverless and clustered
---------
Co-authored-by: Jason Stirnaman <jstirnaman@influxdata.com>
* add note about using timeformat for partition templates
* Apply suggestions from code review
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* Update create management token, must have double quotes.md
Must have quotes on description otherwise it doesn't work
* Apply suggestions from code review
* ported changes to clustered
* added quotes to examples
---------
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
Co-authored-by: Scott Anderson <scott@influxdata.com>
* Update create.md
should be `expires-at` not `expire-at`
* updated other isntances of incorrect influxctl flag
---------
Co-authored-by: Scott Anderson <scott@influxdata.com>
* add infomrmation about sql timezone support
* Apply suggestions from code review
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* fixed typos
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* added influxql query support for influxctl
* removed sql tag from task-based influxctl query guide
* Influxctl v2.8.0 (#5418)
* Release influxctl v2.8.0
* Update change logs
* Apply suggestions from code review
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
---------
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Add influxctl write timeout and new insecure TLS config (#5419)
* add timeout flag to write, update config with insecure tls
* fixed link
* Add 'enable-system-tables' flag to `influxctl query` (#5415)
* add enable system tables flag to influxctl
* Apply suggestions from code review
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* Query system tables with influxctl (#5414)
* outline for querying system tables
* finalized system table query examples
* updated system table validity date
* Apply suggestions from code review
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* Apply suggestions from code review
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
---------
Co-authored-by: Joshua Powers <powersj@fastmail.com>
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* feat(dedicated): Parameterized queries for SQL and InfluxQL using the native Flight RPC API
* feat(v3): Parameterized queries for SQL and InfluxQL
* feat(v3): Parameterized queries for SQL and InfluxQL
* feat(v3): Dedicated: Parameterized queries for SQL and InfluxQL
* feat(v3): Serverless: Parameterized queries for SQL and InfluxQL
* feat(v3): Clustered: Parameterized queries for SQL and InfluxQL
* feat(v3): Cleanup parameterized queries
* Apply suggestions from code review
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Apply suggestions from code review
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Apply suggestions from code review
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-dedicated/reference/influxql/time-and-timezone.md
* Update content/influxdb/cloud-dedicated/reference/influxql/time-and-timezone.md
* Update content/influxdb/cloud-dedicated/reference/influxql/time-and-timezone.md
* Influxctl v2.7.1 (#5395)
* Release influxctl v2.7.1
* Update change logs
* feat(v3): Parameterized queries: Add references to time and data types pages
* feat(v3): InfluxQL parameterized queries data types
* feat(v3): InfluxQL parameterized queries data types
* feat(v3): Note that you can't parameterize identifiers in queries
* feat(v3): Parameterized queries restrictions
---------
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
Co-authored-by: Joshua Powers <powersj@fastmail.com>
* Strategies to improve query performance: operations, number and size of parquet files
Fixes#5108
- Add query performance strategies to optimize-queries
* Apply suggestions from code review
* Apply suggestions from code review
* Update content/influxdb/cloud-dedicated/query-data/execute-queries/optimize-queries.md
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
* chore(v3): WIP query perf
Fixes#5108
* chore(v3): WIP: Query performance
* chore(v3): WIP: Explain the EXPLAIN report and indicators of query expense, performance problems.
* WIP: optimize queries - how to read a query plan, operators
* WIP: Read a query plan example 2
* WIP: moved how to read a query plan to its own page.
* WIP(v3): operators
* chore(v3): WIP add query plan info from DataFusion slides and @NGA-TRAN
* chore(v3): WIP read a query plan - explain tree format and reorganize
* WIP: query plan
- Adds Query Plan reference
- Completes Analyze a Query Plan, pending cleanup, continue at :471
- Added image from Nga's blog
- Updates EXPLAIN doc
- TODO: Create public docs for
https://github.com/influxdata/docs.influxdata.io/blob/main/content/operations/specifications/iox_runbooks/slow-queries.md
* chore(spelling): Vale config changes
- Add vale to package.json and use Yarn to manage the binary. You can use `npx vale` to run manually.
- Move InfluxData spelling ignore list into the style.
- Reorganize custom (product) spelling lists to comply with Vale 3.x
- Add InfluxDB v3 terms
* chore(spelling): Vale config changes
- Add vale to package.json and use Yarn to manage the binary. You can use `npx vale` to run manually.
- Move InfluxData spelling ignore list into the style.
- Reorganize custom (product) spelling lists to comply with Vale 3.x
- Add InfluxDB v3 terms
* chore(v3): Reorg of query troubleshooting and optimizing docs
- Adds query-data/troubleshoot-and-optimize
- Splits optimize docs into troubleshoot and optimize docs
- Moves Flight response doc to flight-responses.md
* chore: Fixes broken links, typos, missing content, etc.
- Fixes various errors and style violations reported by Vale.
- Fixes broken links and missing content in glossaries.
- Fixes missing and extraneous whitespace.
* Apply suggestions from code review
* Update content/influxdb/cloud-dedicated/query-data/troubleshoot-and-optimize/analyze-query-plan.md
* chore(clustered): Query plan: Apply review suggestions
Co-Authored-By: Nga Tran <20850014+NGA-TRAN@users.noreply.github.com>
* feature(v3): Analyze a query plan:
- Apply code formatting to plan implementor names
- Simplify some points
- Add links
* add query plan html diagram (#5365)
* Update content/influxdb/cloud-dedicated/query-data/troubleshoot-and-optimize/analyze-query-plan.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-dedicated/query-data/troubleshoot-and-optimize/optimize-queries.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-dedicated/query-data/troubleshoot-and-optimize/trace.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-dedicated/query-data/troubleshoot-and-optimize/trace.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-dedicated/query-data/troubleshoot-and-optimize/trace.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-serverless/query-data/troubleshoot-and-optimize/analyze-query-plan.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* fix(v3): finish the EXPLAIN descriptions and examples
* chore(tests): Setup a python venv in test containers
* fix(ci): Vale vocab
* fix(v3): Punctuation typo
* chore(ci): Update README
* fix(v3): Apply review suggestions and capitalization
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* fix(v3): Add note to optimize page and revise troubleshoot
* fix(v3): optimize-queries link
---------
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
Co-authored-by: Nga Tran <20850014+NGA-TRAN@users.noreply.github.com>
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* updates sql functions added upstream
* Apply suggestions from code review
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* port changes to serverless and clustered
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* updated sql time and date functions
* update sql casting docs with new TIMESTAMP behavior, closes#5331
* Apply suggestions from code review
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* added format_n argument to to_timestamp* functions
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* Release influxctl v2.4.4
* Update release notes
* add --trace global flag to influxctl docs
* port influxctl --trace flag to clustered
---------
Co-authored-by: Scott Anderson <scott@influxdata.com>
* add note to show tag values docs about including a FROM clause, closes#5321
* Update content/influxdb/cloud-dedicated/reference/influxql/show.md
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* port changes to serverless and clustered
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
Fixes#5271
- Updates Go samples that use the client library to use the same Arrow package version (v13) used in the client library
- Updates Go FlightSQL examples to use the latest Arrow package (v14).
* update mentions of IOx to v3
* Apply suggestions from code review
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* WIP SQL operators
* add more descriptions for sql operators
* Apply suggestions from code review
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* port sql operator docs to serverless and clustered
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* add influxctl release notes
* update influxctl release notes to address PR feedback
* fix typo in influxctl user list frontmatter
* port influctl release notes and changes to clustered
* fix(v3): remove v2-prefer note, replace with specific recommendations
- removes the shared v2-prefer shortcode note.
- adds "Flight client" tag to all Flight RPC and Flight SQL client pages.
- replaces the note with specific write/query notes in each platform.
- misc fixes
* fix(v3): v2 client library typo
* fix(v3): Cleanup usage note for all v2 client libraries
- Change note to warning
- Condense
- Move warning to prepend block
- Make consistent on all pages
- Remove autolinking to GitHub repos
* chore(v3): Add "Clustered"
* fix(v3): typo
* chore(test): Use my python client fork (pending approval) to allow custom headers.
* feature(query): Add Optimize Queries page with query analysis help
- Closes Client library query traces: Python #5143
- Dedicated and Clustered examples for enabling query tracing and extracting headers
- System.queries table
- Explain and Analyze
- For now, skip tests for sample Flight responses until we add in code samples.
* Update content/influxdb/clustered/query-data/execute-queries/optimize-queries.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-dedicated/query-data/execute-queries/optimize-queries.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-dedicated/query-data/execute-queries/optimize-queries.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-dedicated/query-data/execute-queries/optimize-queries.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/clustered/query-data/execute-queries/optimize-queries.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/clustered/query-data/execute-queries/optimize-queries.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/clustered/query-data/execute-queries/optimize-queries.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/clustered/query-data/execute-queries/optimize-queries.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-dedicated/query-data/execute-queries/optimize-queries.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-dedicated/query-data/execute-queries/optimize-queries.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* feat(v3): influx-trace-id for dedicated, tracing not ready for clustered (Client library query traces: Python #5143)
---------
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* chore(ci): Update vocab.
* chore(test): Set language-specific replacements for code sample tests
This is a bit of kludge to allow for language-specific replacement patterns
while keeping the code samples valid when a user replaces placeholder strings with their own and copies the sample.
This is necessary for executing (not for validating syntax) of the code samples.
- Workaround for identifying language-specific replacements for pytest-codeblocks test runs.
- Uses Python f-strings to identify Python-specific placeholders.
- To import os for your code sample and hide it from users, wrap it in a comment and use the `pytest-codeblocks:cont` comment tag. See d0ca7e22b8/README.md?plain=1#L117
* fix(v3): Cleanup: fix link and grammar
* WIP base changes for clustered docs
* WIP clustered docs
* Add new influxdb/host shortcode and implement it in 3.0 docs (#5077)
* add new influxdb/host shortcode and implement it in 3.0 docs
* remove oss- cloud-only shortcodes from serverless
* Apply suggestions from code review
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* updated urls js to PR suggestion
* Updated JavaScript, templates, and styles for Clustered URLs (#5079)
* updated js, templates, and styles for clustered urls
* Apply suggestions from code review
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* restructure product dropdown template to be more extensible
* fixed more page template bugs
* fixed references to cloud in clustered
* updated docsearch templates
* added early access flagging and cta-link shortcode
* minor content updates in clustered
* updated staging config
* fixed typo in clustered description
* ported influxctl 2.0.1 to clustered
* ported get started changes to clustered
* ported 3.0 admin docs to clustered
* port null tag content to clustered
* ported influxctl note to clustered
* ported query reorg changes to clustered
* updated early access to limited availability, updated clustered landing content
* ported new content to clustered
* ported new content to clustered
* updated cta on clustered landing page
* Updated notifications and added InfluxDB Clustered announcement notification (#5125)
* updated notifications, added clustered announcement notification
* updated cta in clustered notification
* updated influxctl profile configs
* update clustered search attributes
* updated learn more link in clustered notification
* Apply suggestions from code review
* fixed typos
* fixed typos
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* feature(dedicated): InfluxDB Flight responses and errors (Closes#5114):
- Describe Flight+gRPC high-level request semantics.
- Relationship between gRPC, Flight, InfluxDB
- List error codes using by InfluxDB, how they translate to Flight and gRPC statuses.
- Example errors, what they mean, possible causes
Co-authored by: Jay Clifford<@Jayclifford345>
* Update content/influxdb/cloud-dedicated/query-data/troubleshoot.md
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
* fix(v3): Apply suggestions from @alamb. Refine organization, add stream and RecordBatch sections.
* fix(v3): improve stream, schema, batch
* fix(v3): toc
* fix(v3): troubleshoot flight (Flight responses and errors when querying v3 #5114):
- gRPC server-side streaming and nomenclature.
* fix(v3): Fix evaluation and prototyping #5120
* fix(v3): rename, update v3 Python reference, fix params (closes Flight responses and errors when querying v3 #5114)
* fix(v3): file name
* Update content/influxdb/cloud-dedicated/query-data/execute-queries/troubleshoot.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-dedicated/query-data/execute-queries/troubleshoot.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-serverless/query-data/execute-queries/troubleshoot.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* Update content/influxdb/cloud-serverless/query-data/execute-queries/troubleshoot.md
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* fix(v3): add PR suggestions
---------
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
Co-authored-by: Scott Anderson <sanderson@users.noreply.github.com>
* influxctl authentication note
This just adds a helpful pointer to eliminate an annoying and unnecessary warning message that may trip up parsing JSON output from the utility. The note is Linux specific. It may be Ubuntu specific as well, but this is one of the most popular distros.
* Update content/influxdb/cloud-dedicated/reference/cli/influxctl/_index.md
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* Update content/influxdb/cloud-dedicated/reference/cli/influxctl/_index.md
* Update _index.md
Apply suggestion
Co-authored by: Jamie Strandboge <jdstrand@users.noreply.github.com>
* Update content/influxdb/cloud-dedicated/reference/cli/influxctl/_index.md
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* added data durability to dedicated
* Update content/influxdb/cloud-dedicated/reference/internals/durability.md
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
* ported data durability doc from dedicated to serverless
* fixed serverless durability frontmatter
---------
Co-authored-by: Jason Stirnaman <stirnamanj@gmail.com>
Joshua Powers
Scott Anderson
Jason Stirnaman
Adam
Jason Stirnaman
Scott Anderson
Benjamin Corbett
Andreas Deininger
Jacob Marble
Reid Kaufmann