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