Results of 1 - 10 of about 12 for Absolute (0.003 sec.)
- ODBC Configuration 13265
- This page documents the files using the ODBC configuration, odbc.ini and odbcinst.ini . These are either placed in the home directory as dotfiles ( .odbc.ini and .odbcinst.ini , respectively) or in a system directory. For platform-specific
...ameters: [ODBC] : The DM configuration section. Trace : Enables the ODBC trace file using the option yes . TraceFile : The absolute system file path for the ODBC trace file. [DuckDB Driver] : The section of the DuckDB installed driver. Driver : The absol... - https://man.mtool.work/duckdb/2.0/clients/odbc/configuration.html
- Numeric Functions 11214
- Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5
...ll numeric data types. Numeric Functions The table below shows the available mathematical functions. Name Description @(x) Absolute value. Parentheses are optional if x is a column name. abs(x) Absolute value. acos(x) Computes the inverse cosine of x . a...tanh(x) Computes the hyperbolic tangent of x . trunc(x) Truncates the number. xor(x, y) Bitwise XOR. @(x) | Description | Absolute value. Parentheses are optional if x is a column name. | | Example | @(-17.4) | | Result | 17.4 | | Alias | abs | abs(x) |...Description | Absolute value. | | Example | abs(-17.4) | | Result | 17.4 | | Alias | @ | acos(x) | Description | Computes the inverse cosine of x... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Share a DuckDB Database That Only Stores Views 9445
- A DuckDB database file does not have to contain any data: it can store only view definitions that point at remote data such as Parquet files on object storage. The resulting file is only a few hundred kilobytes, yet it behaves like a shared
...a persistent database file and define views that reference the remote data. Use fully qualified locations (remote URLs or absolute paths) so that the views resolve regardless of the client's working directory: ATTACH 'catalog.duckdb' AS catalog; USE cat... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_views_only...
- Timestamp Types 9445
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...number of non-leap microseconds since the Unix epoch 1970-01-01 00:00:00+00 , and thus unambiguously identifies a point in absolute time, or instant . The reason for the labels time zone aware and WITH TIME ZONE is that timestamp arithmetic, binning , an...TH TIME ZONE types, it helps to start with two concepts: instants and temporal binning . Instants An instant is a point in absolute time, usually given as a count of some time increment from a fixed point in time (called the epoch ). This is similar to h... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- CSV Import 9144
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...f-8 ). VARCHAR utf-8 filename Add path of the containing file to each row, as a string column named filename . Relative or absolute paths are returned depending on the path or glob pattern provided to read_csv , not just filenames. Since DuckDB 1.3.0, th...3 AA New York, NY Los Angeles, CA The path can either be a relative path (relative to the current working directory) or an absolute path. We can use read_csv to create a persistent table as well: CREATE TABLE ontime AS SELECT * FROM read_csv('flights.csv... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- Unit Tester Configuration 8277
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...orm comment line --data-dir <path> Root dir for test data; default WORKING_DIR/data. Relative values resolve per test cwd; absolute/remote (e.g. az://... ) values are used verbatim. --database-destroy <on|off|on-success> Default on-success: keep on failu... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- Unity Catalog Extension 7977
- The unity_catalog extension attaches a Unity Catalog catalog, on Databricks or Unity Catalog OSS, as a DuckDB database. You can list, read, insert into and create its Delta Lake tables. It uses the delta extension to access the tables. For
...location option, the table is an external table at that location. The location can be any expression that evaluates to an absolute path or a URI: CREATE TABLE my_catalog.my_schema.my_external_table (id INTEGER, name VARCHAR) WITH (location = 's3://⟨my_b... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- Aggregate Functions 7977
- 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
...kurtosis(x) The excess kurtosis (Fisher's definition) with bias correction according to the sample size. mad(x) The median absolute deviation. Temporal types return a positive INTERVAL . median(x) The middle value of the set. For even value counts, quant...isher's definition) with bias correction according to the sample size. | | Formula | - | mad(x) | Description | The median absolute deviation. Temporal types return a positive INTERVAL . | | Formula | median(abs(x - median(x))) | median(x) | Description... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- Spatial Functions 7676
- 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
...element that can be used in an SVG document. The second boolean argument specifies whether the path should be relative or absolute. The third argument specifies the maximum number of digits to use for the coordinates. Points are formatted as cx/cy using...absolute coordinates or x/y using relative coordinates. Example SELECT ST_AsSVG('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))'::GEOMETRY, fal... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- ADBC Client 7393
- Installation To use the DuckDB ADBC client, download the libduckdb archive for your platform and follow the instructions below . For Python, install the duckdb package instead, as described in the Python section . The latest stable version
...n in-memory database is created. uri Alternative to path . Accepts plain paths or file: URIs (e.g., file:test.db , file:///absolute/path.db ). Takes precedence over path if both are set. Connection A set of functions that create and destroy a connection... - https://man.mtool.work/duckdb/2.0/clients/adbc.html
DuckDB 2.0 Documentation / man.mtool.work