Results of 1 - 8 of about 8 for preserves (0.002 sec.)
- Profiling Queries 12362
- DuckDB supports profiling queries via the EXPLAIN and EXPLAIN ANALYZE statements. EXPLAIN To see the query plan of a query without executing it, run: EXPLAIN ⟨query⟩; The output of EXPLAIN contains the estimated cardinalities for each opera
...rom the input query (for example through join reordering, constant folding, or subquery introduction). The generated query preserves the result column names, column order, and logical types, but the exact formatting and any generated aliases are not a sta... - https://man.mtool.work/duckdb/2.0/sql/statements/profiling.html
- Reading and Writing Parquet Files 10085
- Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.par
...d by legacy writers such as Impala and older Spark versions). Options are timestamp (microsecond precision), timestamp_ns (preserves nanoseconds; out-of-range values saturate) and struct (a STRUCT(date DATE, time TIME_NS) that preserves the full range and... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
- Order Preservation 10085
- For many operations, DuckDB preserves the order of rows, similarly to data frame libraries such as Pandas. Example Take the following table for example: CREATE TABLE tbl AS SELECT * FROM (VALUES (1, 'a'), (2, 'b'), (3, 'c')) t(x, y); SELECT
... - https://man.mtool.work/duckdb/2.0/sql/dialect/order_preservation.html
- PEG Parser 9525
- New Starting with DuckDB 2.0, the PEG parser is the default parser. In earlier versions it was an experimental, opt-in feature enabled with enable_peg_parser() , which is no longer required or available. DuckDB uses a parser based on PEG (
...avior is tied to the parser or transformer rather than to downstream code. It provides a best-effort legacy experience and preserves several DuckDB 1.5 quirks: ~ and !~ perform full regular expression matches, whereas DuckDB 2.0 defaults to partial matche... - https://man.mtool.work/duckdb/2.0/sql/peg_parser.html
- Keywords and Identifiers 8386
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
..._á FROM (SELECT 'x' AS col_a); -- fails Preserving cases: While DuckDB treats identifiers in a case-insensitive manner, it preserves the cases of these identifiers. That is, each character's case (uppercase/lowercase) is maintained as originally specified... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- PostgreSQL Compatibility 8386
- DuckDB's SQL dialect closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by
...nsitive. The way PostgreSQL achieves case insensitivity is by lowercasing unquoted identifiers within SQL, whereas quoting preserves case, e.g., the following command creates a table named mytable but tries to query for MyTaBLe because quotes preserve the... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- Spatial Functions 7247
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...Returns a simplified version of the geometry ST_SimplifyPreserveTopology Returns a simplified version of the geometry that preserves topology ST_StartPoint Returns the start point of a LINESTRING. ST_TileEnvelope The ST_TileEnvelope scalar function genera...T_SimplifyPreserveTopology (geom GEOMETRY, tolerance DOUBLE) Description Returns a simplified version of the geometry that preserves topology ST_StartPoint Signatures GEOMETRY ST_StartPoint (geom GEOMETRY) POINT_2D ST_StartPoint (line LINESTRING_2D) Descr... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Aggregate Functions 6109
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...eries of (x, y) points to at most n representative points using the Largest-Triangle-Three-Buckets (LTTB) algorithm, which preserves the visual shape of the series. Returns a LIST of STRUCT s with fields x and y , always including the first and the last p... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work