Export data to a file after logging into the Impala shell

Hello,

After logging into the impala shell and while at the hadoop prompt [hadoop-2:21000] >, we are able to execute queries and see data on the terminal. Does anyone know how to pipe the output of the query to a file? Consider the following command that results in the display of the tables at the terminal. How do I modify this command so as to pipe the output to a text file? TIA.[hadoop-2:21000] > show tables;Satish

I already read the guide. What I see is only the "script" command that lets you record all the terminal activities. That is understood. All I am wondering about is, if we login to the shell through putty without using the script command and then execute a query from the impala shell (i.e., the hadoop prompt you see), is there a way to redirect that output to a file on a per command basis. This is my first time looking at impala and to some extent sql as well and hence the question. There must be some redirection operator like your > symbol that we use to redirect output from a linux terminal, I guess?

Thank you. We managed to use traffic and export some data to .csv. However, we are wondering if it is possible to reduce the sampling rate? It seems as if he historical data is being sampled at 1 second intervals. Is there a way to get it at some rate, say, 30 sec intervals?

Regards,
Satish