Results of 1 - 8 of about 8 for zstd (0.008 sec.)
- Reading and Writing Parquet Files – DuckDB 13176
- 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
...compression and row group size: COPY ( FROM generate_series ( 100_000 )) TO 'test.parquet' ( FORMAT parquet , COMPRESSION zstd , ROW_GROUP_SIZE 100_000 ); Export the table contents of the entire database as parquet: EXPORT DATABASE 'target_directory...a Snappy-compressed Parquet file: COPY ( SELECT * FROM tbl ) TO 'result-snappy.parquet' ( FORMAT parquet ); Write tbl to a zstd-compressed Parquet file: COPY tbl TO 'result-zstd.parquet' ( FORMAT parquet , COMPRESSION zstd ); Write tbl to a zstd-comp...ressed Parquet file with the lowest compression level yielding the fastest compression: COPY tbl TO 'result-zstd.parquet' ( FORMAT parquet , COMPRESSION zstd , COMPRESSION_LEVEL 1 ); Write to Parquet file with key-value metadata : COPY... - https://man.mtool.work/duckdb/1.3/data/parquet/overview.html
- COPY Statement – DuckDB 10194
- 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
...ult of a query to a Parquet file: COPY ( SELECT l_orderkey , l_partkey FROM lineitem ) TO 'lineitem.parquet' ( COMPRESSION zstd ); Copy the entire content of database db1 to database db2 : COPY FROM DATABASE db1 TO db2 ; Copy only the schema (catalog...fault this will be detected automatically from the file extension (e.g., file.csv.gz will use gzip , file.csv.zst will use zstd , and file.csv will use none ). Options are none , gzip , zstd . VARCHAR auto DATEFORMAT Specifies the date format to use...ng Parquet files. Name Description Type Default COMPRESSION The compression format to use ( uncompressed , snappy , gzip , zstd , brotli , lz4 , lz4_raw ). VARCHAR snappy COMPRESSION_LEVEL Compression level, set between 1 (lowest compression, fastest... - https://man.mtool.work/duckdb/1.3/sql/statements/copy.html
- Text Types – DuckDB 9452
- 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
...Compression Type You can specify a compression type for a string with the USING COMPRESSION clause. For example, to apply zstd compression, run: CREATE TABLE tbl ( s VARCHAR USING COMPRESSION zstd ); Text Type Values Values of the text type are char...xt literals Types allows Unicode Internally encoded Variable maximum effect compatibility reasons example Type compression zstd Values 関連するページ Bitstring Type Information Schema Values Literal Types Pattern Matching Array Type See this page as... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
- EXPORT and IMPORT DATABASE Statements – DuckDB 8585
- 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
...arget_directory' ( FORMAT parquet ); Export to directory 'target_directory', tables serialized as Parquet, compressed with ZSTD, with a row_group_size of 100,000: EXPORT DATABASE 'target_directory' ( FORMAT parquet , COMPRESSION zstd , ROW_GROUP_SIZE... - https://man.mtool.work/duckdb/1.3/sql/statements/export.html
- Loading JSON – DuckDB 7952
- 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
...ted automatically from the file extension (e.g., t.json.gz will use gzip, t.json will use none). Options are none , gzip , zstd and auto_detect . VARCHAR auto_detect filename Whether or not an extra filename column should be included in the result. S...matically from the file extension (e.g., t.json.gz will use gzip, t.json will use none). Options are uncompressed , gzip , zstd and auto_detect . VARCHAR auto_detect convert_strings_to_integers Whether strings representing integer values should be co... - https://man.mtool.work/duckdb/1.3/data/json/loading_json.html
- Configuration – DuckDB 7826
- 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
...used by the system. BIGINT # CPU cores username , user The username to use. Ignored for legacy compatibility. VARCHAR NULL zstd_min_string_length The (average) length at which to enable ZSTD compression, defaults to 4096 UBIGINT 4096 Local Configurat... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- File Formats – DuckDB 7573
- 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
...nsive decompression time every time the file is accessed. Meanwhile, lightweight compression methods like Snappy, LZ4, and zstd, are faster to decompress. You may use the parquet_metadata function to find out the compression algorithm used. Microbenc... - https://man.mtool.work/duckdb/1.3/guides/performance/file_formats.html
- CSV Import – DuckDB 7464
- 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
...cted automatically from the file extension (e.g., t.csv.gz will use gzip, t.csv will use none ). Options are none , gzip , zstd . VARCHAR auto dateformat Date format used when parsing and writing dates. VARCHAR (empty) date_format Alias for dateforma... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work