You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Fang-Yu Rao (Jira)" <ji...@apache.org> on 2023/09/05 22:20:00 UTC

[jira] [Created] (IMPALA-12423) Impala shell should allow a user to set up query options when the underlying protocol is strict_hs2_protocol

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)