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