drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bohdan Kazydub (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-6606) Hash Join returns incorrect data types when joining subqueries with limit 0
Date Fri, 13 Jul 2018 10:43:00 GMT
Bohdan Kazydub created DRILL-6606:
-------------------------------------

             Summary: Hash Join returns incorrect data types when joining subqueries with
limit 0
                 Key: DRILL-6606
                 URL: https://issues.apache.org/jira/browse/DRILL-6606
             Project: Apache Drill
          Issue Type: Task
            Reporter: Bohdan Kazydub


PreparedStatement for query
{code:sql}
SELECT l.l_quantity, l.l_shipdate, o.o_custkey
FROM (SELECT * FROM cp.`tpch/lineitem.parquet` LIMIT 0) l
    JOIN (SELECT * FROM cp.`tpch/orders.parquet` LIMIT 0) o 
    ON l.l_orderkey = o.o_orderkey
LIMIT 0
{code}
 is created with wrong types (nullable INTEGER) for all selected columns, no matter what
their actual type is. This behavior reproduces with hash join only and is very likely to be
caused by DRILL-6027 as the query works fine before this feature was implemented.

To reproduce the problem you can put the aforementioned query into TestPreparedStatementProvider#joinOrderByQuery()
test method.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message