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= -- 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
