Results of 1 - 10 of about 20 for Stop (0.002 sec.)
- Dutch Railway Datasets 14189
- 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
...EAN 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 VARCHAR YES NULL NULL NULL...Stop:Arrival time TIMESTAMP WITH TIME ZONE YES NULL NULL NULL Stop:Arrival delay BIGINT YES NULL NULL NULL Stop:Arrival cancell...ed BOOLEAN YES NULL NULL NULL Stop:Departure time TIMESTAMP WITH TIME ZONE YES NULL NULL NULL Stop:Departure delay BIGINT YES NULL NULL NULL Stop:Departure c... - https://man.mtool.work/duckdb/2.0/guides/snippets/dutch_railway_datasets.html
- List Functions 12048
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...list, lambda(x)) Alias for list_filter . flatten(nested_list) Flattens a nested list by one level. generate_series(start[, stop][, step]) Creates a list of values between start and stop - the stop parameter is inclusive. grade_up(list[, col1][, col2]...g elements are replaced with NULL . If truncate is set, all lists are truncated to the smallest list length. range(start[, stop][, step]) Creates a list of values between start and stop - the stop parameter is exclusive. reduce(list, lambda(x,y)[, in...ested list by one level. | | Example | flatten([[1, 2, 3], [4, 5]]) | | Result | [1, 2, 3, 4, 5] | generate_series(start[, stop][, step]) | Description | Creates a list of values between start and stop - the stop parameter is inclusive. | | Example |... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Utility Functions 9822
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...ity Table Functions A table function is used in place of a table in a FROM clause. Name Description generate_series(start, stop, step) Returns a table of values between start and stop (inclusive), incrementing by step . glob(search_path) Return filen...by the search_path in a single column named file . The search_path may contain glob pattern matching syntax . range(start, stop, step) Returns a table of values between start and stop (exclusive), incrementing by step . repeat(value, count) Returns a...ided by the autocomplete extension. unnest(list) Returns a table with one row per element of list . generate_series(start, stop, step) | Description | Returns a table of values between start and stop , incrementing by step . The stop parameter is inc... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Excel Import 9244
- DuckDB supports reading Excel .xlsx files. However, .xls files are not supported. Importing Excel Sheets Use the read_xlsx function in the FROM clause of a query: SELECT * FROM read_xlsx('test_excel.xlsx'); Alternatively, you can omit the r
...cutive non-empty cells and the first empty row spanning the same columns. By default, if no range is provided, DuckDB will stop reading the Excel file when encountering an empty row. But when a range is provided, the default is to read until the end...of the range. This behavior can be controlled with the stop_at_empty parameter: -- Read the first 100 rows, or until the first empty row, whichever comes first SELECT * FROM read_xls...x('test_excel.xlsx', range = '1:100', stop_at_empty = true); -- Always read the whole sheet, even if it contains empty rows SELECT * FROM read_xlsx('test_excel.xlsx'... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_import.html
- UI Extension 8887
- The ui extension adds a user interface for your local DuckDB instance. Usage To start the UI from the command line: duckdb -ui To start the UI from SQL: CALL start_ui(); Running either of these will open the UI in your default browser. The
...erage all the resources of your local environment: all cores, memory and files. Closing this instance will cause the UI to stop working. The UI is served from an HTTP server embedded in DuckDB. To start this server without launching the browser, run:...CALL start_ui_server(); You can then load the UI in your browser by navigating to http://localhost:4213 . To stop the HTTP server, run: CALL stop_ui_server(); Local Query Execution By default, the DuckDB UI runs your queries fully local... - https://man.mtool.work/duckdb/2.0/core_extensions/ui.html
- Community Extensions 8089
- Community-contributed extensions can be installed from the Community Extensions repository since summer 2024 . Please visit the “Community Extensions” section of the documentation for more details. Warning Community extensions are contribut
...form (macOS on Intel). DuckDB and its core extensions are still available for osx_amd64 in DuckDB 2.0, but DuckDB 2.1 will stop supporting this platform. See the list of supported platforms .... - https://man.mtool.work/duckdb/2.0/extensions/community_extensions.html
- Excel Extension 8021
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...ar region of cells between the first row of consecutive non-empty cells and the first empty row spanning the same columns. stop_at_empty BOOLEAN automatically inferred Whether to stop reading the file when an empty row is encountered. If an explicit... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- Create Synthetic Data 8021
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...Python function API using cross products (Cartesian products) range and generate_series The range functions turn a start, stop, and step into a table of rows, which is the usual starting point for a synthetic dataset: SELECT i FROM range(1, 4) t(i);...┌───────┐ │ i │ │ int64 │ ├───────┤ │ 1 │ │ 2 │ │ 3 │ └───────┘ range excludes the stop value, while generate_series includes it. VALUES The VALUES clause generates rows from literal tuples, which is convenient... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Quack Remote Protocol 7885
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...494 quack:[::1]:1234 ::1 1234 (IPv6) You can parse and validate a URI with the quack_uri_parser(uri, ssl) scalar function. Stopping a Server To stop a server, run: {:.codebox-server} CALL quack_stop('quack:localhost'); Client-Side Usage There are thr... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Requirements 7817
- DuckDB is designed to be portable and has very few runtime dependencies. Still, there are a few requirements to be aware of before installing or running DuckDB. Supported Platforms DuckDB officially supports Linux, macOS and Windows on both
...ibuted for this platform but, starting with DuckDB 2.0.0, community extensions are no longer built for it. DuckDB 2.1 will stop supporting osx_amd64 . DuckDB can also run on other platforms, such as Linux distributions using musl libc (e.g., Alpine L... - https://man.mtool.work/duckdb/2.0/operations_manual/installing_duckdb/requiremen...
DuckDB 2.0 Documentation / man.mtool.work