Results of 1 - 10 of about 10 for stdin (0.002 sec.)
- CLI Charting with YouPlot 11888
- DuckDB can be used with CLI graphing tools to quickly pipe input to stdout to graph your data in one line. YouPlot is a Ruby-based CLI tool for drawing visually pleasing plots on the terminal. It can accept input from other programs by pipi
...ng data from stdin . It takes tab-separated (or delimiter of your choice) data and can easily generate various types of plots including bar,...omma-separated delimiter ( -d, ), that the data has a header ( -H ), and give the plot a title ( -t ). Additional Example: stdin + stdout You might be piping data through jq or downloading a JSON file from somewhere. You can also tell DuckDB to read d...ata from another process by changing the filename to /dev/stdin . Let's combine this with a quick curl from GitHub to see what a certain user has been up to lately. curl -sL "https://api... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/youplot.html
- Command Line Client 11548
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...LOAD commands as you would other SQL statements. INSTALL fts; LOAD fts; For details, see the Extension docs . Reading from stdin and Writing to stdout When in a Unix environment, it can be useful to pipe data between multiple commands. DuckDB is able...to read data from stdin as well as write to stdout using the file location of stdin ( /dev/stdin ) and stdout ( /dev/stdout ) within SQL commands,...I, pass in the location of the database to open, in this case, an in-memory database, and a SQL command that utilizes /dev/stdin as a file location. cat test.csv | duckdb -c "SELECT * FROM read_csv('/dev/stdin')" woot 42 43 To write back to stdout, th... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Command Line Arguments 11066
- The table below summarizes DuckDB's command line options. To list all command line options, use the command: duckdb -help For a list of dot commands available in the CLI shell, see the Dot Commands page . Argument Description -agent Render
...atch Force batch I/O -box Set output mode to box -column Set output mode to column -cmd COMMAND Run COMMAND before reading stdin -connect [TYPE[:SECRET]] Connect to a remote database. The default type is quack . A named secret can be provided after th...ipt in FILENAME and exit. Note that the ~/.duckdbrc is read and executed first (if it exists) -format Format SQL read from stdin , writing the result to stdout -format-file FILENAME Format the SQL in FILENAME , writing the result to stdout -init FILEN...ode page -no-init Skip processing the init file ( ~/.duckdbrc or the file passed to -init ) -noheader Turn headers off -no-stdin Exit after processing options instead of reading stdin -nullvalue TEXT Set text string for NULL values. Default: NULL -quo... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- JSON Overview 9081
- DuckDB supports SQL functions that are useful for reading values from existing JSON and creating new JSON data. JSON is supported with the json extension which is shipped with most DuckDB distributions and is auto-loaded on first use. If yo
...at = 'array', columns = {userId: 'UBIGINT', id: 'UBIGINT', title: 'VARCHAR', completed: 'BOOLEAN'}); Read a JSON file from stdin, auto-infer options: cat data/json/todos.json | duckdb -c "SELECT * FROM read_json('/dev/stdin')" Read a JSON file into a... - https://man.mtool.work/duckdb/2.0/data/json/overview.html
- Unit Tester Configuration 8259
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...st --statically-loaded-extensions <comma-separated strings> Extensions to be loaded (from the statically available ones) --stdin Read a single sqllogictest script from stdin --storage-fuzzer , --no-storage-fuzzer Run storage fuzzer tests --storage-ver... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- CREATE MACRO Statement 8259
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
..., the following fails at creation time when the file is not present: CREATE MACRO read_pipe() AS TABLE FROM read_csv('/dev/stdin'); IO Error: No files found that match the pattern "/dev/stdin" To resolve the file name at call time instead, pass it as...ying a default value keeps the macro callable without arguments: CREATE OR REPLACE TEMPORARY MACRO read_pipe(pipe := '/dev/stdin') AS TABLE FROM read_csv(pipe); FROM read_pipe(); Overloading It is possible to overload a macro based on the types or the... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- CSV Import 7597
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...lightDate': 'DATE', 'UniqueCarrier': 'VARCHAR', 'OriginCityName': 'VARCHAR', 'DestCityName': 'VARCHAR' }); Read a CSV from stdin, auto-infer options: cat flights.csv | duckdb -c "SELECT * FROM read_csv('/dev/stdin')" Read a CSV file into a table: CREA... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- Directly Reading Files 7419
- DuckDB allows directly reading files via the read_text and read_blob functions. These functions accept a filename, a list of filenames, or a glob pattern. They output the content of each file as a VARCHAR or BLOB , respectively, along with
...UTF-8, DuckDB throws an error suggesting to use read_blob instead. read_text also supports reading from pipes (e.g., /dev/stdin ). The maximum allowed file size for read_text is 3.9 GiB. read_blob The read_blob table function reads from the selected... - https://man.mtool.work/duckdb/2.0/guides/file_formats/read_file.html
- Troubleshooting 7258
- Troubleshooting Running EXPLAIN Renders Newlines In Python, the output of the EXPLAIN statement contains hard line breaks ( \n ): In [1]: import duckdb ...: duckdb.sql("EXPLAIN SELECT 42 AS x") Out[1]: ┌───────────────┬─────────────────────
...e could not be found. Windows fatal exception: access violation Current thread 0x0000311c (most recent call first): File "<stdin>", line 1 in <module> Process finished with exit code -1073741819 (0xC0000005) The problem is likely caused by using an ou... - https://man.mtool.work/duckdb/2.0/clients/python/known_issues.html
- CSV Auto Detection 6936
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...ferent locations in the file. If we are reading from a file in which we cannot jump – such as a .gz compressed CSV file or stdin – samples are taken only from the beginning of the file. sniff_csv Function It is possible to run the CSV sniffer as a sep... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work