I am trying to load csv file: Its working perfectly fine but I cannot see the full data:
// Read File
String fileLocation = "/usr/local/tomcat/webapps/analytics-project/docs/examples/OSHA-data/Mapping_sheet_long.csv";
BufferedReader reader;
reader = new BufferedReader(new InputStreamReader(new FileInputStream(fileLocation)));
List<String[]> rows = new ArrayList<String[]>();
String line = null;
int numRows = 0;
while((line = reader.readLine()) != null){
numRows = numRows + 1;
rows.add(line.split(",", -1));
}
// Insert rows
StringSerializer stringSerializer = StringSerializer.get();
int count = 0;
int len = numRows;
while(len-- > 0){
String key = rows.get(count)[0];
System.out.println(key);
Mutator<String> mutator = HFactory.createMutator(myKeyspace, stringSerializer);
mutator.addInsertion(key, "oshachemicals", HFactory.createStringColumn("chemical_name", rows.get(count)[1]));
mutator.addInsertion(key, "oshachemicals", HFactory.createStringColumn("chemical_code", rows.get(count)[2]));
MutationResult mr = mutator.execute();
count = count + 1;
}
Dataset is like:
11111111, lead, 213
11111112, chromium, P213 ....
I can see few datas using list command but not all data is available
