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

Reply via email to