Results of 1 - 10 of about 48 for Alternatively (0.001 sec.)
- CSV Import 12980
- To read data from a CSV file, use the read_csv function in the FROM clause of a query: SELECT * FROM read_csv('input.csv'); Alternatively, you can omit the read_csv function and let DuckDB infer it from the extension: SELECT * FROM 'input.c
...existing table from a query, use INSERT INTO from a SELECT statement: INSERT INTO tbl SELECT * FROM read_csv('input.csv'); Alternatively, the COPY statement can also be used to load data from a CSV file into an existing table: COPY tbl FROM 'input.csv'; For a... - https://man.mtool.work/duckdb/2.0/guides/file_formats/csv_import.html
- Importing Data 12450
- The first step to using a database system is to insert data into that system. DuckDB can directly connect to many popular data sources and offers several data ingestion methods that allow you to easily and efficiently fill up the database.
...ciently loaded from CSV files using several methods. The simplest is to use the CSV file's name: SELECT * FROM 'test.csv'; Alternatively, use the read_csv function to pass along options: SELECT * FROM read_csv('test.csv', header = false); Or use the COPY stat.... Parquet Loading Parquet files can be efficiently loaded and queried using their filename: SELECT * FROM 'test.parquet'; Alternatively, use the read_parquet function : SELECT * FROM read_parquet('test.parquet'); Or use the COPY statement : COPY tbl FROM 'te...t loading . JSON Loading JSON files can be efficiently loaded and queried using their filename: SELECT * FROM 'test.json'; Alternatively, use the read_json function : SELECT * FROM read_json('test.json'); Or use the COPY statement : COPY tbl FROM 'test.json';... - https://man.mtool.work/duckdb/2.0/data/overview.html
- Parquet Import 11632
- To read data from a Parquet file, use the read_parquet function in the FROM clause of a query: SELECT * FROM read_parquet('input.parquet'); Alternatively, you can omit the read_parquet function and let DuckDB infer it from the extension: SE
...table from a query, use INSERT INTO from a SELECT statement: INSERT INTO tbl SELECT * FROM read_parquet('input.parquet'); Alternatively, use the COPY statement to load data from a Parquet file into an existing table: COPY tbl FROM 'input.parquet' (FORMAT par... - https://man.mtool.work/duckdb/2.0/guides/file_formats/parquet_import.html
- Excel Import 9451
- DuckDB supports reading Excel .xlsx files. However, .xls files are not supported. Importing Excel Sheets Use the read_xlsx function in the FROM clause of a query: SELECT * FROM read_xlsx('test_excel.xlsx'); Alternatively, you can omit the r
...ry, use INSERT INTO from a SELECT statement: INSERT INTO tbl SELECT * FROM read_xlsx('test_excel.xlsx', sheet = 'Sheet1'); Alternatively, you can use the COPY statement with the XLSX format option to import an Excel file into an existing table: COPY tbl FROM... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_import.html
- JSON Import 9451
- To read data from a JSON file, use the read_json function in the FROM clause of a query: SELECT * FROM read_json('input.json'); To create a new table using the result from a query, use CREATE TABLE AS from a SELECT statement: CREATE TABLE n
...isting table from a query, use INSERT INTO from a SELECT statement: INSERT INTO tbl SELECT * FROM read_json('input.json'); Alternatively, the COPY statement can also be used to load data from a JSON file into an existing table: COPY tbl FROM 'input.json'; For... - https://man.mtool.work/duckdb/2.0/guides/file_formats/json_import.html
- Safe Mode 8906
- The DuckDB CLI client supports “safe mode”. Safe mode can be enabled from the command line using the -safe argument : duckdb -safe Alternatively, it can be activated during a session using the .safe_mode dot command . In safe mode, the CLI
... - https://man.mtool.work/duckdb/2.0/clients/cli/safe_mode.html
- SQLite Import 8906
- To run a query directly on a SQLite file, the sqlite extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL sqlite; To load the sqlite extension
...an function: -- Scan the table "tbl_name" from the SQLite file "test.db" SELECT * FROM sqlite_scan('test.db', 'tbl_name'); Alternatively, the entire file can be attached using the ATTACH command . This allows you to query all tables stored within a SQLite dat... - https://man.mtool.work/duckdb/2.0/guides/database_integration/sqlite.html
- Import from Pandas 8633
- CREATE TABLE ... AS and INSERT INTO can be used to create a table from any query. We can then create tables or insert into existing tables by referring to the Pandas DataFrame in the query. There is no need to register the DataFrames manual
...are present in the DataFrame, use INSERT INTO ... BY NAME : duckdb.sql("INSERT INTO my_table BY NAME SELECT * FROM my_df") Alternatively, the append method appends a DataFrame to an existing table directly, without writing a SQL query. Pass by_name=True to ma... - https://man.mtool.work/duckdb/2.0/guides/python/import_pandas.html
- Text Types 8360
- In DuckDB, strings can be stored in the VARCHAR field. The field allows storage of Unicode characters. Internally, the data is encoded as UTF-8. Name Aliases Description VARCHAR CHAR , BPCHAR , STRING , TEXT Variable-length character string
...th Special Characters To use special characters in a string, use escape string literals or dollar-quoted string literals . Alternatively, you can use concatenation and the chr character function : SELECT 'Hello' || chr(10) || 'world' AS msg; ┌──────────────┐... - https://man.mtool.work/duckdb/2.0/sql/data_types/text.html
- Concurrency 8088
- Handling Concurrency Single Process In in-process mode, DuckDB has two configurable options for concurrency: Read-write mode: one process can both read and write to the database. Read-only mode: multiple processes can read from the database
...hips a polished version of Quack (first released in DuckDB 1.5.3) with substantial performance and stability improvements. Alternatively, consider using the DuckLake format with PostgreSQL as the catalog database . By coordinating through a central PostgreSQL... - https://man.mtool.work/duckdb/2.0/connect/concurrency.html
DuckDB 2.0 Documentation / man.mtool.work