[HIVE-21061] CTAS query fails with IllegalStateException for empty source

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Hive
• Hadoop Flags: Reviewed
• Assignee: Riju Trivedi
• Reporter: Riju Trivedi
• Created: 20/Dec/18 13:13
• Updated: 17/Nov/22 08:54
• Resolved: 30/Apr/19 06:02

Description

Creating a table using CTAS from an empty source table with predicate condition evaluating to False

create table testctas1 (id int);
create table testctas2 as select * from testctas1 where 1=2;

Fails with below exception:

Caused by: java.lang.IllegalStateException: null
 at com.google.common.base.Preconditions.checkState(Preconditions.java:159)
 at org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer$VectorizationDispatcher.verifyAndSetVectorPartDesc(Vectorizer.java:1312)
 at org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer$VectorizationDispatcher.validateInputFormatAndSchemaEvolution(Vectorizer.java:1654)
 at org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer$VectorizationDispatcher.validateAndVectorizeMapWork(Vectorizer.java:1865)
 at org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer$VectorizationDispatcher.convertMapWork(Vectorizer.java:1109)
 at org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer$VectorizationDispatcher.dispatch(Vectorizer.java:961)
 at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.dispatch(TaskGraphWalker.java:111)
 at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.walk(TaskGraphWalker.java:180)
 at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.startWalking(TaskGraphWalker.java:125)
 at org.apache.hadoop.hive.ql.optimizer.physical.Vectorizer.resolve(Vectorizer.java:2442)
 at org.apache.hadoop.hive.ql.parse.TezCompiler.optimizeTaskPlan(TezCompiler.java:717)
 at org.apache.hadoop.hive.ql.parse.TaskCompiler.compile(TaskCompiler.java:258)
 at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:12443)
 at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:358)
 at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:285)
 at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:664)
 at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1863)
 at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1810)
 at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1805)
 at org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
 at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:197)
 ... 36 more