[jira] [Created] (HIVE-20909) Just "MSCK" should throw SemanticException

["Naveen Gangam (JIRA)" <ji...@apache.org>]

Naveen Gangam created HIVE-20909:
------------------------------------

             Summary: Just "MSCK" should throw SemanticException
                 Key: HIVE-20909
                 URL: https://issues.apache.org/jira/browse/HIVE-20909
             Project: Hive
          Issue Type: Bug
          Components: Hive
    Affects Versions: 4.0.0
            Reporter: Naveen Gangam
            Assignee: Naveen Gangam


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

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)