Results of 1 - 10 of about 11 for real (0.002 sec.)
- Troubleshooting Quack 13727
- DuckDB 2.0 ships a polished version of Quack (first released in DuckDB 1.5.3) with substantial performance and stability improvements. If you experience any issues with Quack, try upgrading all your DuckDB clients to the latest version of t
...b_tables() and cannot bind: Catalog Error: Type with name UNKNOWN does not exist! The UNKNOWN type here is not the table's real type, and it does not mean the client must install the iceberg extension. It means the server has not yet resolved the tab...rver with TABLE_RESOLUTION 'eager' so that schemas are resolved while tables are enumerated, which lets Quack import their real definitions: {:.codebox-server} -- Server: substitute your own warehouse, URI, and secret. LOAD iceberg; LOAD quack; ATTAC... - https://man.mtool.work/duckdb/2.0/quack/troubleshooting.html
- HTTP CSV Import 10402
- To load a CSV file directly over HTTP(S), the httpfs extension is required. This can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL httpfs; To load the httpfs extension for usage, use the LOAD SQL comman
...nism : SELECT * FROM 'https://⟨domain⟩/path/to/file.csv'; Example The following query reads an openly licensed (CC BY 4.0) real-world CSV directly over HTTP and aggregates it, with no local download step: SELECT area, round(avg(sunbed_price), 0) AS a... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/http_csv_import.h...
- Loops 9566
- Loops can be used in sqllogictests when it is required to execute the same query many times but with slight modifications in constant values. For example, suppose we want to fire off 100 queries that check for the presence of the values 0..
...isting CSV or Parquet file. There are several large CSV files that can be loaded from the directory test/sql/copy/csv/data/real using a COPY INTO statement or the read_csv_auto function. The TPC-H and TPC-DS extensions can also be used to generate sy... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/loops.html
- Tableau – A Data Visualization Tool 8730
- Tableau is a popular commercial data visualization tool. In addition to a large number of built-in connectors, it also provides generic database connectivity via ODBC and JDBC connectors. Tableau has two main versions: Desktop and Online (S
...its repository, but essentially you will need the duckdb_jdbc.taco file. (Despite what the Tableau documentation says, the real security risk is in the JDBC driver code, not the small amount of JavaScript in the Taco file.) Server (Online) On Linux,... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Data Types 8730
- General-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL
...d scale, defaults to prec = 18 and scale = 3 DOUBLE FLOAT8 Double precision floating-point number (8 bytes) FLOAT FLOAT4 , REAL Single precision floating-point number (4 bytes) GEOMETRY Geospatial entity, see the GEOMETRY data type HUGEINT Signed six... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- SQLite Extension 8321
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...or if no type is specified then it is translated into BLOB . If the declared type for a column contains any of the strings REAL , FLOA , DOUB , DEC or NUM then it is translated into DOUBLE . If the declared type is DATE , then it is translated into D... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
- Security 7895
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...name = true . The server does not use TLS for local URIs, as TLS for localhost communication only adds dependencies for no real benefit. Non-local URIs default to HTTPS with a self-signed certificate (see quack_serve parameters ). Bestpractice For an... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Numeric Types 7895
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...d the SCALE Both parameters are optional, and a trailing comma after the WIDTH is accepted. The following spellings therefore all bind to a concrete decimal type: SELECT typeof(1.5::DECIMAL) AS "DECIMAL", typeof(1.5::DECIMAL()) AS "DECIMAL()", typeof...e extent that the underlying processor, operating system, and compiler support it. Name Aliases Description FLOAT FLOAT4 , REAL Single precision floating-point number (4 bytes) DOUBLE FLOAT8 Double precision floating-point number (8 bytes) Like for f... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- GROUPING SETS 7895
- GROUPING SETS , ROLLUP and CUBE can be used in the GROUP BY clause to perform a grouping over multiple dimensions within the same query. Note that this syntax is not compatible with GROUP BY ALL . Examples Compute the average income along t
...themselves contain actual NULL -values, then it can be challenging to distinguish whether the value in the resultset is a “real” NULL -value coming out of the data itself, or a NULL -value generated by the grouping construct. The GROUPING_ID() or GRO... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/grouping_sets.html
- Dot Commands 7486
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...rendering numbers. Only for duckbox mode .timer ⟨on/off⟩ ⟨DIGITS⟩ Turn SQL timer on or off , with DIGITS decimals for the real time (default: 3). SQL statements separated by ; but not separated via newline are measured together .ui_command ⟨COMMAND⟩... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
DuckDB 2.0 Documentation / man.mtool.work