Results of 1 - 10 of about 18 for glob (0.005 sec.)
- Pattern Matching – DuckDB 14207
- 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
...atching provided by DuckDB: the traditional SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE expression returns true if the string matches the supplied...quivalent to NOT SIMILAR TO . In DuckDB, these equivalences do not hold currently, see the PostgreSQL compatibility page . Globbing DuckDB supports file name expansion, also known as globbing, for discovering files. DuckDB's glob syntax uses the ques...ed inside the first bracket to search for a character that is not contained within the brackets. To learn more, visit the “glob (programming)” Wikipedia page . GLOB The GLOB operator returns true or false if the string matches the GLOB pattern. The G... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- Reading Multiple Files – DuckDB 12268
- 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
...tiple Files DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to read. See the combining schemas page for tips on reading files with different s..._csv ([ 'flights1.csv' , 'flights2.csv' ], union_by_name = true , filename = true ); Parquet Read all files that match the glob pattern: SELECT * FROM 'test/*.parquet' ; Read three Parquet files and treat them as a single table: SELECT * FROM read_pa...folders: SELECT * FROM read_parquet ([ 'folder1/*.parquet' , 'folder2/*.parquet' ]); Read all Parquet files that match the glob pattern at any depth: SELECT * FROM read_parquet ( 'dir/**/*.parquet' ); Multi-File Reads and Globs DuckDB can also read a... - https://man.mtool.work/duckdb/1.3/data/multiple_files/overview.html
- Utility Functions – DuckDB 9145
- 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
...uses UNION ALL BY NAME semantics. read_blob(source) Returns the content from source (a filename, a list of filenames, or a glob pattern) as a BLOB . See the read_blob guide for more details. read_text(source) Returns the content from source (a filena...me, a list of filenames, or a glob pattern) as a VARCHAR . The file content is first validated to be valid UTF-8. If read_text attempts to read a file with i...on of the two tables) read_blob(source) Description Returns the content from source (a filename, a list of filenames, or a glob pattern) as a BLOB . See the read_blob guide for more details. Example read_blob('hello.bin') Result hello\x0A read_text(s... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Directly Reading Files – DuckDB 8356
- 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
...ectly reading files via the read_text and read_blob functions. These functions accept a filename, a list of filenames or a glob pattern, and output the content of each file as a VARCHAR or BLOB , respectively, as well as additional metadata such as t...ble functions also utilize projection pushdown to avoid computing properties unnecessarily. So you could e.g., use this to glob a directory full of huge files to get the file size in the size column, as long as you omit the content column the data wo...n't be read into DuckDB. 関連キーワード read table files content size text blob filename column functions DuckDB glob last reads selected parse path Hello World three valid instead Documentation Guides Formats 関連するページ Caveats Reading... - https://man.mtool.work/duckdb/1.3/guides/file_formats/read_file.html
- Python Client API – DuckDB 8218
- 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
...in df from_parquet ( * args , ** kwargs ) ¶ Overloaded function. from_parquet(self: duckdb.duckdb.DuckDBPyConnection, file_glob: str, binary_as_string: bool = False, * , file_row_number: bool = False, filename: bool = False, hive_partitioning: bool =...lse, compression: object = None) -> duckdb.duckdb.DuckDBPyRelation Create a relation object from the Parquet files in file_glob from_parquet(self: duckdb.duckdb.DuckDBPyConnection, file_globs: list[str], binary_as_string: bool = False, * , file_row_n...lse, compression: object = None) -> duckdb.duckdb.DuckDBPyRelation Create a relation object from the Parquet files in file_globs from_query ( self : duckdb.duckdb.DuckDBPyConnection , query : object , * , alias : str = '' , params : object = None ) →... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- Reading and Writing Parquet Files – DuckDB 8064
- 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
...table: SELECT * FROM read_parquet ([ 'file1.parquet' , 'file2.parquet' , 'file3.parquet' ]); Read all files that match the glob pattern: SELECT * FROM 'test/*.parquet' ; Read all files that match the glob pattern, and include the filename virtual col...ut a configuration options since DuckDB v1.3.0): SELECT * , filename FROM read_parquet ( 'test/*.parquet' ); Use a list of globs to read all Parquet files from two specific folders: SELECT * FROM read_parquet ([ 'folder1/*.parquet' , 'folder2/*.parqu...nfer that you are reading a Parquet file: SELECT * FROM 'test.parquet' ; Multiple files can be read at once by providing a glob or a list of files. Refer to the multiple files section for more information. Parameters There are a number of options exp... - https://man.mtool.work/duckdb/1.3/data/parquet/overview.html
- Relational API – DuckDB 8012
- 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
..._parquet ( * args , ** kwargs ) Overloaded function . 1. from_parquet ( self : duckdb . duckdb . DuckDBPyConnection , file_glob : str , binary_as_string : bool = False , * , file_row_number : bool = False , filename : bool = False , hive_partitioning...ompression : object = None ) -> duckdb . duckdb . DuckDBPyRelation Create a relation object from the Parquet files in file_glob 2. from_parquet ( self : duckdb . duckdb . DuckDBPyConnection , file_globs : list [ str ], binary_as_string : bool = False...ompression : object = None ) -> duckdb . duckdb . DuckDBPyRelation Create a relation object from the Parquet files in file_globs Description Create a relation object from the Parquet files Aliases : read_parquet Parameters file_glob : str File path o... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Loading JSON – DuckDB 8012
- 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
...lumns are shown: userId completed 1 false 1 false 1 false 1 true 1 false Multiple files can be read at once by providing a glob or a list of files. Refer to the multiple files section for more information. Functions for Reading JSON Objects The follo...Description read_json_objects(filename) Read a JSON object from filename , where filename can also be a list of files or a glob pattern. read_ndjson_objects(filename) Alias for read_json_objects with the parameter format set to newline_delimited . re...tions: Function Description read_json(filename) Read JSON from filename , where filename can also be a list of files, or a glob pattern. read_json_auto(filename) Alias for read_json . read_ndjson(filename) Alias for read_json with parameter format se... - https://man.mtool.work/duckdb/1.3/data/json/loading_json.html
- Hugging Face Support – DuckDB 7961
- 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
...he data table as follows: SELECT * FROM data ; Multiple Files To query all files under a specific directory, you can use a glob pattern . For example: SELECT count ( * ) AS count FROM 'hf://datasets/cais/mmlu/astronomy/*.parquet' ; count 173 By using...glob patterns, you can efficiently handle large datasets and perform comprehensive queries across multiple files, simplifying y... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/hugging_face.html
- Blob Functions – DuckDB 7961
- 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
...h(blob) Number of bytes in blob . read_blob(source) Returns the content from source (a filename, a list of filenames, or a glob pattern) as a BLOB . See the read_blob guide for more details. repeat(blob, count) Repeats the blob count number of times....\xBB'::BLOB) Result 2 read_blob(source) Description Returns the content from source (a filename, a list of filenames, or a glob pattern) as a BLOB . See the read_blob guide for more details. Example read_blob('hello.bin') Result hello\x0A repeat(blob... - https://man.mtool.work/duckdb/1.3/sql/functions/blob.html
DuckDB 1.3 Documentation / man.mtool.work