insert-directory
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Last revision Both sides next revision | ||
|
insert-directory [2016/03/09 08:22] dmtolpeko |
insert-directory [2016/03/09 08:28] dmtolpeko |
||
|---|---|---|---|
| Line 18: | Line 18: | ||
| <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
