Page History

...

LOAD DATA LOCAL INFILE 'c:\\MSR\\Lambda\\2017-08-01_event-export.csv' REPLACE INTO TABLE reports.infinera_dna_outages FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 10 LINES;

** Richard to see if we can run this directly on the test msr box

** Pay attention to the year and the month value in the above statement. The month value is the actual month you are preparing the report. E.g. the above example will contain the data for July and NOT for August

...