Data Import
Examples
Write a table to a Hive partitioned data set of Parquet files:  
```sql
COPY orders TO 'orders' (FORMAT PARQUET, PARTITION_BY (year, month));
```  
Write a table to a Hive partitioned data set of CSV files, allowing overwrites:  
```sql
COPY orders TO 'orders' (FORMAT CSV, PARTITION_BY (year, month), OVERWRITE_OR_IGNORE);
```  
Write a table to a Hive partitioned data set of GZIP-compressed CSV files, setting explicit data files' extension:  
```sql
COPY orders TO 'orders' (FORMAT CSV, PARTITION_BY (year, month), COMPRESSION GZIP, FILE_EXTENSION 'csv.gz');
```