Exporting data from employees table to /tmp/ca_employees
INSERT OVERWRITE LOCAL DIRECTORY '/tmp/ca_employees' SELECT name, salary, address FROM employees WHERE se.state = 'CA';
Exporting data from employees table to multiple local directories based on specific condition
The below query shows how ...
