Results of 1 - 10 of about 16 for scale (0.007 sec.)
- TPC-H Extension – DuckDB 12805
- 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
...you would like to install and load it manually, run: INSTALL tpch ; LOAD tpch ; Usage Generating Data To generate data for scale factor 1, use: CALL dbgen ( sf = 1 ); Calling dbgen does not clean up existing TPC-H tables. To clean up existing tables,...rns a table with columns query_nr and query . Listing Expected Answers To produced the expected results for all queries on scale factors 0.01, 0.1, and 1, run: FROM tpch_answers (); This function returns a table with columns query_nr , scale_factor ,...and answer . Generating the Schema It's possible to generate the schema of TPC-H without any data by setting the scale factor to 0: CALL dbgen ( sf = 0 ); Data Generator Parameters The data generator function dbgen has the following paramete... - https://man.mtool.work/duckdb/1.3/core_extensions/tpch.html
- Types – DuckDB 11835
- 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
..._to_hugeint ( double val ); Decimal Helpers duckdb_decimal duckdb_double_to_decimal ( double val , uint8_t width , uint8_t scale ); double duckdb_decimal_to_double ( duckdb_decimal val ); Logical Type Interface duckdb_logical_type duckdb_create_logica...onst char ** member_names , idx_t member_count ); duckdb_logical_type duckdb_create_decimal_type ( uint8_t width , uint8_t scale ); duckdb_type duckdb_get_type_id ( duckdb_logical_type type ); uint8_t duckdb_decimal_width ( duckdb_logical_type type );...uint8_t duckdb_decimal_scale ( duckdb_logical_type type ); duckdb_type duckdb_decimal_internal_type ( duckdb_logical_type type ); duckdb_type duckdb_en... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Numeric Types – DuckDB 10189
- 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
...es). Both negative and positive values are supported by the VARINT type. Fixed-Point Decimals The data type DECIMAL(WIDTH, SCALE) (also available under the alias NUMERIC(WIDTH, SCALE) ) represents an exact fixed-point decimal value. When creating a va...lue of type DECIMAL , the WIDTH and SCALE can be specified to define which size of decimal values can be held in the field. The WIDTH field determines how many digi...ts can be held, and the scale determines the amount of digits after the decimal point. For example, the type DECIMAL(3, 2) can fit the value 1.23 , but... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Data Types – DuckDB 10189
- 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
...gth binary data BOOLEAN BOOL , LOGICAL Logical Boolean ( true / false ) DATE Calendar date (year, month day) DECIMAL(prec, scale) NUMERIC(prec, scale) Fixed-precision number with the given width (precision) and scale, defaults to prec = 18 and scale =...for details. Pages in This Section 関連キーワード type types byte integer values different union Types Signed number keys scale precision time used length date prec nested Rules multiple table aliases column Description 関連するページ Map Type Numeri... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
- TPC-DS Extension – DuckDB 9236
- 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
...epository. If you would like to install and load it manually, run: INSTALL tpcds ; LOAD tpcds ; Usage To generate data for scale factor 1, use: CALL dsdgen ( sf = 1 ); To run a query, e.g., query 8, use: PRAGMA tpcds ( 8 ); s_store_name sum(ss_net_pro...16 ought -10994052.78 Generating the Schema It's possible to generate the schema of TPC-DS without any data by setting the scale factor to 0: CALL dsdgen ( sf = 0 ); Limitations The tpcds ( query_id ) function runs a fixed TPC-DS query with pre-define...ossible to change the query parameters using the tpcds extension. 関連キーワード tpcds query extension parameters generate scale factor dsdgen Documentation Core Extensions Copy Markdown Extension implements generator queries benchmark Installing Load... - https://man.mtool.work/duckdb/1.3/core_extensions/tpcds.html
- Complete API – DuckDB 8820
- 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
...to_uhugeint ( double val ); Decimal Helpers duckdb_decimal duckdb_double_to_decimal ( double val , uint8_t width , uint8_t scale ); double duckdb_decimal_to_double ( duckdb_decimal val ); Prepared Statements duckdb_state duckdb_prepare ( duckdb_connec...onst char ** member_names , idx_t member_count ); duckdb_logical_type duckdb_create_decimal_type ( uint8_t width , uint8_t scale ); duckdb_type duckdb_get_type_id ( duckdb_logical_type type ); uint8_t duckdb_decimal_width ( duckdb_logical_type type );...uint8_t duckdb_decimal_scale ( duckdb_logical_type type ); duckdb_type duckdb_decimal_internal_type ( duckdb_logical_type type ); duckdb_type duckdb_en... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Schema – DuckDB 8681
- 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
...ng Timestamps We illustrate the difference in aggregation speed using the creationDate column of the LDBC Comment table on scale factor 300 . This table has approx. 554 million unordered timestamp values. We run a simple aggregation query that returns...gs We illustrate the difference caused by joining on different types by computing a self-join on the LDBC Comment table at scale factor 100 . The table has 64-bit integer identifiers used as the id attribute of each row. We perform the following join.... Microbenchmark: The Effect of Primary Keys We illustrate the effect of using primary keys with the LDBC Comment table at scale factor 300 . This table has approx. 554 million entries. In the first experiments, we create the schema without a primary... - https://man.mtool.work/duckdb/1.3/guides/performance/schema.html
- Spatial Functions – DuckDB 8283
- 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
...or calling ST_Affine. ST_RotateZ Rotates a geometry around the Z axis. This is a shorthand macro for calling ST_Affine. ST_Scale ST_TransScale Translates and then scales a geometry in X and Y direction. This is a shorthand macro for calling ST_Affine....(2, 3) SELECT ST_Affine ( ST_Point ( 1 , 1 ), 1 , 0 , -- a, b 0 , 1 , -- d, e 2 , 3 ); -- xoff, yoff ---- POINT ( 3 4 ) -- Scale a geometry by factor 2 in X and Y SELECT ST_Affine ( ST_Point ( 1 , 1 ), 2 , 0 , 0 , -- a, b, c 0 , 2 , 0 , -- d, e, f 0 ,...oint 90 degrees (π/2 radians) around the Z-axis SELECT ST_RotateZ ( ST_Point ( 1 , 0 ), pi () / 2 ); ---- POINT ( 0 1 ) ST_Scale Signatures GEOMETRY ST_Scale ( geom GEOMETRY , xs double , ys double , zs double ) GEOMETRY ST_Scale ( geom GEOMETRY , xs... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Python Client API – DuckDB 7728
- 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
...aseError class duckdb. DateValue ( object : Any ) ¶ Bases: Value class duckdb. DecimalValue ( object : Any , width : int , scale : int ) ¶ Bases: Value duckdb. DefaultExpression ( ) → duckdb.duckdb.Expression ¶ class duckdb. DoubleValue ( object : Any...tion ¶ Create a duplicate of the current connection decimal_type ( self : duckdb.duckdb.DuckDBPyConnection , width : int , scale : int ) → duckdb.duckdb.typing.DuckDBPyType ¶ Create a decimal type with ‘width' and ‘scale' property description ¶ Get re...n = None ) → duckdb.DuckDBPyConnection ¶ Create a duplicate of the current connection duckdb. decimal_type ( width : int , scale : int , * , connection : duckdb.DuckDBPyConnection = None ) → duckdb.duckdb.typing.DuckDBPyType ¶ Create a decimal type wi... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- Vectors – DuckDB 7589
- 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
...ternal_type can be used to obtain the internal type of the decimal. Decimals are stored as integer values multiplied by 10^scale . The scale of a decimal can be obtained using duckdb_decimal_scale . For example, a decimal value of 10.5 with type DECIM... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
DuckDB 1.3 Documentation / man.mtool.work