You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "LakeShen (Jira)" <ji...@apache.org> on 2023/08/08 13:35:00 UTC
[jira] (CALCITE-5906) RelToSqlConverter throw AssertionError when RelNode tree has the Sample RelNode
[ https://issues.apache.org/jira/browse/CALCITE-5906 ]
LakeShen deleted comment on CALCITE-5906:
-----------------------------------
was (Author: shenlang):
Because of the TableSample percentage is float datatype, like this :
!image-2023-08-08-20-16-27-188.png|width=322,height=133!
When I tried to transform Sample to TABLESAMPLE SqlCall,it shows imprecise precision,like this :
!image-2023-08-08-20-19-01-269.png|width=516,height=114!
I want to change the TableSample percentage to the type of precise precision,such as bigdecimal,could anyone else give me some advice?
> RelToSqlConverter throw AssertionError when RelNode tree has the Sample RelNode
> -------------------------------------------------------------------------------
>
> Key: CALCITE-5906
> URL: https://issues.apache.org/jira/browse/CALCITE-5906
> Project: Calcite
> Issue Type: Bug
> Reporter: LakeShen
> Priority: Major
> Fix For: 1.36.0
>
> Attachments: image-2023-08-08-20-16-27-188.png, image-2023-08-08-20-19-01-269.png
>
>
> Currently in the RelToSqlConverter class, there is no visit method to handle the Sample RelNode.If a SQL plan has Sample RelNode, RelToSqlConverter will throw a AssertionError like this:
> {code:java}
> java.lang.AssertionError: Need to implement org.apache.calcite.rel.core.Sample
> {code}
> This will cause the Sample RelNode plan to fail to translate to the corresponding dialect.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)