Results of 1 - 5 of about 5 for Moreover (0.001 sec.)
- HTTP Parquet Import 11766
- To load a Parquet file 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 command: LO
...ttps://⟨domain⟩/path/to/file.parquet'); For example: SELECT * FROM read_parquet('https://duckdb.org/data/prices.parquet'); Moreover, the read_parquet function itself can also be omitted thanks to DuckDB's replacement scan mechanism : SELECT * FROM 'https... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/http_import.html
- List Tables 10534
- The SHOW TABLES command can be used to obtain a list of all tables within the selected schema. CREATE TABLE tbl (i INTEGER); SHOW TABLES; name tbl SHOW or SHOW ALL TABLES can be used to obtain a list of all tables within all attached databa
...ma of an individual table, use the DESCRIBE command . See Also The SQL-standard information_schema views are also defined. Moreover, DuckDB defines sqlite_master and many PostgreSQL system catalog tables for compatibility with SQLite and PostgreSQL respe... - https://man.mtool.work/duckdb/2.0/guides/meta/list_tables.html
- HTTP CSV Import 9302
- 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
...d over http(s) the same way as a local file, using read_csv : SELECT * FROM read_csv('https://⟨domain⟩/path/to/file.csv'); Moreover, the read_csv function itself can also be omitted thanks to DuckDB's replacement scan mechanism : SELECT * FROM 'https://⟨... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/http_csv_import.h...
- Graph Queries 7464
- DuckDB supports graph queries via the DuckPGQ community extension , which implements the SQL/PGQ syntax from the SQL:2023 standard. Warning DuckPGQ is a community extension and is still under active development. It may not be available for
...every DuckDB version: check the DuckPGQ community extension page for the supported versions. Moreover, some features may be incomplete. See the DuckPGQ website for the latest status. Graph queries allow you to find patterns... - https://man.mtool.work/duckdb/2.0/guides/sql_features/graph_queries.html
- Schema 6857
- Types It is important to use the correct type for encoding columns (e.g., BIGINT , DATE , DATETIME ). While it is always possible to use string types ( VARCHAR , etc.) to encode more specific values, this is not recommended. Strings use mor
...integrity but they have a negative effect on load performance as they necessitate building indexes and performing checks. Moreover, they very rarely improve the performance of queries as DuckDB does not rely on these indexes for join and aggregation ope... - https://man.mtool.work/duckdb/2.0/guides/performance/schema.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work