[
https://issues.apache.org/jira/browse/HIVE-20909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Naveen Gangam reassigned HIVE-20909:
------------------------------------
> 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
> Priority: Minor
>
> 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)
