Results of 1 - 10 of about 28 for None (0.009 sec.)
- Python Client API – DuckDB 15468
- 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
...log (WAL) to the database data file (no-op for in-memory connections) close ( self : duckdb.duckdb.DuckDBPyConnection ) → None ¶ Close the connection commit ( self : duckdb.duckdb.DuckDBPyConnection ) → duckdb.duckdb.DuckDBPyConnection ¶ Commit chan...ansaction create_function ( self: duckdb.duckdb.DuckDBPyConnection , name: str , function: Callable , parameters: object = None , return_type: duckdb.duckdb.typing.DuckDBPyType = None , * , type: duckdb.duckdb.functional.PythonUDFType = <PythonUDFTyp...sisting of the list of ‘values' execute ( self : duckdb.duckdb.DuckDBPyConnection , query : object , parameters : object = None ) → duckdb.duckdb.DuckDBPyConnection ¶ Execute the given SQL query, optionally using prepared statements with parameters s... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- Relational API – DuckDB 11814
- 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
...o the CSV file or buffer to read from. header : Optional[bool], Optional[int] Row number(s) to use as the column names, or None if no header. compression : Optional[str] Compression type (e.g., 'gzip', 'bz2'). sep : Optional[str] Delimiter to use; de...False , filename : bool = False , hive_partitioning : bool = False , union_by_name : bool = False , compression : object = None ) -> duckdb . duckdb . DuckDBPyRelation Create a relation object from the Parquet files in file_glob 2. from_parquet ( sel...False , filename : bool = False , hive_partitioning : bool = False , union_by_name : bool = False , compression : object = None ) -> duckdb . duckdb . DuckDBPyRelation Create a relation object from the Parquet files in file_globs Description Create a... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Python Function API – DuckDB 9323
- 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 connection catalog. function The Python function you wish to register as a UDF. parameters Scalar functions can operate on one or more columns. This parameter takes a list of column types used as input. return_type Scalar functions return one eleme...varchar │ ├─────────────┤ │ 42 │ └─────────────┘ If only the parameter list types can be inferred, you'll need to pass in None as parameters . NULL Handling By default when functions receive a NULL value, this instantly returns NULL , as part of the...nt_intercept_null , [ BIGINT ], BIGINT ) res = duckdb . sql ( "SELECT dont_intercept(NULL)" ). fetchall () print ( res ) [(None,)] With null_handling="special" : import duckdb from duckdb.typing import * def dont_intercept_null ( x ): return 5 duckdb... - https://man.mtool.work/duckdb/1.3/clients/python/function.html
- Expression API – DuckDB 8848
- 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
...erences a column by name. import duckdb import pandas as pd df = pd . DataFrame ({ 'a' : [ 1 , 2 , 3 , 4 ], 'b' : [ True , None , False , True ], 'c' : [ 42 , 21 , 13 , 14 ] }) Selecting a single column: col = duckdb . ColumnExpression ( 'a' ) duckdb...r strings or Expressions. import duckdb import pandas as pd df = pd . DataFrame ({ 'a' : [ 1 , 2 , 3 , 4 ], 'b' : [ True , None , False , True ], 'c' : [ 42 , 21 , 13 , 14 ] }) star = duckdb . StarExpression ( exclude = [ 'b' ]) duckdb . df ( df ). s...contains a single value. import duckdb import pandas as pd df = pd . DataFrame ({ 'a' : [ 1 , 2 , 3 , 4 ], 'b' : [ True , None , False , True ], 'c' : [ 42 , 21 , 13 , 14 ] }) const = duckdb . ConstantExpression ( 'hello' ) duckdb . df ( df ). selec... - https://man.mtool.work/duckdb/1.3/clients/python/expression.html
- Python DB API – DuckDB 7996
- 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
...The transaction will only close once fetchone is called and there are no more results remaining (the return value will be None ). As an example, in the case of a query only returning a single row, fetchone should be called once to retrieve the resul...cimal('42.20'), 2) print ( con . fetchone ()) # This closes the transaction. Any subsequent calls to .fetchone will return None # None The description property of the connection object contains the column names as per the standard. Prepared Statement... - https://man.mtool.work/duckdb/1.3/clients/python/dbapi.html
- Full-Text Search Extension – DuckDB 7996
- 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
...wegian' , 'porter' , 'portuguese' , 'romanian' , 'russian' , 'serbian' , 'spanish' , 'swedish' , 'tamil' , 'turkish' , or 'none' if no stemming is to be used. Defaults to 'porter' stopwords VARCHAR Qualified name of table containing a single VARCHAR...column containing the desired stopwords, or 'none' if no stopwords are to be used. Defaults to 'english' for a pre-defined list of 571 English stopwords ignore VARCHAR Regu...wegian' , 'porter' , 'portuguese' , 'romanian' , 'russian' , 'serbian' , 'spanish' , 'swedish' , 'tamil' , 'turkish' , or 'none' if no stemming is to be used. Example Usage Create a table and fill it with text data: CREATE TABLE documents ( document_... - https://man.mtool.work/duckdb/1.3/core_extensions/full_text_search.html
- COPY Statement – DuckDB 7996
- 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
...he generated file(s). VARCHAR auto PER_THREAD_OUTPUT When true , the COPY command generates one file per thread, rather than one file in total. This allows for faster parallel writing. BOOL false FILE_SIZE_BYTES If this parameter is set, the COPY pro...utomatically from the file extension (e.g., file.csv.gz will use gzip , file.csv.zst will use zstd , and file.csv will use none ). Options are none , gzip , zstd . VARCHAR auto DATEFORMAT Specifies the date format to use when writing dates. See Date...matically from the file extension (e.g., file.json.gz will use gzip , file.json.zst will use zstd , and file.json will use none ). Options are none , gzip , zstd . VARCHAR auto DATEFORMAT Specifies the date format to use when writing dates. See Date... - https://man.mtool.work/duckdb/1.3/sql/statements/copy.html
- Loading JSON – DuckDB 7865
- 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
...le. By default this will be detected automatically from the file extension (e.g., t.json.gz will use gzip, t.json will use none). Options are none , gzip , zstd and auto_detect . VARCHAR auto_detect filename Whether or not an extra filename column sh...le. By default this will be detected automatically from the file extension (e.g., t.json.gz will use gzip, t.json will use none). Options are uncompressed , gzip , zstd and auto_detect . VARCHAR auto_detect convert_strings_to_integers Whether strings... - https://man.mtool.work/duckdb/1.3/data/json/loading_json.html
- Configuration – DuckDB 7832
- 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
...duckdb database files (new as-in, they do not yet exist). UBIGINT 262144 default_collation The collation setting used when none is specified VARCHAR default_null_order , null_order NULL ordering used when none is specified ( NULLS_FIRST or NULLS_LAST...) VARCHAR NULLS_LAST default_order The order type used when none is specified ( ASC or DESC ) VARCHAR ASC default_secret_storage Allows switching the default storage for secrets VARCHAR l... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- Reading Multiple Files – DuckDB 7832
- 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
...syntax to read multiple files that match a pattern. Wildcard Description * Matches any number of any characters (including none) ** Matches any number of subdirectories (including none) ? Matches any single character [abc] Matches one character given... - https://man.mtool.work/duckdb/1.3/data/multiple_files/overview.html
DuckDB 1.3 Documentation / man.mtool.work