Results of 1 - 7 of about 7 for demonstrate (0.001 sec.)
- JSON Format Settings 12832
- The JSON extension can attempt to determine the format of a JSON file when setting format to auto . Here are some example JSON files and the corresponding format settings that should be used. In each of the below cases, the format setting w
...Format: array If the JSON file contains a JSON array of objects (pretty-printed or not), array_of_objects may be used. To demonstrate its use, we use the example file records-in-array.json : [ {"key1":"value1", "key2": "value1"}, {"key1":"value2", "key2":...ormat: unstructured If the JSON file contains JSON that is not newline-delimited or an array, unstructured may be used. To demonstrate its use, we use the example file unstructured.json : { "key1":"value1", "key2":"value1" } { "key1":"value2", "key2":"value... - https://man.mtool.work/duckdb/2.0/data/json/format_settings.html
- UNPIVOT Statement 9960
- The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column (which contains the name of the source column) and a VALUE column (which contain
...eful when the goal is to reduce the extent to which a dataset is pivoted, but not completely stack all pivoted columns. To demonstrate this, the query below will generate a dataset with a separate column for the number of each month within the quarter (mont...eful when the goal is to reduce the extent to which a dataset is pivoted, but not completely stack all pivoted columns. To demonstrate this, the query below will generate a dataset with a separate column for the number of each month within the quarter (mont... - https://man.mtool.work/duckdb/2.0/sql/statements/unpivot.html
- EXPLAIN: Inspect Query Plans 9542
- EXPLAIN SELECT * FROM tbl; The EXPLAIN statement displays the physical plan, i.e., the query plan that will get executed, and is enabled by prepending the query with EXPLAIN . The physical plan is a tree of operators that are executed in a
...rate an efficient physical plan, the query optimizer transforms the existing physical plan into a better physical plan. To demonstrate, see the below example: CREATE TABLE students (name VARCHAR, sid INTEGER); CREATE TABLE exams (eid INTEGER, subject VARCHA... - https://man.mtool.work/duckdb/2.0/guides/meta/explain.html
- Importing Duckbox Tables 8724
- The scripts provided in this page work on Linux, macOS, and WSL. By default, the DuckDB CLI client renders query results in the duckbox format , which uses rich, ASCII-art inspired tables to show data. These tables are often shared verbatim
...in other documents. For example, take the table used to demonstrate new CSV features in the DuckDB 1.2.0 release blog post : ┌─────────┬───────┐ │ a │ b │ │ varchar │ int64 │ ├─────────┼────... - https://man.mtool.work/duckdb/2.0/guides/snippets/importing_duckbox_tables.html
- Interval Type 7906
- INTERVAL s represent periods of time that can be added to or subtracted from DATE , TIMESTAMP , TIMESTAMPTZ , or TIME values. Name Description INTERVAL Period of time An INTERVAL can be constructed by providing amounts together with units.
...seconds component is split into hours, minutes and microseconds. The days component is not split into additional units. To demonstrate this, the following query generates an INTERVAL called period by summing random amounts of the three basis units. It then... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Reading Faulty CSV Files 7488
- CSV files can come in all shapes and forms, with some presenting many errors that make the process of cleanly reading them inherently difficult. To help users read these files, DuckDB supports detailed error messages, the ability to skip fa
...ws containing data that would otherwise cause the CSV parser to generate an error will be ignored. In our example, we will demonstrate a CAST error, but note that any of the errors described in our Structural Error section would cause the faulty line to be... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
- FROM and JOIN Clauses 7088
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...putting the FROM clause before the SELECT clause or completely omitting the SELECT clause. We use the following example to demonstrate it: CREATE TABLE tbl AS SELECT * FROM (VALUES ('a'), ('b')) t1(s), range(1, 3) t2(i); FROM -First Syntax with a SELECT Cla...use The following statement demonstrates the use of the FROM -first syntax: FROM tbl SELECT i, s; This is equivalent to: SELECT i, s FROM tbl; i s 1 a 2 a 1 b 2 b...FROM -First Syntax without a SELECT Clause The following statement demonstrates the use of the optional SELECT clause: FROM tbl; This is equivalent to: SELECT * FROM tbl; s i a 1 a 2 b 1 b 2 Syntax... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work