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://github.com/apache/drill/blob/master/exec/java-exec/src/test/java/org/apache/drill/exec/compile/TestLargeFileCompilation.java




--

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

Reply via email to