[jira] [Commented] (TRAFODION-3304) Create Table on a select with 4 left joins creates the table and extra bad rows

["jon (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16824677#comment-16824677 ] 

jon commented on TRAFODION-3304:
--------------------------------

Crud - I meant to attach this to Apache Impala. Sorry

> Create Table on a select with 4 left joins creates the table and extra bad rows
> -------------------------------------------------------------------------------
>
>                 Key: TRAFODION-3304
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-3304
>             Project: Apache Trafodion
>          Issue Type: Bug
>         Environment: Using Hue to access Impala. I sadly don't know what version of Impala or Kudu I am working with
>            Reporter: jon
>            Priority: Major
>              Labels: newbie
>
> Create Table on a select with 4 left joins creates the table, but the row count of the table differs from when I just do a count(*) and left join the tables after
> select <ALL MY COLUMNS>
> from table1 
> left join table2
> on table1.pk = table2.pk
> left join table3
> on table1.pk = table3.pk
> left join table4
> on table1.pk = table4.pk
> left join table5
> on table1.pk = table5.pk
>  
> However, when I do the query below, I get the correct row count:
> select count(*)
> FROM TABLE1
> LEFT JOIN .... <same remaining query as above query>
>  
> I am using Kudu as a DB and impala to query Kudu. I think the issue has to do when the query is actually materializing the columns and rows in a CREATE TABLE that the bug occurs.
>  



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