Dump query result to file without showing it in Database Console


I am using DataGrip to connect and query Impala (Hadoop). When I execute a query and then save the result, the query runs twice on the full dataset due to how Impala works.


Is there a way to immediately dump the query result to a file without having to run the query and then hit the "Dump Data" button?



Comment actions Permalink

This would be very useful for me as well

Comment actions Permalink

Try right-clicking or control-clicking (depending on your system) on your query and select "Execute to File" from the menu. Then choose how you want it saved from the sub-menu.



Please sign in to leave a comment.