Results of 1 - 5 of about 5 for labels (0.001 sec.)
- Result Verification 12115
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...be sorted in a specific manner. This field goes in the same location as the connection label. Because of that, connection labels and result sorting cannot be mixed. The possible values of this field are nosort , rowsort and valuesort . An example of h...answers. However, existing sqllogictests use this field extensively, hence it is important to know of its existence. Query Labels Another feature that can be used for result verification are query labels . These can be used to verify that different que...ide the same result. This is useful for comparing queries that are logically equivalent, but formulated differently. Query labels are provided after the connection label or sorting specifier. Queries that have a query label do not need to have a result... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Integration with PyTorch 10442
- PyTorch tensors can be built from DuckDB query results by exporting each result batch as Apache Arrow . This pattern is useful when training or serving models on Parquet data because DuckDB can filter and project the input before the batche
...res = torch.tensor( np.column_stack( [ batch.column(0).to_numpy(), batch.column(1).to_numpy(), ] ), dtype=torch.float32, ) labels = torch.tensor(batch.column(2).to_numpy(), dtype=torch.int64) print(features.shape, labels) torch.Size([2, 2]) tensor([1,... - https://man.mtool.work/duckdb/2.0/guides/python/pytorch.html
- Multiple Connections 8548
- For tests whose purpose is to verify that the transactional management or versioning of data works correctly, it is generally necessary to use multiple connections. For example, if we want to verify that the creation of tables is correctly
...hat the table is not accessible yet until committed. We can use multiple connections in the sqllogictests using connection labels . The connection label can be optionally appended to any statement or query . All queries with the same connection label w... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/multiple_connections.html
- DuckDB_% Metadata Functions 7501
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...of string key–value pairs. MAP(VARCHAR, VARCHAR) internal Whether this is an internal (built-in) or a user object. BOOLEAN labels Labels for categorizing types. Used for generating the documentation. VARCHAR[] duckdb_variables The duckdb_variables() fu... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Timestamp Types 7298
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...epoch 1970-01-01 00:00:00+00 , and thus unambiguously identifies a point in absolute time, or instant . The reason for the labels time zone aware and WITH TIME ZONE is that timestamp arithmetic, binning , and string formatting for this type are perform... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work