Results of 1 - 10 of about 53 for bigint (0.004 sec.)
- DuckDB_% Metadata Functions – DuckDB 12666
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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/1.3/sql/meta/duckdb_table_functions.html
- Querying Parquet Metadata – DuckDB 12532
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...'test.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/1.3/data/parquet/metadata.html
- Describe – DuckDB 11535
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...E 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/1.3/guides/meta/describe.html
- DuckLake – DuckDB 11356
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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[]) ducklake_table_info The duckl...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/1.3/core_extensions/ducklake.html
- Timestamp with Time Zone Functions – DuckDB 9749
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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...le now() 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_timestamp(double) Desc...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/1.3/sql/functions/timestamptz.html
- Node.js Client (Neo) – DuckDB 8722
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
..., 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...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...nths": 999, "days": 999, "micros": "999999999" } // ] // ] const rowObjects = reader . getRowObjectsJson (); // [ // { // "bigint": "-9223372036854775808", // "date": "5877642-06-25 (BC)", // "interval": { "months": 0, "days": 0, "micros": "0" } // },... - https://man.mtool.work/duckdb/1.3/clients/node_neo/overview.html
- Types API – DuckDB 8379
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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 DTypes The table below shows the mapping of Numpy DType to DuckDB type. Type DuckDB type bool BOOLEAN fl...oat32 FLOAT float64 DOUBLE int16 SMALLINT int32 INTEGER int64 BIGINT int8 TINYINT uint16 USMALLINT uint32 UINTEGER uint64 UBIGINT uint8 UTINYINT Nested Types list[child_type] list type object...m typing import Union duckdb . typing . DuckDBPyType ( list [ dict [ Union [ str , int ], str ]]) MAP(UNION(u1 VARCHAR, u2 BIGINT), VARCHAR)[] dict[key_type, value_type] dict type objects map to a MAP type of the key type and the value type. import duc... - https://man.mtool.work/duckdb/1.3/clients/python/types.html
- Pragmas – DuckDB 8335
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...low: database_name VARCHAR , -- database name database_size VARCHAR , -- total block count times the block size block_size BIGINT , -- database block size total_blocks BIGINT , -- total blocks in the database used_blocks BIGINT , -- used blocks in the...database free_blocks BIGINT , -- free blocks in the database wal_size VARCHAR , -- write ahead log size memory_usage VARCHAR , -- memory used by the d...info ( 'table_name' ); This call returns the following information for the given table: Name Type Description row_group_id BIGINT column_name VARCHAR column_id BIGINT column_path VARCHAR segment_id BIGINT segment_type VARCHAR start BIGINT The start row... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- Dutch Railway Datasets – DuckDB 8201
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...rg/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/1.3/guides/snippets/dutch_railway_datasets.html
- Timestamp Functions – DuckDB 8156
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
.... last_day(timestamp) The last day of the month. least(timestamp, timestamp) The earlier of two timestamps. make_timestamp(bigint, bigint, bigint, bigint, bigint, double) The timestamp for the given parts. make_timestamp(microseconds) Converts microsec...east(TIMESTAMP '1992-09-20 20:38:48', TIMESTAMP '1992-03-22 01:02:03.1234') Result 1992-03-22 01:02:03.1234 make_timestamp(bigint, bigint, bigint, bigint, bigint, double) Description The timestamp for the given parts. Example make_timestamp(1992, 9, 20... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
DuckDB 1.3 Documentation / man.mtool.work