You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2017/06/29 20:36:00 UTC
[jira] [Created] (DRILL-5629) large traceback is query attempts to
use TABLESAMPLE
N Campbell created DRILL-5629:
---------------------------------
Summary: large traceback is query attempts to use TABLESAMPLE
Key: DRILL-5629
URL: https://issues.apache.org/jira/browse/DRILL-5629
Project: Apache Drill
Issue Type: Bug
Components: Server
Affects Versions: 1.10.0
Environment: Drill 1.10
ORACLE 12C2
Reporter: N Campbell
Priority: Minor
A plugin is defined to ORACLE
Following statement is sent to DRILL which returns large exception response
SELECT RNUM, C1 FROM certora.DBCERT.TOLAP TABLESAMPLE SYSTEM ( 2 ) repeatable ( 5 )
SYSTEM ERROR: CannotPlanException: Node [rel#939863:Subset#2.LOGICAL.ANY([]).[]] could not be implemented; planner state:
Root: rel#939863:Subset#2.LOGICAL.ANY([]).[]
Original rel:
Sets:
Set#0, type: RecordType(DECIMAL(38, 0) RNUM, CHAR(3) C1, CHAR(2) C2, DECIMAL(38, 0) C3, DECIMAL(38, 0) C4)
rel#939858:Subset#0.JDBC.certora.ANY([]).[], best=rel#939844, importance=0.7290000000000001
rel#939844:JdbcTableScan.JDBC.certora.ANY([]).[](table=[certora, DBCERT, TOLAP]), rowcount=100.0, cumulative cost={100.0 rows, 101.0 cpu, 0.0 io, 0.0 network, 0.0 memory}
rel#939894:AbstractConverter.JDBC.certora.ANY([]).[](input=rel#939893:Subset#0.LOGICAL.ANY([]).[],convention=JDBC.certora,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939900:AbstractConverter.JDBC.certora.ANY([]).[](input=rel#939899:Subset#0.ENUMERABLE.ANY([]).[],convention=JDBC.certora,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939908:AbstractConverter.JDBC.certora.ANY([]).[](input=rel#939907:Subset#0.PHYSICAL.ANY([]).[],convention=JDBC.certora,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939893:Subset#0.LOGICAL.ANY([]).[], best=rel#939892, importance=0.6561
rel#939895:AbstractConverter.LOGICAL.ANY([]).[](input=rel#939858:Subset#0.JDBC.certora.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939892:JdbcDrel.LOGICAL.ANY([]).[](input=rel#939858:Subset#0.JDBC.certora.ANY([]).[]), rowcount=100.0, cumulative cost={200.0 rows, 201.0 cpu, 0.0 io, 0.0 network, 0.0 memory}
rel#939901:AbstractConverter.LOGICAL.ANY([]).[](input=rel#939899:Subset#0.ENUMERABLE.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939909:AbstractConverter.LOGICAL.ANY([]).[](input=rel#939907:Subset#0.PHYSICAL.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939899:Subset#0.ENUMERABLE.ANY([]).[], best=rel#939898, importance=0.5904900000000001
rel#939902:AbstractConverter.ENUMERABLE.ANY([]).[](input=rel#939858:Subset#0.JDBC.certora.ANY([]).[],convention=ENUMERABLE,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939903:AbstractConverter.ENUMERABLE.ANY([]).[](input=rel#939893:Subset#0.LOGICAL.ANY([]).[],convention=ENUMERABLE,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939898:JdbcToEnumerableConverter.ENUMERABLE.ANY([]).[](input=rel#939858:Subset#0.JDBC.certora.ANY([]).[]), rowcount=100.0, cumulative cost={110.0 rows, 111.0 cpu, 0.0 io, 0.0 network, 0.0 memory}
rel#939910:AbstractConverter.ENUMERABLE.ANY([]).[](input=rel#939907:Subset#0.PHYSICAL.ANY([]).[],convention=ENUMERABLE,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939907:Subset#0.PHYSICAL.ANY([]).[], best=rel#939906, importance=0.531441
rel#939911:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#939858:Subset#0.JDBC.certora.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939912:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#939893:Subset#0.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939913:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#939899:Subset#0.ENUMERABLE.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939906:JdbcIntermediatePrel.PHYSICAL.ANY([]).[](input=rel#939858:Subset#0.JDBC.certora.ANY([]).[]), rowcount=100.0, cumulative cost={200.0 rows, 201.0 cpu, 0.0 io, 0.0 network, 0.0 memory}
Set#1, type: RecordType(DECIMAL(38, 0) RNUM, CHAR(3) C1, CHAR(2) C2, DECIMAL(38, 0) C3, DECIMAL(38, 0) C4)
rel#939860:Subset#1.NONE.ANY([]).[], best=null, importance=0.81
rel#939859:Sample.NONE.ANY([]).[](input=rel#939858:Subset#0.JDBC.certora.ANY([]).[],mode=system,rate=0.02,repeatableSeed=5), rowcount=100.0, cumulative cost={inf}
rel#939865:Subset#1.JDBC.certora.ANY([]).[], best=null, importance=0.81
rel#939889:AbstractConverter.JDBC.certora.ANY([]).[](input=rel#939888:Subset#1.LOGICAL.ANY([]).[],convention=JDBC.certora,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939888:Subset#1.LOGICAL.ANY([]).[], best=null, importance=0.7290000000000001
rel#939890:AbstractConverter.LOGICAL.ANY([]).[](input=rel#939865:Subset#1.JDBC.certora.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
Set#2, type: RecordType(DECIMAL(38, 0) RNUM, CHAR(3) C1)
rel#939862:Subset#2.NONE.ANY([]).[], best=null, importance=0.9
rel#939861:LogicalProject.NONE.ANY([]).[](input=rel#939860:Subset#1.NONE.ANY([]).[],RNUM=$0,C1=$1), rowcount=100.0, cumulative cost={inf}
rel#939863:Subset#2.LOGICAL.ANY([]).[], best=null, importance=1.0
rel#939864:AbstractConverter.LOGICAL.ANY([]).[](input=rel#939862:Subset#2.NONE.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939868:AbstractConverter.LOGICAL.ANY([]).[](input=rel#939867:Subset#2.JDBC.certora.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939870:JdbcDrel.LOGICAL.ANY([]).[](input=rel#939867:Subset#2.JDBC.certora.ANY([]).[]), rowcount=100.0, cumulative cost={inf}
rel#939873:AbstractConverter.LOGICAL.ANY([]).[](input=rel#939872:Subset#2.PHYSICAL.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939880:AbstractConverter.LOGICAL.ANY([]).[](input=rel#939879:Subset#2.ENUMERABLE.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939891:DrillProjectRel.LOGICAL.ANY([]).[](input=rel#939888:Subset#1.LOGICAL.ANY([]).[],RNUM=$0,C1=$1), rowcount=100.0, cumulative cost={inf}
rel#939867:Subset#2.JDBC.certora.ANY([]).[], best=null, importance=0.9
rel#939869:AbstractConverter.JDBC.certora.ANY([]).[](input=rel#939863:Subset#2.LOGICAL.ANY([]).[],convention=JDBC.certora,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939866:JdbcProject.JDBC.certora.ANY([]).[](input=rel#939865:Subset#1.JDBC.certora.ANY([]).[],RNUM=$0,C1=$1), rowcount=100.0, cumulative cost={inf}
rel#939874:AbstractConverter.JDBC.certora.ANY([]).[](input=rel#939872:Subset#2.PHYSICAL.ANY([]).[],convention=JDBC.certora,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939881:AbstractConverter.JDBC.certora.ANY([]).[](input=rel#939879:Subset#2.ENUMERABLE.ANY([]).[],convention=JDBC.certora,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939872:Subset#2.PHYSICAL.ANY([]).[], best=null, importance=0.81
rel#939875:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#939863:Subset#2.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939876:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#939867:Subset#2.JDBC.certora.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939871:JdbcIntermediatePrel.PHYSICAL.ANY([]).[](input=rel#939867:Subset#2.JDBC.certora.ANY([]).[]), rowcount=100.0, cumulative cost={inf}
rel#939882:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#939879:Subset#2.ENUMERABLE.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939879:Subset#2.ENUMERABLE.ANY([]).[], best=null, importance=0.7290000000000001
rel#939883:AbstractConverter.ENUMERABLE.ANY([]).[](input=rel#939863:Subset#2.LOGICAL.ANY([]).[],convention=ENUMERABLE,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939884:AbstractConverter.ENUMERABLE.ANY([]).[](input=rel#939867:Subset#2.JDBC.certora.ANY([]).[],convention=ENUMERABLE,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939885:AbstractConverter.ENUMERABLE.ANY([]).[](input=rel#939872:Subset#2.PHYSICAL.ANY([]).[],convention=ENUMERABLE,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=100.0, cumulative cost={inf}
rel#939878:JdbcToEnumerableConverter.ENUMERABLE.ANY([]).[](input=rel#939867:Subset#2.JDBC.certora.ANY([]).[]), rowcount=100.0, cumulative cost={inf}
ORACLE DDL
CREATE TABLE "DBCERT"."TOLAP"
( "RNUM" NUMBER(*,0),
"C1" CHAR(3 BYTE),
"C2" CHAR(2 BYTE),
"C3" NUMBER(*,0),
"C4" NUMBER(*,0)
) ;
GRANT SELECT ON "DBCERT"."TOLAP" TO PUBLIC;
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)