public void executeHQL(String[] hqls) throws CommandNeedRetryException, IOException { for (String sql : hqls) executeHQL(sql); }
@Override protected ExecuteResult doWork(ExecutableContext context) throws ExecuteException { try { Map<String, String> configMap = getConfiguration(); HiveClient hiveClient = new HiveClient(configMap); for (String hql: getHqls()) { hiveClient.executeHQL(hql); } return new ExecuteResult(ExecuteResult.State.SUCCEED); } catch (Exception e) { logger.error("error run hive query:" + getHqls(), e); return new ExecuteResult(ExecuteResult.State.ERROR, e.getLocalizedMessage()); } }
hiveClient.executeHQL("CREATE DATABASE IF NOT EXISTS EDW"); hiveClient.executeHQL(generateCreateTableHql(metaMgr.getTableDesc(TABLE_CAL_DT.toUpperCase()))); hiveClient.executeHQL(generateCreateTableHql(metaMgr.getTableDesc(TABLE_CATEGORY_GROUPINGS.toUpperCase()))); hiveClient.executeHQL(generateCreateTableHql(metaMgr.getTableDesc(TABLE_KYLIN_FACT.toUpperCase()))); hiveClient.executeHQL(generateCreateTableHql(metaMgr.getTableDesc(TABLE_SELLER_TYPE_DIM.toUpperCase()))); hiveClient.executeHQL(generateCreateTableHql(metaMgr.getTableDesc(TABLE_SITES.toUpperCase()))); hiveClient.executeHQL(generateLoadDataHql(TABLE_CAL_DT, tableFileDir)); hiveClient.executeHQL(generateLoadDataHql(TABLE_CATEGORY_GROUPINGS, tableFileDir)); hiveClient.executeHQL(generateLoadDataHql(TABLE_KYLIN_FACT, tableFileDir)); hiveClient.executeHQL(generateLoadDataHql(TABLE_SELLER_TYPE_DIM, tableFileDir)); hiveClient.executeHQL(generateLoadDataHql(TABLE_SITES, tableFileDir));
public void executeHQL(String[] hqls) throws CommandNeedRetryException, IOException { for (String sql : hqls) executeHQL(sql); }
@Override protected ExecuteResult doWork(ExecutableContext context) throws ExecuteException { try { Map<String, String> configMap = getConfiguration(); HiveClient hiveClient = new HiveClient(configMap); for (String hql : getHqls()) { hiveClient.executeHQL(hql); } return new ExecuteResult(ExecuteResult.State.SUCCEED); } catch (Exception e) { logger.error("error run hive query:" + getHqls(), e); return new ExecuteResult(ExecuteResult.State.ERROR, e.getLocalizedMessage()); } }