Results of 1 - 7 of about 7 for mask (0.006 sec.)
- Vectors 13322
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...s NULL , the values contained within the primary array at that index is undefined (and can be uninitialized). The validity mask is a bitmask consisting of uint64_t elements. For every 64 values in the vector, one uint64_t element exists (rounded up)....The validity mask has its bit set to 1 if the value is valid, or set to 0 if the value is invalid (i.e., NULL ). The bits of the bitmask can...lid can be used to check whether or not a value is NULL . The duckdb_vector_get_validity returns a pointer to the validity mask. Note that if all values in a vector are valid, this function might return nullptr in which case the validity mask does no... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- Import from Numpy 9178
- It is possible to query Numpy arrays from DuckDB. There is no need to register the arrays manually – DuckDB can find them in the Python process by name thanks to replacement scans . For example: import duckdb import numpy as np columns = {
...ray, treating each outer array as a column. Transpose an array whose outer dimension represents rows before querying it. A masked array is read with its mask: masked elements become NULL . my_masked_arr = np.ma.masked_array([1.0, 2.0, 3.0], mask=[Fal...se, True, False]) duckdb.sql("SELECT * FROM my_masked_arr") ┌─────────┐ │ column0 │ │ double │ ├─────────┤ │ 1.0 │ │ NULL │ │ 3.0 │ └─────────┘ See Also DuckDB also supports... - https://man.mtool.work/duckdb/2.0/guides/python/import_numpy.html
- Complete API 9051
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...ws_changed ( duckdb_result * result ); void * duckdb_column_data ( duckdb_result * result , idx_t col ); bool * duckdb_nullmask_data ( duckdb_result * result , idx_t col ); const char * duckdb_result_error ( duckdb_result * result ); duckdb_error_typ...uckdb_value value ); void duckdb_vector_reference_vector ( duckdb_vector to_vector , duckdb_vector from_vector ); Validity Mask Functions bool duckdb_validity_row_is_valid ( uint64_t * validity , idx_t row ); void duckdb_validity_set_row_validity ( u...ct to fetch the column data from. col : The column index. Return Value The column data of the specified column. duckdb_nullmask_data Deprecated This method has been deprecated. Prefer using duckdb_result_get_chunk instead. Returns the nullmask of a s... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- List Functions 8579
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...y_transform(list, lambda(x)) Alias for list_transform . array_unique(list) Alias for list_unique . array_where(value_list, mask_list) Alias for list_where . array_zip(list_1, ..., list_n[, truncate]) Alias for list_zip . char_length(list) Alias for l...unction var_pop to the list . list_var_samp(list) Applies aggregate function var_samp to the list . list_where(value_list, mask_list) Returns a list with the BOOLEAN s in mask_list applied as a mask to the value_list . list_zip(list_1, ..., list_n[,...aggregate function var_samp to the list . | | Example | list_var_samp([3,3,9]) | | Result | 12.0 | list_where(value_list, mask_list) | Description | Returns a list with the BOOLEAN s in mask_list applied as a mask to the value_list . | | Example | l... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- inet Extension 7906
- The inet extension defines the INET data type for storing IPv4 and IPv6 Internet addresses. It supports the CIDR notation for subnet masks (e.g., 198.51.100.0/22 , 2001:db8:3c4d::/48 ). Installing and Loading The inet extension will be tran
...bl; cidr host 192.168.0.0/16 192.168.0.0 127.0.0.1 127.0.0.1 2001:db8:3c4d:15::1a2f:1a2b/96 2001:db8:3c4d:15::1a2f:1a2b netmask Function Computes the network mask for the address's network. CREATE TABLE tbl (cidr INET); INSERT INTO tbl VALUES ('192.1...68.1.5/24'), ('127.0.0.1'), ('2001:db8:3c4d:15::1a2f:1a2b/96'); SELECT cidr, netmask(cidr) AS netmask FROM tbl; cidr netmask 192.168.1.5/24 255.255.255.0/24 127.0.0.1 255.255.255.255 2001:db8:3c4d:15::1a2f:1...ff:ffff:ffff::/96 network Function Returns the network part of the address, zeroing out whatever is to the right of the netmask. CREATE TABLE tbl (cidr INET); INSERT INTO tbl VALUES ('192.168.1.5/24'), ('127.0.0.1'), ('2001:db8:3c4d:15::1a2f:1a2b/96'... - https://man.mtool.work/duckdb/2.0/core_extensions/inet.html
- Import Data 7833
- Overview The JDBC driver offers two ways to load data into DuckDB in bulk: the high-performance Appender and a JDBC batch writer. This page describes both and when to use each. Appender The Appender is available in the DuckDB JDBC driver vi
...on(); appender.endRow(); } For a LIST or ARRAY column, pass a Java array as a single value, optionally with a boolean null mask where true marks the corresponding element as NULL : try (var appender = conn.createAppender("list_tbl")) { appender.begin... - https://man.mtool.work/duckdb/2.0/clients/java/data_import.html
- Python Client API 7688
- 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
...urtosis', 0, []), 'kurtosis_pop': ('list_kurtosis_pop', 0, []), 'last': ('list_last', 0, []), 'mad': ('list_mad', 0, []), 'mask': ('list_where', 0, ['T[]', 'BOOLEAN[]']), 'max': ('list_max', 0, []), 'median': ('list_median', 0, []), 'min': ('list_min...SQL: list_last . mad ( * args : ValueOrExpr ) → Expression The median absolute deviation of the elements. SQL: list_mad . mask ( * args : ValueOrExpr ) → ListExpr The elements where the matching boolean is true. Arguments: mask_list. SQL: list_where... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work