Results of 1 - 10 of about 17 for dictionary (0.006 sec.)
- Execution Format – DuckDB 13897
- 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
...nly store the literal once. Constant vectors are also emitted by the storage when decompressing from constant compression. Dictionary Vectors Dictionary vectors are physically stored as a child vector, and a selection vector that contains indexes into the...child vector. Dictionary vectors are emitted by the storage when decompressing from dictionary Just like constant vectors, dictionary vectors are a...lso emitted by the storage. When deserializing a dictionary compressed column segment, we store this in a dictionary vector so we can keep the data compressed during query execution.... - https://man.mtool.work/duckdb/1.3/internals/vector.html
- Types – DuckDB 10949
- 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
...ype ( duckdb_logical_type type ); duckdb_type duckdb_enum_internal_type ( duckdb_logical_type type ); uint32_t duckdb_enum_dictionary_size ( duckdb_logical_type type ); char * duckdb_enum_dictionary_value ( duckdb_logical_type type , idx_t index ); duckdb_...logical_type type ); Parameters type : The logical type object Return Value The internal type of the enum type duckdb_enum_dictionary_size Retrieves the dictionary size of the enum type. Syntax uint32_t duckdb_enum_dictionary_size ( duckdb_logical_type typ...e ); Parameters type : The logical type object Return Value The dictionary size of the enum type duckdb_enum_dictionary_value Retrieves the dictionary value at the specified position from the enum.... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Vectors – DuckDB 9759
- 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
...f-ten. Enums Enums are stored as unsigned integer values internally. The exact native type depends on the size of the enum dictionary, as shown in the following table: Dictionary size NativeType <= 255 uint8_t <= 65535 uint16_t <= 4294967295 uint32_t The d...n be used to obtain the internal type of the enum. In order to obtain the actual string value of the enum, the duckdb_enum_dictionary_value function must be used to obtain the enum value that corresponds to the given dictionary entry. Note that the enum di...tor. The max value in the selection vector must be less than the length of the vector The resulting vector happens to be a dictionary vector. Syntax void duckdb_slice_vector ( duckdb_vector vector , duckdb_selection_vector selection , idx_t len ); Paramete... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- Data Ingestion – DuckDB 9621
- 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
...This is useful when querying a DataFrame/Arrow object that is stored in another way (as a class variable, or a value in a dictionary). Below is a Pandas example: If your Pandas DataFrame is stored in another location, here is an example of manually regist...ering it: import duckdb import pandas as pd my_dictionary = {} my_dictionary [ "test_df" ] = pd . DataFrame . from_dict ({ "i" : [ 1 , 2 , 3 , 4 ], "j" : [ "one" , "two" , "three"..., "four" ]}) duckdb . register ( "test_df_view" , my_dictionary [ "test_df" ]) print ( duckdb . sql ( "SELECT * FROM test_df_view" ). fetchall ()) [(1, 'one'), (2, 'two'), (3, 'three'),... - https://man.mtool.work/duckdb/1.3/clients/python/data_ingestion.html
- Reading and Writing Parquet Files – DuckDB 9173
- 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
...00_000 )) TO 'result-brotli.parquet' ( FORMAT parquet , COMPRESSION brotli ); To configure the page size of Parquet file's dictionary pages, use the STRING_DICTIONARY_PAGE_SIZE_LIMIT option (default: 1 MB): COPY lineitem TO 'lineitem-with-custom-dictionary...-size.parquet' ( FORMAT parquet , STRING_DICTIONARY_PAGE_SIZE_LIMIT 100_000 ); DuckDB's EXPORT command can be used to export an entire database to a series of Parquet files.... - https://man.mtool.work/duckdb/1.3/data/parquet/overview.html
- Complete API – DuckDB 9017
- 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
...ype ( duckdb_logical_type type ); duckdb_type duckdb_enum_internal_type ( duckdb_logical_type type ); uint32_t duckdb_enum_dictionary_size ( duckdb_logical_type type ); char * duckdb_enum_dictionary_value ( duckdb_logical_type type , idx_t index ); duckdb_...logical_type type ); Parameters type : The logical type object Return Value The internal type of the enum type duckdb_enum_dictionary_size Retrieves the dictionary size of the enum type. Syntax uint32_t duckdb_enum_dictionary_size ( duckdb_logical_type typ...e ); Parameters type : The logical type object Return Value The dictionary size of the enum type duckdb_enum_dictionary_value Retrieves the dictionary value at the specified position from the enum.... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Enum Data Type – DuckDB 8880
- 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
...ecution Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Enum Data Type Name Description ENUM Dictionary representing all possible string values of a column The enum type represents a dictionary data structure with all possible...lity (i.e., fewer distinct values). This is because the column only stores a numerical reference to the string in the enum dictionary, resulting in immense savings in disk storage and faster query performance. Enum Definition Enum types are created from ei... - https://man.mtool.work/duckdb/1.3/sql/data_types/enum.html
- Conversion between DuckDB and Python – DuckDB 8569
- 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
...hree': [1, 2, 3], 'False': true} │ └────────────────────────────────────────────────────────────────────┘ Every key of the dictionary is converted to string. tuple tuple converts to LIST by default, when it's used to construct a Value object of type STRUCT...ovides multiple additional methods that can be used to efficiently retrieve data. NumPy fetchnumpy() fetches the data as a dictionary of NumPy arrays Pandas df() fetches the data as a Pandas DataFrame fetchdf() is an alias of df() fetch_df() is an alias of...int ( df ) item value count 0 jeans 20.0 1 1 hammer 42.2 2 2 laptop 2000.0 1 3 chainsaw 500.0 10 4 iphone 300.0 2 Fetch as dictionary of NumPy arrays: arr = con . execute ( "SELECT * FROM items" ). fetchnumpy () print ( arr ) {'item': masked_array(data=['j... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Data Types – DuckDB 8138
- 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
...have the same data type within each instance of the LIST , but can have any number of elements. [1, 2, 3] INTEGER[] MAP A dictionary of multiple named values, each key having the same type and each value having the same type. Keys and values can be any ty...be different types from one another. Rows may have different keys. map([1, 2], ['a', 'b']) MAP(INTEGER, VARCHAR) STRUCT A dictionary of multiple named values, where each key is a string, but the value can be a different type for each key. Each row must ha... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
- WITH Clause – DuckDB 7690
- 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
...ion: if the current iteration produces a row with key k , it replaces a row with the same key k in the union table (like a dictionary). If no such row exists in the union table yet, the new row is appended to the union table as usual. This allows a CTE to...FROM tbl WHERE a < 3 ) SELECT * FROM tbl ; Example: USING KEY References Union Table As well as using the union table as a dictionary, we can now reference it in queries. This allows you to use results from not just the previous iteration, but also earlier... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/with.html
DuckDB 1.3 Documentation / man.mtool.work