Results of 1 - 8 of about 8 for flights (0.003 sec.)
- CSV Import – DuckDB 13085
- 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
...Sitemap Live Demo Documentation / Data Import / CSV Files Copy Markdown CSV Import 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 cust...om options: SELECT * FROM read_csv ( 'flights.csv' , delim = '|' , header = true , columns = { 'FlightDate' : 'DATE' , 'UniqueCarrier' : 'VARCHAR' , 'OriginCityName' :...'VARCHAR' , 'DestCityName' : 'VARCHAR' }); Read a CSV from stdin, auto-infer options: cat flights.csv | duckdb -c "SELECT * FROM read_csv('/dev/stdin')" Read a CSV file into a table: CREATE TABLE ontime ( FlightDate DATE... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- CSV Import Tips – DuckDB 10573
- 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
...Import Tips Below is a collection of tips to help when attempting to import complex CSV files. In the examples, we use the flights.csv file. Override the Header Flag if the Header Is Not Correctly Detected If a file contains only string columns the head...er auto-detection might fail. Provide the header option to override this behavior. SELECT * FROM read_csv ( 'flights.csv' , header = true ); Provide Names if the File Does Not Contain a Header If the file does not contain a header, names w...ill be auto-generated by default. You can provide your own names with the names option. SELECT * FROM read_csv ( 'flights.csv' , names = [ 'DateOfFlight' , 'CarrierName' ]); Override the Types of Specific Columns The types flag can be used to o... - https://man.mtool.work/duckdb/1.3/data/csv/tips.html
- R Client – DuckDB 8639
- 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
...rom R. Here is an example: library ( "duckdb" ) library ( "dplyr" ) con <- dbConnect ( duckdb ()) duckdb_register ( con , "flights" , nycflights13 :: flights ) tbl ( con , "flights" ) |> group_by ( dest ) |> summarise ( delay = mean ( dep_time , na.rm =...> summarise ( across ( disp : wt , .fns = mean )) |> collect () # Establish a set of Parquet files dbExecute ( con , "COPY flights TO 'dataset' (FORMAT parquet, PARTITION_BY (year, month))" ) # Summarize the dataset in DuckDB to avoid reading 12 Parquet... - https://man.mtool.work/duckdb/1.3/clients/r.html
- CREATE TABLE Statement – DuckDB 8639
- 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
...tion, the FROM -first syntax , and the HTTP(S) support , yielding concise SQL commands such as the following: CREATE TABLE flights AS FROM 'https://duckdb.org/data/flights.csv' ; The CTAS construct also works with the OR REPLACE modifier, yielding CREAT...E OR REPLACE TABLE ... AS statements: CREATE OR REPLACE TABLE flights AS FROM 'https://duckdb.org/data/flights.csv' ; Copying the Schema You can create a copy of the table's schema (column nam... - https://man.mtool.work/duckdb/1.3/sql/statements/create_table.html
- Combining Schemas – DuckDB 8549
- 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
...Copy Markdown Combining Schemas Examples Read a set of CSV files combining columns by position: SELECT * FROM read_csv ( 'flights*.csv' ); Read a set of CSV files combining columns by name: SELECT * FROM read_csv ( 'flights*.csv' , union_by_name = true...file is combined together, as well as the second column in each file, etc. For example, consider the following two files. flights1.csv : FlightDate|UniqueCarrier|OriginCityName|DestCityName 1988-01-01|AA|New York, NY|Los Angeles, CA 1988-01-02|AA|New Y...ork, NY|Los Angeles, CA flights2.csv : FlightDate|UniqueCarrier|OriginCityName|DestCityName 1988-01-03|AA|New York, NY|Los Angeles, CA Reading the two fil... - https://man.mtool.work/duckdb/1.3/data/multiple_files/combining_schemas.html
- CSV Auto Detection – DuckDB 8061
- 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
...ct detection. Parameters Considered values delim , | ; \t quote " ' (empty) escape " ' \ (empty) Consider the example file flights.csv : FlightDate|UniqueCarrier|OriginCityName|DestCityName 1988-01-01|AA|New York, NY|Los Angeles, CA 1988-01-02|AA|New Yo...type has the lowest priority meaning that all columns are converted to VARCHAR if they cannot be cast to anything else. In flights.csv the FlightDate column will be cast to a DATE , while the other columns will be cast to VARCHAR . The set of candidate...works by checking if the candidate header row deviates from the other rows in the file in terms of types. For example, in flights.csv , we can see that the header row consists of only VARCHAR columns – whereas the values contain a DATE value for the Fl... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
- Parquet Tips – DuckDB 7374
- 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
...t or missing columns. For files that do not have certain columns, NULL values are filled in: SELECT * FROM read_parquet ( 'flights*.parquet' , union_by_name = true ); Tips for Writing Parquet Files Using a glob pattern upon read or a Hive partitioning s... - https://man.mtool.work/duckdb/1.3/data/parquet/tips.html
- Reading Multiple Files – DuckDB 7284
- 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
...all files with a name ending in .csv , at any depth in the folder dir : SELECT * FROM 'dir/**/*.csv' ; Read the CSV files flights1.csv and flights2.csv : SELECT * FROM read_csv ([ 'flights1.csv' , 'flights2.csv' ]); Read the CSV files flights1.csv and...flights2.csv , unifying schemas by name and outputting a filename column: SELECT * FROM read_csv ([ 'flights1.csv' , 'flights2.csv' ], union_by_name = true , filename = true ); Parquet Read all files that match the glob pattern: SE...extra filename column to the result that indicates which row came from which file. For example: SELECT * FROM read_csv ([ 'flights1.csv' , 'flights2.csv' ], union_by_name = true , filename = true ); FlightDate OriginCityName DestCityName UniqueCarrier f... - https://man.mtool.work/duckdb/1.3/data/multiple_files/overview.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work