Fang-Yu Rao created IMPALA-12423:
------------------------------------
Summary: Impala shell should allow a user to set up query options
when the underlying protocol is strict_hs2_protocol
Key: IMPALA-12423
URL: https://issues.apache.org/jira/browse/IMPALA-12423
Project: IMPALA
Issue Type: New Feature
Reporter: Fang-Yu Rao
Assignee: Fang-Yu Rao
Currently when we use the Impala shell to connect to a service, e.g.,
HiveServer2, via the strict HS2 protocol, we are not able to execute the SET
statement or to set up the value of a query option as shown in the following.
It would be much more convenient if a user is at least able to set up the value
of a query option in the Impala shell when the Impala shell is used to connect
to an external frontend that sends query plans to the Impala server for
execution.
{code:java}
fangyurao@fangyu-upstream-dev:~$ impala-shell.sh -i 'localhost:11050'
--strict_hs2_protocol
Starting Impala Shell with no authentication using Python 2.7.16
WARNING: Unable to track live progress with strict_hs2_protocol
LDAP password for fangyurao:
Opened TCP connection to localhost:11050
Connected to localhost:11050
Server version: N/A
***********************************************************************************
Welcome to the Impala shell.
(Impala Shell v4.3.0-SNAPSHOT (2f06a7b) built on Tue Sep 5 14:14:24 PDT 2023)
To see how Impala will plan to run your query without actually executing it, use
the EXPLAIN command. You can change the level of detail in the EXPLAIN output by
setting the EXPLAIN_LEVEL query option.
***********************************************************************************
[localhost:11050] default> set;
Query options (defaults shown in []):
No options available.
Shell Options
WRITE_DELIMITED: False
VERBOSE: True
VERTICAL: False
LIVE_SUMMARY: False
OUTPUT_FILE: None
DELIMITER: \t
LIVE_PROGRESS: False
Variables:
No variables defined.
[localhost:11050] default> set num_nodes=2;
Unknown query option: num_nodes
Available query options, with their values (defaults shown in []):
Query options (defaults shown in []):
No options available.
Shell Options
WRITE_DELIMITED: False
VERBOSE: True
VERTICAL: False
LIVE_SUMMARY: False
OUTPUT_FILE: None
DELIMITER: \t
LIVE_PROGRESS: False
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
