Hello Anup,
I could not repro the issue with my data, can you please share the data that you used so I can try it again with your data. Thanks, Khurram ________________________________ From: Anup Tiwari <[email protected]> Sent: Monday, February 19, 2018 3:09:22 AM To: [email protected] Subject: Re: Code too large Hi Khurram/Arjun, Anyone got time to look into it? On Fri, Feb 16, 2018 4:53 PM, Anup Tiwari [email protected] wrote: Hi Arjun, After posting this reply ; i have found the same answer on net and that parameter to 30 and then query worked but it took bit more time than expected. Also don't you think these type of things should be adjusted automatically? @khurram, Please find below query and logs(since log is huge in drillbit.log for this query so i have divided logs into 3 parts in an order which i got for the query - error + some drill code(which was too large) + error). FYI : hive.cs_all is a hive(2.1.1) parquet table. Query :- create table dfs.tmp.cs_all_test AS select log_date,ssid ,select log_date,ssid , count((case when ((id like 'cta-action-%' and event = 'click' and sit = 'pnow' and ptype = '1' and stype = '1') OR (id like '1:100%' and event = 'pnowclick' and STRPOS(url,'mrc/player/sit.html') > 0) OR (id like '/fmg/110%/pn/pnow.html' or (id like '110%/fmgopt/pnow'))) then ssid end)) as pnow_prac_c , count((case when ((id like 'btsit%' and event = 'click' and sit like '%TSit%' and ptype1 = '1' and stype1 = '1') OR (event = 'ts.click' and id like '1:100%') OR (id like '/mgems/over/110%/ts.html')) then ssid end)) as ts_prac_c , count((case when ((id = '/res/vinit/' and mptype = '1' and (mgtype = 'cfp' OR mftype = '100')) OR (id like '/dl%/fmg/110%/pn/ftpracga/vinit.html' or id like '/dl%/fmg/110%/pn/vinit.html')) then ssid end)) as vinit_prac_c , count((case when (id = '/res/tiu/' and mptype = '1' and (mgtype = 'cfp' OR mftype = '100')) then ssid end)) as tiu_prac_c , count((case when (id = '/onstClick/btnStHr/' and event='click' and mptype = '1' and (mgtype = 'cfp' OR mftype = '100')) then ssid end)) as StHr_prac_c , count((case when ((id = '/res/dcd/' and mptype = '1' and (mgtype = 'cfp' OR mftype = '100')) OR (id like '/dl%/fmg/110%/pn/ftpracga/dcd.html' or id like '/dl%/fmg/110%/pn/dcd.html')) then ssid end)) as dcd_prac_c , count((case when ((id = '/confirmdr/btnY/' and event in ('click','Click') and mptype = '1' and (mgtype = 'cfp' OR mftype = '100')) OR (id like '/dl%/fmg/110%/pn/dr.html')) then ssid end)) as dr_prac_c , count((case when ((id = '/res/finish/' and mptype = '1' and (mgtype = 'cfp' OR mftype = '100')) OR (id like '/dl%/fmg/110%/pn/ftpracga/finish.html' or id like '/dl%/fmg/110%/pn/finish.html')) then ssid end)) as finish_prac_c , count((case when ((id like 'cta-action-%' and event = 'click' and sit = 'pnow' and ptype = '2' and stype = '1') OR (id like '2:100%' and event = 'pnowclick' and STRPOS(url,'mrc/player/sit.html') > 0) OR (id like '/fmg/210%/pn/pnow.html' or (id like '210%/fmgopt/pnow'))) then ssid end)) as pnow_cash_c , count((case when (id like '2:100%' and event = 'pnowclick' and STRPOS(url,'mrc/player/sit.html') = 0) then ssid end)) as pnow_cash_c_pac , count((case when ((id like 'btsit%' and event = 'click' and sit like '%TSit%' and ptype1 = '2' and stype1 = '1') OR (event = 'ts.click' and id like '2:100%') OR (id like '/mgems/over/210%/ts.html')) then ssid end)) as ts_cash_c , count((case when ((id = '/res/vinit/' and mptype = '2' and (mgtype = 'cfp' OR mftype = '100')) OR (id like '/dl%/fmg/210%/pn/ftpracga/vinit.html' or id like '/dl%/fmg/210%/pn/vinit.html')) then ssid end)) as vinit_cash_c , count((case when (id = '/res/tiu/' and mptype = '2' and (mgtype = 'cfp' OR mftype = '100')) then ssid end)) as tiu_cash_c , count((case when (id = '/onstClick/btnStHr/' and event='click' and mptype = '2' and (mgtype = 'cfp' OR mftype = '100')) then ssid end)) as StHr_cash_c , count((case when ((id = '/res/dcd/' and mptype = '2' and (mgtype = 'cfp' OR mftype = '100')) OR (id like '/dl%/fmg/210%/pn/ftpracga/dcd.html' or id like '/dl%/fmg/210%/pn/dcd.html')) then ssid end)) as dcd_cash_c , count((case when ((id = '/confirmdr/btnY/' and event in ('click','Click') and mptype = '2' and (mgtype = 'cfp' OR mftype = '100')) OR (id like '/dl%/fmg/210%/pn/dr.html')) then ssid end)) as dr_cash_c , count((case when ((id = '/res/finish/' and mptype = '2' and (mgtype = 'cfp' OR mftype = '100')) OR (id like '/dl%/fmg/210%/pn/ftpracga/finish.html' or id like '/dl%/fmg/210%/pn/finish.html')) then ssid end)) as finish_cash_c , count((case when event = 'event.ajax' and ajaxUrl = '/pyr/ac/change-uname' and ajaxResponse like '%validationResponse%true%updateResponse%true%' then ssid end)) as changeunamesuccess , count((case when unameautoassign = 'true' then ssid end)) as unameautoassign , count((case when (id = '/res/cdsdlt/' or id like '/dl%/fmg/210%/pn/cdsdlt.html%') and mptype = '2' and (mgtype = 'cfp' OR mftype = '100') then ssid end)) as cds_dlt_cfp_cash , count((case when ((id like 'cta-action-%' and event = 'click' and sit = 'pnow' and ptype = 1 and stype = 2) OR (id like '1:20%' and event = 'pnowclick' and STRPOS(url,'mrc/player/sit.html') > 0) OR (id like '/fmg/120%/pn/pnow.html' or (id like '120%/fmgopt/pnow'))) then ssid end)) as pnow_prac_pl , count((case when ((id like 'btsit%' and event = 'click' and sit like '%TSit%' and ptype1 = 1 and stype1 = 2) OR (event = 'ts.click' and id like '1:20%') OR (id like '/mgems/over/120%/ts.html')) then ssid end)) as ts_prac_pl , count((case when ((id = '/res/vinit/' and mptype= 1 and (mgtype = 'pl' OR mftype in('201','202'))) OR (id like '/dl%/fmg/120%/pn/ftpracga/vinit.html' or id like '/dl%/fmg/120%/pn/vinit.html')) then ssid end)) as vinit_prac_pl , count((case when (id = '/res/tiu/' and mptype= 1 and (mgtype = 'pl' OR mftype in('201','202'))) then ssid end)) as tiu_prac_pl , count((case when (id = '/onstClick/btnStHr/' and event='click' and mptype= 1 and (mgtype = 'pl' OR mftype in('201','202'))) then ssid end)) as StHr_prac_pl , count((case when ((id = '/res/dcd/' and mptype= 1 and (mgtype = 'pl' OR mftype in('201','202'))) OR (id like '/dl%/fmg/120%/pn/ftpracga/dcd.html' or id like '/dl%/fmg/120%/pn/dcd.html')) then ssid end)) as dcd_prac_pl , count((case when ((id = '/confirmdr/btnY/' and event in ('click','Click') and mptype= 1 and (mgtype = 'pl' OR mftype in('201','202'))) OR (id like '/dl%/fmg/120%/pn/dr.html')) then ssid end)) as dr_prac_pl , count((case when ((id = '/res/finish/' and mptype= 1 and (mgtype = 'pl' OR mftype in('201','202'))) OR (id like '/dl%/fmg/120%/pn/ftpracga/finish.html' or id like '/dl%/fmg/120%/pn/finish.html')) then ssid end)) as finish_prac_pl , count((case when ((id like 'cta-action-%' and event = 'click' and sit = 'pnow' and ptype = 2 and stype = 2) OR (id like '2:20%' and event = 'pnowclick' and STRPOS(url,'mrc/player/sit.html') > 0) OR (id like '/fmg/220%/pn/pnow.html' or (id like '220%/fmgopt/pnow'))) then ssid end)) as pnow_cash_pl , count((case when (id like '2:20%' and event = 'pnowclick' and STRPOS(url,'mrc/player/sit.html') = 0) then ssid end)) as pnow_cash_pl_pac , count((case when ((id like 'btsit%' and event = 'click' and sit like '%TSit%' and ptype1 = 2 and stype1 = 2) OR (event = 'ts.click' and id like '2:20%') OR (id like '/mgems/over/220%/ts.html')) then ssid end)) as ts_cash_pl , count((case when ((id = '/res/vinit/' and mptype= 2 and (mgtype = 'pl' OR mftype in('201','202'))) OR (id like '/dl%/fmg/220%/pn/ftpracga/vinit.html' or id like '/dl%/fmg/220%/pn/vinit.html')) then ssid end)) as vinit_cash_pl , count((case when (id = '/res/tiu/' and mptype= 2 and (mgtype = 'pl' OR mftype in('201','202'))) then ssid end)) as tiu_cash_pl , count((case when (id = '/onstClick/btnStHr/' and event='click' and mptype= 2 and (mgtype = 'pl' OR mftype in('201','202'))) then ssid end)) as StHr_cash_pl , count((case when ((id = '/res/dcd/' and mptype= 2 and (mgtype = 'pl' OR mftype in('201','202'))) OR (id like '/dl%/fmg/220%/pn/ftpracga/dcd.html' or id like '/dl%/fmg/220%/pn/dcd.html')) then ssid end)) as dcd_cash_pl , count((case when ((id = '/confirmdr/btnY/' and event in ('click','Click') and mptype= 2 and (mgtype = 'pl' OR mftype in('201','202'))) OR (id like '/dl%/fmg/220%/pn/dr.html')) then ssid end)) as dr_cash_pl , count((case when ((id = '/res/finish/' and mptype= 2 and (mgtype = 'pl' OR mftype in('201','202'))) OR (id like '/dl%/fmg/220%/pn/ftpracga/finish.html' or id like '/dl%/fmg/220%/pn/finish.html')) then ssid end)) as finish_cash_pl , count((case when (((id like '%confirmAutodr/btnY/%' or (id like '%/AutodrWindow/confirmAutodr/btnY/%' and event = 'Click' )) and mptype= 1 and (mgtype = 'pl' OR mftype in('201','202'))) OR (id like '/dl%/fmg/120%/pn/autodr/yes.html')) then ssid end)) as autodr_prac_pl , count((case when (((id like '%confirmAutodr/btnY/%' or (id like '%/AutodrWindow/confirmAutodr/btnY/%' and event = 'Click' )) and mptype= 2 and (mgtype = 'pl' OR mftype in('201','202'))) OR (id like '/dl%/fmg/220%/pn/autodr/yes.html')) then ssid end)) as autodr_cash_pl , count((case when (id = '/res/cdsdlt/' or id like '/dl%/fmg/220%/pn/cdsdlt.html%') and mptype= 2 and (mgtype = 'pl' OR mftype in('201','202')) then ssid end)) as cds_dlt_pl_cash, count((case when ((id like 'cta-action-%' and event = 'click' and sit = 'pnow' and ptype = 1 and stype = 3) OR (id like '1:30%' and event = 'pnowclick' and STRPOS(url,'mrc/player/sit.html') > 0) OR (id like '/fmg/130%/pn/pnow.html' or (id like '130%/fmgopt/pnow'))) then ssid end)) as pnow_prac_bn , count((case when ((id like 'btsit%' and event = 'click' and sit like '%TSit%' and ptype1 = 1 and stype1 = 3) OR (event = 'ts.click' and id like '1:30%') OR (id like '/mgems/over/130%/ts.html')) then ssid end)) as ts_prac_bn , count((case when ((id = '/res/vinit/' and mptype= 1 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) OR (id like '/dl%/fmg/130%/pn/ftpracga/vinit.html' or id like '/dl%/fmg/130%/pn/vinit.html')) then ssid end)) as vinit_prac_bn , count((case when (id = '/res/tiu/' and mptype= 1 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) then ssid end)) as tiu_prac_bn , count((case when (id = '/onstClick/btnStHr/' and event='click' and mptype= 1 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) then ssid end)) as StHr_prac_bn , count((case when ((id = '/res/dcd/' and mptype= 1 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) OR (id like '/dl%/fmg/130%/pn/ftpracga/dcd.html' or id like '/dl%/fmg/130%/pn/dcd.html')) then ssid end)) as dcd_prac_bn , count((case when ((id = '/confirmdr/btnY/' and event in ('click','Click') and mptype= 1 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) OR (id like '/dl%/fmg/130%/pn/dr.html')) then ssid end)) as dr_prac_bn , count((case when ((id = '/res/finish/' and mptype= 1 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) OR (id like '/dl%/fmg/130%/pn/ftpracga/finish.html' or id like '/dl%/fmg/130%/pn/finish.html')) then ssid end)) as finish_prac_bn , count((case when ((id like 'cta-action-%' and event = 'click' and sit = 'pnow' and ptype = 2 and stype = 3) OR (id like '2:30%' and event = 'pnowclick' and STRPOS(url,'mrc/player/sit.html') > 0) OR (id like '/fmg/230%/pn/pnow.html' or (id like '230%/fmgopt/pnow'))) then ssid end)) as pnow_cash_bn , count((case when (id like '2:30%' and event = 'pnowclick' and STRPOS(url,'mrc/player/sit.html') = 0) then ssid end)) as pnow_cash_bn_pac , count((case when ((id like 'btsit%' and event = 'click' and sit like '%TSit%' and ptype1 = 2 and stype1 = 3) OR (event = 'ts.click' and id like '2:30%') OR (id like '/mgems/over/230%/ts.html')) then ssid end)) as ts_cash_bn , count((case when ((id = '/res/vinit/' and mptype= 2 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) OR (id like '/dl%/fmg/230%/pn/ftpracga/vinit.html' or id like '/dl%/fmg/230%/pn/vinit.html')) then ssid end)) as vinit_cash_bn , count((case when (id = '/res/tiu/' and mptype= 2 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) then ssid end)) as tiu_cash_bn , count((case when (id = '/onstClick/btnStHr/' and event='click' and mptype= 2 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) then ssid end)) as StHr_cash_bn , count((case when ((id = '/res/dcd/' and mptype= 2 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) OR (id like '/dl%/fmg/230%/pn/ftpracga/dcd.html' or id like '/dl%/fmg/230%/pn/dcd.html')) then ssid end)) as dcd_cash_bn , count((case when ((id = '/confirmdr/btnY/' and event in ('click','Click') and mptype= 2 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) OR (id like '/dl%/fmg/230%/pn/dr.html')) then ssid end)) as dr_cash_bn , count((case when ((id = '/res/finish/' and mptype= 2 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) OR (id like '/dl%/fmg/230%/pn/ftpracga/finish.html' or id like '/dl%/fmg/230%/pn/finish.html')) then ssid end)) as finish_cash_bn , count((case when (((id like '%confirmAutodr/btnY/%' or (id like '%/AutodrWindow/confirmAutodr/btnY/%' and event = 'Click' )) and mptype= 1 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) OR (id like '/dl%/fmg/130%/pn/autodr/yes.html')) then ssid end)) as autodr_prac_bn , count((case when (((id like '%confirmAutodr/btnY/%' or (id like '%/AutodrWindow/confirmAutodr/btnY/%' and event = 'Click' )) and mptype= 2 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312'))) OR (id like '/dl%/fmg/230%/pn/autodr/yes.html')) then ssid end)) as autodr_cash_bn , count((case when (id = '/res/cdsdlt/' or id like '/dl%/fmg/230%/pn/cdsdlt.html%') and mptype= 2 and (mgtype = 'dlsrummy' OR mftype in('302','303','306','312')) then ssid end)) as cds_dlt_bn_cash from hive.cs_all group by log_date,ssid ; Error :- 1. Error :- [25794487-3ece-471b-864e-0dd33647729e:frag:3:10] ERROR o.a.d.e.c.DrillDiagnosticListener - ProjectorGen1348.java:1517: error: code too large public void doEval(int inIndex, int outIndex) ^ (compiler.err.limit.code)2018-02-16 16:37:40,983 [25794487-3ece-471b-864e-0dd33647729e:frag:3:42] ERROR o.a.d.e.r.AbstractSingleRecordBatch - Failure during query org.apache.drill.exec.exception.SchemaChangeException: Failure while attempting to load generated class at org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.setupNewSchema(ProjectRecordBatch.java:492) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:78) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:133) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:162) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:109) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.physical.impl.aggregate.HashAggBatch.buildSchema(HashAggBatch.java:111) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:142) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:109) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:51) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:133) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:162) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:105) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.physical.impl.SingleSenderCreator$SingleSenderRootExec.innerNext(SingleSenderCreator.java:92) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:95) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:234) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:227) [drill-java-exec-1.11.0.jar:1.11.0] at java.security.AccessController.doPrivileged(Native Method) [na:1.8.0_72] at javax.security.auth.Subject.doAs(Subject.java:422) [na:1.8.0_72] at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) [hadoop-common-2.7.1.jar:na] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:227) [drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) [drill-common-1.11.0.jar:1.11.0] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_72] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]Caused by: org.apache.drill.exec.exception.ClassTransformationException: java.util.concurrent.ExecutionException: org.apache.drill.exec.exception.ClassTransformationException: Failure generating transformation classes for value: /*2. A lot of code like :- StringFunctions$Like_setup: { matcher = java.util.regex.Pattern.compile(org.apache.drill.exec.expr.fn.impl.RegexpUtil.sqlToRegexLike(org.apache.drill.exec.expr.fn.impl.StringFunctionHelpers.toStringFromUTF8(pattern.start, pattern.end, pattern.buffer))).matcher(""); charSequenceWrapper = new org.apache.drill.exec.expr.fn.impl.CharSequenceWrapper(); matcher.reset(charSequenceWrapper);} work3441 = matcher; work3442 = charSequenceWrapper; } /** end SETUP for function like **/ int[] fieldIds3447 = new int[ 1 ] ; fieldIds3447 [ 0 ] = 10; Object tmp3448 = (incoming).getValueAccessorById(NullableVarCharVector.class, fieldIds3447).getValueVector(); if (tmp3448 == null) { throw new SchemaChangeException("Failure while loading vector vv3446 with id: TypedFieldId [fieldIds=[10], remainder=null]."); } vv3446 = ((NullableVarCharVector) tmp3448); /** start SETUP for function castINT **/ { {} } /** end SETUP for function castINT **/ IntHolder out3451 = new IntHolder(); out3451 .value = 2; constant3452 = out3451; /** start SETUP for function equal **/ { IntHolder right = constant3452; {} } /** end SETUP for function equal **/ int[] fieldIds3455 = new int[ 1 ] ; fieldIds3455 [ 0 ] = 1; Object tmp3456 = (incoming).getValueAccessorById(NullableVarCharVector.class, fieldIds3455).getValueVector(); if (tmp3456 == null) { throw new SchemaChangeException("Failure while loading vector vv3454 with id: TypedFieldId [fieldIds=[1], remainder=null]."); } vv3454 = ((NullableVarCharVector) tmp3456); NullableVarCharHolder out3458 = new NullableVarCharHolder(); constant3459 = out3458; int[] fieldIds3461 = new int[ 1 ] ; fieldIds3461 [ 0 ] = 61; Object tmp3462 = (outgoing).getValueAccessorById(NullableVarCharVector.class, fieldIds3461).getValueVector(); if (tmp3462 == null) { throw new SchemaChangeException("Failure while loading vector vv3460 with id: TypedFieldId [fieldIds=[61], remainder=null]."); } vv3460 = ((NullableVarCharVector) tmp3462); } } public void __DRILL_INIT__() throws SchemaChangeException { } } */ 3. Error Continue :- Caused by: org.codehaus.commons.compiler.CompileException: File 'org.apache.drill.exec.compile.DrillJavaFileObject[ProjectorGen1348.java]', Line 1517, Column 17: ProjectorGen1348.java:1517: error: code too large public void doEval(int inIndex, int outIndex) ^ (compiler.err.limit.code) at org.apache.drill.exec.compile.DrillDiagnosticListener.report(DrillDiagnosticListener.java:43) ~[drill-java-exec-1.11.0.jar:1.11.0] at com.sun.tools.javac.api.ClientCodeWrapper$WrappedDiagnosticListener.report(ClientCodeWrapper.java:559) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.util.Log.writeDiagnostic(Log.java:428) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.util.Log.report(Log.java:416) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.util.AbstractLog.error(AbstractLog.java:94) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.jvm.Code.checkLimits(Code.java:95) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.jvm.Gen.genMethod(Gen.java:948) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.jvm.Gen.visitMethodDef(Gen.java:885) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.tree.JCTree$JCMethodDecl.accept(JCTree.java:669) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.jvm.Gen.genDef(Gen.java:684) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.jvm.Gen.genClass(Gen.java:2235) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.main.JavaCompiler.genCode(JavaCompiler.java:712) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.main.JavaCompiler.generate(JavaCompiler.java:1451) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.main.JavaCompiler.generate(JavaCompiler.java:1419) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.main.JavaCompiler.compile2(JavaCompiler.java:870) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.main.JavaCompiler.compile(JavaCompiler.java:829) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.main.Main.compile(Main.java:439) ~[jdk.tools-1.7.jar:na] at com.sun.tools.javac.api.JavacTaskImpl.call(JavacTaskImpl.java:132) ~[jdk.tools-1.7.jar:na] at org.apache.drill.exec.compile.JDKClassCompiler.doCompile(JDKClassCompiler.java:82) ~[drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.compile.JDKClassCompiler.getByteCode(JDKClassCompiler.java:64) ~[drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.compile.AbstractClassCompiler.getClassByteCode(AbstractClassCompiler.java:55) ~[drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.compile.ClassCompilerSelector.getClassByteCode(ClassCompilerSelector.java:123) ~[drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.compile.QueryClassLoader.getClassByteCode(QueryClassLoader.java:90) ~[drill-java-exec-1.11.0.jar:1.11.0] at org.apache.drill.exec.compile.ClassTransformer.getImplementationClass(ClassTransformer.java:243) ~[drill-java-exec-1.11.0.jar:1.11.0] ... 42 common frames omitted On Thu, Feb 15, 2018 2:21 AM, Arjun kr [email protected] wrote: Hi Anup, You may try setting configuration option 'exec.java.compiler.exp_in_method_size' to lower value from default of 50 and run the query to see if it helps. Even lowering to a value of 1 doesn't help, the query details and stack trace may helpful for analysis as Khurram mentioned. alter session set `exec.java.compiler.exp_in_method_size` = <value>; Refer doc for more details on this configuration property: https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_configuration-2Doptions-2Dintroduction_&d=DwIFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=H5JEl9vb-mBIjic10QAbDD2vkUUKAxjO6wZO322RtdI&m=REIpiPGn0G5wyx7pQLeSqlcxzhPl7nyVZH0N5737hhw&s=XcZrMGyI88G8MAc8PO37lcr2KmhvvvsmRNCy4QdPz4M&e= Thanks, Arjun ________________________________ From: Khurram Faraaz <[email protected]> Sent: Thursday, February 15, 2018 12:55 AM To: [email protected] Subject: Re: Code too large Can you please share the exact query as is (without formatting) here. And the error that you see on Drill 1.11.0, so we can try and repro it. Thanks, Khurram ________________________________ From: Anup Tiwari <[email protected]> Sent: Wednesday, February 14, 2018 3:14:01 AM To: [email protected] Subject: Re: Code too large Hi Team, Do we have any updates on this? It is coming even in Drill 1.11.0 and i tried same query on hive, it is working perfectly. On Fri, Mar 25, 2016 2:30 AM, Jacques Nadeau [email protected] wrote: Looking at the trace it looks like Drill is correctly using the JDK compiler which is good. However, it looks like we're not breaking apart the expressions into submethods. @Aditya, since you worked on DRILL-1155, do you have any sense to why we're not subdividing the code in this situation? If I recall, we said we would only include 100 expressions per project method. Or are we hitting a limit of fields or some other limit? We test large projects here: https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apache_drill_blob_master_exec_java-2Dexec_src_test_java_org_apache_drill_exec_compile_TestLargeFileCompilation.java&d=DwIFAg&c=cskdkSMqhcnjZxdQVpwTXg&r=H5JEl9vb-mBIjic10QAbDD2vkUUKAxjO6wZO322RtdI&m=7Q3xDEBNDJpTxOv5CZjQjvw57jo8TxbjdDjkojonXp8&s=uiwsx3NwkuLNc6GpAJfcs0KPM0FQcNoAt4OD7TcMr8w&e= [https://urldefense.proofpoint.com/v2/url?u=https-3A__avatars3.githubusercontent.com_u_47359-3Fs-3D400-26v-3D4&d=DwIFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=H5JEl9vb-mBIjic10QAbDD2vkUUKAxjO6wZO322RtdI&m=REIpiPGn0G5wyx7pQLeSqlcxzhPl7nyVZH0N5737hhw&s=m2nE45FnsGWz8R-whMmIa7sOglHqfcFv_aL6I6Dw4yQ&e=]<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apache_drill_blob_master_exec_java-2Dexec_src_test_java_org_apache_drill_exec_compile_TestLargeFileCompilation.java&d=DwIFAg&c=cskdkSMqhcnjZxdQVpwTXg&r=H5JEl9vb-mBIjic10QAbDD2vkUUKAxjO6wZO322RtdI&m=7Q3xDEBNDJpTxOv5CZjQjvw57jo8TxbjdDjkojonXp8&s=uiwsx3NwkuLNc6GpAJfcs0KPM0FQcNoAt4OD7TcMr8w&e=> apache/drill<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apache_drill_blob_master_exec_java-2Dexec_src_test_java_org_apache_drill_exec_compile_TestLargeFileCompilation.java&d=DwIFAg&c=cskdkSMqhcnjZxdQVpwTXg&r=H5JEl9vb-mBIjic10QAbDD2vkUUKAxjO6wZO322RtdI&m=7Q3xDEBNDJpTxOv5CZjQjvw57jo8TxbjdDjkojonXp8&s=uiwsx3NwkuLNc6GpAJfcs0KPM0FQcNoAt4OD7TcMr8w&e=> urldefense.proofpoint.com drill - Mirror of Apache Drill -- Jacques Nadeau CTO and Co-Founder, Dremio On Thu, Mar 24, 2016 at 11:54 AM, Edmon Begoli <[email protected]> wrote: > Logs and queries attached. > > On Thu, Mar 24, 2016 at 2:22 PM, Edmon Begoli <[email protected]> wrote: > >> We are working on it. >> >> On Thu, Mar 24, 2016 at 2:07 PM, Ted Dunning <[email protected]> >> wrote: >> >>> Providing the stack traces and logs is a key first step in fixing this. >>> >>> >>> >>> On Thu, Mar 24, 2016 at 11:02 AM, Nirav Shah <[email protected]> >>> wrote: >>> >>> > I had the same issue but till date even in version 1.6 it's there. >>> > I checked about JDK also. >>> > >>> > it would be great if we can solve this issue. >>> > >>> > Regards, >>> > Nirav >>> > >>> > On Thu, Mar 24, 2016 at 11:06 PM, Edmon Begoli <[email protected]> >>> wrote: >>> > >>> > > Here is the query: >>> > > >>> > > CREATE TABLE >>> > > cms.joe.`ALL_IP_HS_FINAL` >>> > > AS >>> > > SELECT CASE WHEN columns[0] =3D '' THEN NULL ELSE CAST(columns[0] as >>> > > DOUBLE= >>> > > ) >>> > > END as `DSYSRTKY`, CASE WHEN columns[1] =3D '' THEN NULL ELSE >>> > > CAST(columns[1] as DOUBLE) END as `CLAIMNO`, NULLIF(columns[2],'') >>> as >>> > > `PROVIDER`, CASE WHEN columns[3] =3D '' THEN NULL ELSE >>> > TO_DATE(columns[3], >>> > > 'yyyyMMdd') END as `THRU_DT`, NULLIF(columns[4],'') as `RIC_CD`, >>> > > NULLIF(columns[5],'') as `CLM_TYPE`, NULLIF(columns[6],'') as >>> `QUERY_CD`, >>> > > NULLIF(columns[7],'') as `FAC_TYPE`, NULLIF(columns[8],'') as >>> `TYPESRVC`, >>> > > NULLIF(columns[9],'') as `FREQ_CD`, NULLIF(columns[10],'') as >>> `FI_NUM`, >>> > > NULLIF(columns[11],'') as `NOPAY_CD`, CASE WHEN columns[12] =3D '' >>> THEN >>> > > NUL= >>> > > L >>> > > ELSE CAST(columns[12] as DOUBLE) END as `PMT_AMT`, CASE WHEN >>> > columns[13] = >>> > > =3D >>> > > '' THEN NULL ELSE CAST(columns[13] as DOUBLE) END as `PRPAYAMT`, >>> > > NULLIF(columns[14],'') as `PRPAY_CD`, NULLIF(columns[15],'') as >>> > `ACTIONCD`, >>> > > NULLIF(columns[16],'') as `PRSTATE`, NULLIF(columns[17],'') as >>> > `ORGNPINM`, >>> > > NULLIF(columns[18],'') as `AT_UPIN`, NULLIF(columns[19],'') as >>> `AT_NPI`, >>> > > NULLIF(columns[20],'') as `OP_UPIN`, NULLIF(columns[21],'') as >>> `OP_NPI`, >>> > > NULLIF(columns[22],'') as `OT_UPIN`, NULLIF(columns[23],'') as >>> `OT_NPI`, >>> > > NULLIF(columns[24],'') as `MCOPDSW`, NULLIF(columns[25],'') as >>> `STUS_CD`, >>> > > NULLIF(columns[26],'') as `PPS_IND`, CASE WHEN columns[27] =3D '' >>> THEN >>> > NULL >>> > > ELSE CAST(columns[27] as DOUBLE) END as `TOT_CHRG`, CASE WHEN >>> > columns[28] >>> > > =3D '' THEN NULL ELSE TO_DATE(columns[28], 'yyyyMMdd') END as >>> > `ADMSN_DT`, >>> > > NULLIF(columns[29],'') as `TYPE_ADM`, >>> > > NULLIF(columns[30],'') as `SRC_ADMS`, NULLIF(columns[31],'') as >>> > `PTNTSTUS`, >>> > > CASE WHEN columns[32] =3D '' THEN NULL ELSE CAST(columns[32] as >>> DOUBLE) >>> > END >>> > > as `PER_DIEM`, CASE WHEN columns[33] =3D '' THEN NULL ELSE >>> > > CAST(columns[33= >>> > > ] >>> > > as DOUBLE) END as `DED_AMT`, CASE WHEN columns[34] =3D '' THEN NULL >>> ELSE >>> > > CAST(columns[34] as DOUBLE) END as `COIN_AMT`, CASE WHEN >>> columns[35] =3D >>> > > '= >>> > > ' >>> > > THEN NULL ELSE CAST(columns[35] as DOUBLE) END as `BLDDEDAM`, CASE >>> WHEN >>> > > columns[36] =3D '' THEN NULL ELSE CAST(columns[36] as DOUBLE) END as >>> > > `PCCHGAMT`, CASE WHEN columns[37] =3D '' THEN NULL ELSE >>> CAST(columns[37] >>> > as >>> > > DOUBLE) END as `NCCHGAMT`, >>> > > CASE WHEN columns[38] =3D '' THEN NULL ELSE CAST(columns[38] as >>> DOUBLE) >>> > END >>> > > as `PPS_CPTL`, CASE WHEN columns[39] =3D '' THEN NULL ELSE >>> > > CAST(columns[39= >>> > > ] >>> > > as DOUBLE) END as `CPTL_FSP`, CASE WHEN columns[40] =3D '' THEN NULL >>> > ELSE >>> > > CAST(columns[40] as DOUBLE) END as `CPTLOUTL`, CASE WHEN >>> columns[41] =3D >>> > > '= >>> > > ' >>> > > THEN NULL ELSE CAST(columns[41] as DOUBLE) END as `DISP_SHR`, CASE >>> WHEN >>> > > columns[42] =3D '' THEN NULL ELSE CAST(columns[42] as DOUBLE) END as >>> > > `IME_AMT`, CASE WHEN columns[43] =3D '' THEN NULL ELSE >>> CAST(columns[43] >>> > as >>> > > DOUBLE) END as `CPTL_EXP`, CASE WHEN columns[44] =3D '' THEN NULL >>> ELSE >>> > > CAST(columns[44] as DOUBLE) END as `HLDHRMLS`, >>> > > CASE WHEN columns[45] =3D '' THEN NULL ELSE CAST(columns[45] as >>> DOUBLE) >>> > END >>> > > as `DRGWTAMT`, CASE WHEN columns[46] =3D '' THEN NULL ELSE >>> > > CAST(columns[46= >>> > > ] >>> > > as DOUBLE) END as `UTIL_DAY`, CASE WHEN columns[47] =3D '' THEN NULL >>> > ELSE >>> > > CAST(columns[47] as DOUBLE) END as `COIN_DAY`, CASE WHEN >>> columns[48] =3D >>> > > '= >>> > > ' >>> > > THEN NULL ELSE CAST(columns[48] as DOUBLE) END as `LRD_USE`, CASE >>> WHEN >>> > > columns[49] =3D '' THEN NULL ELSE CAST(columns[49] as DOUBLE) END as >>> > > `NUTILDAY`, CASE WHEN columns[50] =3D '' THEN NULL ELSE >>> CAST(columns[50] >>> > as >>> > > DOUBLE) END as `BLDFRNSH`, CASE WHEN columns[51] =3D '' THEN NULL >>> ELSE >>> > > TO_DATE(columns[51], 'yyyyMMdd') END as `NCOVFROM`, CASE WHEN >>> > columns[52] >>> > > =3D '' THEN NULL ELSE TO_DATE(columns[52], 'yyyyMMdd') END as >>> > `NCOVTHRU`, >>> > > CASE WHEN columns[53] =3D '' THEN NULL ELSE TO_DATE(columns[53], >>> > > 'yyyyMMdd'= >>> > > ) >>> > > END as `EXHST_DT`, CASE WHEN columns[54] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[54], 'yyyyMMdd') END as `DSCHRGDT`, >>> > NULLIF(columns[55],'') >>> > > as `DRG_CD`, NULLIF(columns[56],'') as `OUTLR_CD`, CASE WHEN >>> columns[57] >>> > = >>> > > =3D >>> > > '' THEN NULL ELSE CAST(columns[57] as DOUBLE) END as `OUTLRPMT`, >>> > > NULLIF(columns[58],'') as `ADMTG_DGNS_CD`, NULLIF(columns[59],'') as >>> > > `ADMTG_DGNS_VRSN_CD`, NULLIF(columns[60],'') as `PRNCPAL_DGNS_CD`, >>> > > NULLIF(columns[61],'') as `PRNCPAL_DGNS_VRSN_CD`, >>> NULLIF(columns[62],'') >>> > as >>> > > `ICD_DGNS_CD1`, NULLIF(columns[63],'') as `ICD_DGNS_VRSN_CD1`, >>> > > NULLIF(columns[64],'') as `CLM_POA_IND_SW1`, NULLIF(columns[65],'') >>> as >>> > > `ICD_DGNS_CD2`, >>> > > NULLIF(columns[66],'') as `ICD_DGNS_VRSN_CD2`, >>> NULLIF(columns[67],'') as >>> > > `CLM_POA_IND_SW2`, NULLIF(columns[68],'') as `ICD_DGNS_CD3`, >>> > > NULLIF(columns[69],'') as `ICD_DGNS_VRSN_CD3`, >>> NULLIF(columns[70],'') as >>> > > `CLM_POA_IND_SW3`, NULLIF(columns[71],'') as `ICD_DGNS_CD4`, >>> > > NULLIF(columns[72],'') as `ICD_DGNS_VRSN_CD4`, >>> NULLIF(columns[73],'') as >>> > > `CLM_POA_IND_SW4`, NULLIF(columns[74],'') as `ICD_DGNS_CD5`, >>> > > NULLIF(columns[75],'') as `ICD_DGNS_VRSN_CD5`, >>> NULLIF(columns[76],'') as >>> > > `CLM_POA_IND_SW5`, NULLIF(columns[77],'') as `ICD_DGNS_CD6`, >>> > > NULLIF(columns[78],'') as `ICD_DGNS_VRSN_CD6`, >>> NULLIF(columns[79],'') as >>> > > `CLM_POA_IND_SW6`, NULLIF(columns[80],'') as `ICD_DGNS_CD7`, >>> > > NULLIF(columns[81],'') as `ICD_DGNS_VRSN_CD7`, >>> > > NULLIF(columns[82],'') as `CLM_POA_IND_SW7`, NULLIF(columns[83],'') >>> as >>> > > `ICD_DGNS_CD8`, NULLIF(columns[84],'') as `ICD_DGNS_VRSN_CD8`, >>> > > NULLIF(columns[85],'') as `CLM_POA_IND_SW8`, NULLIF(columns[86],'') >>> as >>> > > `ICD_DGNS_CD9`, NULLIF(columns[87],'') as `ICD_DGNS_VRSN_CD9`, >>> > > NULLIF(columns[88],'') as `CLM_POA_IND_SW9`, NULLIF(columns[89],'') >>> as >>> > > `ICD_DGNS_CD10`, NULLIF(columns[90],'') as `ICD_DGNS_VRSN_CD10`, >>> > > NULLIF(columns[91],'') as `CLM_POA_IND_SW10`, NULLIF(columns[92],'') >>> as >>> > > `ICD_DGNS_CD11`, NULLIF(columns[93],'') as `ICD_DGNS_VRSN_CD11`, >>> > > NULLIF(columns[94],'') as `CLM_POA_IND_SW11`, NULLIF(columns[95],'') >>> as >>> > > `ICD_DGNS_CD12`, >>> > > NULLIF(columns[96],'') as `ICD_DGNS_VRSN_CD12`, >>> NULLIF(columns[97],'') as >>> > > `CLM_POA_IND_SW12`, NULLIF(columns[98],'') as `ICD_DGNS_CD13`, >>> > > NULLIF(columns[99],'') as `ICD_DGNS_VRSN_CD13`, >>> NULLIF(columns[100],'') >>> > as >>> > > `CLM_POA_IND_SW13`, NULLIF(columns[101],'') as `ICD_DGNS_CD14`, >>> > > NULLIF(columns[102],'') as `ICD_DGNS_VRSN_CD14`, >>> NULLIF(columns[103],'') >>> > as >>> > > `CLM_POA_IND_SW14`, NULLIF(columns[104],'') as `ICD_DGNS_CD15`, >>> > > NULLIF(columns[105],'') as `ICD_DGNS_VRSN_CD15`, >>> > > NULLIF(columns[106],'') as `CLM_POA_IND_SW15`, >>> NULLIF(columns[107],'') as >>> > > `ICD_DGNS_CD16`, NULLIF(columns[108],'') as `ICD_DGNS_VRSN_CD16`, >>> > > NULLIF(columns[109],'') as `CLM_POA_IND_SW16`, >>> NULLIF(columns[110],'') as >>> > > `ICD_DGNS_CD17`, NULLIF(columns[111],'') as `ICD_DGNS_VRSN_CD17`, >>> > > NULLIF(columns[112],'') as `CLM_POA_IND_SW17`, >>> NULLIF(columns[113],'') as >>> > > `ICD_DGNS_CD18`, NULLIF(columns[114],'') as `ICD_DGNS_VRSN_CD18`, >>> > > NULLIF(columns[115],'') as `CLM_POA_IND_SW18`, >>> NULLIF(columns[116],'') as >>> > > `ICD_DGNS_CD19`, NULLIF(columns[117],'') as `ICD_DGNS_VRSN_CD19`, >>> > > NULLIF(columns[118],'') as `CLM_POA_IND_SW19`, >>> NULLIF(columns[119],'') as >>> > > `ICD_DGNS_CD20`, NULLIF(columns[120],'') as `ICD_DGNS_VRSN_CD20`, >>> > > NULLIF(columns[121],'') as `CLM_POA_IND_SW20`, >>> NULLIF(columns[122],'') as >>> > > `ICD_DGNS_CD21`, >>> > > NULLIF(columns[123],'') as `ICD_DGNS_VRSN_CD21`, >>> NULLIF(columns[124],'') >>> > as >>> > > `CLM_POA_IND_SW21`, NULLIF(columns[125],'') as `ICD_DGNS_CD22`, >>> > > NULLIF(columns[126],'') as `ICD_DGNS_VRSN_CD22`, >>> NULLIF(columns[127],'') >>> > as >>> > > `CLM_POA_IND_SW22`, NULLIF(columns[128],'') as `ICD_DGNS_CD23`, >>> > > NULLIF(columns[129],'') as `ICD_DGNS_VRSN_CD23`, >>> NULLIF(columns[130],'') >>> > as >>> > > `CLM_POA_IND_SW23`, NULLIF(columns[131],'') as `ICD_DGNS_CD24`, >>> > > NULLIF(columns[132],'') as `ICD_DGNS_VRSN_CD24`, >>> NULLIF(columns[133],'') >>> > as >>> > > `CLM_POA_IND_SW24`, >>> > > NULLIF(columns[134],'') as `ICD_DGNS_CD25`, NULLIF(columns[135],'') >>> as >>> > > `ICD_DGNS_VRSN_CD25`, NULLIF(columns[136],'') as `CLM_POA_IND_SW25`, >>> > > NULLIF(columns[137],'') as `FST_DGNS_E_CD`, NULLIF(columns[138],'') >>> as >>> > > `FST_DGNS_E_VRSN_CD`, NULLIF(columns[139],'') as `ICD_DGNS_E_CD1`, >>> > > NULLIF(columns[140],'') as `ICD_DGNS_E_VRSN_CD1`, >>> NULLIF(columns[141],'') >>> > > as `CLM_E_POA_IND_SW1`, NULLIF(columns[142],'') as `ICD_DGNS_E_CD2`, >>> > > NULLIF(columns[143],'') as `ICD_DGNS_E_VRSN_CD2`, >>> NULLIF(columns[144],'') >>> > > as `CLM_E_POA_IND_SW2`, NULLIF(columns[145],'') as `ICD_DGNS_E_CD3`, >>> > > NULLIF(columns[146],'') as `ICD_DGNS_E_VRSN_CD3`, >>> NULLIF(columns[147],'') >>> > > as `CLM_E_POA_IND_SW3`, NULLIF(columns[148],'') as `ICD_DGNS_E_CD4`, >>> > > NULLIF(columns[149],'') as `ICD_DGNS_E_VRSN_CD4`, >>> NULLIF(columns[150],'') >>> > > as `CLM_E_POA_IND_SW4`, >>> > > NULLIF(columns[151],'') as `ICD_DGNS_E_CD5`, NULLIF(columns[152],'') >>> as >>> > > `ICD_DGNS_E_VRSN_CD5`, NULLIF(columns[153],'') as >>> `CLM_E_POA_IND_SW5`, >>> > > NULLIF(columns[154],'') as `ICD_DGNS_E_CD6`, NULLIF(columns[155],'') >>> as >>> > > `ICD_DGNS_E_VRSN_CD6`, NULLIF(columns[156],'') as >>> `CLM_E_POA_IND_SW6`, >>> > > NULLIF(columns[157],'') as `ICD_DGNS_E_CD7`, NULLIF(columns[158],'') >>> as >>> > > `ICD_DGNS_E_VRSN_CD7`, NULLIF(columns[159],'') as >>> `CLM_E_POA_IND_SW7`, >>> > > NULLIF(columns[160],'') as `ICD_DGNS_E_CD8`, NULLIF(columns[161],'') >>> as >>> > > `ICD_DGNS_E_VRSN_CD8`, NULLIF(columns[162],'') as >>> `CLM_E_POA_IND_SW8`, >>> > > NULLIF(columns[163],'') as `ICD_DGNS_E_CD9`, >>> > > NULLIF(columns[164],'') as `ICD_DGNS_E_VRSN_CD9`, >>> NULLIF(columns[165],'') >>> > > as `CLM_E_POA_IND_SW9`, NULLIF(columns[166],'') as `ICD_DGNS_E_CD10`, >>> > > NULLIF(columns[167],'') as `ICD_DGNS_E_VRSN_CD10`, >>> > NULLIF(columns[168],'') >>> > > as `CLM_E_POA_IND_SW10`, NULLIF(columns[169],'') as >>> `ICD_DGNS_E_CD11`, >>> > > NULLIF(columns[170],'') as `ICD_DGNS_E_VRSN_CD11`, >>> > NULLIF(columns[171],'') >>> > > as `CLM_E_POA_IND_SW11`, NULLIF(columns[172],'') as >>> `ICD_DGNS_E_CD12`, >>> > > NULLIF(columns[173],'') as `ICD_DGNS_E_VRSN_CD12`, >>> > NULLIF(columns[174],'') >>> > > as `CLM_E_POA_IND_SW12`, NULLIF(columns[175],'') as `ICD_PRCDR_CD1`, >>> > > NULLIF(columns[176],'') as `ICD_PRCDR_VRSN_CD1`, >>> > > CASE WHEN columns[177] =3D '' THEN NULL ELSE TO_DATE(columns[177], >>> > > 'yyyyMMdd') END as `PRCDR_DT1`, NULLIF(columns[178],'') as >>> > > `ICD_PRCDR_CD2`, NULLIF(columns[179],'') as `ICD_PRCDR_VRSN_CD2`, >>> CASE >>> > WHEN >>> > > columns[180] =3D '' THEN NULL ELSE TO_DATE(columns[180], 'yyyyMMdd') >>> END >>> > > a= >>> > > s >>> > > `PRCDR_DT2`, NULLIF(columns[181],'') as `ICD_PRCDR_CD3`, >>> > > NULLIF(columns[182],'') as `ICD_PRCDR_VRSN_CD3`, CASE WHEN >>> columns[183] >>> > =3D >>> > > '' THEN NULL ELSE TO_DATE(columns[183], 'yyyyMMdd') END as >>> `PRCDR_DT3`, >>> > > NULLIF(columns[184],'') as `ICD_PRCDR_CD4`, NULLIF(columns[185],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD4`, CASE WHEN columns[186] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[186], 'yyyyMMdd') END as `PRCDR_DT4`, >>> > > NULLIF(columns[187],'') as `ICD_PRCDR_CD5`, >>> > > NULLIF(columns[188],'') as `ICD_PRCDR_VRSN_CD5`, CASE WHEN >>> columns[189] >>> > =3D >>> > > '' THEN NULL ELSE TO_DATE(columns[189], 'yyyyMMdd') END as >>> `PRCDR_DT5`, >>> > > NULLIF(columns[190],'') as `ICD_PRCDR_CD6`, NULLIF(columns[191],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD6`, CASE WHEN columns[192] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[192], 'yyyyMMdd') END as `PRCDR_DT6`, >>> > > NULLIF(columns[193],'') as `ICD_PRCDR_CD7`, NULLIF(columns[194],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD7`, CASE WHEN columns[195] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[195], 'yyyyMMdd') END as `PRCDR_DT7`, >>> > > NULLIF(columns[196],'') as `ICD_PRCDR_CD8`, NULLIF(columns[197],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD8`, CASE WHEN columns[198] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[198], 'yyyyMMdd') END as `PRCDR_DT8`, >>> > > NULLIF(columns[199],'') as `ICD_PRCDR_CD9`, NULLIF(columns[200],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD9`, CASE WHEN columns[201] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[201], 'yyyyMMdd') END as `PRCDR_DT9`, >>> > > NULLIF(columns[202],'') as `ICD_PRCDR_CD10`, NULLIF(columns[203],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD10`, CASE WHEN columns[204] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[204], 'yyyyMMdd') END as `PRCDR_DT10`, >>> > > NULLIF(columns[205],'') as `ICD_PRCDR_CD11`, NULLIF(columns[206],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD11`, CASE WHEN columns[207] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[207], 'yyyyMMdd') END as `PRCDR_DT11`, >>> > > NULLIF(columns[208],'') as `ICD_PRCDR_CD12`, >>> > > NULLIF(columns[209],'') as `ICD_PRCDR_VRSN_CD12`, CASE WHEN >>> columns[210] >>> > = >>> > > =3D >>> > > '' THEN NULL ELSE TO_DATE(columns[210], 'yyyyMMdd') END as >>> `PRCDR_DT12`, >>> > > NULLIF(columns[211],'') as `ICD_PRCDR_CD13`, NULLIF(columns[212],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD13`, CASE WHEN columns[213] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[213], 'yyyyMMdd') END as `PRCDR_DT13`, >>> > > NULLIF(columns[214],'') as `ICD_PRCDR_CD14`, NULLIF(columns[215],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD14`, CASE WHEN columns[216] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[216], 'yyyyMMdd') END as `PRCDR_DT14`, >>> > > NULLIF(columns[217],'') as `ICD_PRCDR_CD15`, NULLIF(columns[218],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD15`, CASE WHEN columns[219] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[219], 'yyyyMMdd') END as `PRCDR_DT15`, >>> > > NULLIF(columns[220],'') as `ICD_PRCDR_CD16`, NULLIF(columns[221],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD16`, CASE WHEN columns[222] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[222], 'yyyyMMdd') END as `PRCDR_DT16`, >>> > > NULLIF(columns[223],'') as `ICD_PRCDR_CD17`, NULLIF(columns[224],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD17`, CASE WHEN columns[225] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[225], 'yyyyMMdd') END as `PRCDR_DT17`, >>> > > NULLIF(columns[226],'') as `ICD_PRCDR_CD18`, NULLIF(columns[227],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD18`, CASE WHEN columns[228] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[228], 'yyyyMMdd') END as `PRCDR_DT18`, >>> > > NULLIF(columns[229],'') as `ICD_PRCDR_CD19`, NULLIF(columns[230],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD19`, CASE WHEN columns[231] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[231], 'yyyyMMdd') END as `PRCDR_DT19`, >>> > > NULLIF(columns[232],'') as `ICD_PRCDR_CD20`, >>> > > NULLIF(columns[233],'') as `ICD_PRCDR_VRSN_CD20`, CASE WHEN >>> columns[234] >>> > = >>> > > =3D >>> > > '' THEN NULL ELSE TO_DATE(columns[234], 'yyyyMMdd') END as >>> `PRCDR_DT20`, >>> > > NULLIF(columns[235],'') as `ICD_PRCDR_CD21`, NULLIF(columns[236],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD21`, CASE WHEN columns[237] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[237], 'yyyyMMdd') END as `PRCDR_DT21`, >>> > > NULLIF(columns[238],'') as `ICD_PRCDR_CD22`, NULLIF(columns[239],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD22`, CASE WHEN columns[240] =3D '' THEN NULL ELSE >>> > > TO_DATE(columns[240], 'yyyyMMdd') END as `PRCDR_DT22`, >>> > > NULLIF(columns[241],'') as `ICD_PRCDR_CD23`, NULLIF(columns[242],'') >>> as >>> > > `ICD_PRCDR_VRSN_CD23`, >>> > > CASE WHEN columns[243] =3D '' THEN NULL ELSE TO_DATE(columns[243], >>> > > 'yyyyMMdd') END as `PRCDR_DT23`, NULLIF(columns[244],'') as >>> > > `ICD_PRCDR_CD24`, NULLIF(columns[245],'') as `ICD_PRCDR_VRSN_CD24`, >>> CASE >>> > > WHEN columns[246] =3D '' THEN NULL ELSE TO_DATE(columns[246], >>> 'yyyyMMdd') >>> > > E= >>> > > ND >>> > > as `PRCDR_DT24`, NULLIF(columns[247],'') as `ICD_PRCDR_CD25`, >>> > > NULLIF(columns[248],'') as `ICD_PRCDR_VRSN_CD25`, CASE WHEN >>> columns[249] >>> > = >>> > > =3D >>> > > '' THEN NULL ELSE TO_DATE(columns[249], 'yyyyMMdd') END as >>> `PRCDR_DT25`, >>> > > CASE WHEN columns[250] =3D '' THEN NULL ELSE CAST(columns[250] as >>> DOUBLE) >>> > > E= >>> > > ND >>> > > as `DOB_DT`, NULLIF(columns[251],'') as `GNDR_CD`, >>> > NULLIF(columns[252],'') >>> > > as `RACE_CD`, NULLIF(columns[253],'') as `CNTY_CD`, >>> > NULLIF(columns[254],'') >>> > > as `STATE_CD`, >>> > > NULLIF(columns[255],'') as `CWF_BENE_MDCR_STUS_CD` >>> > > FROM cms.`blair`.`ALL_IP_OS.csv` >>> > > WHERE columns[58] =3D '70583' OR columns[62] =3D '70583' OR >>> columns[66] >>> > =3D >>> > > '70583' ; >>> > > >>> > > >>> > > On Thu, Mar 24, 2016 at 9:22 AM, Jacques Nadeau <[email protected]> >>> > > wrote: >>> > > >>> > > > It would also good to get the full stack trace. Do you have jdk or >>> only >>> > > Joe >>> > > > on these machines? >>> > > > On Mar 24, 2016 5:27 AM, "Edmon Begoli" <[email protected]> wrote: >>> > > > >>> > > > > Does anyone know what might be causing this exception: >>> > > > > >>> > > > > *Error: SYSTEM ERROR: CompileException: File >>> > > > > >>> > > >>> 'org.apache.drill.exec.compile.DrillJavaFileObject[ProjectorGen10.java]', >>> > > > > Line 7275, Column 17: ProjectorGen10.java:7275: error: code too >>> > large* >>> > > > > >>> > > > > * public void doEval(int inIndex, int outIndex)* >>> > > > > >>> > > > > * ^ (compiler.err.limit.code)* >>> > > > > >>> > > > > >>> > > > > *Fragment 0:0* >>> > > > > >>> > > > > >>> > > > > *[Error Id: 687009ec-4d55-443a-9066-218fb3ac8adb on >>> localhost:31010] >>> > > > > (state=,code=0)* >>> > > > > >>> > > > >>> > > >>> > >>> >> >> > Regards, Anup Tiwari Regards, Anup Tiwari Regards, Anup Tiwari Sent with Mixmax
