Java tutorial
/** * Licensed to the Apache Software Foundation (ASF) under one * or more contributor license agreements. See the NOTICE file * distributed with this work for additional information * regarding copyright ownership. The ASF licenses this file * to you under the Apache License, Version 2.0 (the * "License"); you may not use this file except in compliance * with the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package org.apache.hive.hplsql; import java.net.URL; import java.util.HashMap; import org.apache.hadoop.conf.Configuration; import org.apache.hive.hplsql.Exec.OnError; /** * HPL/SQL run-time configuration */ public class Conf extends Configuration { public static final String SITE_XML = "hplsql-site.xml"; public static final String DOT_HPLSQLRC = ".hplsqlrc"; public static final String HPLSQLRC = "hplsqlrc"; public static final String HPLSQL_LOCALS_SQL = "hplsql_locals.sql"; public static final String CONN_CONVERT = "hplsql.conn.convert."; public static final String CONN_DEFAULT = "hplsql.conn.default"; public static final String DUAL_TABLE = "hplsql.dual.table"; public static final String INSERT_VALUES = "hplsql.insert.values"; public static final String ONERROR = "hplsql.onerror"; public static final String TEMP_TABLES = "hplsql.temp.tables"; public static final String TEMP_TABLES_SCHEMA = "hplsql.temp.tables.schema"; public static final String TEMP_TABLES_LOCATION = "hplsql.temp.tables.location"; public static final String TRUE = "true"; public static final String FALSE = "false"; public static final String YES = "yes"; public static final String NO = "no"; public enum InsertValues { NATIVE, SELECT }; public enum TempTables { NATIVE, MANAGED }; public String defaultConnection; OnError onError = OnError.EXCEPTION; InsertValues insertValues = InsertValues.NATIVE; TempTables tempTables = TempTables.NATIVE; String dualTable = null; String tempTablesSchema = ""; String tempTablesLocation = "/tmp/hplsql"; HashMap<String, Boolean> connConvert = new HashMap<String, Boolean>(); /** * Set an option */ public void setOption(String key, String value) { if (key.startsWith(CONN_CONVERT)) { setConnectionConvert(key.substring(19), value); } else if (key.compareToIgnoreCase(CONN_DEFAULT) == 0) { defaultConnection = value; } else if (key.compareToIgnoreCase(DUAL_TABLE) == 0) { dualTable = value; } else if (key.compareToIgnoreCase(INSERT_VALUES) == 0) { setInsertValues(value); } else if (key.compareToIgnoreCase(ONERROR) == 0) { setOnError(value); } else if (key.compareToIgnoreCase(TEMP_TABLES) == 0) { setTempTables(value); } else if (key.compareToIgnoreCase(TEMP_TABLES_SCHEMA) == 0) { tempTablesSchema = value; } else if (key.compareToIgnoreCase(TEMP_TABLES_LOCATION) == 0) { tempTablesLocation = value; } } /** * Set hplsql.insert.values option */ private void setInsertValues(String value) { if (value.compareToIgnoreCase("NATIVE") == 0) { insertValues = InsertValues.NATIVE; } else if (value.compareToIgnoreCase("SELECT") == 0) { insertValues = InsertValues.SELECT; } } /** * Set hplsql.temp.tables option */ private void setTempTables(String value) { if (value.compareToIgnoreCase("NATIVE") == 0) { tempTables = TempTables.NATIVE; } else if (value.compareToIgnoreCase("MANAGED") == 0) { tempTables = TempTables.MANAGED; } } /** * Set error handling approach */ private void setOnError(String value) { if (value.compareToIgnoreCase("EXCEPTION") == 0) { onError = OnError.EXCEPTION; } else if (value.compareToIgnoreCase("SETERROR") == 0) { onError = OnError.SETERROR; } if (value.compareToIgnoreCase("STOP") == 0) { onError = OnError.STOP; } } /** * Set whether convert or not SQL for the specified connection profile */ void setConnectionConvert(String name, String value) { boolean convert = false; if (value.compareToIgnoreCase(TRUE) == 0 || value.compareToIgnoreCase(YES) == 0) { convert = true; } connConvert.put(name, convert); } /** * Get whether convert or not SQL for the specified connection profile */ boolean getConnectionConvert(String name) { Boolean convert = connConvert.get(name); if (convert != null) { return convert.booleanValue(); } return false; } /** * Load parameters */ public void init() { addResource(SITE_XML); } /** * Get the location of the configuration file */ public String getLocation() { URL url = getResource(SITE_XML); if (url != null) { return url.toString(); } return ""; } }