Results of 1 - 6 of about 6 for mask (0.006 sec.)
- Vectors – DuckDB 13124
- 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 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/1.3/clients/c/vector.html
- Complete API – DuckDB 8920
- 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
...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/1.3/clients/c/api.html
- List Functions – DuckDB 8536
- 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 the unique elements of a list. list_value(any, ...) Create a LIST containing the argument values. 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_2, ...[,...a LIST containing the argument values. Example list_value(4, 5, 6) Result [4, 5, 6] Alias list_pack 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 list_where(... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Conversion between DuckDB and Python – DuckDB 8262
- 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 Fetch as dictionary of NumPy arrays: arr = con . execute ( "SELECT * FROM items" ). fetchnumpy () print ( arr ) {'item': masked_array(data=['jeans', 'hammer', 'laptop', 'chainsaw', 'iphone'], mask=[False, False, False, False, False], fill_value='?'..., dtype=object), 'value': masked_array(data=[20.0, 42.2, 2000.0, 500.0, 300.0], mask=[False, False, False, False, False], fill_value=1e+20), 'count': mas...ked_array(data=[1, 2, 1, 10, 2], mask=[False, False, False, False, False], fill_value=999999, dtype=int32)} Fetch as an Arrow table. Converting to Pandas afterw... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Export to Numpy – DuckDB 8262
- 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 . sql ( "SELECT unnest([1, 2, 3]) AS x, 5.0 AS y" ). fetchnumpy () my_arr {'x': array([1, 2, 3], dtype=int32), 'y': masked_array(data=[5.0, 5.0, 5.0], mask=[False, False, False], fill_value=1e+20)} Then, the array can be processed using Numpy...Numpy using fetchnumpy import duckdb Documentation Guides Copy Markdown Export query converted example numpy unnest dtype masked mask fill processed functions Also DuckDB also supports 関連するページ Import from Numpy Export to Pandas Python API Exe... - https://man.mtool.work/duckdb/1.3/guides/python/export_numpy.html
- inet Extension – DuckDB 7677
- 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
...xtension 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 transparently autoloaded...dr host(cidr) 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 ( '19...2.168.1.5/24' ), ( '127.0.0.1' ), ( '2001:db8:3c4d:15::1a2f:1a2b/96' ); SELECT cidr , netmask ( cidr ) FROM tbl ; cidr netmask(cidr) 192.168.1.5/24 255.255.255.0/24 127.0.0.1 255.255.255.255 2001:db8:3c4d:15::1a2f:1a... - https://man.mtool.work/duckdb/1.3/core_extensions/inet.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work