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)
