[HIVE-6978] beeline always exits with 0 status, should exit with non-zero status on error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.12.0
• Fix Version/s: 0.14.0
• Component/s: HiveServer2
• Assignee: Navis Ryu
• Reporter: Gwen Shapira
• Created: 25/Apr/14 22:31
• Updated: 04/Mar/15 15:10
• Resolved: 01/Sep/14 01:55

Description

Was supposed to be fixed in Hive 0.12 (HIVE-4364). Doesn't look fixed from here.

[i@p sqoop]$ beeline -u 'jdbc:hive2://p:10000/k;principal=hive/p@L' -e "select * from MEMBERS" --outputformat=vertical
scan complete in 3ms
Connecting to jdbc:hive2://p:10000/k;principal=hive/p@L
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-5.0.0-1.cdh5.0.0.p0.47/lib/zookeeper/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-5.0.0-1.cdh5.0.0.p0.47/lib/avro/avro-tools-1.7.5-cdh5.0.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
Connected to: Apache Hive (version 0.12.0-cdh5.0.0)
Driver: Hive JDBC (version 0.12.0-cdh5.0.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
-hiveconf (No such file or directory)
hive.aux.jars.path=[redacted]
Error: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 1:14 Table not found 'MEMBERS' (state=42S02,code=10001)
Beeline version 0.12.0-cdh5.0.0 by Apache Hive
Closing: org.apache.hive.jdbc.HiveConnection
[inter@p sqoop]$ echo $?
0

Issue Links

• duplicates: HIVE-9263 Implement controllable exit code in beeline
• links to: review board