You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "jon (JIRA)" <ji...@apache.org> on 2019/04/24 00:05:00 UTC
[jira] [Updated] (TRAFODION-3304) Create Table on a select with 4
left joins creates the table and extra bad rows
[ https://issues.apache.org/jira/browse/TRAFODION-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
jon updated TRAFODION-3304:
---------------------------
Priority: Major (was: Minor)
> 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)