You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/05/20 18:02:57 UTC
[jira] [Commented] (DRILL-715) verification fails for 2 join
conditions on a compound primary key
[ https://issues.apache.org/jira/browse/DRILL-715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14003537#comment-14003537 ]
Jacques Nadeau commented on DRILL-715:
--------------------------------------
Fixed in 5d7e3d3
> verification fails for 2 join conditions on a compound primary key
> ------------------------------------------------------------------
>
> Key: DRILL-715
> URL: https://issues.apache.org/jira/browse/DRILL-715
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Zhiyong Liu
>
> 2014-05-13 11:29:53 INFO QuerySubmitter:89 - Submitting query:
> select count(*)
> from (select l.l_quantity
> from lineitem l, partsupp ps
> where l.l_partkey = ps.ps_partkey
> and l.l_suppkey = ps.ps_suppkey) as foo
> 2014-05-13 11:30:08 INFO DrillTestBase:201 - Query submit end time: 2014/05/13 11:30:08.0008
> 2014-05-13 11:30:08 INFO DrillTestBase:202 - The execution time for the query: 14 seconds.
> 2014-05-13 11:30:08 INFO TestVerifier:203 - These rows are not expected:
> 2014-05-13 11:30:08 INFO TestVerifier:206 - 60164 : 1 time(s).
> 2014-05-13 11:30:08 INFO TestVerifier:213 - Total number of unexpected rows: 1
> 2014-05-13 11:30:08 INFO TestVerifier:217 - These rows are expected but are not in result set:
> 2014-05-13 11:30:08 INFO TestVerifier:220 - 60175 : 1 time(s).
> 2014-05-13 11:30:08 INFO TestVerifier:227 - Total number of expected but missing: 1
> also, inconsistent resultset in split file tables.
--
This message was sent by Atlassian JIRA
(v6.2#6252)