hive动态分区shell_一段读取 excel 自动生成 hive load shell 脚本的代码

自动化是程序员的天性，这里是一段小代码自动化手工重复的工作。

package collect;

import com.google.common.base.Charsets;

import com.google.common.base.Joiner;

import com.google.common.io.Files;

import com.google.common.io.LineProcessor;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.ss.usermodel.WorkbookFactory;

import java.io.File;

import java.io.FilenameFilter;

import java.io.IOException;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;

import java.util.regex.Matcher;

import java.util.regex.Pattern;

/**

* All rights Reserved, Designed By Migu.cn

*

* @Description: 读取表 Excel 信息，自动生成动态分区脚本

* @Author: Yao

* @Date: 2018/5/8 9:27

* @Version: v0.1

*/

public class AutoGenSh {

public static final String template_file = "dynamicLoadTemplate.txt";

public static final String interface_name = "%interface_name%";

public static final String date = "%date%";

public static final String table_name = "%ods_table_name%";

public static final String file_name = "%file_name%";

public static final String tmpTableName = "%tmp_table_name%";

public static final String start_index = "%startIndex%"