Dump query result to file without showing it in Database Console

Answered

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?

 

Thanks

5
2 comments
Avatar
Permanently deleted user

This would be very useful for me as well

1
Avatar
Permanently deleted user

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.

 

3

Please sign in to leave a comment.