[HIVE-28436] Incorrect syntax in Hive schema file for table MIN_HISTORY_LEVEL

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.1.0, 4.0.1
• Labels: hive-4.0.1-merged hive-4.0.1-must pull-request-available
• Assignee: Indhumathi Muthumurugesh Assign to me
• Reporter: Indhumathi Muthumurugesh
• Created: 05/Aug/24 19:05
• Updated: 24/Sep/24 02:15
• Resolved: 12/Aug/24 06:19

Description

Steps to Reproduce:

Install latest hive 4.1.0 version.

Run the below query in SYS DB.

select * from sys.MIN_HISTORY_LEVEL;

Exception:

ERROR : Failed with exception java.io.IOException:java.io.IOException: org.apache.hive.storage.jdbc.exception.HiveJdbcDatabaseAccessException: Caught exception while trying to execute query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM "MIN_HISTORY_LEVEL"' at line 4

java.io.IOException: java.io.IOException: org.apache.hive.storage.jdbc.exception.HiveJdbcDatabaseAccessException: Caught exception while trying to execute query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM "MIN_HISTORY_LEVEL"' at line 4

at org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:628)

at org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:535)

at org.apache.hadoop.hive.ql.exec.FetchTask.executeInner(FetchTask.java:194)

at org.apache.hadoop.hive.ql.exec.FetchTask.execute(FetchTask.java:95)

at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:201)

at org.apache.hadoop.hive.ql.Driver.run(Driver.java:142)

at org.apache.hadoop.hive.ql.Driver.run(Driver.java:137)

at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:185)

at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:236)

at org.apache.hive.service.cli.operation.SQLOperation.access$500(SQLOperation.java:90)

at org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:336)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.Subject.doAs(Subject.java:422)

at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)

at org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:356)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

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)

Issue Links

• links to: GitHub Pull Request #5388