[HIVE-20909] Just "MSCK" should throw SemanticException

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 4.0.0
• Component/s: Hive
• Assignee: Naveen Gangam
• Reporter: Naveen Gangam
• Created: 13/Nov/18 16:20
• Updated: 13/Nov/18 16:20

Description

Per documentation, the syntax for MSCK command is
MSCK [REPAIR] TABLE table_name [ADD/DROP/SYNC PARTITIONS];

So just submitting "MSCK" should throw a SemanticException like it does for other queries with incorrect syntax. But instead it appears to be attempting to do something.

$ hive --hiveconf hive.root.logger=INFO,console -e "msck;"

2018-11-08T15:21:25,016 INFO [main] SessionState:
2018-11-08T15:21:26,203 INFO [main] session.SessionState: Created HDFS directory: /tmp/hive/hive/b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78
2018-11-08T15:21:26,222 INFO [main] session.SessionState: Created local directory: /tmp/root/b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78
2018-11-08T15:21:26,229 INFO [main] session.SessionState: Created HDFS directory: /tmp/hive/hive/b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78/_tmp_space.db
2018-11-08T15:21:26,244 INFO [main] conf.HiveConf: Using the default value passed in for log id: b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78
2018-11-08T15:21:26,246 INFO [main] session.SessionState: Updating thread name to b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78 main
2018-11-08T15:21:26,246 INFO [b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78 main] conf.HiveConf: Using the default value passed in for log id: b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78
2018-11-08T15:21:26,548 INFO [b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78 main] ql.Driver: Compiling command(queryId=root_20181108152126_3babeb6f-8396-4ef3-8f85-2cbf12ebe9c1): msck
2018-11-08T15:21:28,140 INFO [b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78 main] hive.metastore: Trying to connect to metastore with URI thrift://nightly61x-1.vpc.cloudera.com:9083
2018-11-08T15:21:28,184 INFO [b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78 main] hive.metastore: Opened a connection to metastore, current connections: 1
2018-11-08T15:21:28,185 INFO [b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78 main] hive.metastore: Connected to metastore.
FAILED: SemanticException empty table creation??
2018-11-08T15:21:28,339 ERROR [b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78 main] ql.Driver: FAILED: SemanticException empty table creation??
org.apache.hadoop.hive.ql.parse.SemanticException: empty table creation??
at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.getTable(BaseSemanticAnalyzer.java:1670)
at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.getTable(BaseSemanticAnalyzer.java:1652)
at org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeMetastoreCheck(DDLSemanticAnalyzer.java:3118)
at org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeInternal(DDLSemanticAnalyzer.java:414)
at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:250)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:600)
at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1414)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1543)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1332)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1321)
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:187)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:409)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:342)
at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:802)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:774)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:701)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:313)
at org.apache.hadoop.util.RunJar.main(RunJar.java:227)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: empty table creation??
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1273)
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1234)
at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.getTable(BaseSemanticAnalyzer.java:1663)
... 22 more

2018-11-08T15:21:28,340 INFO [b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78 main] ql.Driver: Completed compiling command(queryId=root_20181108152126_3babeb6f-8396-4ef3-8f85-2cbf12ebe9c1); Time taken: 2.044 seconds
2018-11-08T15:21:28,356 INFO [b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78 main] conf.HiveConf: Using the default value passed in for log id: b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78
2018-11-08T15:21:28,356 INFO [b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78 main] session.SessionState: Resetting thread name to main
2018-11-08T15:21:28,366 INFO [main] conf.HiveConf: Using the default value passed in for log id: b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78
2018-11-08T15:21:28,381 INFO [main] session.SessionState: Deleted directory: /tmp/hive/hive/b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78 on fs with scheme hdfs
2018-11-08T15:21:28,382 INFO [main] session.SessionState: Deleted directory: /tmp/root/b1b62e04-5a1c-4c6a-babd-31b4f1d2bd78 on fs with scheme file
2018-11-08T15:21:28,385 INFO [main] hive.metastore: Closed a connection to metastore, current connections: 0