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:21] 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_' || current_date 'select * from || 'sales_daily'; | + | 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 | ||
+ | 'select * from ' || tabname; | ||
</code> | </code> | ||