Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone i am keep getting this error
i have free space of about 16 GB on the disc that is running the following script:
//שע מטבע לתאריך החשבונית ולמטבע השורה
Left JOIN (INV_SALES_TEMP)
LOAD
CUR_CURRENCY AS INV_CURRENCY,
CUR_EXCHANGE
Resident CURRENCIES;
LEFT JOIN (INV_SALES_TEMP)
LOAD
Date ( CURREG_CURDATE/60/24+32143,'DD/MM/YYYY') AS INV_IVDATE,
CURREG_CURRENCY AS INV_CURRENCY,
CURREG_EXCHANGE
Resident CURREG;
left JOIN (INV_SALES_TEMP)
LOAD /*CUR_CURRENCY AS INV_CURRENCY ,*/
CUR_EXCHANGE AS CUR_EXCHANGE2
Resident CURRENCIES Where CUR_CURRENCY = -2;
LEFT JOIN (INV_SALES_TEMP)
LOAD Date ( CURREG_CURDATE/60/24+32143,'DD/MM/YYYY') AS INV_IVDATE ,
/* CURREG_CURRENCY AS INV_CURRENCY,*/
CURREG_EXCHANGE AS CURREG_EXCHANGE2
Resident CURREG Where CURREG_CURRENCY = -2;
Left JOIN (INV_SALES_TEMP)
LOAD /* CUR_CURRENCY AS INV_CURRENCY ,*/
CUR_EXCHANGE AS CUR_EXCHANGE3
Resident CURRENCIES;
left JOIN (INV_SALES_TEMP)
LOAD
Date ( CURREG_CURDATE/60/24+32143,'DD/MM/YYYY') AS INV_IVDATE ,
/* CURREG_CURRENCY AS INV_CURRENCY ,*/
CURREG_EXCHANGE AS CURREG_EXCHANGE3
Resident CURREG;
// // LINE 183 IN THE SALES CHART//
LEFT JOIN (INV_SALES_TEMP)
LOAD
ACC_COSTFLAG,
DATE((NUM(MAX(ACC_COSTDATE)))/60/24+32143,'DD/MM/YYYY') AS MAXACC_COSTDATE
RESIDENT ACCDATES WHERE ACC_COSTDATE<>0
GROUP BY ACC_COSTFLAG;
DROP TABLE ACCDATES;
check with the datamodel...if the data is cmg or not?
cmg?