You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Qifan Chen (Jira)" <ji...@apache.org> on 2020/06/08 14:11:00 UTC
[jira] [Updated] (IMPALA-9839) A logging functionality from within
the impala-shell is desirable
[ https://issues.apache.org/jira/browse/IMPALA-9839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Qifan Chen updated IMPALA-9839:
-------------------------------
Description:
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].
was:
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].
> 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
> Priority: Minor
>
> 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