Hi Khurram/Arjun,
Anyone got time to look into it?
On Fri, Feb 16, 2018 4:53 PM, Anup Tiwari anup.tiw...@games24x7.com 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 arjun...@outlook.com 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://drill.apache.org/docs/configuration-options-introduction/
Thanks,
Arjun
________________________________
From: Khurram Faraaz <kfar...@mapr.com>
Sent: Thursday, February 15, 2018 12:55 AM
To: user@drill.apache.org
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 <anup.tiw...@games24x7.com>
Sent: Wednesday, February 14, 2018 3:14:01 AM
To: user@drill.apache.org
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 jacq...@dremio.com 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://avatars3.githubusercontent.com/u/47359?s=400&v=4]<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 <ebeg...@gmail.com> wrote:
> Logs and queries attached.
>
> On Thu, Mar 24, 2016 at 2:22 PM, Edmon Begoli <ebeg...@gmail.com> wrote:
>
>> We are working on it.
>>
>> On Thu, Mar 24, 2016 at 2:07 PM, Ted Dunning <ted.dunn...@gmail.com>
>> 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 <nirav.s...@games24x7.com>
>>> 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 <ebeg...@gmail.com>
>>> 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 <jacq...@dremio.com>
>>> > > 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" <ebeg...@gmail.com> 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
