Hi all! Looks like the above issue is connected to much expressions in the generated code. I believe it can be resolved by reducing the value for "exec.java.compiler.exp_in_method_size" option on the session or system level [1]. If it is not working, it means that logic is not implemented for operators which are used for yours query. And it will be good to place the Jira to implement that.
Also you can try to use Janino compiler "exec.java_compiler" = "JANINO" [1]. [1] https://drill.apache.org/docs/configuration-options-introduction/#system-options Kind regards Vitalii On Wed, Feb 21, 2018 at 1:21 AM, Khurram Faraaz <[email protected]> wrote: > 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=7Q3xDEBNDJpTxOv5CZjQjvw57jo8Tx > bjdDjkojonXp8&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 >
