⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 1.3 ドキュメント 全文検索
advanced help
per page, with , order by , clip by
Results of 1 - 1 of about 1 for purchases (0.001 sec.)
CLI Charting with YouPlot – DuckDB 9414
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 ... FROM read_json_auto('input.json')" To prepare the data for YouPlot, write a simple aggregate: duckdb -s "SELECT date, sum(purchases) AS total_purchases FROM read_json_auto('input.json') GROUP BY 1 ORDER BY 2 DESC LIMIT 10" Finally, wrap the SELECT in the ... , HEADER ); The full DuckDB command below outputs the query in CSV format with a header: duckdb -s "COPY (SELECT date, sum(purchases) AS total_purchases FROM read_json_auto('input.json') GROUP BY 1 ORDER BY 2 DESC LIMIT 10) TO '/dev/stdout' WITH (FORMAT c ... to YouPlot Finally, the data can now be piped to YouPlot! Let's assume we have an input.json file with dates and number of purchases made by somebody on that date. Using the query above, we'll pipe the data to the uplot command to draw a plot of the Top 1 ...
https://man.mtool.work/duckdb/1.3/guides/data_viewers/youplot.html
PREV 1 NEXT
DuckDB 1.3 Documentation / man.mtool.work