[ https://issues.apache.org/jira/browse/HIVE-11372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15036562#comment-15036562 ]
Matt McCline commented on HIVE-11372: ------------------------------------- MR: VectorMapJoinOperator input batch: {code} VectorizedBatchUtil.java:debugDisplayOneRow(694)) - process row 0 (col 0) 0 (col 1) NULL VectorizedBatchUtil.java:debugDisplayOneRow(694)) - process row 1 (col 0) 1 (col 1) -1 VectorizedBatchUtil.java:debugDisplayOneRow(694)) - process row 2 (col 0) 2 (col 1) 0 VectorizedBatchUtil.java:debugDisplayOneRow(694)) - process row 3 (col 0) 3 (col 1) 1 VectorizedBatchUtil.java:debugDisplayOneRow(694)) - process row 4 (col 0) 4 (col 1) 10 {code} Very strange -- the key expressions are both empty? {code} Stage: Stage-3 Map Reduce Map Operator Tree: TableScan alias: tsint Statistics: Num rows: 5 Data size: 36 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: rnum (type: int), csint (type: smallint) outputColumnNames: _col0, _col1 Statistics: Num rows: 5 Data size: 36 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Inner Join 0 to 1 keys: 0 1 outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 5 Data size: 39 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: _col1 BETWEEN _col3 AND _col3 (type: boolean) Statistics: Num rows: 2 Data size: 15 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: int), _col2 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 2 Data size: 15 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 2 Data size: 15 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized Local Work: Map Reduce Local Work {code} > join with between predicate comparing integer types returns no rows when ORC > format used > ---------------------------------------------------------------------------------------- > > Key: HIVE-11372 > URL: https://issues.apache.org/jira/browse/HIVE-11372 > Project: Hive > Issue Type: Bug > Affects Versions: 1.2.0 > Reporter: N Campbell > Assignee: Matt McCline > Attachments: TINT, TSINT > > > getDatabaseProductName Apache Hive > getDatabaseProductVersion 1.2.1.2.3.0.0-2557 > getDriverName Hive JDBC > getDriverVersion 1.2.1.2.3.0.0-2557 > getDriverMajorVersion 1 > getDriverMinorVersion 2 > select tint.rnum, tsint.rnum from tint , tsint where tint.cint between > tsint.csint and tsint.csint > when ORC used no rows returned versus TEXT > create table if not exists TSINT ( RNUM int , CSINT smallint ) > -- ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' > STORED AS orc ; > create table if not exists TINT ( RNUM int , CINT int ) > -- ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' > STORED AS orc ; -- This message was sent by Atlassian JIRA (v6.3.4#6332)