Results of 1 - 10 of about 66 for bigint (0.002 sec.)
- Querying Parquet Metadata 11772
- Parquet Metadata The parquet_metadata function can be used to query the metadata contained within a Parquet file, which reveals various internal details of the Parquet file such as the statistics of the different columns. This can be useful
...data/*.parquet'); Below is a table of the columns returned by parquet_metadata . Field Type file_name VARCHAR row_group_id BIGINT row_group_num_rows BIGINT row_group_num_columns BIGINT row_group_bytes BIGINT column_id BIGINT file_offset BIGINT num_valu...es BIGINT path_in_schema VARCHAR type VARCHAR stats_min VARCHAR stats_max VARCHAR stats_null_count BIGINT stats_distinct_count BIGIN...T stats_min_value VARCHAR stats_max_value VARCHAR compression VARCHAR encodings VARCHAR index_page_offset BIGINT dictionary_page_offset BIGINT data_page_offset BIGINT total_compressed_size BIGINT total_uncompressed_size BIGINT key_valu... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
- Describe 11701
- Describing a Table To view the schema of a table, use the DESCRIBE statement (or its alias DESC ) followed by the table name. CREATE TABLE tbl (i INTEGER PRIMARY KEY, j VARCHAR); DESCRIBE tbl; column_name column_type null key default extra
...BE TABLE 'https://blobs.duckdb.org/data/Star_Trek-Season_1.csv'; column_name column_type null key default extra season_num BIGINT YES NULL NULL NULL episode_num BIGINT YES NULL NULL NULL aired_date DATE YES NULL NULL NULL cnt_kirk_hookups BIGINT YES NU...LL NULL NULL cnt_downed_redshirts BIGINT YES NULL NULL NULL bool_aliens_almost_took_over_planet BIGINT YES NULL NULL NULL bool_aliens_almost_took_over_enterprise B...IGINT YES NULL NULL NULL cnt_vulcan_nerve_pinch BIGINT YES NULL NULL NULL cnt_warp_speed_orders BIGINT YES NULL NULL NULL highest_warp_speed_issued BIGINT YES NULL NULL NULL boo... - https://man.mtool.work/duckdb/2.0/guides/meta/describe.html
- DuckDB_% Metadata Functions 11701
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...that contains the column object. VARCHAR database_oid Internal identifier of the database that contains the column object. BIGINT schema_name The SQL name of the schema that contains the table object that defines this column. VARCHAR schema_oid Interna...l identifier of the schema object that contains the table of the column. BIGINT table_name The SQL name of the table that defines the column. VARCHAR table_oid Internal identifier (name) of the table ob...ject that defines the column. BIGINT column_name The SQL name of the column. VARCHAR column_index The unique position of the column within its table. INTEGER c... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- DuckLake 11415
- DuckLake 1.1 was released together with DuckDB 2.0. Read the announcement blog post . The ducklake extension adds support for attaching to databases stored in the DuckLake format . The complete documentation of this extension is available a
...catalog VARCHAR no The information is encoded into a table with the following schema: Column name Column type snapshot_id BIGINT snapshot_time TIMESTAMP WITH TIME ZONE schema_version BIGINT changes MAP(VARCHAR, VARCHAR[]) author VARCHAR commit_message...no The information is encoded into a table with the following schema: Column name Column type table_name VARCHAR schema_id BIGINT table_id BIGINT table_uuid UUID file_count BIGINT file_size_bytes BIGINT delete_file_count BIGINT delete_file_size_bytes B...ven versions or timestamps. The function has two variants, depending on whether start_snapshot and end_snapshot have types BIGINT or TIMESTAMP WITH TIME ZONE . Parameter name Parameter type Named parameter Description catalog VARCHAR no schema_name VAR... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- ODBC Extension Functions 10302
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...starts another implicit transaction on this connection. See Transaction management for details. Parameters: conn_handle ( BIGINT ): ODBC connection handle created with odbc_connect Returns: Always returns NULL ( VARCHAR ). Example: SELECT odbc_begin_t...ransaction(getvariable('conn')) odbc_bind_params odbc_bind_params(conn_handle BIGINT, params_handle BIGINT, params STRUCT) -> BIGINT Binds specified parameter values to the specified parameters handle. Only...necessary with 2-step parameters binding, see Query parameters for details. Parameters: conn_handle ( BIGINT ): ODBC connection handle created with odbc_connect params_handle ( BIGINT ): parameters handle created with odbc_create_p... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Timestamp with Time Zone Functions 9061
- This section describes functions and operators for examining and manipulating TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ ) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In th
...Current date and time (start of current transaction). timetz_byte_comparable(timetz) Converts a TIME WITH TIME ZONE to a UBIGINT sort key. to_timestamp(double) Converts seconds since the epoch to a timestamp with time zone. transaction_timestamp() Cur...Result | 2022-10-08 12:44:46.122-07 | timetz_byte_comparable(timetz) | Description | Converts a TIME WITH TIME ZONE to a UBIGINT sort key. | | Example | timetz_byte_comparable('18:18:16.21-07:00'::TIMETZ) | | Result | 2494691656335442799 | to_timestam...estamptz) Get subfield from a TIMESTAMP WITH TIME ZONE . last_day(timestamptz) The last day of the month. make_timestamptz(bigint, bigint, bigint, bigint, bigint, double, string) The TIMESTAMP WITH TIME ZONE for the given parts and time zone. make_time... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Dutch Railway Datasets 8647
- Examples in this documentation often use datasets based on the Dutch Railway datasets . These high-quality datasets are maintained by the team behind the Rijden de Treinen (Are the trains running?) application . This page contains download
....org/nl-railway/services-2025-03.csv.gz'; DESCRIBE services; column_name column_type null key default extra Service:RDT-ID BIGINT YES NULL NULL NULL Service:Date DATE YES NULL NULL NULL Service:Type VARCHAR YES NULL NULL NULL Service:Company VARCHAR YE...S NULL NULL NULL Service:Train number BIGINT YES NULL NULL NULL Service:Completely cancelled BOOLEAN YES NULL NULL NULL Service:Partly cancelled BOOLEAN YES NULL NULL...NULL Service:Maximum delay BIGINT YES NULL NULL NULL Stop:RDT-ID BIGINT YES NULL NULL NULL Stop:Station code VARCHAR YES NULL NULL NULL Stop:Station name VA... - https://man.mtool.work/duckdb/2.0/guides/snippets/dutch_railway_datasets.html
- Types API 8604
- The DuckDBPyType class, duckdb.sqltypes.DuckDBPyType , represents one of the data types . Use DuckDBPyType to describe SQL types when declaring function parameters, return types or casts. Python types such as int are accepted too: int descr
...ibes BIGINT . Converting a data value such as 5 follows different rules; see Python Object Conversion . Converting from Other Types Wh...f Python Built-in types to DuckDB type. Built-in types DuckDB type bool BOOLEAN bytearray BLOB bytes BLOB float DOUBLE int BIGINT str VARCHAR NumPy Scalar Types The table below shows the mapping of NumPy scalar types to DuckDB type. A NumPy dtype objec...kDB type numpy.bool_ BOOLEAN numpy.float32 FLOAT numpy.float64 DOUBLE numpy.int16 SMALLINT numpy.int32 INTEGER numpy.int64 BIGINT numpy.int8 TINYINT numpy.uint16 USMALLINT numpy.uint32 UINTEGER numpy.uint64 UBIGINT numpy.uint8 UTINYINT Type Names A str... - https://man.mtool.work/duckdb/2.0/clients/python/types.html
- Node.js Client (Neo) 8319
- Installation To use the DuckDB Node.js client, visit the Node.js installation page . The latest stable version of the DuckDB Node.js (Neo) client is 2.0.0. An API for using DuckDB in Node.js . The primary package, @duckdb/node-api , is a hi
...1, 12]), }); Specifying Values Values of many data types are represented using one of the JS primitives boolean , number , bigint , or string . Also, any type can have null values. Values of some data types need to be constructed using special function...representation BOOLEAN boolean TINYINT , SMALLINT , INTEGER , UTINYINT , USMALLINT , UINTEGER number FLOAT , DOUBLE number BIGINT , HUGEINT , UBIGINT , UHUGEINT bigint VARCHAR , ENUM string Types represented as a specialized object (see Inspect Data Va...to do this. Examples (using the Json forms): const reader = await connection.runAndReadAll( 'from test_all_types() select bigint, date, interval limit 2' ); const rows = reader.getRowsJson(); // [ // [ // "-9223372036854775808", // "5877642-06-25 (BC)... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
- Lance Extension 8205
- The lance extension adds support for reading and writing Lance tables. Lance is a modern lakehouse format optimized for ML/AI workloads, with native cloud storage support. Installing and Loading You can install the lance extension from Duck
...atement to materialize query results as a Lance dataset. -- Create/overwrite a Lance dataset from a query COPY ( SELECT 1::BIGINT AS id, 'a'::VARCHAR AS s UNION ALL SELECT 2::BIGINT AS id, 'b'::VARCHAR AS s ) TO '⟨path/to/dataset.lance⟩' ( FORMAT lance...placement scan SELECT count(*) FROM '⟨path/to/dataset.lance⟩'; -- Append more rows to an existing dataset COPY ( SELECT 3::BIGINT AS id, 'c'::VARCHAR AS s ) TO '⟨path/to/dataset.lance⟩' ( FORMAT lance, MODE 'append' ); -- Optionally create an empty dat...aset (schema only) COPY ( SELECT 1::BIGINT AS id, 'x'::VARCHAR AS s WITH NO DATA ) TO 'path/to/empty.lance' ( FORMAT lance, MODE 'overwrite', WRITE_EMPTY_FILE true )... - https://man.mtool.work/duckdb/2.0/core_extensions/lance.html
DuckDB 2.0 Documentation / man.mtool.work