Results of 1 - 6 of about 6 for InvalidInputException (0.004 sec.)
- Python Function API 12466
- You can create a DuckDB user-defined function (UDF) from a Python function so it can be used in SQL queries. Similarly to regular functions , they need to have a name, a return type and parameter types. Creating Functions To register a Pyth
...print(con.sql("SELECT add_one(41)").fetchall()) [(42,)] UDFs need NumPy. Without the numpy package, create_function raises InvalidInputException: 'numpy' is required for this operation, but it wasn't installed . The signature is create_function(name, function, parame...UDF cannot use the connection that runs its query: such a call raises a ResourceInUseException , and the query fails with InvalidInputException: Python exception occurred while executing the UDF: ResourceInUseException: Resource In Use Error: code running inside a q...annotation accepts any type. The return type must be annotated or given as return_type ; otherwise create_function raises InvalidInputException: Could not infer the return type, please set it explicitly . NULL Handling By default when functions receive a NULL value,... - https://man.mtool.work/duckdb/2.0/clients/python/function.html
- Conversion between DuckDB and Python 10620
- This page documents the rules for converting DuckDB results to Python and Python objects to DuckDB . Result Conversion: DuckDB Results to Python A result is read from a relation or, when using the DB-API / con.execute() , from the connectio
...rules are as follows. str A str that UTF-8 cannot encode, such as one that holds a lone surrogate ( "\ud800" ), raises an InvalidInputException that says it cannot encode str as UTF-8 . The connection stays usable. memoryview A memoryview converts to a BLOB of the b...a UBIGINT , 2**64 and -(2**63) - 1 are HUGEINT and 2**127 is a UHUGEINT . An integer that does not fit in 128 bits raises InvalidInputException: Python integer too large for 128-bit integer type . A subclass of int converts by the value it stores. When using the Duc...g a TIMESTAMPTZ value into Python needs the pytz package, which is not installed with DuckDB; without it, the fetch raises InvalidInputException: Required module 'pytz' failed to import . datetime.datetime.max and datetime.datetime.min convert to ordinary timestamps,... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
- Troubleshooting 8536
- Troubleshooting Running EXPLAIN Renders Newlines In Python, the output of the EXPLAIN statement contains hard line breaks ( \n ): In [1]: import duckdb ...: duckdb.sql("EXPLAIN SELECT 42 AS x") Out[1]: ┌───────────────┬─────────────────────
...fetchone() and fetchall() do, needs the pytz package , which is not installed with DuckDB. Without it, the fetch raises an InvalidInputException saying Required module 'pytz' failed to import . Install pytz with pip install pytz . max_temp_directory_size Is Ignored i... - https://man.mtool.work/duckdb/2.0/clients/python/known_issues.html
- Data Ingestion 8134
- This page contains examples for data ingestion to Python using DuckDB. First, import the DuckDB package: import duckdb Then, proceed with any of the following sections. CSV Files CSV files can be read using the read_csv function, called eit
...mes are read whole, and the filter applies to what they return. A RecordBatchReader can be read once. A second scan raises InvalidInputException: This RecordBatchReader has already been consumed and cannot be scanned again. To scan its data more than once, read it in... - https://man.mtool.work/duckdb/2.0/clients/python/data_ingestion.html
- Relational API 7713
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...ion object from the CSV file in 'name'. The options other than path_or_buffer are keyword arguments; an unknown one raises InvalidInputException . Most are the option of the same name of the SQL read_csv function ; sep and delimiter are delim , dtype is dtypes , na_v...appended. An 'inner' , 'left' , 'right' , 'outer' , 'full' , 'semi' , 'anti' or 'asof' join needs a condition , and raises InvalidInputException without one; a 'cross' , 'positional' or 'natural' join takes none. The joins section of the FROM clause says what each jo... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Python Client API 7311
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...r class duckdb. InternalException Bases: InternalError class duckdb. InterruptException Bases: DatabaseError class duckdb. InvalidInputException Bases: ProgrammingError class duckdb. InvalidTypeException Bases: ProgrammingError class duckdb. IOException Bases: Operat... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work