Results of 1 - 2 of about 2 for ontime (0.001 sec.)
- CSV Import 11228
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...fer options: cat flights.csv | duckdb -c "SELECT * FROM read_csv('/dev/stdin')" Read a CSV file into a table: CREATE TABLE ontime ( FlightDate DATE, UniqueCarrier VARCHAR, OriginCityName VARCHAR, DestCityName VARCHAR ); COPY ontime FROM 'flights.csv';...atively, create a table without specifying the schema manually using a CREATE TABLE ... AS SELECT statement : CREATE TABLE ontime AS SELECT * FROM 'flights.csv'; We can use the FROM -first syntax to omit SELECT * . CREATE TABLE ontime AS FROM 'flights....the current working directory) or an absolute path. We can use read_csv to create a persistent table as well: CREATE TABLE ontime AS SELECT * FROM read_csv('flights.csv'); DESCRIBE ontime; column_name column_type null key default extra FlightDate DATE... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- query and query_table Functions 7485
- The query_table and query functions enable powerful and more dynamic SQL. The query_table function returns the table whose name is specified by its string argument; the query function returns the table obtained by executing the query specif
...))::VARCHAR AS "max_\0" FROM query_table(table_name::VARCHAR) ); SELECT * FROM my_summarize('https://blobs.duckdb.org/data/ontime.parquet') LIMIT 3; column_name min_value max_value year 2017 2017 quarter 1 3 month 1 9 The query function allows for even... - https://man.mtool.work/duckdb/2.0/guides/sql_features/query_and_query_table_func...
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work