python读取hive数据库mapreduce_MapReduce+hive数据操作-------第一天

packageData;importjava.io.BufferedReader;importjava.io.BufferedWriter;importjava.io.File;importjava.io.FileNotFoundException;importjava.io.FileOutputStream;importjava.io.FileReader;importjava.io.IOException;importjava.io.OutputStreamWriter;importjava.io.UnsupportedEncodingException;importjava.io.Writer;public classData {public static void main(String[] args) throwsFileNotFoundException, UnsupportedEncodingException {

FileReader read= new FileReader("result.txt");

BufferedReader br= newBufferedReader(read);

Writer writer= null;

File outFile= new File("result2.txt");

writer= new OutputStreamWriter(new FileOutputStream(outFile),"utf-8");

BufferedWriter bw= newBufferedWriter(writer);

String row;

String[] data=new String[6];int hang=1;try{while((row = br.readLine())!=null){

data=change(row);

data=chage(data);for(int i=0;i

System.out.print(data[i]+"\t");

}

System.out.println();

row=data[0]+","+data[1]+","+data[2]+","+data[3]+","+data[4]+","+data[5];

bw.write(row+ "\r\n");//i++;

}

}catch(IOException e) {//TODO Auto-generated catch block

e.printStackTrace();

}

}private staticString[] chage(String[] data) {/** for(int i=0;i

String[] time=new String[7];int j=0;int k=0;for(int i=0;i

time[k]=data[1].substring(j,i);

j=i+1;

k++;

}

}

time[k]=data[1].substring(j, data[1].length());switch(time[1]) { case "Jan":time[1]="01";break; case

"Feb":time[1]="02";break; case "Mar":time[1]="03";break; case

"Apr":time[1]="04";break; case "May":time[1]="05";break; case

"Jun":time[1]="06";break; case "Jul":time[1]="07";break; case

"Aug":time[1]="08";break; case "Sep":time[1]="09";break; case

"Oct":time[1]="10";break; case "Nov":time[1]="11";break; case

"Dec":time[1]="12";break; }

data[1]=time[2]+"-"+time[1]+"-"+time[0]+" "+time[3]+":"+time[4]+":"+time[5];

data[3]=data[3].substring(0, data[3].length()-1);returndata;

}private staticString [] change(String row) {char [] str1=row.toCharArray();

String [] data=new String [6];int j=0;int k=0;for(int i=0;i

data[k]=row.substring(j, i);

j=i+1;

k++;

}

}

data[k]=row.substring(j, str1.length);returndata;

}

}