You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@beam.apache.org by "Anton Kedin (JIRA)" <ji...@apache.org> on 2019/07/23 21:23:00 UTC

[jira] [Updated] (BEAM-7513) [SQL] Row Estimation for BigQueryTable

     [ https://issues.apache.org/jira/browse/BEAM-7513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anton Kedin updated BEAM-7513:
------------------------------
    Summary: [SQL] Row Estimation for BigQueryTable  (was: Row Estimation for BigQueryTable)

> [SQL] Row Estimation for BigQueryTable
> --------------------------------------
>
>                 Key: BEAM-7513
>                 URL: https://issues.apache.org/jira/browse/BEAM-7513
>             Project: Beam
>          Issue Type: New Feature
>          Components: dsl-sql, io-java-gcp
>            Reporter: Alireza Samadianzakaria
>            Assignee: Alireza Samadianzakaria
>            Priority: Major
>             Fix For: 2.14.0
>
>          Time Spent: 10h 10m
>  Remaining Estimate: 0h
>
> Calcite tables (org.apache.calcite.schema.Table) should implement the method org.apache.calcite.schema.Statistic getStatistic(). The Statistic instance returned by this method is used for the Volcano optimizer in Calcite. 
> Currently, org.apache.beam.sdk.extensions.sql.impl.BeamCalciteTable has not implemented getStatistic() which means it uses the implementation in org.apache.calcite.schema.impl.AbstractTable and that implementation just returns Statistics.UNKNOWN for all sources.
>  
> Things needed to be implemented:
> 1- Implementing getStatistic in BeamCalciteTable such that it calls a row count estimation method from BeamSqlTable and adding this method to BeamSqlTable.
> 2- Implementing the row count estimation method for BigQueryTable. 



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)