[HIVE-28674] MV creation having partition on clause fails when cbo is false

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Assignee: Raghav Aggarwal
• Reporter: Raghav Aggarwal
• Created: 19/Dec/24 17:11
• Updated: 23/Dec/24 16:11

Description

Attaching q file to reproduce the issue on master (f44e1beacb0d8f115c2a0b6d8c88088537aa2e15) branch.

Stacktrace:

2024-12-19 22:39:51,265 ERROR thrift.ThriftCLIService: Failed to execute statement [request: TExecuteStatementReq(sessionHandle:TSessionHandle(sessionId:THandleIdentifier(guid:9B 9D 01 B6 88 5B 40 F4 A5 59 E1 5A 0C 20 A4 F6, secret:13 B6 05 75 1B 9B 44 FD 91 B1 8A BC CC FE EC 39)), statement:create materialized view mv1 disable rewrite partitioned on (deptno) as select * from emps where empid < 150, confOverlay:{}, runAsync:true, queryTimeout:0)]
org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException 1:86 The number of columns produced by the SELECT clause does not match the number of column names specified by CREATE VIEW. Error encountered near token '150'; Query ID: raghav_20241219223951_e95d229a-2e82-4e27-a131-3cace6bdbd0f
    at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:376)
    at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:212)
    at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:268)
    at org.apache.hive.service.cli.operation.Operation.run(Operation.java:286)
    at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:558)
    at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:543)
    at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:316)
    at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:652)
    at org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1670)
    at org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1650)
    at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38)
    at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:38)
    at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
    at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:250)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:750)
Caused by: org.apache.hadoop.hive.ql.parse.SemanticException: 1:86 The number of columns produced by the SELECT clause does not match the number of column names specified by CREATE VIEW. Error encountered near token '150'
    at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.saveViewDefinition(SemanticAnalyzer.java:13426)
    at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:13274)
    at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:12669)
    at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:332)
    at org.apache.hadoop.hive.ql.Compiler.analyze(Compiler.java:224)
    at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:109)
    at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:499)
    at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:451)
    at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:415)
    at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:409)
    at org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
    at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:205)
    ... 15 more 

Issue Links

• relates to: HIVE-27830 Deprecate hive.cbo.enable property