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)
