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 <[email protected]> Sent: Thursday, February 15, 2018 12:55 AM To: [email protected] Subject: Re: Code too large Can you please share the exact query as is (without formatting) here. And the error that you see on Drill 1.11.0, so we can try and repro it. Thanks, Khurram ________________________________ From: Anup Tiwari <[email protected]> Sent: Wednesday, February 14, 2018 3:14:01 AM To: [email protected] Subject: Re: Code too large Hi Team, Do we have any updates on this? It is coming even in Drill 1.11.0 and i tried same query on hive, it is working perfectly. On Fri, Mar 25, 2016 2:30 AM, Jacques Nadeau [email protected] wrote: Looking at the trace it looks like Drill is correctly using the JDK compiler which is good. However, it looks like we're not breaking apart the expressions into submethods. @Aditya, since you worked on DRILL-1155, do you have any sense to why we're not subdividing the code in this situation? If I recall, we said we would only include 100 expressions per project method. Or are we hitting a limit of fields or some other limit? We test large projects here: https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apache_drill_blob_master_exec_java-2Dexec_src_test_java_org_apache_drill_exec_compile_TestLargeFileCompilation.java&d=DwIFAg&c=cskdkSMqhcnjZxdQVpwTXg&r=H5JEl9vb-mBIjic10QAbDD2vkUUKAxjO6wZO322RtdI&m=7Q3xDEBNDJpTxOv5CZjQjvw57jo8TxbjdDjkojonXp8&s=uiwsx3NwkuLNc6GpAJfcs0KPM0FQcNoAt4OD7TcMr8w&e= [https://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 <[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
