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

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

jon created TRAFODION-3304:
------------------------------

             Summary: 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


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)