insert-directory
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
insert-directory [2016/03/09 08:22] dmtolpeko |
insert-directory [2016/03/09 08:33] dmtolpeko |
||
|---|---|---|---|
| Line 15: | Line 15: | ||
| **Examples:** | **Examples:** | ||
| - | Export sales data for the current date: | + | Export sales data: |
| <code language=sql> | <code language=sql> | ||
| + | insert overwrite directory '/data/sales_daily' select * from sales_daily; | ||
| + | </code> | ||
| + | |||
| + | Export sales data from the specified table and put to the directory for the current date: | ||
| + | |||
| + | <code language=sql> | ||
| + | declare tabname string = 'sales_daily'; | ||
| + | |||
| insert overwrite directory '/data/sales_' || current_date | insert overwrite directory '/data/sales_' || current_date | ||
| - | 'select * from ' || 'sales_daily'; | + | 'select * from ' || tabname; |
| </code> | </code> | ||
Page Tools
