[
https://issues.apache.org/jira/browse/HIVE-4684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13697207#comment-13697207
]
Jitendra Nath Pandey commented on HIVE-4684:
--------------------------------------------
All the expressions generated in getVectorBinaryComparisonFilterExpression are
filter expressions. We don't need to check for the opType in this method. The
boolean expressions outside the 'where clause' e.g. in projections are not
being handled right now. That should be addressed separately in a different
jira.
> 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
> Assignee: Sarvesh Sakalanaga
> Attachments: Hive-4684.0.patch
>
>
> 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
