You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Steven Phillips (JIRA)" <ji...@apache.org> on 2014/05/14 05:31:16 UTC
[jira] [Commented] (DRILL-714) verification fails for self-join on
varchar columns
[ https://issues.apache.org/jira/browse/DRILL-714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13997236#comment-13997236 ]
Steven Phillips commented on DRILL-714:
---------------------------------------
I am not seeing this result.
Could you describe your set up in more detail?
> verification fails for self-join on varchar columns
> ---------------------------------------------------
>
> Key: DRILL-714
> URL: https://issues.apache.org/jira/browse/DRILL-714
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Zhiyong Liu
>
> git.commit.id=e7a486d784c072458d44b7692ea0262da368f001
> 2014-05-13 11:26:56 INFO QuerySubmitter:89 - Submitting query:
> select count(*)
> from part p1, part p2
> where p1.p_name = p2.p_name
> and p1.p_mfgr = p2.p_mfgr
> 2014-05-13 11:27:02 INFO DrillTestBase:201 - Query submit end time: 2014/05/13 11:27:02.0002
> 2014-05-13 11:27:02 INFO DrillTestBase:202 - The execution time for the query: 6 seconds.
> 2014-05-13 11:27:02 INFO TestVerifier:203 - These rows are not expected:
> 2014-05-13 11:27:02 INFO TestVerifier:206 - 1998 : 1 time(s).
> 2014-05-13 11:27:02 INFO TestVerifier:213 - Total number of unexpected rows: 1
> 2014-05-13 11:27:02 INFO TestVerifier:217 - These rows are expected but are not in result set:
> 2014-05-13 11:27:02 INFO TestVerifier:220 - 2000 : 1 time(s).
> 2014-05-13 11:27:02 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)