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)* > > > > > > > > > > > > > > >