Results of 1 - 10 of about 115 for like (0.004 sec.)
- Pattern Matching – DuckDB 17515
- 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
...y Markdown Pattern Matching There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions.... LIKE The LIKE expression returns true if the string matches the supplied pattern. (As expected, the NOT LIKE expression returns...false if LIKE returns true , and vice versa. An equivalent expression is NOT (string LIKE pattern) .) If pattern does not contain percen... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- Text Functions – DuckDB 11551
- 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
...in or end arguments are interpreted as the beginning or end of the list respectively. Negative values are accepted. string LIKE target Returns true if the string matches the like specifier (see Pattern Matching ). string SIMILAR TO regex Returns true...of the value . Note that this is not a cryptographic hash. hex(string) Converts the string to hexadecimal representation. ilike_escape(string, like_specifier, escape_character) Returns true if the string matches the like_specifier (see Pattern Matchi...n string . length(string) Number of characters in string . length_grapheme(string) Number of grapheme clusters in string . like_escape(string, like_specifier, escape_character) Returns true if the string matches the like_specifier (see Pattern Matchi... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- UI Extension – DuckDB 7985
- 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
...n By default, the DuckDB UI runs your queries fully locally: your queries and data never leave your computer. If you would like to use MotherDuck through the UI, you have to opt-in explicitly and sign into MotherDuck. Configuration Local Port The loc...al port of the HTTP server can be configured with a SQL command like: SET ui_local_port = 4213 ; The environment variable ui_local_port can also be used. The default port is 4213. (Why? 4 = D...default URL for the remote server is https://ui.duckdb.org . An alternate remote URL can be configured with a SQL command like: SET ui_remote_url = 'https://ui.duckdb.org' ; The environment variable ui_remote_port can also be used. This setting is a... - https://man.mtool.work/duckdb/1.3/core_extensions/ui.html
- Securing Extensions – DuckDB 7546
- 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
...y Extensions repository , which allows convenient installation of third-party extensions. Community extension repositories like pip or npm are essentially enabling remote code execution by design. This is less dramatic than it sounds. For better or w...our shells, and routinely install a staggering amount of transitive dependencies without thinking twice. Some repositories like CRAN enforce a human inspection at some point, but that's no guarantee for anything either. We've studied several differen...a step down from reviewing everything manually. We allow users to report malicious extensions and show adoption statistics like GitHub stars and download count. Because we manage the repository, we can remove problematic extensions from distribution... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/securing_ext...
- Profiling – DuckDB 7370
- 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 OPERATOR_ROWS_SCANNED CPU_TIME measures the cumulative operator timings. It does not include time spent in other stages, like parsing, query planning, etc. Thus, for some queries, the LATENCY in the QUERY_ROOT can be greater than the CPU_TIME . Det...OPERATOR_CARDINALITY": "true", "OPERATOR_TIMING": "true"}' ; SELECT name FROM students JOIN exams USING ( sid ) WHERE name LIKE 'Ma%' ; The file's content after executing the query: { "extra_info" : {}, "query_name" : "SELECT name \n FROM students \n...JOIN exams USING (sid) \n WHERE name LIKE 'Ma%';" , "children" : [ { "operator_timing" : 0.000001 , "operator_cardinality" : 2 , "operator_type" : "PROJECTION" , "e... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
- Gitignore for DuckDB – DuckDB 7270
- 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
...nore configuration snippets for DuckDB. Ignore Temporary Files but Keep Database This configuration is useful if you would like to keep the database file in the version control system: *.wal *.tmp/ Ignore Database and Temporary Files If you would lik...p/ 関連キーワード DuckDB Gitignore files database Files configuration duckdb temporary following Ignore Temporary Database like wal extension Documentation Operations Footprint Copy Markdown work repository want to configure disable 関連するページ Fi... - https://man.mtool.work/duckdb/1.3/operations_manual/footprint_of_duckdb/gitignor...
- Star Expression – DuckDB 7270
- 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
...col1 AS height , col2 AS width ) FROM tbl ; Column Filtering via Pattern Matching Operators The pattern matching operators LIKE , GLOB , SIMILAR TO and their variants allow you to select columns by matching their names to patterns. SELECT * LIKE 'col...eturned. This allows the execution of arbitrary expressions in order to select and rename columns. SELECT COLUMNS ( c -> c LIKE '%num%' ) FROM numbers ; number 10 20 NULL COLUMNS List COLUMNS also supports passing in a list of column names. SELECT CO...he previously mentioned capabilities. The difference is in how the expression expands. *COLUMNS will expand in-place, much like the iterable unpacking behavior in Python , which inspired the * syntax. This implies that the expression expands into the... - https://man.mtool.work/duckdb/1.3/sql/expressions/star.html
- Logging – DuckDB 7094
- 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 enabled or disabled using pragmas. By default, logs are stored in a special table called duckdb_logs that can be queried like any other table. Example: PRAGMA enable_logging ; -- Run some queries.. SELECT * FROM duckdb_logs ; Log Level DuckDB suppo...set the correct log level, and will add the HTTP type to the enabled_log_types settings. Structured Logging Some log types like HTTP will have an associated message schema. To make DuckDB automatically parse the message, use the duckdb_logs_parsed()...es messages Logging information using duckdb enable type default level Types message automatically mechanism enabled table like queries warnings errors detailed 関連するページ Python Function API Pragmas Reading Faulty CSV Files Analyzing a Git Repos... - https://man.mtool.work/duckdb/1.3/operations_manual/logging/overview.html
- SQL Introduction – DuckDB 7094
- 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
...'s columns. This kind of query is called an outer join. (The joins we have seen so far are inner joins.) The command looks like this: SELECT * FROM weather LEFT OUTER JOIN cities ON weather.city = cities.name ; city temp_lo temp_hi prcp date name lat...which there is no right-table match, empty (null) values are substituted for the right-table columns. Aggregate Functions Like most other relational database products, DuckDB supports aggregate functions. An aggregate function computes a single resu...ies that have all temp_lo values below 40. Finally, if we only care about cities whose names begin with S , we can use the LIKE operator: SELECT city , max ( temp_lo ) FROM weather WHERE city LIKE 'S%' -- (1) GROUP BY city HAVING max ( temp_lo ) < 40... - https://man.mtool.work/duckdb/1.3/sql/introduction.html
- Array Type – DuckDB 7006
- 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
...lue function: SELECT array_value ( 1 , 2 , 3 ); You can always implicitly cast an array to a list (and use list functions, like list_extract , [i] ): SELECT array_value ( 1 , 2 , 3 )[ 2 ]; You can cast from a list to an array (the dimensions have to...ieving one or more values from an array can be accomplished using brackets and slicing notation, or through list functions like list_extract and array_extract . Using the example in Defining an Array Field . The following queries for extracting the s...le extract element length store using types values column fixed arrays fields used embeddings variable nested created cast like Defining example 関連するページ List Type Nested Functions Map Type JSON Type List Functions Indexing See this page as Mar... - https://man.mtool.work/duckdb/1.3/sql/data_types/array.html
DuckDB 1.3 Documentation / man.mtool.work