Results of 1 - 3 of about 3 for kv (0.001 sec.)
- Querying Parquet Metadata 11868
- Parquet Metadata The parquet_metadata function can be used to query the metadata contained within a Parquet file, which reveals various internal details of the Parquet file such as the statistics of the different columns. This can be useful
...etadata VARCHAR file_size_bytes UBIGINT footer_size UBIGINT column_orders VARCHAR[] Parquet Key-Value Metadata The parquet_kv_metadata function can be used to query custom metadata defined as key-value pairs: SELECT * FROM parquet_kv_metadata('test....parquet'); Below is a table of the columns returned by parquet_kv_metadata . Field Type file_name VARCHAR key BLOB value BLOB GeoParquet Metadata GeoParquet files store their geospatial me...encoding, the coordinate reference system, and more) under the geo key of the Parquet key-value metadata. Because parquet_kv_metadata returns the key and value as BLOB s that contain JSON, use the decode function to turn them into strings and the... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
- Reading and Writing Parquet Files 8501
- Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.par
...ELECT * FROM parquet_file_metadata('test.parquet'); Query the key-value metadata of a Parquet file : SELECT * FROM parquet_kv_metadata('test.parquet'); Query the schema of a Parquet file : SELECT * FROM parquet_schema('test.parquet'); Write the res...d) int96_as How to read INT96 columns (a deprecated timestamp encoding used by legacy writers such as Impala and older Spark versions). Options are timestamp (microsecond precision), timestamp_ns (preserves nanoseconds; out-of-range values saturate...d, COMPRESSION_LEVEL 1); Write to Parquet file with key-value metadata : COPY ( SELECT 42 AS number, true AS is_even ) TO 'kv_metadata.parquet' ( FORMAT parquet, KV_METADATA { number: 'Answer to life, universe, and everything', is_even: 'not ''odd'... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
- COPY Statement 7515
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...ty) PARQUET_VERSION The Parquet version to use ( V1 , V2 ). VARCHAR V1 CHUNK_SIZE Alias for ROW_GROUP_SIZE . BIGINT 122880 KV_METADATA Custom key-value metadata to embed in the file footer, supplied as a STRUCT of keys to values. BLOB values are wr... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work