Results of 1 - 10 of about 52 for second (0.006 sec.)
- Map Functions – DuckDB 15204
- 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
...ue for a given key as a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_concat(maps...) Returns a map created from...ue for a given key as a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_extract_value(map, key) Returns the value f...or a given key or NULL if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_from_entries(STRUCT(k, v)[]) Returns a map... - https://man.mtool.work/duckdb/1.3/sql/functions/map.html
- Indexing – DuckDB 11515
- 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
...indexing. Examples The index origin is 1 for strings, lists, etc. SELECT list [ 1 ] AS element FROM ( SELECT [ 'first' , 'second' , 'third' ] AS list ); ┌─────────┐ │ element │ │ varchar │ ├─────────┤ │ first │ └─────────┘ The index origin is 0 for JS...ON objects. SELECT json [ 1 ] AS element FROM ( SELECT '["first", "second", "third"]' :: JSON AS json ); ┌──────────┐ │ element │ │ json │ ├──────────┤ │ "second" │ └──────────┘ 関連キーワード ele...ment first second json DuckDB based indexing objects index origin list third Documentation Dialect Copy Markdown Indexing uses except Exampl... - https://man.mtool.work/duckdb/1.3/sql/dialect/indexing.html
- Date Part Functions – DuckDB 9767
- 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
...orian day days , d , dayofmonth 3 decade Gregorian decade dec , decades , decs 202 hour Hours hr , hours , hrs , h 11 microseconds Sub-minute microseconds microsecond , us , usec , usecs , usecond , useconds 44123456 millennium Gregorian millennium mil..., millenniums , millenia , mils , millenium 3 milliseconds Sub-minute milliseconds millisecond , ms , msec , msecs , msecond , mseconds 44123 minute Minutes min , minutes , mins ,...m 59 month Gregorian month mon , months , mons 8 quarter Quarter of the year (1-4) quarters 3 second Seconds sec , seconds , secs , s 44 year Gregorian year yr , y , years , yrs 2021 Part Specifiers Only Usable as Date Part... - https://man.mtool.work/duckdb/1.3/sql/functions/datepart.html
- Spatial Functions – DuckDB 9379
- 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
...lowHoles to a non-zero value to allow output containing holes. ST_Contains Returns true if the first geometry contains the second geometry ST_ContainsProperly Returns true if the first geometry "properly" contains the second geometry ST_ConvexHull Retu...Returns the Voronoi diagram of the supplied MultiPoint geometry ST_Within Returns true if the first geometry is within the second ST_WithinProperly Returns true if the first geometry "properly" is contained by the second geometry ST_X Returns the X coo...or path The SVG fragment is returned as a string. The fragment is a path element that can be used in an SVG document. The second boolean argument specifies whether the path should be relative or absolute. The third argument specifies the maximum numbe... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Schema – DuckDB 9185
- 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 and run the query using the extract datetime function : SELECT avg ( extract ( 'day' FROM creationDate )) FROM Comment ; Second, we use the VARCHAR type and use string operations: SELECT avg ( CAST ( creationDate [ 9 : 10 ] AS INTEGER )) FROM Comment...use the correct (most restrictive) types, i.e., both the id and the ParentCommentId columns are defined as BIGINT . In the second experiment, we define all columns with the VARCHAR type. While the results of the queries are the same for all both experi...rox. 554 million entries. In the first experiments, we create the schema without a primary key, then load the data. In the second experiment, we create the schema with a primary key, then load the data. In the third case, we create the schema without a... - https://man.mtool.work/duckdb/1.3/guides/performance/schema.html
- Interval Functions – DuckDB 9185
- 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
...(part, interval) Alias of date_part . extract(part FROM interval) Alias of date_part . epoch(interval) Get total number of seconds, as double precision floating point number, in interval. to_centuries(integer) Construct a century interval. to_days(inte...uct a day interval. to_decades(integer) Construct a decade interval. to_hours(integer) Construct an hour interval. to_microseconds(integer) Construct a microsecond interval. to_millennia(integer) Construct a millennium interval. to_milliseconds(integer...) Construct a millisecond interval. to_minutes(integer) Construct a minute interval. to_months(integer) Construct a month interval. to_quarters(inte... - https://man.mtool.work/duckdb/1.3/sql/functions/interval.html
- Python DB API – DuckDB 8796
- 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
...rue ) # to explicitly get the default connection con = duckdb . connect ( database = ":default:" ) If you want to create a second connection to an existing database, you can use the cursor() method. This might be useful for example to allow parallel th...example, in the case of a query only returning a single row, fetchone should be called once to retrieve the results and a second time to close the transaction. Below are some short examples: # create a table con . execute ( "CREATE TABLE items (item V...insert a row using a prepared statement : con . execute ( "INSERT INTO items VALUES (?, ?, ?)" , [ "laptop" , 2000 , 1 ]) Second, insert several rows using a prepared statement : con . executemany ( "INSERT INTO items VALUES (?, ?, ?)" , [[ "chainsaw"... - https://man.mtool.work/duckdb/1.3/clients/python/dbapi.html
- List Functions – DuckDB 8796
- 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
...' ])) t ( strings ); strings [HELLO, WORLD] List comprehensions can also use the position of the list elements by adding a second variable. In the following example, we use x, i , where x is the value and i is the position: SELECT [ 4 , 5 , 6 ] AS l ,...xecution of arbitrary existing aggregate functions on the elements of a list. Its first argument is the list (column), its second argument is the aggregate function name, e.g., min , histogram or sum . list_aggregate accepts additional arguments after...the aggregate function name. These extra arguments are passed directly to the aggregate function, which serves as the second argument of list_aggregate . SELECT list_aggregate ([ 1 , 2 , -4 , NULL ], 'min' ); -4 SELECT list_aggregate ([ 2 , 4 , 8... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Time Types – DuckDB 8602
- 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
...ap Live Demo Documentation / SQL / Data Types Copy Markdown Time Types The TIME and TIMETZ types specify the hour, minute, second, microsecond of a day. Name Aliases Description TIME TIME WITHOUT TIME ZONE Time of day (ignores time zone) TIMETZ TIME WI...represent their timestamps. 関連キーワード Time Types types time zone type Documentation Copy Markdown specify hour minute second microsecond Aliases Description ignores uses Instances created using names keyword formatted according format 関連するペー... - https://man.mtool.work/duckdb/1.3/sql/data_types/time.html
- Reading Faulty CSV Files – DuckDB 8408
- 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 Error when converting column "birth_date". date field value out of range: "The 90s", expected format is (DD-MM-YYYY) The second block provides us with potential solutions: Column date is being converted as type DATE This type was auto-detected from t...faulty.csv : Pedro,31 Oogie Boogie, three If you read the CSV file, specifying that the first column is a VARCHAR and the second column is an INTEGER , loading the file would fail, as the string three cannot be converted to an INTEGER . For example, t...FROM read_csv ( 'faulty.csv' , columns = { 'name' : 'VARCHAR' , 'age' : 'INTEGER' }); However, with ignore_errors set, the second row of the file is skipped, outputting only the complete first row. For example: FROM read_csv ( 'faulty.csv' , columns =... - https://man.mtool.work/duckdb/1.3/data/csv/reading_faulty_csv_files.html
DuckDB 1.3 Documentation / man.mtool.work