/*
 * 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 com.treasuredata.jdbc;

import java.sql.SQLException;
import java.sql.Types;

public class Utils
{

    /**
     * Convert hive types to sql types.
     *
     * @param type
     * @return Integer java.sql.Types values
     * @throws SQLException
     */
    public static int TDTypeToSqlType(String type)
            throws SQLException
    {
        if ("string".equalsIgnoreCase(type)) {
            return Types.VARCHAR;
        }
        else if ("varchar".equalsIgnoreCase(type)) {
            return Types.VARCHAR;
        }
        else if ("float".equalsIgnoreCase(type)) {
            return Types.FLOAT;
        }
        else if ("double".equalsIgnoreCase(type)) {
            return Types.DOUBLE;
        }
        else if ("boolean".equalsIgnoreCase(type)) {
            return Types.BOOLEAN;
        }
        else if ("tinyint".equalsIgnoreCase(type)) {
            return Types.TINYINT;
        }
        else if ("smallint".equalsIgnoreCase(type)) {
            return Types.SMALLINT;
        }
        else if ("int".equalsIgnoreCase(type)) {
            return Types.INTEGER;
        }
        else if ("long".equalsIgnoreCase(type)) {
            return Types.BIGINT;
        }
        else if ("bigint".equalsIgnoreCase(type)) {
            return Types.BIGINT;
        }
        else if ("date".equalsIgnoreCase(type)) {
            return Types.DATE;
        }
        else if ("timestamp".equalsIgnoreCase(type)) {
            return Types.TIMESTAMP;
        }
        else if (type.startsWith("map<")) {
            return Types.VARCHAR;
        }
        else if (type.startsWith("array<")) {
            return Types.VARCHAR;
        }
        else if (type.startsWith("struct<")) {
            return Types.VARCHAR;
        }
        throw new SQLException("Unrecognized column type: " + type);
    }
}

@@ -979,19 +979,16 @@
 @param t
-ype
 %0A     * 
@@ -1107,19 +1107,16 @@
 String t
-ype
 )%0A      
@@ -1147,16 +1147,55 @@
 n%0A    %7B%0A
+        String type = t.toLowerCase();%0A
         
@@ -1209,34 +1209,24 @@
 ring%22.equals
-IgnoreCase
 (type)) %7B%0A  
@@ -1296,39 +1296,60 @@
 char%22.equals
-IgnoreCase(type
+(type) %7C%7C type.startsWith(%22varchar(%22
 )) %7B%0A       
@@ -1412,34 +1412,24 @@
 loat%22.equals
-IgnoreCase
 (type)) %7B%0A  
@@ -1496,34 +1496,24 @@
 uble%22.equals
-IgnoreCase
 (type)) %7B%0A  
@@ -1582,34 +1582,24 @@
 lean%22.equals
-IgnoreCase
 (type)) %7B%0A  
@@ -1669,34 +1669,24 @@
 yint%22.equals
-IgnoreCase
 (type)) %7B%0A  
@@ -1757,34 +1757,24 @@
 lint%22.equals
-IgnoreCase
 (type)) %7B%0A  
@@ -1841,34 +1841,24 @@
 %22int%22.equals
-IgnoreCase
 (type)) %7B%0A  
@@ -1925,34 +1925,24 @@
 long%22.equals
-IgnoreCase
 (type)) %7B%0A  
@@ -2010,34 +2010,24 @@
 gint%22.equals
-IgnoreCase
 (type)) %7B%0A  
@@ -2093,34 +2093,24 @@
 date%22.equals
-IgnoreCase
 (type)) %7B%0A  
@@ -2187,18 +2187,8 @@
 uals
-IgnoreCase
 (typ

Handle varchar(n) as varchar