protected String getDataType(String mySqlType, int size) {
    switch(mySqlType.toLowerCase())
    {
      case "char":
        return ColumnType.CHAR_TYPE_NAME + wrapSize(size);
      case "varchar":
      case "tinytext":
        return ColumnType.VARCHAR_TYPE_NAME + wrapSize(size);
      case "text":
      case "mediumtext":
      case "enum":
      case "set":
      case "tsvector":
      case "tsquery":
      case "uuid":
      case "json":
        return ColumnType.STRING_TYPE_NAME;
      case "blob":
      case "mediumblob":
      case "longblob":
      case "bytea":
      case "binary":
      case "varbinary":
      case "binary varying":
        return ColumnType.BINARY_TYPE_NAME;
      case "tinyint":
        return ColumnType.TINYINT_TYPE_NAME;
      case "smallint":
      case "smallserial":
        return ColumnType.SMALLINT_TYPE_NAME;
      case "mediumint":
      case "int":
      case "serial":
        return ColumnType.INT_TYPE_NAME;
      case "bigint":
      case "bigserial":
      case "money":
        return ColumnType.BIGINT_TYPE_NAME;
      case "float":
      case "real":
        return ColumnType.FLOAT_TYPE_NAME;
      case "double":
      case "double precision":
        return ColumnType.DOUBLE_TYPE_NAME;
      case "decimal":
      case "numeric":
        return ColumnType.DECIMAL_TYPE_NAME;
      case "date":
        return ColumnType.DATE_TYPE_NAME;
      case "datetime":
        return ColumnType.DATETIME_TYPE_NAME;
      case "timestamp":
      case "time":
      case "interval":
        return ColumnType.TIMESTAMP_TYPE_NAME;
      case "timestampz":
      case "timez":
        return ColumnType.TIMESTAMPTZ_TYPE_NAME;
      case "bool":
      case "boolean":
        return ColumnType.BOOLEAN_TYPE_NAME;
      default:
        return ColumnType.VOID_TYPE_NAME;
    }
  }
Fetch a single table with the given name, returns a Hive Table object from the remote database
@return Table A Table object for the matching table, null otherwise.
@throws MetaException To indicate any failures with executing this API
@param tableName
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/dataconnector/jdbc/AbstractJDBCConnectorProvider.java