[HIVE-4684] Query with filter constant on left of "=" and column expression on right does not vectorize

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: vectorization-branch, 0.13.0
• Component/s: Query Processor
• Assignee: Jitendra Nath Pandey
• Reporter: Eric N. Hanson
• Created: 07/Jun/13 17:32
• Updated: 23/Oct/13 21:59
• Resolved: 23/Jul/13 19:04

Description

select dmachineid from factsqlengineam_vec_orc where 1073 = dmachineid + 1;

Does not go down the vectorization path.

Output:

hive> select dmachineid from factsqlengineam_vec_orc where 1073 = dmachineid + 1;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Validating if vectorized execution is applicable
Cannot vectorize the plan: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassNotFoundException: org.apache.hadoop.hiv
e.ql.exec.vector.expressions.gen.FilterLongScalarEqualLongColumn
Starting Job = job_201306061504_0038, Tracking URL = http://localhost:50030/jobdetails.jsp?jobid=job_201306061504_0038
Kill Command = c:\Hadoop\hadoop-1.1.0-SNAPSHOT\bin\hadoop.cmd job -kill job_201306061504_0038
Hadoop job information for Stage-1: number of mappers: 8; number of reducers: 0
2013-06-07 10:25:30,932 Stage-1 map = 0%, reduce = 0%
2013-06-07 10:25:39,953 Stage-1 map = 25%, reduce = 0%
2013-06-07 10:25:42,959 Stage-1 map = 49%, reduce = 0%, Cumulative CPU 8.172 sec
2013-06-07 10:25:43,962 Stage-1 map = 49%, reduce = 0%, Cumulative CPU 8.172 sec
...