Results of 1 - 2 of about 2 for orderkey (0.001 sec.)
- COPY Statement 11228
- 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
...a CSV file, omitting quotes: COPY lineitem TO lineitem.csv; Write the result 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 db...parators to create a TSV file without a header: COPY lineitem TO 'lineitem.tsv' (DELIMITER '\t', HEADER false); Copy the l_orderkey column of the lineitem table to the file orderkey.tbl : COPY lineitem(l_orderkey) TO 'orderkey.tbl' (DELIMITER '|'); Copy...ARRAY true); Return the files and their column statistics that were written as part of the COPY statement: COPY (SELECT l_orderkey, l_comment FROM lineitem) TO 'lineitem_part.parquet' (RETURN_STATS); filename count file_size_bytes footer_size_bytes colu... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Summarize 7485
- The SUMMARIZE command can be used to easily compute a number of aggregates over a table or a query. The SUMMARIZE command launches a query that computes a number of aggregates over all columns ( min , max , approx_unique , avg , std , q25 ,
...gen(sf = 1); SUMMARIZE lineitem; column_name column_type min max approx_unique avg std q25 q50 q75 count null_percentage l_orderkey INTEGER 1 6000000 1508227 3000279.604204982 1732187.8734803519 1509447 2989869 4485232 6001215 0.00 l_partkey INTEGER 1 20... - https://man.mtool.work/duckdb/2.0/guides/meta/summarize.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work