Results of 1 - 10 of about 27 for World (0.004 sec.)
- Regular Expressions – DuckDB 14252
- 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
...lit_regex . Splits the string along the regex . A set of optional options can be set. Example regexp_split_to_array('hello world; 42', ';? ') Result ['hello', 'world', '42'] regexp_split_to_table(string, regex[, options]) Description Splits the string...long the regex and returns a row for each part. A set of optional options can be set. Example regexp_split_to_table('hello world; 42', ';? ') Result Three rows: 'hello' , 'world' , '42' The regexp_matches function is similar to the SIMILAR TO operator...bcd' , 'ABC' , 'i' ); -- true SELECT regexp_matches ( 'ab^/$cd' , '^/$' , 'l' ); -- true SELECT regexp_matches ( E 'hello\nworld' , 'hello.world' , 'p' ); -- false SELECT regexp_matches ( E 'hello\nworld' , 'hello.world' , 's' ); -- true Using regexp_... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Text Functions – DuckDB 11998
- 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
...catenates multiple strings, lists, or blobs. NULL inputs are skipped. See also operator || . Example concat('Hello', ' ', 'World') Result Hello World concat_ws(separator, string, ...) Description Concatenates many strings, separated by separator . NUL...ption Splits the string along the regex . A set of optional regex options can be set. Example regexp_split_to_array('hello world; 42', ';? ') Result [hello, world, 42] Aliases str_split_regex , string_split_regex regexp_split_to_table(string, regex) D...escription Splits the string along the regex and returns a row for each part. Example regexp_split_to_table('hello world; 42', ';? ') Result Multiple rows: 'hello' , 'world' , '42' repeat(string, count) Description Repeats the string count num... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Literal Types – DuckDB 10450
- 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
...literals separated only by whitespace that contains at least one newline are implicitly concatenated: SELECT 'Hello' ' ' 'World' AS greeting ; is equivalent to: SELECT 'Hello' || ' ' || 'World' AS greeting ; They both return the following result: gre...eting Hello World Note that implicit concatenation only works if there is at least one newline between the literals. Using adjacent string l...iterals separated by whitespace without a newline results in a syntax error: SELECT 'Hello' ' ' 'World' AS greeting ; Parser Error: syntax error at or near "' '" LINE 1: SELECT 'Hello' ' ' 'World' AS greeting; ^ Also note tha... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Expression API – DuckDB 9759
- 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
..., 2 , 3 , 4 ], 'b' : [ True , None , False , True ], 'c' : [ 42 , 21 , 13 , 14 ] }) hello = ConstantExpression ( 'hello' ) world = ConstantExpression ( 'world' ) case = \ CaseExpression ( condition = ColumnExpression ( 'b' ) == False , value = world )...). select ( case ). show () ┌──────────────────────────────────────────────────────────┐ │ CASE WHEN ((b = false)) THEN ('world') ELSE 'hello' END │ │ varchar │ ├──────────────────────────────────────────────────────────┤ │ hello │ │ hello │ │ world...ColumnExpression list show SQLExpression alias expressions pandas DataFrame None ConstantExpression case constant contains world selecting multiply provided order Indicates 関連するページ Python Client API Star Expression Import from Pandas Regular Ex... - https://man.mtool.work/duckdb/1.3/clients/python/expression.html
- Importing Duckbox Tables – DuckDB 9084
- 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 DuckDB v1.2.0 release blog post : ┌─────────┬───────┐ │ a │ b │ │ varchar │ int64 │ ├─────────┼───────┤ │ hello │ 42 │ │ world │ 84 │ └─────────┴───────┘ What if we would like to load this data back to DuckDB? This is not supported by default but it...*//;s/ *│ $/ /;s/ *│ */│/g" duckbox.csv >> duckbox-cleaned.csv The duckbox-cleaned.csv file looks as follows: a│b hello│42 world│84 We can then simply load this to DuckDB via: FROM read_csv ( 'duckbox-cleaned.csv' , delim = '│' ); And export it to a C...SV: COPY ( FROM read_csv ( 'duckbox-cleaned.csv' , delim = '│' )) TO 'out.csv' ; a,b hello,42 world,84 Using shellfs To parse duckbox tables with a single read_csv call – and without creating any temporary files –, we can... - https://man.mtool.work/duckdb/1.3/guides/snippets/importing_duckbox_tables.html
- Directly Reading Files – DuckDB 8591
- 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
.../sql/table_function/files/*.txt' ); size parse_path(filename) content 12 [test, sql, table_function, files, one.txt] Hello World! 2 [test, sql, table_function, files, three.txt] 42 10 [test, sql, table_function, files, two.txt] Foo Bar\nFöö Bär The fi...filename 178 PK\x03\x04\x0A\x00\x00\x00\x00\x00\xACi=X\x14t\xCE\xC7\x0A… test/sql/table_function/files/four.blob 12 Hello World! test/sql/table_function/files/one.txt 2 42 test/sql/table_function/files/three.txt 10 F\xC3\xB6\xC3\xB6 B\xC3\xA4r test/s...ーワード read table files content size text blob filename column functions DuckDB glob last reads selected parse path Hello World three valid instead Documentation Guides Formats 関連するページ Caveats Reading and Writing Parquet Files Reading Multiple... - https://man.mtool.work/duckdb/1.3/guides/file_formats/read_file.html
- Casting – DuckDB 8492
- 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
...to a number if the input is an INTEGER : CREATE TABLE tbl ( i INTEGER , s VARCHAR ); INSERT INTO tbl VALUES ( 42 , 'hello world' ); CREATE MACRO conditional_add ( col , nr ) AS CASE WHEN typeof ( col ) == 'INTEGER' THEN cast_to_type ( col :: INTEGER...OLUMNS ( * ), 100 ) FROM tbl ; ┌───────┬─────────────┐ │ i │ s │ │ int32 │ varchar │ ├───────┼─────────────┤ │ 142 │ hello world │ └───────┴─────────────┘ Note that the CASE statement needs to return the same type in all code paths. We can perform the...casting also throw return syntax explicit expr DuckDB generate series convert behavior instead allows column macros input world addition 関連するページ Typecasting JSON Type Union Type CREATE TYPE Statement Nested Functions ALTER TABLE Statement See... - https://man.mtool.work/duckdb/1.3/sql/expressions/cast.html
- CREATE SEQUENCE Statement – DuckDB 8294
- 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
...CREATE TABLE tbl ( id INTEGER DEFAULT nextval ( 'id_sequence' ), s VARCHAR ); INSERT INTO tbl ( s ) VALUES ( 'hello' ), ( 'world' ); SELECT * FROM tbl ; The script results in the following table: id s 1 hello 2 world Sequences can also be added using...and fills it with values generated by the sequence: CREATE TABLE tbl ( s VARCHAR ); INSERT INTO tbl VALUES ( 'hello' ), ( 'world' ); CREATE SEQUENCE id_sequence START 1 ; ALTER TABLE tbl ADD COLUMN id INTEGER DEFAULT nextval ( 'id_sequence' ); SELECT... - https://man.mtool.work/duckdb/1.3/sql/statements/create_sequence.html
- Command Line Arguments – DuckDB 7998
- 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
...rder, similarly to the behavior of the SQLite CLI. For example: duckdb -csv -c 'SELECT 42 AS hello' -json -c 'SELECT 84 AS world' Returns the following: hello 42 [{"world":84}] 関連キーワード output mode DuckDB line list table command options database... - https://man.mtool.work/duckdb/1.3/clients/cli/arguments.html
- List Functions – DuckDB 7899
- 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
...over elements in a list. For example: SELECT [ lower ( x ) FOR x IN strings ] AS strings FROM ( VALUES ([ 'Hello' , '' , 'World' ])) t ( strings ); strings [hello, , world] SELECT [ upper ( x ) FOR x IN strings IF len ( x ) > 0 ] AS strings FROM ( VA...LUES ([ 'Hello' , '' , 'World' ])) t ( strings ); strings [HELLO, WORLD] List comprehensions can also use the position of the list elements by adding a... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
DuckDB 1.3 Documentation / man.mtool.work