Skip to content

Instantly share code, notes, and snippets.

@v5tech
Created June 4, 2025 14:04
Show Gist options
  • Save v5tech/c9b292b3de332bc93ae11c6fa31f56f5 to your computer and use it in GitHub Desktop.
Save v5tech/c9b292b3de332bc93ae11c6fa31f56f5 to your computer and use it in GitHub Desktop.
CREATE OR REPLACE TABLE trains AS
FROM "http://blobs.duckdb.org/train_services.parquet";
FROM trains;
COPY (FROM trains) TO "./trains.csv";
FROM "./trains.csv";
SELECT * FROM read_csv_auto('user.csv', header=true);
CREATE TABLE tcs_bill_summary AS
SELECT * FROM read_csv_auto('/Users/fengj/Downloads/L3-明细账单/*.csv',
header=true,
encoding='UTF-8',
nullstr='-'
);
select count(*) from tcs_bill_summary;
select REPLACE("账单月", CHR(9), '') as "账单月","产品名称",sum("现金支付(元)") as "现金支付" from tcs_bill_summary group by "账单月","产品名称" order by "账单月";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment