[ https://issues.apache.org/jira/browse/HIVE-4922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13717628#comment-13717628 ]
Eric Hanson commented on HIVE-4922: ----------------------------------- I verified that comparisons with a scalar on the left and a column on the right run end-to-end, using these queries, which all run vectorized: select l_orderkey, l_shipmode from lineitem_orc where l_orderkey = 1 and 'MAIL' = l_shipmode; select l_orderkey, l_shipmode from lineitem_orc where l_orderkey = 1 and 'MAIL' <> l_shipmode; select l_orderkey, l_shipmode from lineitem_orc where l_orderkey = 1 and 'MAIL' <= l_shipmode; select l_orderkey, l_shipmode from lineitem_orc where l_orderkey = 1 and 'MAIL' >= l_shipmode; select l_orderkey, l_shipmode from lineitem_orc where l_orderkey = 1 and 'MAIL' < l_shipmode; select l_orderkey, l_shipmode from lineitem_orc where l_orderkey = 1 and 'MAIL' > l_shipmode; > create template for string scalar compared with string column > ------------------------------------------------------------- > > Key: HIVE-4922 > URL: https://issues.apache.org/jira/browse/HIVE-4922 > Project: Hive > Issue Type: Sub-task > Affects Versions: vectorization-branch > Reporter: Eric Hanson > Assignee: Eric Hanson > > Create a template to generate classes to handle comparisons with a scalar on > the left and a column on the right. > This allows queries similar to the following to run vectorized: > select l_orderkey, l_shipmode > from lineitem_orc > where l_orderkey = 1 and 'M' > l_shipmode; -- 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