PLAN ERROR: Node [rel#629853:Subset#3.LOGICAL.ANY([]).[]] could not be implemented; planner state

1

Dremio Server 14.0.0-202103011714040666-9a0c2e10
Dremio JDBC 14.0.0-202103011714040666-9a0c2e10

I am assuming that Dremio doesn’t claim to support sampling, but parser does not reject a statement such as follows.

rnum, c1 from cert.tolap tablesample system ( 2 ) repeatable ( 5 )

PLAN ERROR: Node [rel#629853:Subset#3.LOGICAL.ANY([]).[]] could not be implemented; planner state:

Root: rel#629853:Subset#3.LOGICAL.ANY([]).[]
Original rel:
LogicalProject(subset=[rel#629853:Subset#3.LOGICAL.ANY([]).[]], rnum=[$0], c1=[$1]): rowcount = 8.0, cumulative cost = {8.0 rows, 16.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 629851
Sample(subset=[rel#629850:Subset#2.NONE.ANY([]).[]], mode=[system], rate=[0.02], repeatableSeed=[5]): rowcount = 8.0, cumulative cost = {8.0 rows, 8.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 629849
LogicalProject(subset=[rel#629848:Subset#1.NONE.ANY([]).[]], rnum=[$0], c1=[$1], c2=[$2], c3=[$3], c4=[$4]): rowcount = 8.0, cumulative cost = {8.0 rows, 40.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 629847
ScanCrel(subset=[rel#629846:Subset#0.NONE.ANY([]).[]], table=[S3_CERT.cognosbi.cert_pq.data.tolap.“tolap.parquet”], columns=[rnum, c1, c2, c3, c4], splits=[1]): rowcount = 8.0, cumulative cost = {8.0 rows, 40.0 cpu, 40.0 io, 40.0 network, 0.0 memory}, id = 629787

Sets:
Set#0, type: RecordType(INTEGER rnum, VARCHAR(65536) c1, VARCHAR(65536) c2, INTEGER c3, INTEGER c4)
rel#629846:Subset#0.NONE.ANY([]).[], best=null, importance=0.6561
rel#629787:ScanCrel.NONE.ANY([])…

2

I’ve noticed that too.
Dremio, could you please respond.
In case you confirm that it is not supported at this moment, could you please share with use whether it will be in the future ?

3

@msmetek Are you able to send the job profile over?

4

@balaji.ramaswamy - it was confirmed as a missing feature last year.

5

5de3a351-274a-4d2c-854c-3e1ea01fb3ad.zip (9.7 KB)

6

@msmetek Thanks for bringing this up, we have an internal JIRA to give a better message as Dremio currently does not have an implementation although Calcite understands it