[HIVE-12200] INSERT INTO table using a select statement w/o a FROM clause fails

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.3.0, 2.0.0
• Labels: TODOC1.3
• Hadoop Flags: Reviewed
• Assignee: Jimmy Xiang
• Reporter: Jimmy Xiang
• Created: 15/Oct/15 23:05
• Updated: 16/Feb/16 23:51
• Resolved: 20/Oct/15 16:44

Description

Here is the stack trace:

FailedPredicateException(regularBody,{$s.tree.getChild(1) !=null}?)
	at org.apache.hadoop.hive.ql.parse.HiveParser.regularBody(HiveParser.java:41047)
	at org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpressionBody(HiveParser.java:40222)
	at org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpression(HiveParser.java:40092)
	at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1656)
	at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1140)
	at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:202)
	at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)
	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:407)
	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:312)
	at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1162)
	at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1215)
	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1091)
	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1081)
	at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:225)
	at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:177)
	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:388)
	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:323)
	at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:731)
	at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:704)
	at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
	at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
FAILED: ParseException line 1:29 Failed to recognize predicate '<EOF>'. Failed rule: 'regularBody' in statement