Eric Hanson created HIVE-4684: --------------------------------- Summary: Query with filter constant on left of "=" and column expression on right does not vectorize Key: HIVE-4684 URL: https://issues.apache.org/jira/browse/HIVE-4684 Project: Hive Issue Type: Sub-task Components: Query Processor Reporter: Eric Hanson
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 ... -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira