Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8682B101CB for ; Sun, 2 Nov 2014 22:57:59 +0000 (UTC) Received: (qmail 56530 invoked by uid 500); 2 Nov 2014 22:57:59 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 56503 invoked by uid 500); 2 Nov 2014 22:57:59 -0000 Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.incubator.apache.org Delivered-To: mailing list issues@drill.incubator.apache.org Received: (qmail 56494 invoked by uid 99); 2 Nov 2014 22:57:59 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Nov 2014 22:57:59 +0000 X-ASF-Spam-Status: No, hits=-2000.6 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Sun, 02 Nov 2014 22:57:53 +0000 Received: (qmail 55860 invoked by uid 99); 2 Nov 2014 22:57:33 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Nov 2014 22:57:33 +0000 Date: Sun, 2 Nov 2014 22:57:33 +0000 (UTC) From: "Jacques Nadeau (JIRA)" To: issues@drill.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DRILL-1622) Analytic tool generated SQL queries hang or fail MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DRILL-1622?page=3Dcom.atlassia= n.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Nadeau updated DRILL-1622: ---------------------------------- Description:=20 Queries generated by Analytic tools can include unnecessary tables and join= s. When tracing ODBC calls and executing queries in sqlline the problems ar= e still experienced. Example query that hangs: dfs.views .orderview points to CSV files in MapR= -FS and dfs.views.customerview points to MapR-DB {code} SELECT ord.`month`, count(*) FROM dfs.views.orderview ord, dfs.views.custom= erview cust where cust.cust_id=3Dord.cust_id group by ord.`month` {code} The following query fails: {code} SELECT ord.`month`, count(*) FROM dfs.views.orderview ord, dfs.views.custom= erview cust group by ord.`month`=20 {code} {code} Query failed: Failure while parsing sql. Node [rel#25065:Subset#7.LOGICAL.A= NY([]).[]] could not be implemented; planner state: Output received below Root: rel#25065:Subset#7.LOGICAL.ANY([]).[] Original rel: AbstractConverter(subset=3D[rel#25065:Subset#7.LOGICAL.ANY([]).[]], convent= ion=3D[LOGICAL], DrillDistributionTraitDef=3D[ANY([])], sort=3D[[]]): rowco= unt =3D 1.7976931348623157E308, cumulative cost =3D {inf}, id =3D 25066 AggregateRel(subset=3D[rel#25064:Subset#7.NONE.ANY([]).[]], group=3D[{0}]= , EXPR$1=3D[COUNT()]): rowcount =3D 1.7976931348623158E307, cumulative cost= =3D {1.7976931348623158E307 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 memory= }, id =3D 25063 ProjectRel(subset=3D[rel#25062:Subset#6.NONE.ANY([]).[]], month=3D[$1])= : rowcount =3D 1.7976931348623157E308, cumulative cost =3D {1.7976931348623= 157E308 rows, 1.7976931348623157E308 cpu, 0.0 io, 0.0 network, 0.0 memory},= id =3D 25061 JoinRel(subset=3D[rel#25060:Subset#5.NONE.ANY([]).[]], condition=3D[t= rue], joinType=3D[inner]): rowcount =3D 1.7976931348623157E308, cumulative = cost =3D {1.7976931348623157E308 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 me= mory}, id =3D 25059 ProjectRel(subset=3D[rel#25053:Subset#1.NONE.ANY([]).[]], order_id= =3D[CAST(ITEM($1, 0)):BIGINT NOT NULL], month=3D[CAST(ITEM($1, 1)):VARCHAR(= 1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL],= purch_date=3D[CAST(ITEM($1, 2)):TIMESTAMP(0) NOT NULL], cust_id=3D[CAST(IT= EM($1, 3)):BIGINT NOT NULL], state=3D[CAST(ITEM($1, 4)):VARCHAR(1) CHARACTE= R SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL], prod_id=3D= [CAST(ITEM($1, 5)):BIGINT NOT NULL], order_total=3D[CAST(ITEM($1, 6)):INTEG= ER NOT NULL]): rowcount =3D 100.0, cumulative cost =3D {100.0 rows, 700.0 c= pu, 0.0 io, 0.0 network, 0.0 memory}, id =3D 25052 EnumerableTableAccessRel(subset=3D[rel#25051:Subset#0.ENUMERABLE.= ANY([]).[]], table=3D[[dfs, data, /orders]]): rowcount =3D 100.0, cumulativ= e cost =3D {100.0 rows, 101.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id =3D= 25027 ProjectRel(subset=3D[rel#25058:Subset#4.NONE.ANY([]).[]], cust_id= =3D[$0], cust_name=3D[CAST($1):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLA= TE "ISO-8859-1$en_US$primary" NOT NULL], cust_age=3D[CAST($2):VARCHAR(20) C= HARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL], agg= _rev=3D[CAST($3):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary" NOT NULL], membership=3D[CAST($4):VARCHAR(20) CHARACTER SET= "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL], address=3D[CAST= ($5):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$prima= ry" NOT NULL]): rowcount =3D 1.7976931348623157E308, cumulative cost =3D {1= .7976931348623157E308 rows, Infinity cpu, 0.0 io, 0.0 network, 0.0 memory},= id =3D 25057 ProjectRel(subset=3D[rel#25056:Subset#3.NONE.ANY([]).[]], cust_id= =3D[CAST($0):BIGINT NOT NULL], cust_name=3D[CAST(ITEM($3, 'name')):VARCHAR(= 20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], cust_ag= e=3D[CAST(ITEM($3, 'age')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "= ISO-8859-1$en_US$primary"], agg_rev=3D[CAST(ITEM($2, 'agg_rev')):VARCHAR(20= ) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], membershi= p=3D[CAST(ITEM($2, 'membership')):VARCHAR(20) CHARACTER SET "ISO-8859-1" CO= LLATE "ISO-8859-1$en_US$primary"], address=3D[CAST(ITEM($1, 'state')):VARCH= AR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"]): row= count =3D 100.0, cumulative cost =3D {100.0 rows, 600.0 cpu, 0.0 io, 0.0 ne= twork, 0.0 memory}, id =3D 25055 EnumerableTableAccessRel(subset=3D[rel#25054:Subset#2.ENUMERABL= E.ANY([]).[]], table=3D[[maprdb, customers]]): rowcount =3D 100.0, cumulati= ve cost =3D {100.0 rows, 101.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = =3D 25031 Sets: Set#0, type: (DrillRecordRow[*, columns]) =09rel#25051:Subset#0.ENUMERABLE.ANY([]).[], best=3Drel#25027, importance= =3D0.5904900000000001 =09=09rel#25027:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=3D[dfs= , data, /orders]), rowcount=3D100.0, cumulative cost=3D{100.0 rows, 101.0 c= pu, 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25117:AbstractConverter.ENUMERABLE.ANY([]).[](child=3Drel#25116:S= ubset#0.LOGICAL.ANY([]).[],convention=3DENUMERABLE,DrillDistributionTraitDe= f=3DANY([]),sort=3D[]), rowcount=3D6456.0, cumulative cost=3D{inf} =09rel#25116:Subset#0.LOGICAL.ANY([]).[], best=3Drel#25137, importance=3D0.= 531441 =09=09rel#25118:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25051:Subs= et#0.ENUMERABLE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef= =3DANY([]),sort=3D[]), rowcount=3D100.0, cumulative cost=3D{inf} =09=09rel#25137:DrillScanRel.LOGICAL.ANY([]).[](table=3D[dfs, data, /orders= ],groupscan=3DEasyGroupScan [selectionRoot=3D/mapr/c1/andries/demo/data/ord= ers, numFiles=3D10, columns =3D [SchemaPath [`*`]]]), rowcount=3D6456.0, cu= mulative cost=3D{6456.0 rows, 6.456E7 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#1, type: RecordType(BIGINT order_id, VARCHAR(1) month, TIMESTAMP(0) pur= ch_date, BIGINT cust_id, VARCHAR(1) state, BIGINT prod_id, INTEGER order_to= tal) =09rel#25053:Subset#1.NONE.ANY([]).[], best=3Dnull, importance=3D0.6561 =09=09rel#25052:ProjectRel.NONE.ANY([]).[](child=3Drel#25051:Subset#0.ENUME= RABLE.ANY([]).[],order_id=3DCAST(ITEM($1, 0)):BIGINT NOT NULL,month=3DCAST(= ITEM($1, 1)):VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_U= S$primary" NOT NULL,purch_date=3DCAST(ITEM($1, 2)):TIMESTAMP(0) NOT NULL,cu= st_id=3DCAST(ITEM($1, 3)):BIGINT NOT NULL,state=3DCAST(ITEM($1, 4)):VARCHAR= (1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,= prod_id=3DCAST(ITEM($1, 5)):BIGINT NOT NULL,order_total=3DCAST(ITEM($1, 6))= :INTEGER NOT NULL), rowcount=3D100.0, cumulative cost=3D{inf} =09rel#25114:Subset#1.LOGICAL.ANY([]).[], best=3Drel#25113, importance=3D0.= 6561 =09=09rel#25115:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25053:Subs= et#1.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25113:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25112:Subset= #14.LOGICAL.ANY([]).[],order_id=3DCAST(ITEM($0, 0)):BIGINT NOT NULL,month= =3DCAST(ITEM($0, 1)):VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-885= 9-1$en_US$primary" NOT NULL,purch_date=3DCAST(ITEM($0, 2)):TIMESTAMP(0) NOT= NULL,cust_id=3DCAST(ITEM($0, 3)):BIGINT NOT NULL,state=3DCAST(ITEM($0, 4))= :VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" N= OT NULL,prod_id=3DCAST(ITEM($0, 5)):BIGINT NOT NULL,order_total=3DCAST(ITEM= ($0, 6)):INTEGER NOT NULL), rowcount=3D6456.0, cumulative cost=3D{12912.0 r= ows, 6484.0 cpu, 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25136:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25116:Subset= #0.LOGICAL.ANY([]).[],order_id=3DCAST(ITEM($1, 0)):BIGINT NOT NULL,month=3D= CAST(ITEM($1, 1)):VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary" NOT NULL,purch_date=3DCAST(ITEM($1, 2)):TIMESTAMP(0) NOT NU= LL,cust_id=3DCAST(ITEM($1, 3)):BIGINT NOT NULL,state=3DCAST(ITEM($1, 4)):VA= RCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT = NULL,prod_id=3DCAST(ITEM($1, 5)):BIGINT NOT NULL,order_total=3DCAST(ITEM($1= , 6)):INTEGER NOT NULL), rowcount=3D6456.0, cumulative cost=3D{12912.0 rows= , 6.4560028E7 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#2, type: RecordType(ANY row_key, (VARCHAR(1), ANY) MAP address, (VARCHA= R(1), ANY) MAP loyalty, (VARCHAR(1), ANY) MAP personal) =09rel#25054:Subset#2.ENUMERABLE.ANY([]).[], best=3Drel#25031, importance= =3D0.531441 =09=09rel#25031:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=3D[map= rdb, customers]), rowcount=3D100.0, cumulative cost=3D{100.0 rows, 101.0 cp= u, 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25121:AbstractConverter.ENUMERABLE.ANY([]).[](child=3Drel#25120:S= ubset#2.LOGICAL.ANY([]).[],convention=3DENUMERABLE,DrillDistributionTraitDe= f=3DANY([]),sort=3D[]), rowcount=3D1048576.0, cumulative cost=3D{inf} =09rel#25120:Subset#2.LOGICAL.ANY([]).[], best=3Drel#25138, importance=3D0.= 4782969000000001 =09=09rel#25122:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25054:Subs= et#2.ENUMERABLE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef= =3DANY([]),sort=3D[]), rowcount=3D100.0, cumulative cost=3D{inf} =09=09rel#25138:DrillScanRel.LOGICAL.ANY([]).[](table=3D[maprdb, customers]= ,groupscan=3DHBaseGroupScan [HBaseScanSpec=3DHBaseScanSpec [tableName=3Dcus= tomers, startRow=3Dnull, stopRow=3Dnull, filter=3Dnull], columns=3D[SchemaP= ath [`*`]]]), rowcount=3D1048576.0, cumulative cost=3D{1048576.0 Error: exc= eption while executing query: Failure while trying to get next result batch= . (state=3D,code=3D0) rows, 4194304.0 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#3, type: RecordType(BIGINT cust_id, VARCHAR(20) cust_name, VARCHAR(20) = cust_age, VARCHAR(20) agg_rev, VARCHAR(20) membership, VARCHAR(20) address) =09rel#25056:Subset#3.NONE.ANY([]).[], best=3Dnull, importance=3D0.59049000= 00000001 =09=09rel#25055:ProjectRel.NONE.ANY([]).[](child=3Drel#25054:Subset#2.ENUME= RABLE.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(ITEM($= 3, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_U= S$primary",cust_age=3DCAST(ITEM($3, 'age')):VARCHAR(20) CHARACTER SET "ISO-= 8859-1" COLLATE "ISO-8859-1$en_US$primary",agg_rev=3DCAST(ITEM($2, 'agg_rev= ')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primar= y",membership=3DCAST(ITEM($2, 'membership')):VARCHAR(20) CHARACTER SET "ISO= -8859-1" COLLATE "ISO-8859-1$en_US$primary",address=3DCAST(ITEM($1, 'state'= )):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary= "), rowcount=3D100.0, cumulative cost=3D{inf} =09rel#25108:Subset#3.LOGICAL.ANY([]).[], best=3Drel#25107, importance=3D0.= 6561 =09=09rel#25109:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25056:Subs= et#3.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25107:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25106:Subset= #13.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(= ITEM($1, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-= 1$en_US$primary",cust_age=3DCAST(ITEM($1, 'age')):VARCHAR(20) CHARACTER SET= "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary",agg_rev=3DCAST(ITEM($2, 'a= gg_rev')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$= primary",membership=3DCAST(ITEM($2, 'membership')):VARCHAR(20) CHARACTER SE= T "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary",address=3DCAST(ITEM($3, '= state')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$p= rimary"), rowcount=3D1048576.0, cumulative cost=3D{2097152.0 rows, 4194328.= 0 cpu, 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25135:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25120:Subset= #2.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(I= TEM($3, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary",cust_age=3DCAST(ITEM($3, 'age')):VARCHAR(20) CHARACTER SET = "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary",agg_rev=3DCAST(ITEM($2, 'ag= g_rev')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$p= rimary",membership=3DCAST(ITEM($2, 'membership')):VARCHAR(20) CHARACTER SET= "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary",address=3DCAST(ITEM($1, 's= tate')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$pr= imary"), rowcount=3D1048576.0, cumulative cost=3D{2097152.0 rows, 4194328.0= cpu, 0.0 io, 0.0 network, 0.0 memory} Set#4, type: RecordType(BIGINT cust_id, VARCHAR(20) cust_name, VARCHAR(20) = cust_age, VARCHAR(20) agg_rev, VARCHAR(20) membership, VARCHAR(20) address) =09rel#25058:Subset#4.NONE.ANY([]).[], best=3Dnull, importance=3D0.6561 =09=09rel#25057:ProjectRel.NONE.ANY([]).[](child=3Drel#25056:Subset#3.NONE.= ANY([]).[],cust_id=3D$0,cust_name=3DCAST($1):VARCHAR(20) CHARACTER SET "ISO= -8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,cust_age=3DCAST($2):VA= RCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT= NULL,agg_rev=3DCAST($3):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "IS= O-8859-1$en_US$primary" NOT NULL,membership=3DCAST($4):VARCHAR(20) CHARACTE= R SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,address=3DCA= ST($5):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$pri= mary" NOT NULL), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25102:ProjectRel.NONE.ANY([]).[](child=3Drel#25054:Subset#2.ENUME= RABLE.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(CAST(I= TEM($3, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary" NOT NULL,cust_age=3DCAST(CAST(ITEM($3, 'age')):VARCHAR(20) = CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20) = CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,agg_= rev=3DCAST(CAST(ITEM($2, 'agg_rev')):VARCHAR(20) CHARACTER SET "ISO-8859-1"= COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1"= COLLATE "ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST(CAST(ITEM($2= , 'membership')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary" NOT NULL,address=3DCAST(CAST(ITEM($1, 'state')):VARCHAR(20)= CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20)= CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), r= owcount=3D100.0, cumulative cost=3D{inf} =09rel#25125:Subset#4.LOGICAL.ANY([]).[], best=3Drel#25131, importance=3D0.= 6561 =09=09rel#25126:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25058:Subs= et#4.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25131:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25106:Subset= #13.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(= CAST(ITEM($1, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-= 8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-= 8859-1$en_US$primary" NOT NULL,cust_age=3DCAST(CAST(ITEM($1, 'age')):VARCHA= R(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHA= R(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NUL= L,agg_rev=3DCAST(CAST(ITEM($2, 'agg_rev')):VARCHAR(20) CHARACTER SET "ISO-8= 859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8= 859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST(CAST(I= TEM($2, 'membership')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-= 8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-= 8859-1$en_US$primary" NOT NULL,address=3DCAST(CAST(ITEM($3, 'state')):VARCH= AR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCH= AR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NU= LL), rowcount=3D1048576.0, cumulative cost=3D{2097152.0 rows, 4194328.0 cpu= , 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25132:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25120:Subset= #2.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(C= AST(ITEM($3, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8= 859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8= 859-1$en_US$primary" NOT NULL,cust_age=3DCAST(CAST(ITEM($3, 'age')):VARCHAR= (20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR= (20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL= ,agg_rev=3DCAST(CAST(ITEM($2, 'agg_rev')):VARCHAR(20) CHARACTER SET "ISO-88= 59-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-88= 59-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST(CAST(IT= EM($2, 'membership')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8= 859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8= 859-1$en_US$primary" NOT NULL,address=3DCAST(CAST(ITEM($1, 'state')):VARCHA= R(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHA= R(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NUL= L), rowcount=3D1048576.0, cumulative cost=3D{2097152.0 rows, 4194328.0 cpu,= 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25134:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25108:Subset= #3.LOGICAL.ANY([]).[],cust_id=3D$0,cust_name=3DCAST($1):VARCHAR(20) CHARACT= ER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,cust_age=3D= CAST($2):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$p= rimary" NOT NULL,agg_rev=3DCAST($3):VARCHAR(20) CHARACTER SET "ISO-8859-1" = COLLATE "ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST($4):VARCHAR(2= 0) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,a= ddress=3DCAST($5):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-= 1$en_US$primary" NOT NULL), rowcount=3D1048576.0, cumulative cost=3D{314572= 8.0 rows, 4194352.0 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#5, type: RecordType(BIGINT order_id, VARCHAR(1) month, TIMESTAMP(0) pur= ch_date, BIGINT cust_id, VARCHAR(1) state, BIGINT prod_id, INTEGER order_to= tal, BIGINT cust_id0, VARCHAR(20) cust_name, VARCHAR(20) cust_age, VARCHAR(= 20) agg_rev, VARCHAR(20) membership, VARCHAR(20) address) =09rel#25060:Subset#5.NONE.ANY([]).[], best=3Dnull, importance=3D0.72900000= 00000001 =09=09rel#25059:JoinRel.NONE.ANY([]).[](left=3Drel#25053:Subset#1.NONE.ANY(= []).[],right=3Drel#25058:Subset#4.NONE.ANY([]).[],condition=3Dtrue,joinType= =3Dinner), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09rel#25088:Subset#5.LOGICAL.ANY([]).[], best=3Dnull, importance=3D0.81 =09=09rel#25089:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25060:Subs= et#5.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25133:DrillJoinRel.LOGICAL.ANY([]).[](left=3Drel#25114:Subset#1.L= OGICAL.ANY([]).[],right=3Drel#25125:Subset#4.LOGICAL.ANY([]).[],condition= =3Dtrue,joinType=3Dinner), rowcount=3D1048576.0, cumulative cost=3D{inf} Set#6, type: RecordType(VARCHAR(1) month) =09rel#25062:Subset#6.NONE.ANY([]).[], best=3Dnull, importance=3D0.81 =09=09rel#25061:ProjectRel.NONE.ANY([]).[](child=3Drel#25060:Subset#5.NONE.= ANY([]).[],month=3D$1), rowcount=3D1.7976931348623157E308, cumulative cost= =3D{inf} =09=09rel#25078:ProjectRel.NONE.ANY([]).[](child=3Drel#25077:Subset#10.NONE= .ANY([]).[],month=3D$0), rowcount=3D1.7976931348623157E308, cumulative cost= =3D{inf} =09rel#25067:Subset#6.LOGICAL.ANY([]).[], best=3Dnull, importance=3D0.9 =09=09rel#25068:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25062:Subs= et#6.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25081:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25079:Subset= #10.LOGICAL.ANY([]).[],month=3D$0), rowcount=3D1.7976931348623157E308, cumu= lative cost=3D{inf} =09=09rel#25090:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25088:Subset= #5.LOGICAL.ANY([]).[],month=3D$1), rowcount=3D1.7976931348623157E308, cumul= ative cost=3D{inf} Set#7, type: RecordType(VARCHAR(1) month, BIGINT EXPR$1) =09rel#25064:Subset#7.NONE.ANY([]).[], best=3Dnull, importance=3D0.9 =09=09rel#25063:AggregateRel.NONE.ANY([]).[](child=3Drel#25062:Subset#6.NON= E.ANY([]).[],group=3D{0},EXPR$1=3DCOUNT()), rowcount=3D1.7976931348623158E3= 07, cumulative cost=3D{inf} =09rel#25065:Subset#7.LOGICAL.ANY([]).[], best=3Dnull, importance=3D1.0 =09=09rel#25066:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25064:Subs= et#7.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25069:DrillAggregateRel.LOGICAL.ANY([]).[](child=3Drel#25067:Subs= et#6.LOGICAL.ANY([]).[],group=3D{0},EXPR$1=3DCOUNT()), rowcount=3D1.7976931= 348623158E307, cumulative cost=3D{inf} Set#8, type: RecordType(VARCHAR(1) month) =09rel#25074:Subset#8.NONE.ANY([]).[], best=3Dnull, importance=3D0.6561 =09=09rel#25070:ProjectRel.NONE.ANY([]).[](child=3Drel#25053:Subset#1.NONE.= ANY([]).[],month=3D$1), rowcount=3D1.7976931348623157E308, cumulative cost= =3D{inf} =09=09rel#25097:ProjectRel.NONE.ANY([]).[](child=3Drel#25051:Subset#0.ENUME= RABLE.ANY([]).[],month=3DCAST(ITEM($1, 1)):VARCHAR(1) CHARACTER SET "ISO-88= 59-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=3D100.0, cumul= ative cost=3D{inf} =09rel#25083:Subset#8.LOGICAL.ANY([]).[], best=3Drel#25101, importance=3D0.= 7290000000000001 =09=09rel#25084:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25074:Subs= et#8.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25101:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25100:Subset= #12.LOGICAL.ANY([]).[],month=3DCAST(ITEM($0, 1)):VARCHAR(1) CHARACTER SET "= ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=3D6456.0= , cumulative cost=3D{12912.0 rows, 6460.0 cpu, 0.0 io, 0.0 network, 0.0 mem= ory} =09=09rel#25119:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25116:Subset= #0.LOGICAL.ANY([]).[],month=3DCAST(ITEM($1, 1)):VARCHAR(1) CHARACTER SET "I= SO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=3D6456.0,= cumulative cost=3D{12912.0 rows, 6.4560004E7 cpu, 0.0 io, 0.0 network, 0.0= memory} =09=09rel#25128:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25114:Subset= #1.LOGICAL.ANY([]).[],month=3D$1), rowcount=3D6456.0, cumulative cost=3D{19= 368.0 rows, 6488.0 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#9, type: RecordType(BIGINT cust_id) =09rel#25075:Subset#9.NONE.ANY([]).[], best=3Dnull, importance=3D0.6561 =09=09rel#25071:ProjectRel.NONE.ANY([]).[](child=3Drel#25058:Subset#4.NONE.= ANY([]).[],cust_id=3D$0), rowcount=3D1.7976931348623157E308, cumulative cos= t=3D{inf} =09=09rel#25091:ProjectRel.NONE.ANY([]).[](child=3Drel#25056:Subset#3.NONE.= ANY([]).[],cust_id=3D$0), rowcount=3D1.7976931348623157E308, cumulative cos= t=3D{inf} =09=09rel#25092:ProjectRel.NONE.ANY([]).[](child=3Drel#25054:Subset#2.ENUME= RABLE.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL), rowcount=3D100.0, cum= ulative cost=3D{inf} =09rel#25085:Subset#9.LOGICAL.ANY([]).[], best=3Drel#25096, importance=3D0.= 7290000000000001 =09=09rel#25086:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25075:Subs= et#9.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25096:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25095:Subset= #11.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL), rowcount=3D1048= 576.0, cumulative cost=3D{2097152.0 rows, 1048580.0 cpu, 0.0 io, 0.0 networ= k, 0.0 memory} =09=09rel#25123:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25120:Subset= #2.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL), rowcount=3D10485= 76.0, cumulative cost=3D{2097152.0 rows, 4194308.0 cpu, 0.0 io, 0.0 network= , 0.0 memory} =09=09rel#25124:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25108:Subset= #3.LOGICAL.ANY([]).[],cust_id=3D$0), rowcount=3D1048576.0, cumulative cost= =3D{3145728.0 rows, 4194332.0 cpu, 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25127:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25125:Subset= #4.LOGICAL.ANY([]).[],cust_id=3D$0), rowcount=3D1048576.0, cumulative cost= =3D{3145728.0 rows, 4194332.0 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#10, type: RecordType(VARCHAR(1) month, BIGINT cust_id) =09rel#25077:Subset#10.NONE.ANY([]).[], best=3Dnull, importance=3D0.7290000= 000000001 =09=09rel#25076:JoinRel.NONE.ANY([]).[](left=3Drel#25074:Subset#8.NONE.ANY(= []).[],right=3Drel#25075:Subset#9.NONE.ANY([]).[],condition=3Dtrue,joinType= =3Dinner), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09rel#25079:Subset#10.LOGICAL.ANY([]).[], best=3Dnull, importance=3D0.81 =09=09rel#25080:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25077:Subs= et#10.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY(= []),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25087:DrillJoinRel.LOGICAL.ANY([]).[](left=3Drel#25083:Subset#8.L= OGICAL.ANY([]).[],right=3Drel#25085:Subset#9.LOGICAL.ANY([]).[],condition= =3Dtrue,joinType=3Dinner), rowcount=3D1048576.0, cumulative cost=3D{inf} Set#11, type: RecordType(ANY row_key) =09rel#25095:Subset#11.LOGICAL.ANY([]).[], best=3Drel#25093, importance=3D0= .6561 =09=09rel#25093:DrillScanRel.LOGICAL.ANY([]).[](table=3D[maprdb, customers]= ,groupscan=3DHBaseGroupScan [HBaseScanSpec=3DHBaseScanSpec [tableName=3Dcus= tomers, startRow=3Dnull, stopRow=3Dnull, filter=3Dnull], columns=3D[SchemaP= ath [`row_key`]]]), rowcount=3D1048576.0, cumulative cost=3D{1048576.0 rows= , 1048576.0 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#12, type: RecordType(ANY columns) =09rel#25100:Subset#12.LOGICAL.ANY([]).[], best=3Drel#25098, importance=3D0= .6561 =09=09rel#25098:DrillScanRel.LOGICAL.ANY([]).[](table=3D[dfs, data, /orders= ],groupscan=3DEasyGroupScan [selectionRoot=3D/mapr/c1/andries/demo/data/ord= ers, numFiles=3D10, columns =3D [SchemaPath [`columns`[1]]]]), rowcount=3D6= 456.0, cumulative cost=3D{6456.0 rows, 6456.0 cpu, 0.0 io, 0.0 network, 0.0= memory} Set#13, type: RecordType(ANY row_key, (VARCHAR(1), ANY) MAP personal, (VARC= HAR(1), ANY) MAP loyalty, (VARCHAR(1), ANY) MAP address) =09rel#25106:Subset#13.LOGICAL.ANY([]).[], best=3Drel#25104, importance=3D0= .5904900000000001 =09=09rel#25104:DrillScanRel.LOGICAL.ANY([]).[](table=3D[maprdb, customers]= ,groupscan=3DHBaseGroupScan [HBaseScanSpec=3DHBaseScanSpec [tableName=3Dcus= tomers, startRow=3Dnull, stopRow=3Dnull, filter=3Dnull], columns=3D[SchemaP= ath [`row_key`], SchemaPath [`personal`.`name`], SchemaPath [`personal`.`ag= e`], SchemaPath [`loyalty`.`agg_rev`], SchemaPath [`loyalty`.`membership`],= SchemaPath [`address`.`state`]]]), rowcount=3D1048576.0, cumulative cost= =3D{1048576.0 rows, 4194304.0 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#14, type: RecordType(ANY columns) =09rel#25112:Subset#14.LOGICAL.ANY([]).[], best=3Drel#25110, importance=3D0= .5904900000000001 =09=09rel#25110:DrillScanRel.LOGICAL.ANY([]).[](table=3D[dfs, data, /orders= ],groupscan=3DEasyGroupScan [selectionRoot=3D/mapr/c1/andries/demo/data/ord= ers, numFiles=3D10, columns =3D [SchemaPath [`columns`[0]], SchemaPath [`co= lumns`[1]], SchemaPath [`columns`[2]], SchemaPath [`columns`[3]], SchemaPat= h [`columns`[4]], SchemaPath [`columns`[5]], SchemaPath [`columns`[6]]]]), = rowcount=3D6456.0, cumulative cost=3D{6456.0 rows, 6456.0 cpu, 0.0 io, 0.0 = network, 0.0 memory} [8224f29c-1824-45d9-a74b-3d31e48a3419] {code} was: Queries generated by Analytic tools can include unnecessary tables and join= s. When tracing ODBC calls and executing queries in sqlline the problems ar= e still experienced. Example query that hangs: dfs.views .orderview points to CSV files in MapR= -FS and dfs.views.customerview points to MapR-DB {code} SELECT ord.`month`, count(*) FROM dfs.views.orderview ord, dfs.views.custom= erview cust where cust.cust_id=3Dord.cust_id group by ord.`month` The following query fails: SELECT ord.`month`, count(*) FROM dfs.views.orderview ord, dfs.views.custom= erview cust group by ord.`month`=20 Query failed: Failure while parsing sql. Node [rel#25065:Subset#7.LOGICAL.A= NY([]).[]] could not be implemented; planner state: Output received below Root: rel#25065:Subset#7.LOGICAL.ANY([]).[] Original rel: AbstractConverter(subset=3D[rel#25065:Subset#7.LOGICAL.ANY([]).[]], convent= ion=3D[LOGICAL], DrillDistributionTraitDef=3D[ANY([])], sort=3D[[]]): rowco= unt =3D 1.7976931348623157E308, cumulative cost =3D {inf}, id =3D 25066 AggregateRel(subset=3D[rel#25064:Subset#7.NONE.ANY([]).[]], group=3D[{0}]= , EXPR$1=3D[COUNT()]): rowcount =3D 1.7976931348623158E307, cumulative cost= =3D {1.7976931348623158E307 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 memory= }, id =3D 25063 ProjectRel(subset=3D[rel#25062:Subset#6.NONE.ANY([]).[]], month=3D[$1])= : rowcount =3D 1.7976931348623157E308, cumulative cost =3D {1.7976931348623= 157E308 rows, 1.7976931348623157E308 cpu, 0.0 io, 0.0 network, 0.0 memory},= id =3D 25061 JoinRel(subset=3D[rel#25060:Subset#5.NONE.ANY([]).[]], condition=3D[t= rue], joinType=3D[inner]): rowcount =3D 1.7976931348623157E308, cumulative = cost =3D {1.7976931348623157E308 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 me= mory}, id =3D 25059 ProjectRel(subset=3D[rel#25053:Subset#1.NONE.ANY([]).[]], order_id= =3D[CAST(ITEM($1, 0)):BIGINT NOT NULL], month=3D[CAST(ITEM($1, 1)):VARCHAR(= 1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL],= purch_date=3D[CAST(ITEM($1, 2)):TIMESTAMP(0) NOT NULL], cust_id=3D[CAST(IT= EM($1, 3)):BIGINT NOT NULL], state=3D[CAST(ITEM($1, 4)):VARCHAR(1) CHARACTE= R SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL], prod_id=3D= [CAST(ITEM($1, 5)):BIGINT NOT NULL], order_total=3D[CAST(ITEM($1, 6)):INTEG= ER NOT NULL]): rowcount =3D 100.0, cumulative cost =3D {100.0 rows, 700.0 c= pu, 0.0 io, 0.0 network, 0.0 memory}, id =3D 25052 EnumerableTableAccessRel(subset=3D[rel#25051:Subset#0.ENUMERABLE.= ANY([]).[]], table=3D[[dfs, data, /orders]]): rowcount =3D 100.0, cumulativ= e cost =3D {100.0 rows, 101.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id =3D= 25027 ProjectRel(subset=3D[rel#25058:Subset#4.NONE.ANY([]).[]], cust_id= =3D[$0], cust_name=3D[CAST($1):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLA= TE "ISO-8859-1$en_US$primary" NOT NULL], cust_age=3D[CAST($2):VARCHAR(20) C= HARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL], agg= _rev=3D[CAST($3):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary" NOT NULL], membership=3D[CAST($4):VARCHAR(20) CHARACTER SET= "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL], address=3D[CAST= ($5):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$prima= ry" NOT NULL]): rowcount =3D 1.7976931348623157E308, cumulative cost =3D {1= .7976931348623157E308 rows, Infinity cpu, 0.0 io, 0.0 network, 0.0 memory},= id =3D 25057 ProjectRel(subset=3D[rel#25056:Subset#3.NONE.ANY([]).[]], cust_id= =3D[CAST($0):BIGINT NOT NULL], cust_name=3D[CAST(ITEM($3, 'name')):VARCHAR(= 20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], cust_ag= e=3D[CAST(ITEM($3, 'age')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "= ISO-8859-1$en_US$primary"], agg_rev=3D[CAST(ITEM($2, 'agg_rev')):VARCHAR(20= ) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], membershi= p=3D[CAST(ITEM($2, 'membership')):VARCHAR(20) CHARACTER SET "ISO-8859-1" CO= LLATE "ISO-8859-1$en_US$primary"], address=3D[CAST(ITEM($1, 'state')):VARCH= AR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"]): row= count =3D 100.0, cumulative cost =3D {100.0 rows, 600.0 cpu, 0.0 io, 0.0 ne= twork, 0.0 memory}, id =3D 25055 EnumerableTableAccessRel(subset=3D[rel#25054:Subset#2.ENUMERABL= E.ANY([]).[]], table=3D[[maprdb, customers]]): rowcount =3D 100.0, cumulati= ve cost =3D {100.0 rows, 101.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = =3D 25031 Sets: Set#0, type: (DrillRecordRow[*, columns]) =09rel#25051:Subset#0.ENUMERABLE.ANY([]).[], best=3Drel#25027, importance= =3D0.5904900000000001 =09=09rel#25027:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=3D[dfs= , data, /orders]), rowcount=3D100.0, cumulative cost=3D{100.0 rows, 101.0 c= pu, 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25117:AbstractConverter.ENUMERABLE.ANY([]).[](child=3Drel#25116:S= ubset#0.LOGICAL.ANY([]).[],convention=3DENUMERABLE,DrillDistributionTraitDe= f=3DANY([]),sort=3D[]), rowcount=3D6456.0, cumulative cost=3D{inf} =09rel#25116:Subset#0.LOGICAL.ANY([]).[], best=3Drel#25137, importance=3D0.= 531441 =09=09rel#25118:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25051:Subs= et#0.ENUMERABLE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef= =3DANY([]),sort=3D[]), rowcount=3D100.0, cumulative cost=3D{inf} =09=09rel#25137:DrillScanRel.LOGICAL.ANY([]).[](table=3D[dfs, data, /orders= ],groupscan=3DEasyGroupScan [selectionRoot=3D/mapr/c1/andries/demo/data/ord= ers, numFiles=3D10, columns =3D [SchemaPath [`*`]]]), rowcount=3D6456.0, cu= mulative cost=3D{6456.0 rows, 6.456E7 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#1, type: RecordType(BIGINT order_id, VARCHAR(1) month, TIMESTAMP(0) pur= ch_date, BIGINT cust_id, VARCHAR(1) state, BIGINT prod_id, INTEGER order_to= tal) =09rel#25053:Subset#1.NONE.ANY([]).[], best=3Dnull, importance=3D0.6561 =09=09rel#25052:ProjectRel.NONE.ANY([]).[](child=3Drel#25051:Subset#0.ENUME= RABLE.ANY([]).[],order_id=3DCAST(ITEM($1, 0)):BIGINT NOT NULL,month=3DCAST(= ITEM($1, 1)):VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_U= S$primary" NOT NULL,purch_date=3DCAST(ITEM($1, 2)):TIMESTAMP(0) NOT NULL,cu= st_id=3DCAST(ITEM($1, 3)):BIGINT NOT NULL,state=3DCAST(ITEM($1, 4)):VARCHAR= (1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,= prod_id=3DCAST(ITEM($1, 5)):BIGINT NOT NULL,order_total=3DCAST(ITEM($1, 6))= :INTEGER NOT NULL), rowcount=3D100.0, cumulative cost=3D{inf} =09rel#25114:Subset#1.LOGICAL.ANY([]).[], best=3Drel#25113, importance=3D0.= 6561 =09=09rel#25115:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25053:Subs= et#1.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25113:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25112:Subset= #14.LOGICAL.ANY([]).[],order_id=3DCAST(ITEM($0, 0)):BIGINT NOT NULL,month= =3DCAST(ITEM($0, 1)):VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-885= 9-1$en_US$primary" NOT NULL,purch_date=3DCAST(ITEM($0, 2)):TIMESTAMP(0) NOT= NULL,cust_id=3DCAST(ITEM($0, 3)):BIGINT NOT NULL,state=3DCAST(ITEM($0, 4))= :VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" N= OT NULL,prod_id=3DCAST(ITEM($0, 5)):BIGINT NOT NULL,order_total=3DCAST(ITEM= ($0, 6)):INTEGER NOT NULL), rowcount=3D6456.0, cumulative cost=3D{12912.0 r= ows, 6484.0 cpu, 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25136:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25116:Subset= #0.LOGICAL.ANY([]).[],order_id=3DCAST(ITEM($1, 0)):BIGINT NOT NULL,month=3D= CAST(ITEM($1, 1)):VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary" NOT NULL,purch_date=3DCAST(ITEM($1, 2)):TIMESTAMP(0) NOT NU= LL,cust_id=3DCAST(ITEM($1, 3)):BIGINT NOT NULL,state=3DCAST(ITEM($1, 4)):VA= RCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT = NULL,prod_id=3DCAST(ITEM($1, 5)):BIGINT NOT NULL,order_total=3DCAST(ITEM($1= , 6)):INTEGER NOT NULL), rowcount=3D6456.0, cumulative cost=3D{12912.0 rows= , 6.4560028E7 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#2, type: RecordType(ANY row_key, (VARCHAR(1), ANY) MAP address, (VARCHA= R(1), ANY) MAP loyalty, (VARCHAR(1), ANY) MAP personal) =09rel#25054:Subset#2.ENUMERABLE.ANY([]).[], best=3Drel#25031, importance= =3D0.531441 =09=09rel#25031:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=3D[map= rdb, customers]), rowcount=3D100.0, cumulative cost=3D{100.0 rows, 101.0 cp= u, 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25121:AbstractConverter.ENUMERABLE.ANY([]).[](child=3Drel#25120:S= ubset#2.LOGICAL.ANY([]).[],convention=3DENUMERABLE,DrillDistributionTraitDe= f=3DANY([]),sort=3D[]), rowcount=3D1048576.0, cumulative cost=3D{inf} =09rel#25120:Subset#2.LOGICAL.ANY([]).[], best=3Drel#25138, importance=3D0.= 4782969000000001 =09=09rel#25122:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25054:Subs= et#2.ENUMERABLE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef= =3DANY([]),sort=3D[]), rowcount=3D100.0, cumulative cost=3D{inf} =09=09rel#25138:DrillScanRel.LOGICAL.ANY([]).[](table=3D[maprdb, customers]= ,groupscan=3DHBaseGroupScan [HBaseScanSpec=3DHBaseScanSpec [tableName=3Dcus= tomers, startRow=3Dnull, stopRow=3Dnull, filter=3Dnull], columns=3D[SchemaP= ath [`*`]]]), rowcount=3D1048576.0, cumulative cost=3D{1048576.0 Error: exc= eption while executing query: Failure while trying to get next result batch= . (state=3D,code=3D0) rows, 4194304.0 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#3, type: RecordType(BIGINT cust_id, VARCHAR(20) cust_name, VARCHAR(20) = cust_age, VARCHAR(20) agg_rev, VARCHAR(20) membership, VARCHAR(20) address) =09rel#25056:Subset#3.NONE.ANY([]).[], best=3Dnull, importance=3D0.59049000= 00000001 =09=09rel#25055:ProjectRel.NONE.ANY([]).[](child=3Drel#25054:Subset#2.ENUME= RABLE.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(ITEM($= 3, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_U= S$primary",cust_age=3DCAST(ITEM($3, 'age')):VARCHAR(20) CHARACTER SET "ISO-= 8859-1" COLLATE "ISO-8859-1$en_US$primary",agg_rev=3DCAST(ITEM($2, 'agg_rev= ')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primar= y",membership=3DCAST(ITEM($2, 'membership')):VARCHAR(20) CHARACTER SET "ISO= -8859-1" COLLATE "ISO-8859-1$en_US$primary",address=3DCAST(ITEM($1, 'state'= )):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary= "), rowcount=3D100.0, cumulative cost=3D{inf} =09rel#25108:Subset#3.LOGICAL.ANY([]).[], best=3Drel#25107, importance=3D0.= 6561 =09=09rel#25109:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25056:Subs= et#3.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25107:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25106:Subset= #13.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(= ITEM($1, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-= 1$en_US$primary",cust_age=3DCAST(ITEM($1, 'age')):VARCHAR(20) CHARACTER SET= "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary",agg_rev=3DCAST(ITEM($2, 'a= gg_rev')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$= primary",membership=3DCAST(ITEM($2, 'membership')):VARCHAR(20) CHARACTER SE= T "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary",address=3DCAST(ITEM($3, '= state')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$p= rimary"), rowcount=3D1048576.0, cumulative cost=3D{2097152.0 rows, 4194328.= 0 cpu, 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25135:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25120:Subset= #2.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(I= TEM($3, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary",cust_age=3DCAST(ITEM($3, 'age')):VARCHAR(20) CHARACTER SET = "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary",agg_rev=3DCAST(ITEM($2, 'ag= g_rev')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$p= rimary",membership=3DCAST(ITEM($2, 'membership')):VARCHAR(20) CHARACTER SET= "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary",address=3DCAST(ITEM($1, 's= tate')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$pr= imary"), rowcount=3D1048576.0, cumulative cost=3D{2097152.0 rows, 4194328.0= cpu, 0.0 io, 0.0 network, 0.0 memory} Set#4, type: RecordType(BIGINT cust_id, VARCHAR(20) cust_name, VARCHAR(20) = cust_age, VARCHAR(20) agg_rev, VARCHAR(20) membership, VARCHAR(20) address) =09rel#25058:Subset#4.NONE.ANY([]).[], best=3Dnull, importance=3D0.6561 =09=09rel#25057:ProjectRel.NONE.ANY([]).[](child=3Drel#25056:Subset#3.NONE.= ANY([]).[],cust_id=3D$0,cust_name=3DCAST($1):VARCHAR(20) CHARACTER SET "ISO= -8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,cust_age=3DCAST($2):VA= RCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT= NULL,agg_rev=3DCAST($3):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "IS= O-8859-1$en_US$primary" NOT NULL,membership=3DCAST($4):VARCHAR(20) CHARACTE= R SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,address=3DCA= ST($5):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$pri= mary" NOT NULL), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25102:ProjectRel.NONE.ANY([]).[](child=3Drel#25054:Subset#2.ENUME= RABLE.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(CAST(I= TEM($3, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary" NOT NULL,cust_age=3DCAST(CAST(ITEM($3, 'age')):VARCHAR(20) = CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20) = CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,agg_= rev=3DCAST(CAST(ITEM($2, 'agg_rev')):VARCHAR(20) CHARACTER SET "ISO-8859-1"= COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1"= COLLATE "ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST(CAST(ITEM($2= , 'membership')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary" NOT NULL,address=3DCAST(CAST(ITEM($1, 'state')):VARCHAR(20)= CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20)= CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), r= owcount=3D100.0, cumulative cost=3D{inf} =09rel#25125:Subset#4.LOGICAL.ANY([]).[], best=3Drel#25131, importance=3D0.= 6561 =09=09rel#25126:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25058:Subs= et#4.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25131:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25106:Subset= #13.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(= CAST(ITEM($1, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-= 8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-= 8859-1$en_US$primary" NOT NULL,cust_age=3DCAST(CAST(ITEM($1, 'age')):VARCHA= R(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHA= R(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NUL= L,agg_rev=3DCAST(CAST(ITEM($2, 'agg_rev')):VARCHAR(20) CHARACTER SET "ISO-8= 859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8= 859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST(CAST(I= TEM($2, 'membership')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-= 8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-= 8859-1$en_US$primary" NOT NULL,address=3DCAST(CAST(ITEM($3, 'state')):VARCH= AR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCH= AR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NU= LL), rowcount=3D1048576.0, cumulative cost=3D{2097152.0 rows, 4194328.0 cpu= , 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25132:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25120:Subset= #2.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(C= AST(ITEM($3, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8= 859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8= 859-1$en_US$primary" NOT NULL,cust_age=3DCAST(CAST(ITEM($3, 'age')):VARCHAR= (20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR= (20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL= ,agg_rev=3DCAST(CAST(ITEM($2, 'agg_rev')):VARCHAR(20) CHARACTER SET "ISO-88= 59-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-88= 59-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST(CAST(IT= EM($2, 'membership')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8= 859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8= 859-1$en_US$primary" NOT NULL,address=3DCAST(CAST(ITEM($1, 'state')):VARCHA= R(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHA= R(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NUL= L), rowcount=3D1048576.0, cumulative cost=3D{2097152.0 rows, 4194328.0 cpu,= 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25134:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25108:Subset= #3.LOGICAL.ANY([]).[],cust_id=3D$0,cust_name=3DCAST($1):VARCHAR(20) CHARACT= ER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,cust_age=3D= CAST($2):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$p= rimary" NOT NULL,agg_rev=3DCAST($3):VARCHAR(20) CHARACTER SET "ISO-8859-1" = COLLATE "ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST($4):VARCHAR(2= 0) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,a= ddress=3DCAST($5):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-= 1$en_US$primary" NOT NULL), rowcount=3D1048576.0, cumulative cost=3D{314572= 8.0 rows, 4194352.0 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#5, type: RecordType(BIGINT order_id, VARCHAR(1) month, TIMESTAMP(0) pur= ch_date, BIGINT cust_id, VARCHAR(1) state, BIGINT prod_id, INTEGER order_to= tal, BIGINT cust_id0, VARCHAR(20) cust_name, VARCHAR(20) cust_age, VARCHAR(= 20) agg_rev, VARCHAR(20) membership, VARCHAR(20) address) =09rel#25060:Subset#5.NONE.ANY([]).[], best=3Dnull, importance=3D0.72900000= 00000001 =09=09rel#25059:JoinRel.NONE.ANY([]).[](left=3Drel#25053:Subset#1.NONE.ANY(= []).[],right=3Drel#25058:Subset#4.NONE.ANY([]).[],condition=3Dtrue,joinType= =3Dinner), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09rel#25088:Subset#5.LOGICAL.ANY([]).[], best=3Dnull, importance=3D0.81 =09=09rel#25089:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25060:Subs= et#5.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25133:DrillJoinRel.LOGICAL.ANY([]).[](left=3Drel#25114:Subset#1.L= OGICAL.ANY([]).[],right=3Drel#25125:Subset#4.LOGICAL.ANY([]).[],condition= =3Dtrue,joinType=3Dinner), rowcount=3D1048576.0, cumulative cost=3D{inf} Set#6, type: RecordType(VARCHAR(1) month) =09rel#25062:Subset#6.NONE.ANY([]).[], best=3Dnull, importance=3D0.81 =09=09rel#25061:ProjectRel.NONE.ANY([]).[](child=3Drel#25060:Subset#5.NONE.= ANY([]).[],month=3D$1), rowcount=3D1.7976931348623157E308, cumulative cost= =3D{inf} =09=09rel#25078:ProjectRel.NONE.ANY([]).[](child=3Drel#25077:Subset#10.NONE= .ANY([]).[],month=3D$0), rowcount=3D1.7976931348623157E308, cumulative cost= =3D{inf} =09rel#25067:Subset#6.LOGICAL.ANY([]).[], best=3Dnull, importance=3D0.9 =09=09rel#25068:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25062:Subs= et#6.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25081:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25079:Subset= #10.LOGICAL.ANY([]).[],month=3D$0), rowcount=3D1.7976931348623157E308, cumu= lative cost=3D{inf} =09=09rel#25090:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25088:Subset= #5.LOGICAL.ANY([]).[],month=3D$1), rowcount=3D1.7976931348623157E308, cumul= ative cost=3D{inf} Set#7, type: RecordType(VARCHAR(1) month, BIGINT EXPR$1) =09rel#25064:Subset#7.NONE.ANY([]).[], best=3Dnull, importance=3D0.9 =09=09rel#25063:AggregateRel.NONE.ANY([]).[](child=3Drel#25062:Subset#6.NON= E.ANY([]).[],group=3D{0},EXPR$1=3DCOUNT()), rowcount=3D1.7976931348623158E3= 07, cumulative cost=3D{inf} =09rel#25065:Subset#7.LOGICAL.ANY([]).[], best=3Dnull, importance=3D1.0 =09=09rel#25066:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25064:Subs= et#7.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25069:DrillAggregateRel.LOGICAL.ANY([]).[](child=3Drel#25067:Subs= et#6.LOGICAL.ANY([]).[],group=3D{0},EXPR$1=3DCOUNT()), rowcount=3D1.7976931= 348623158E307, cumulative cost=3D{inf} Set#8, type: RecordType(VARCHAR(1) month) =09rel#25074:Subset#8.NONE.ANY([]).[], best=3Dnull, importance=3D0.6561 =09=09rel#25070:ProjectRel.NONE.ANY([]).[](child=3Drel#25053:Subset#1.NONE.= ANY([]).[],month=3D$1), rowcount=3D1.7976931348623157E308, cumulative cost= =3D{inf} =09=09rel#25097:ProjectRel.NONE.ANY([]).[](child=3Drel#25051:Subset#0.ENUME= RABLE.ANY([]).[],month=3DCAST(ITEM($1, 1)):VARCHAR(1) CHARACTER SET "ISO-88= 59-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=3D100.0, cumul= ative cost=3D{inf} =09rel#25083:Subset#8.LOGICAL.ANY([]).[], best=3Drel#25101, importance=3D0.= 7290000000000001 =09=09rel#25084:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25074:Subs= et#8.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25101:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25100:Subset= #12.LOGICAL.ANY([]).[],month=3DCAST(ITEM($0, 1)):VARCHAR(1) CHARACTER SET "= ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=3D6456.0= , cumulative cost=3D{12912.0 rows, 6460.0 cpu, 0.0 io, 0.0 network, 0.0 mem= ory} =09=09rel#25119:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25116:Subset= #0.LOGICAL.ANY([]).[],month=3DCAST(ITEM($1, 1)):VARCHAR(1) CHARACTER SET "I= SO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=3D6456.0,= cumulative cost=3D{12912.0 rows, 6.4560004E7 cpu, 0.0 io, 0.0 network, 0.0= memory} =09=09rel#25128:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25114:Subset= #1.LOGICAL.ANY([]).[],month=3D$1), rowcount=3D6456.0, cumulative cost=3D{19= 368.0 rows, 6488.0 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#9, type: RecordType(BIGINT cust_id) =09rel#25075:Subset#9.NONE.ANY([]).[], best=3Dnull, importance=3D0.6561 =09=09rel#25071:ProjectRel.NONE.ANY([]).[](child=3Drel#25058:Subset#4.NONE.= ANY([]).[],cust_id=3D$0), rowcount=3D1.7976931348623157E308, cumulative cos= t=3D{inf} =09=09rel#25091:ProjectRel.NONE.ANY([]).[](child=3Drel#25056:Subset#3.NONE.= ANY([]).[],cust_id=3D$0), rowcount=3D1.7976931348623157E308, cumulative cos= t=3D{inf} =09=09rel#25092:ProjectRel.NONE.ANY([]).[](child=3Drel#25054:Subset#2.ENUME= RABLE.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL), rowcount=3D100.0, cum= ulative cost=3D{inf} =09rel#25085:Subset#9.LOGICAL.ANY([]).[], best=3Drel#25096, importance=3D0.= 7290000000000001 =09=09rel#25086:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25075:Subs= et#9.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY([= ]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25096:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25095:Subset= #11.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL), rowcount=3D1048= 576.0, cumulative cost=3D{2097152.0 rows, 1048580.0 cpu, 0.0 io, 0.0 networ= k, 0.0 memory} =09=09rel#25123:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25120:Subset= #2.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL), rowcount=3D10485= 76.0, cumulative cost=3D{2097152.0 rows, 4194308.0 cpu, 0.0 io, 0.0 network= , 0.0 memory} =09=09rel#25124:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25108:Subset= #3.LOGICAL.ANY([]).[],cust_id=3D$0), rowcount=3D1048576.0, cumulative cost= =3D{3145728.0 rows, 4194332.0 cpu, 0.0 io, 0.0 network, 0.0 memory} =09=09rel#25127:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25125:Subset= #4.LOGICAL.ANY([]).[],cust_id=3D$0), rowcount=3D1048576.0, cumulative cost= =3D{3145728.0 rows, 4194332.0 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#10, type: RecordType(VARCHAR(1) month, BIGINT cust_id) =09rel#25077:Subset#10.NONE.ANY([]).[], best=3Dnull, importance=3D0.7290000= 000000001 =09=09rel#25076:JoinRel.NONE.ANY([]).[](left=3Drel#25074:Subset#8.NONE.ANY(= []).[],right=3Drel#25075:Subset#9.NONE.ANY([]).[],condition=3Dtrue,joinType= =3Dinner), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09rel#25079:Subset#10.LOGICAL.ANY([]).[], best=3Dnull, importance=3D0.81 =09=09rel#25080:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25077:Subs= et#10.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY(= []),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} =09=09rel#25087:DrillJoinRel.LOGICAL.ANY([]).[](left=3Drel#25083:Subset#8.L= OGICAL.ANY([]).[],right=3Drel#25085:Subset#9.LOGICAL.ANY([]).[],condition= =3Dtrue,joinType=3Dinner), rowcount=3D1048576.0, cumulative cost=3D{inf} Set#11, type: RecordType(ANY row_key) =09rel#25095:Subset#11.LOGICAL.ANY([]).[], best=3Drel#25093, importance=3D0= .6561 =09=09rel#25093:DrillScanRel.LOGICAL.ANY([]).[](table=3D[maprdb, customers]= ,groupscan=3DHBaseGroupScan [HBaseScanSpec=3DHBaseScanSpec [tableName=3Dcus= tomers, startRow=3Dnull, stopRow=3Dnull, filter=3Dnull], columns=3D[SchemaP= ath [`row_key`]]]), rowcount=3D1048576.0, cumulative cost=3D{1048576.0 rows= , 1048576.0 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#12, type: RecordType(ANY columns) =09rel#25100:Subset#12.LOGICAL.ANY([]).[], best=3Drel#25098, importance=3D0= .6561 =09=09rel#25098:DrillScanRel.LOGICAL.ANY([]).[](table=3D[dfs, data, /orders= ],groupscan=3DEasyGroupScan [selectionRoot=3D/mapr/c1/andries/demo/data/ord= ers, numFiles=3D10, columns =3D [SchemaPath [`columns`[1]]]]), rowcount=3D6= 456.0, cumulative cost=3D{6456.0 rows, 6456.0 cpu, 0.0 io, 0.0 network, 0.0= memory} Set#13, type: RecordType(ANY row_key, (VARCHAR(1), ANY) MAP personal, (VARC= HAR(1), ANY) MAP loyalty, (VARCHAR(1), ANY) MAP address) =09rel#25106:Subset#13.LOGICAL.ANY([]).[], best=3Drel#25104, importance=3D0= .5904900000000001 =09=09rel#25104:DrillScanRel.LOGICAL.ANY([]).[](table=3D[maprdb, customers]= ,groupscan=3DHBaseGroupScan [HBaseScanSpec=3DHBaseScanSpec [tableName=3Dcus= tomers, startRow=3Dnull, stopRow=3Dnull, filter=3Dnull], columns=3D[SchemaP= ath [`row_key`], SchemaPath [`personal`.`name`], SchemaPath [`personal`.`ag= e`], SchemaPath [`loyalty`.`agg_rev`], SchemaPath [`loyalty`.`membership`],= SchemaPath [`address`.`state`]]]), rowcount=3D1048576.0, cumulative cost= =3D{1048576.0 rows, 4194304.0 cpu, 0.0 io, 0.0 network, 0.0 memory} Set#14, type: RecordType(ANY columns) =09rel#25112:Subset#14.LOGICAL.ANY([]).[], best=3Drel#25110, importance=3D0= .5904900000000001 =09=09rel#25110:DrillScanRel.LOGICAL.ANY([]).[](table=3D[dfs, data, /orders= ],groupscan=3DEasyGroupScan [selectionRoot=3D/mapr/c1/andries/demo/data/ord= ers, numFiles=3D10, columns =3D [SchemaPath [`columns`[0]], SchemaPath [`co= lumns`[1]], SchemaPath [`columns`[2]], SchemaPath [`columns`[3]], SchemaPat= h [`columns`[4]], SchemaPath [`columns`[5]], SchemaPath [`columns`[6]]]]), = rowcount=3D6456.0, cumulative cost=3D{6456.0 rows, 6456.0 cpu, 0.0 io, 0.0 = network, 0.0 memory} [8224f29c-1824-45d9-a74b-3d31e48a3419] {code} > Analytic tool generated SQL queries hang or fail > ------------------------------------------------ > > Key: DRILL-1622 > URL: https://issues.apache.org/jira/browse/DRILL-1622 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 0.6.0 > Environment: CentOS, DFS, Hive, HBase > MapR 3.1.1 > Reporter: Andries Engelbrecht > Priority: Blocker > > Queries generated by Analytic tools can include unnecessary tables and jo= ins. When tracing ODBC calls and executing queries in sqlline the problems = are still experienced. > Example query that hangs: dfs.views .orderview points to CSV files in Ma= pR-FS and dfs.views.customerview points to MapR-DB > {code} > SELECT ord.`month`, count(*) FROM dfs.views.orderview ord, dfs.views.cust= omerview cust where cust.cust_id=3Dord.cust_id group by ord.`month` > {code} > The following query fails: > {code} > SELECT ord.`month`, count(*) FROM dfs.views.orderview ord, dfs.views.cust= omerview cust group by ord.`month`=20 > {code} > {code} > Query failed: Failure while parsing sql. Node [rel#25065:Subset#7.LOGICAL= .ANY([]).[]] could not be implemented; planner state: > Output received below > Root: rel#25065:Subset#7.LOGICAL.ANY([]).[] > Original rel: > AbstractConverter(subset=3D[rel#25065:Subset#7.LOGICAL.ANY([]).[]], conve= ntion=3D[LOGICAL], DrillDistributionTraitDef=3D[ANY([])], sort=3D[[]]): row= count =3D 1.7976931348623157E308, cumulative cost =3D {inf}, id =3D 25066 > AggregateRel(subset=3D[rel#25064:Subset#7.NONE.ANY([]).[]], group=3D[{0= }], EXPR$1=3D[COUNT()]): rowcount =3D 1.7976931348623158E307, cumulative co= st =3D {1.7976931348623158E307 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 memo= ry}, id =3D 25063 > ProjectRel(subset=3D[rel#25062:Subset#6.NONE.ANY([]).[]], month=3D[$1= ]): rowcount =3D 1.7976931348623157E308, cumulative cost =3D {1.79769313486= 23157E308 rows, 1.7976931348623157E308 cpu, 0.0 io, 0.0 network, 0.0 memory= }, id =3D 25061 > JoinRel(subset=3D[rel#25060:Subset#5.NONE.ANY([]).[]], condition=3D= [true], joinType=3D[inner]): rowcount =3D 1.7976931348623157E308, cumulativ= e cost =3D {1.7976931348623157E308 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 = memory}, id =3D 25059 > ProjectRel(subset=3D[rel#25053:Subset#1.NONE.ANY([]).[]], order_i= d=3D[CAST(ITEM($1, 0)):BIGINT NOT NULL], month=3D[CAST(ITEM($1, 1)):VARCHAR= (1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL]= , purch_date=3D[CAST(ITEM($1, 2)):TIMESTAMP(0) NOT NULL], cust_id=3D[CAST(I= TEM($1, 3)):BIGINT NOT NULL], state=3D[CAST(ITEM($1, 4)):VARCHAR(1) CHARACT= ER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL], prod_id= =3D[CAST(ITEM($1, 5)):BIGINT NOT NULL], order_total=3D[CAST(ITEM($1, 6)):IN= TEGER NOT NULL]): rowcount =3D 100.0, cumulative cost =3D {100.0 rows, 700.= 0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id =3D 25052 > EnumerableTableAccessRel(subset=3D[rel#25051:Subset#0.ENUMERABL= E.ANY([]).[]], table=3D[[dfs, data, /orders]]): rowcount =3D 100.0, cumulat= ive cost =3D {100.0 rows, 101.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = =3D 25027 > ProjectRel(subset=3D[rel#25058:Subset#4.NONE.ANY([]).[]], cust_id= =3D[$0], cust_name=3D[CAST($1):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLA= TE "ISO-8859-1$en_US$primary" NOT NULL], cust_age=3D[CAST($2):VARCHAR(20) C= HARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL], agg= _rev=3D[CAST($3):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1= $en_US$primary" NOT NULL], membership=3D[CAST($4):VARCHAR(20) CHARACTER SET= "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL], address=3D[CAST= ($5):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$prima= ry" NOT NULL]): rowcount =3D 1.7976931348623157E308, cumulative cost =3D {1= .7976931348623157E308 rows, Infinity cpu, 0.0 io, 0.0 network, 0.0 memory},= id =3D 25057 > ProjectRel(subset=3D[rel#25056:Subset#3.NONE.ANY([]).[]], cust_= id=3D[CAST($0):BIGINT NOT NULL], cust_name=3D[CAST(ITEM($3, 'name')):VARCHA= R(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], cust_= age=3D[CAST(ITEM($3, 'age')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE= "ISO-8859-1$en_US$primary"], agg_rev=3D[CAST(ITEM($2, 'agg_rev')):VARCHAR(= 20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], members= hip=3D[CAST(ITEM($2, 'membership')):VARCHAR(20) CHARACTER SET "ISO-8859-1" = COLLATE "ISO-8859-1$en_US$primary"], address=3D[CAST(ITEM($1, 'state')):VAR= CHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"]): r= owcount =3D 100.0, cumulative cost =3D {100.0 rows, 600.0 cpu, 0.0 io, 0.0 = network, 0.0 memory}, id =3D 25055 > EnumerableTableAccessRel(subset=3D[rel#25054:Subset#2.ENUMERA= BLE.ANY([]).[]], table=3D[[maprdb, customers]]): rowcount =3D 100.0, cumula= tive cost =3D {100.0 rows, 101.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = =3D 25031 > Sets: > Set#0, type: (DrillRecordRow[*, columns]) > =09rel#25051:Subset#0.ENUMERABLE.ANY([]).[], best=3Drel#25027, importance= =3D0.5904900000000001 > =09=09rel#25027:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=3D[d= fs, data, /orders]), rowcount=3D100.0, cumulative cost=3D{100.0 rows, 101.0= cpu, 0.0 io, 0.0 network, 0.0 memory} > =09=09rel#25117:AbstractConverter.ENUMERABLE.ANY([]).[](child=3Drel#25116= :Subset#0.LOGICAL.ANY([]).[],convention=3DENUMERABLE,DrillDistributionTrait= Def=3DANY([]),sort=3D[]), rowcount=3D6456.0, cumulative cost=3D{inf} > =09rel#25116:Subset#0.LOGICAL.ANY([]).[], best=3Drel#25137, importance=3D= 0.531441 > =09=09rel#25118:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25051:Su= bset#0.ENUMERABLE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef= =3DANY([]),sort=3D[]), rowcount=3D100.0, cumulative cost=3D{inf} > =09=09rel#25137:DrillScanRel.LOGICAL.ANY([]).[](table=3D[dfs, data, /orde= rs],groupscan=3DEasyGroupScan [selectionRoot=3D/mapr/c1/andries/demo/data/o= rders, numFiles=3D10, columns =3D [SchemaPath [`*`]]]), rowcount=3D6456.0, = cumulative cost=3D{6456.0 rows, 6.456E7 cpu, 0.0 io, 0.0 network, 0.0 memor= y} > Set#1, type: RecordType(BIGINT order_id, VARCHAR(1) month, TIMESTAMP(0) p= urch_date, BIGINT cust_id, VARCHAR(1) state, BIGINT prod_id, INTEGER order_= total) > =09rel#25053:Subset#1.NONE.ANY([]).[], best=3Dnull, importance=3D0.6561 > =09=09rel#25052:ProjectRel.NONE.ANY([]).[](child=3Drel#25051:Subset#0.ENU= MERABLE.ANY([]).[],order_id=3DCAST(ITEM($1, 0)):BIGINT NOT NULL,month=3DCAS= T(ITEM($1, 1)):VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en= _US$primary" NOT NULL,purch_date=3DCAST(ITEM($1, 2)):TIMESTAMP(0) NOT NULL,= cust_id=3DCAST(ITEM($1, 3)):BIGINT NOT NULL,state=3DCAST(ITEM($1, 4)):VARCH= AR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NUL= L,prod_id=3DCAST(ITEM($1, 5)):BIGINT NOT NULL,order_total=3DCAST(ITEM($1, 6= )):INTEGER NOT NULL), rowcount=3D100.0, cumulative cost=3D{inf} > =09rel#25114:Subset#1.LOGICAL.ANY([]).[], best=3Drel#25113, importance=3D= 0.6561 > =09=09rel#25115:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25053:Su= bset#1.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY= ([]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} > =09=09rel#25113:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25112:Subs= et#14.LOGICAL.ANY([]).[],order_id=3DCAST(ITEM($0, 0)):BIGINT NOT NULL,month= =3DCAST(ITEM($0, 1)):VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-885= 9-1$en_US$primary" NOT NULL,purch_date=3DCAST(ITEM($0, 2)):TIMESTAMP(0) NOT= NULL,cust_id=3DCAST(ITEM($0, 3)):BIGINT NOT NULL,state=3DCAST(ITEM($0, 4))= :VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" N= OT NULL,prod_id=3DCAST(ITEM($0, 5)):BIGINT NOT NULL,order_total=3DCAST(ITEM= ($0, 6)):INTEGER NOT NULL), rowcount=3D6456.0, cumulative cost=3D{12912.0 r= ows, 6484.0 cpu, 0.0 io, 0.0 network, 0.0 memory} > =09=09rel#25136:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25116:Subs= et#0.LOGICAL.ANY([]).[],order_id=3DCAST(ITEM($1, 0)):BIGINT NOT NULL,month= =3DCAST(ITEM($1, 1)):VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-885= 9-1$en_US$primary" NOT NULL,purch_date=3DCAST(ITEM($1, 2)):TIMESTAMP(0) NOT= NULL,cust_id=3DCAST(ITEM($1, 3)):BIGINT NOT NULL,state=3DCAST(ITEM($1, 4))= :VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" N= OT NULL,prod_id=3DCAST(ITEM($1, 5)):BIGINT NOT NULL,order_total=3DCAST(ITEM= ($1, 6)):INTEGER NOT NULL), rowcount=3D6456.0, cumulative cost=3D{12912.0 r= ows, 6.4560028E7 cpu, 0.0 io, 0.0 network, 0.0 memory} > Set#2, type: RecordType(ANY row_key, (VARCHAR(1), ANY) MAP address, (VARC= HAR(1), ANY) MAP loyalty, (VARCHAR(1), ANY) MAP personal) > =09rel#25054:Subset#2.ENUMERABLE.ANY([]).[], best=3Drel#25031, importance= =3D0.531441 > =09=09rel#25031:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=3D[m= aprdb, customers]), rowcount=3D100.0, cumulative cost=3D{100.0 rows, 101.0 = cpu, 0.0 io, 0.0 network, 0.0 memory} > =09=09rel#25121:AbstractConverter.ENUMERABLE.ANY([]).[](child=3Drel#25120= :Subset#2.LOGICAL.ANY([]).[],convention=3DENUMERABLE,DrillDistributionTrait= Def=3DANY([]),sort=3D[]), rowcount=3D1048576.0, cumulative cost=3D{inf} > =09rel#25120:Subset#2.LOGICAL.ANY([]).[], best=3Drel#25138, importance=3D= 0.4782969000000001 > =09=09rel#25122:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25054:Su= bset#2.ENUMERABLE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef= =3DANY([]),sort=3D[]), rowcount=3D100.0, cumulative cost=3D{inf} > =09=09rel#25138:DrillScanRel.LOGICAL.ANY([]).[](table=3D[maprdb, customer= s],groupscan=3DHBaseGroupScan [HBaseScanSpec=3DHBaseScanSpec [tableName=3Dc= ustomers, startRow=3Dnull, stopRow=3Dnull, filter=3Dnull], columns=3D[Schem= aPath [`*`]]]), rowcount=3D1048576.0, cumulative cost=3D{1048576.0 Error: e= xception while executing query: Failure while trying to get next result bat= ch. (state=3D,code=3D0) > rows, 4194304.0 cpu, 0.0 io, 0.0 network, 0.0 memory} > Set#3, type: RecordType(BIGINT cust_id, VARCHAR(20) cust_name, VARCHAR(20= ) cust_age, VARCHAR(20) agg_rev, VARCHAR(20) membership, VARCHAR(20) addres= s) > =09rel#25056:Subset#3.NONE.ANY([]).[], best=3Dnull, importance=3D0.590490= 0000000001 > =09=09rel#25055:ProjectRel.NONE.ANY([]).[](child=3Drel#25054:Subset#2.ENU= MERABLE.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(ITEM= ($3, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en= _US$primary",cust_age=3DCAST(ITEM($3, 'age')):VARCHAR(20) CHARACTER SET "IS= O-8859-1" COLLATE "ISO-8859-1$en_US$primary",agg_rev=3DCAST(ITEM($2, 'agg_r= ev')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$prim= ary",membership=3DCAST(ITEM($2, 'membership')):VARCHAR(20) CHARACTER SET "I= SO-8859-1" COLLATE "ISO-8859-1$en_US$primary",address=3DCAST(ITEM($1, 'stat= e')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$prima= ry"), rowcount=3D100.0, cumulative cost=3D{inf} > =09rel#25108:Subset#3.LOGICAL.ANY([]).[], best=3Drel#25107, importance=3D= 0.6561 > =09=09rel#25109:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25056:Su= bset#3.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY= ([]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} > =09=09rel#25107:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25106:Subs= et#13.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAS= T(ITEM($1, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-885= 9-1$en_US$primary",cust_age=3DCAST(ITEM($1, 'age')):VARCHAR(20) CHARACTER S= ET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary",agg_rev=3DCAST(ITEM($2, = 'agg_rev')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_U= S$primary",membership=3DCAST(ITEM($2, 'membership')):VARCHAR(20) CHARACTER = SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary",address=3DCAST(ITEM($3,= 'state')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US= $primary"), rowcount=3D1048576.0, cumulative cost=3D{2097152.0 rows, 419432= 8.0 cpu, 0.0 io, 0.0 network, 0.0 memory} > =09=09rel#25135:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25120:Subs= et#2.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST= (ITEM($3, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859= -1$en_US$primary",cust_age=3DCAST(ITEM($3, 'age')):VARCHAR(20) CHARACTER SE= T "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary",agg_rev=3DCAST(ITEM($2, '= agg_rev')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US= $primary",membership=3DCAST(ITEM($2, 'membership')):VARCHAR(20) CHARACTER S= ET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary",address=3DCAST(ITEM($1, = 'state')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$= primary"), rowcount=3D1048576.0, cumulative cost=3D{2097152.0 rows, 4194328= .0 cpu, 0.0 io, 0.0 network, 0.0 memory} > Set#4, type: RecordType(BIGINT cust_id, VARCHAR(20) cust_name, VARCHAR(20= ) cust_age, VARCHAR(20) agg_rev, VARCHAR(20) membership, VARCHAR(20) addres= s) > =09rel#25058:Subset#4.NONE.ANY([]).[], best=3Dnull, importance=3D0.6561 > =09=09rel#25057:ProjectRel.NONE.ANY([]).[](child=3Drel#25056:Subset#3.NON= E.ANY([]).[],cust_id=3D$0,cust_name=3DCAST($1):VARCHAR(20) CHARACTER SET "I= SO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,cust_age=3DCAST($2):= VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" N= OT NULL,agg_rev=3DCAST($3):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "= ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST($4):VARCHAR(20) CHARAC= TER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,address=3D= CAST($5):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$p= rimary" NOT NULL), rowcount=3D1.7976931348623157E308, cumulative cost=3D{in= f} > =09=09rel#25102:ProjectRel.NONE.ANY([]).[](child=3Drel#25054:Subset#2.ENU= MERABLE.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST(CAST= (ITEM($3, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859= -1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859= -1$en_US$primary" NOT NULL,cust_age=3DCAST(CAST(ITEM($3, 'age')):VARCHAR(20= ) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20= ) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,ag= g_rev=3DCAST(CAST(ITEM($2, 'agg_rev')):VARCHAR(20) CHARACTER SET "ISO-8859-= 1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-= 1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST(CAST(ITEM(= $2, 'membership')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859= -1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859= -1$en_US$primary" NOT NULL,address=3DCAST(CAST(ITEM($1, 'state')):VARCHAR(2= 0) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(2= 0) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL),= rowcount=3D100.0, cumulative cost=3D{inf} > =09rel#25125:Subset#4.LOGICAL.ANY([]).[], best=3Drel#25131, importance=3D= 0.6561 > =09=09rel#25126:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25058:Su= bset#4.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY= ([]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} > =09=09rel#25131:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25106:Subs= et#13.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAS= T(CAST(ITEM($1, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "IS= O-8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "IS= O-8859-1$en_US$primary" NOT NULL,cust_age=3DCAST(CAST(ITEM($1, 'age')):VARC= HAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARC= HAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT N= ULL,agg_rev=3DCAST(CAST(ITEM($2, 'agg_rev')):VARCHAR(20) CHARACTER SET "ISO= -8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO= -8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST(CAST= (ITEM($2, 'membership')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "IS= O-8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "IS= O-8859-1$en_US$primary" NOT NULL,address=3DCAST(CAST(ITEM($3, 'state')):VAR= CHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VAR= CHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT = NULL), rowcount=3D1048576.0, cumulative cost=3D{2097152.0 rows, 4194328.0 c= pu, 0.0 io, 0.0 network, 0.0 memory} > =09=09rel#25132:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25120:Subs= et#2.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL,cust_name=3DCAST= (CAST(ITEM($3, 'name')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO= -8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO= -8859-1$en_US$primary" NOT NULL,cust_age=3DCAST(CAST(ITEM($3, 'age')):VARCH= AR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCH= AR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NU= LL,agg_rev=3DCAST(CAST(ITEM($2, 'agg_rev')):VARCHAR(20) CHARACTER SET "ISO-= 8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-= 8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST(CAST(= ITEM($2, 'membership')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO= -8859-1$en_US$primary"):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO= -8859-1$en_US$primary" NOT NULL,address=3DCAST(CAST(ITEM($1, 'state')):VARC= HAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"):VARC= HAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT N= ULL), rowcount=3D1048576.0, cumulative cost=3D{2097152.0 rows, 4194328.0 cp= u, 0.0 io, 0.0 network, 0.0 memory} > =09=09rel#25134:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25108:Subs= et#3.LOGICAL.ANY([]).[],cust_id=3D$0,cust_name=3DCAST($1):VARCHAR(20) CHARA= CTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,cust_age= =3DCAST($2):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_U= S$primary" NOT NULL,agg_rev=3DCAST($3):VARCHAR(20) CHARACTER SET "ISO-8859-= 1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL,membership=3DCAST($4):VARCHA= R(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NUL= L,address=3DCAST($5):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-88= 59-1$en_US$primary" NOT NULL), rowcount=3D1048576.0, cumulative cost=3D{314= 5728.0 rows, 4194352.0 cpu, 0.0 io, 0.0 network, 0.0 memory} > Set#5, type: RecordType(BIGINT order_id, VARCHAR(1) month, TIMESTAMP(0) p= urch_date, BIGINT cust_id, VARCHAR(1) state, BIGINT prod_id, INTEGER order_= total, BIGINT cust_id0, VARCHAR(20) cust_name, VARCHAR(20) cust_age, VARCHA= R(20) agg_rev, VARCHAR(20) membership, VARCHAR(20) address) > =09rel#25060:Subset#5.NONE.ANY([]).[], best=3Dnull, importance=3D0.729000= 0000000001 > =09=09rel#25059:JoinRel.NONE.ANY([]).[](left=3Drel#25053:Subset#1.NONE.AN= Y([]).[],right=3Drel#25058:Subset#4.NONE.ANY([]).[],condition=3Dtrue,joinTy= pe=3Dinner), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} > =09rel#25088:Subset#5.LOGICAL.ANY([]).[], best=3Dnull, importance=3D0.81 > =09=09rel#25089:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25060:Su= bset#5.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY= ([]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} > =09=09rel#25133:DrillJoinRel.LOGICAL.ANY([]).[](left=3Drel#25114:Subset#1= .LOGICAL.ANY([]).[],right=3Drel#25125:Subset#4.LOGICAL.ANY([]).[],condition= =3Dtrue,joinType=3Dinner), rowcount=3D1048576.0, cumulative cost=3D{inf} > Set#6, type: RecordType(VARCHAR(1) month) > =09rel#25062:Subset#6.NONE.ANY([]).[], best=3Dnull, importance=3D0.81 > =09=09rel#25061:ProjectRel.NONE.ANY([]).[](child=3Drel#25060:Subset#5.NON= E.ANY([]).[],month=3D$1), rowcount=3D1.7976931348623157E308, cumulative cos= t=3D{inf} > =09=09rel#25078:ProjectRel.NONE.ANY([]).[](child=3Drel#25077:Subset#10.NO= NE.ANY([]).[],month=3D$0), rowcount=3D1.7976931348623157E308, cumulative co= st=3D{inf} > =09rel#25067:Subset#6.LOGICAL.ANY([]).[], best=3Dnull, importance=3D0.9 > =09=09rel#25068:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25062:Su= bset#6.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY= ([]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} > =09=09rel#25081:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25079:Subs= et#10.LOGICAL.ANY([]).[],month=3D$0), rowcount=3D1.7976931348623157E308, cu= mulative cost=3D{inf} > =09=09rel#25090:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25088:Subs= et#5.LOGICAL.ANY([]).[],month=3D$1), rowcount=3D1.7976931348623157E308, cum= ulative cost=3D{inf} > Set#7, type: RecordType(VARCHAR(1) month, BIGINT EXPR$1) > =09rel#25064:Subset#7.NONE.ANY([]).[], best=3Dnull, importance=3D0.9 > =09=09rel#25063:AggregateRel.NONE.ANY([]).[](child=3Drel#25062:Subset#6.N= ONE.ANY([]).[],group=3D{0},EXPR$1=3DCOUNT()), rowcount=3D1.7976931348623158= E307, cumulative cost=3D{inf} > =09rel#25065:Subset#7.LOGICAL.ANY([]).[], best=3Dnull, importance=3D1.0 > =09=09rel#25066:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25064:Su= bset#7.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY= ([]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} > =09=09rel#25069:DrillAggregateRel.LOGICAL.ANY([]).[](child=3Drel#25067:Su= bset#6.LOGICAL.ANY([]).[],group=3D{0},EXPR$1=3DCOUNT()), rowcount=3D1.79769= 31348623158E307, cumulative cost=3D{inf} > Set#8, type: RecordType(VARCHAR(1) month) > =09rel#25074:Subset#8.NONE.ANY([]).[], best=3Dnull, importance=3D0.6561 > =09=09rel#25070:ProjectRel.NONE.ANY([]).[](child=3Drel#25053:Subset#1.NON= E.ANY([]).[],month=3D$1), rowcount=3D1.7976931348623157E308, cumulative cos= t=3D{inf} > =09=09rel#25097:ProjectRel.NONE.ANY([]).[](child=3Drel#25051:Subset#0.ENU= MERABLE.ANY([]).[],month=3DCAST(ITEM($1, 1)):VARCHAR(1) CHARACTER SET "ISO-= 8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=3D100.0, cum= ulative cost=3D{inf} > =09rel#25083:Subset#8.LOGICAL.ANY([]).[], best=3Drel#25101, importance=3D= 0.7290000000000001 > =09=09rel#25084:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25074:Su= bset#8.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY= ([]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} > =09=09rel#25101:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25100:Subs= et#12.LOGICAL.ANY([]).[],month=3DCAST(ITEM($0, 1)):VARCHAR(1) CHARACTER SET= "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=3D6456= .0, cumulative cost=3D{12912.0 rows, 6460.0 cpu, 0.0 io, 0.0 network, 0.0 m= emory} > =09=09rel#25119:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25116:Subs= et#0.LOGICAL.ANY([]).[],month=3DCAST(ITEM($1, 1)):VARCHAR(1) CHARACTER SET = "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=3D6456.= 0, cumulative cost=3D{12912.0 rows, 6.4560004E7 cpu, 0.0 io, 0.0 network, 0= .0 memory} > =09=09rel#25128:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25114:Subs= et#1.LOGICAL.ANY([]).[],month=3D$1), rowcount=3D6456.0, cumulative cost=3D{= 19368.0 rows, 6488.0 cpu, 0.0 io, 0.0 network, 0.0 memory} > Set#9, type: RecordType(BIGINT cust_id) > =09rel#25075:Subset#9.NONE.ANY([]).[], best=3Dnull, importance=3D0.6561 > =09=09rel#25071:ProjectRel.NONE.ANY([]).[](child=3Drel#25058:Subset#4.NON= E.ANY([]).[],cust_id=3D$0), rowcount=3D1.7976931348623157E308, cumulative c= ost=3D{inf} > =09=09rel#25091:ProjectRel.NONE.ANY([]).[](child=3Drel#25056:Subset#3.NON= E.ANY([]).[],cust_id=3D$0), rowcount=3D1.7976931348623157E308, cumulative c= ost=3D{inf} > =09=09rel#25092:ProjectRel.NONE.ANY([]).[](child=3Drel#25054:Subset#2.ENU= MERABLE.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL), rowcount=3D100.0, c= umulative cost=3D{inf} > =09rel#25085:Subset#9.LOGICAL.ANY([]).[], best=3Drel#25096, importance=3D= 0.7290000000000001 > =09=09rel#25086:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25075:Su= bset#9.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DANY= ([]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} > =09=09rel#25096:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25095:Subs= et#11.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL), rowcount=3D10= 48576.0, cumulative cost=3D{2097152.0 rows, 1048580.0 cpu, 0.0 io, 0.0 netw= ork, 0.0 memory} > =09=09rel#25123:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25120:Subs= et#2.LOGICAL.ANY([]).[],cust_id=3DCAST($0):BIGINT NOT NULL), rowcount=3D104= 8576.0, cumulative cost=3D{2097152.0 rows, 4194308.0 cpu, 0.0 io, 0.0 netwo= rk, 0.0 memory} > =09=09rel#25124:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25108:Subs= et#3.LOGICAL.ANY([]).[],cust_id=3D$0), rowcount=3D1048576.0, cumulative cos= t=3D{3145728.0 rows, 4194332.0 cpu, 0.0 io, 0.0 network, 0.0 memory} > =09=09rel#25127:DrillProjectRel.LOGICAL.ANY([]).[](child=3Drel#25125:Subs= et#4.LOGICAL.ANY([]).[],cust_id=3D$0), rowcount=3D1048576.0, cumulative cos= t=3D{3145728.0 rows, 4194332.0 cpu, 0.0 io, 0.0 network, 0.0 memory} > Set#10, type: RecordType(VARCHAR(1) month, BIGINT cust_id) > =09rel#25077:Subset#10.NONE.ANY([]).[], best=3Dnull, importance=3D0.72900= 00000000001 > =09=09rel#25076:JoinRel.NONE.ANY([]).[](left=3Drel#25074:Subset#8.NONE.AN= Y([]).[],right=3Drel#25075:Subset#9.NONE.ANY([]).[],condition=3Dtrue,joinTy= pe=3Dinner), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf} > =09rel#25079:Subset#10.LOGICAL.ANY([]).[], best=3Dnull, importance=3D0.81 > =09=09rel#25080:AbstractConverter.LOGICAL.ANY([]).[](child=3Drel#25077:Su= bset#10.NONE.ANY([]).[],convention=3DLOGICAL,DrillDistributionTraitDef=3DAN= Y([]),sort=3D[]), rowcount=3D1.7976931348623157E308, cumulative cost=3D{inf= } > =09=09rel#25087:DrillJoinRel.LOGICAL.ANY([]).[](left=3Drel#25083:Subset#8= .LOGICAL.ANY([]).[],right=3Drel#25085:Subset#9.LOGICAL.ANY([]).[],condition= =3Dtrue,joinType=3Dinner), rowcount=3D1048576.0, cumulative cost=3D{inf} > Set#11, type: RecordType(ANY row_key) > =09rel#25095:Subset#11.LOGICAL.ANY([]).[], best=3Drel#25093, importance= =3D0.6561 > =09=09rel#25093:DrillScanRel.LOGICAL.ANY([]).[](table=3D[maprdb, customer= s],groupscan=3DHBaseGroupScan [HBaseScanSpec=3DHBaseScanSpec [tableName=3Dc= ustomers, startRow=3Dnull, stopRow=3Dnull, filter=3Dnull], columns=3D[Schem= aPath [`row_key`]]]), rowcount=3D1048576.0, cumulative cost=3D{1048576.0 ro= ws, 1048576.0 cpu, 0.0 io, 0.0 network, 0.0 memory} > Set#12, type: RecordType(ANY columns) > =09rel#25100:Subset#12.LOGICAL.ANY([]).[], best=3Drel#25098, importance= =3D0.6561 > =09=09rel#25098:DrillScanRel.LOGICAL.ANY([]).[](table=3D[dfs, data, /orde= rs],groupscan=3DEasyGroupScan [selectionRoot=3D/mapr/c1/andries/demo/data/o= rders, numFiles=3D10, columns =3D [SchemaPath [`columns`[1]]]]), rowcount= =3D6456.0, cumulative cost=3D{6456.0 rows, 6456.0 cpu, 0.0 io, 0.0 network,= 0.0 memory} > Set#13, type: RecordType(ANY row_key, (VARCHAR(1), ANY) MAP personal, (VA= RCHAR(1), ANY) MAP loyalty, (VARCHAR(1), ANY) MAP address) > =09rel#25106:Subset#13.LOGICAL.ANY([]).[], best=3Drel#25104, importance= =3D0.5904900000000001 > =09=09rel#25104:DrillScanRel.LOGICAL.ANY([]).[](table=3D[maprdb, customer= s],groupscan=3DHBaseGroupScan [HBaseScanSpec=3DHBaseScanSpec [tableName=3Dc= ustomers, startRow=3Dnull, stopRow=3Dnull, filter=3Dnull], columns=3D[Schem= aPath [`row_key`], SchemaPath [`personal`.`name`], SchemaPath [`personal`.`= age`], SchemaPath [`loyalty`.`agg_rev`], SchemaPath [`loyalty`.`membership`= ], SchemaPath [`address`.`state`]]]), rowcount=3D1048576.0, cumulative cost= =3D{1048576.0 rows, 4194304.0 cpu, 0.0 io, 0.0 network, 0.0 memory} > Set#14, type: RecordType(ANY columns) > =09rel#25112:Subset#14.LOGICAL.ANY([]).[], best=3Drel#25110, importance= =3D0.5904900000000001 > =09=09rel#25110:DrillScanRel.LOGICAL.ANY([]).[](table=3D[dfs, data, /orde= rs],groupscan=3DEasyGroupScan [selectionRoot=3D/mapr/c1/andries/demo/data/o= rders, numFiles=3D10, columns =3D [SchemaPath [`columns`[0]], SchemaPath [`= columns`[1]], SchemaPath [`columns`[2]], SchemaPath [`columns`[3]], SchemaP= ath [`columns`[4]], SchemaPath [`columns`[5]], SchemaPath [`columns`[6]]]])= , rowcount=3D6456.0, cumulative cost=3D{6456.0 rows, 6456.0 cpu, 0.0 io, 0.= 0 network, 0.0 memory} > [8224f29c-1824-45d9-a74b-3d31e48a3419] > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)