[ 
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)

Reply via email to