Aihua Xu created HIVE-13854:
-------------------------------
Summary: select INPUT__FILE__NAME fails from the join query
Key: HIVE-13854
URL: https://issues.apache.org/jira/browse/HIVE-13854
Project: Hive
Issue Type: Bug
Components: Query Processor
Reporter: Aihua Xu
Assignee: Aihua Xu
The query {{select t1.INPUT__FILE__NAME from src t1 join src t2 limit 1;}}
fails with the following exception
{noformat}
java.lang.RuntimeException: cannot find field input__file__name from [0:key,
1:value]
at
org.apache.hadoop.hive.serde2.objectinspector.ObjectInspectorUtils.getStandardStructFieldRef(ObjectInspectorUtils.java:485)
at
org.apache.hadoop.hive.serde2.BaseStructObjectInspector.getStructFieldRef(BaseStructObjectInspector.java:133)
at
org.apache.hadoop.hive.ql.exec.ExprNodeColumnEvaluator.initialize(ExprNodeColumnEvaluator.java:55)
at
org.apache.hadoop.hive.ql.exec.Operator.initEvaluators(Operator.java:973)
at
org.apache.hadoop.hive.ql.exec.Operator.initEvaluatorsAndReturnStruct(Operator.java:999)
at
org.apache.hadoop.hive.ql.exec.SelectOperator.initializeOp(SelectOperator.java:75)
at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:355)
at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:504)
at
org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:457)
at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:365)
at
org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask.initializeOperators(MapredLocalTask.java:499)
at
org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask.startForward(MapredLocalTask.java:403)
at
org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask.executeInProcess(MapredLocalTask.java:383)
at
org.apache.hadoop.hive.ql.exec.mr.ExecDriver.main(ExecDriver.java:751)
{noformat}
when hive.auto.convert.join is set to true.
The workaround is to set hive.auto.convert.join to false.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
