[jira] [Created] (HIVE-26287) beeline exit status code is 0 when connection to server fails

["Pavel Solomin (Jira)" <ji...@apache.org>]

Pavel Solomin created HIVE-26287:
------------------------------------

             Summary: beeline exit status code is 0 when connection to server fails
                 Key: HIVE-26287
                 URL: https://issues.apache.org/jira/browse/HIVE-26287
             Project: Hive
          Issue Type: Bug
          Components: Beeline
    Affects Versions: 3.1.3
         Environment: {code:java}
bash-4.2$ cat /etc/os-release
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"

bash-4.2$ echo ${BASH_VERSION}
4.2.46(2)-release

bash-4.2$ java -version
openjdk version "1.8.0_322"
OpenJDK Runtime Environment (build 1.8.0_322-b06)
OpenJDK 64-Bit Server VM (build 25.322-b06, mixed mode)


bash-4.2$ beeline --version
Hive 3.1.3 Git git://MacBook-Pro.fios-router.home/Users/ngangam/commit/hive -r 4df4d75bf1e16fe0af75aad0b4179c34c07fc975 Compiled by ngangam on Sun Apr 3 16:58:16 EDT 2022 From source with checksum 5da234766db5dfbe3e92926c9bbab2af{code}
 
            Reporter: Pavel Solomin


When beeline is used to run script files (-f /path/to/hql), it exits with 0 status code even when connection to HiveServer2 fails:
{code:java}
bash-4.2$ echo "select 1" > /tmp/query.hql
bash-4.2$ beeline -u foo -f /tmp/query.hql
scan complete in 3ms
scan complete in 6ms
No known driver to handle "foo"
bash-4.2$ echo $?
0

bash-4.2$ beeline -u jdbc:hive2://bar.com:10000 -f /tmp/query.hql 
Connecting to jdbc:hive2://bar.com:10000
22/06/02 17:46:50 [main]: WARN jdbc.HiveConnection: Failed to connect to bar.com:10000
Could not open connection to the HS2 server. Please check the server URI and if the URI is correct, then ask the administrator to check the server status.
Error: Could not open client transport with JDBC Uri: jdbc:hive2://bar.com:10000: java.net.ConnectException: Connection timed out (Connection timed out) (state=08S01,code=0)
bash-4.2$ echo $?
0{code}
When -e flag is used, the tool seems to report the correct exit status code:
{code:java}
bash-4.2$ beeline -u foo -e "select 1"                            
scan complete in 4ms
scan complete in 3ms
No known driver to handle "foo"
Cannot run commands specified using -e. No current connection
bash-4.2$ echo $?
1{code}
This bug looks to be similar to:

https://issues.apache.org/jira/browse/HIVE-6978

https://issues.apache.org/jira/browse/HIVE-9263

https://issues.apache.org/jira/browse/HIVE-12612

 



--
This message was sent by Atlassian Jira
(v8.20.7#820007)