[jira] [Created] (IMPALA-9839) A logging functionality from within the impala-shell is desirable

["Qifan Chen (Jira)" <ji...@apache.org>]

Qifan Chen created IMPALA-9839:
----------------------------------

             Summary: A logging functionality from within the impala-shell is desirable
                 Key: IMPALA-9839
                 URL: https://issues.apache.org/jira/browse/IMPALA-9839
             Project: IMPALA
          Issue Type: Improvement
          Components: Backend
            Reporter: Qifan Chen


Currently, one can easily submit a SQL script to impala-shell through the the f option. However, there exists no means in impala-shell to log the entire execution of the SQL script, including each query text (DDL/DML) and its execution result, into a log file. The log file can be very useful for review purpose. 

 

One could simulate the functionality through the Linux command 'script' as shown below.

 

script -f mylogfile.txt

impala-shell.sh -f myqueries.txt

exit

 

It is desirable to add a logging command to impala-shell to facilitate the above as follows.

 

impala-shell.sh

> log mylogfile.txt;

> select * from t;

... ...

> 

 

A minimal set of functionalities for the logging command can be the following.
 # Specification of a logging text file;
 # Optionally clear the content of the logging text file before logging;
 # Start the logging;
 # Stop the logging.

 

A similar feature exists in MySQL [here|[https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-application-log-introduction.html],] and in Trafodion [here|https://trafodion.apache.org/docs/command_interface/index.html#cmd_log].

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org