I would like to create a table in hive using Java. Using the following way to do it:
public class HiveCreateTable { private static String driverName = "com.facebook.presto.jdbc.PrestoDriver"; public static void main(String[] args) throws SQLException { // Register driver and create driver instance try { Class.forName(driverName); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } System.out.println("haiiiiii"); Connection con = DriverManager.getConnection("jdbc:presto://192.168.1.119:8082/default", "hadoop", "password"); con.setCatalog("hive"); con.setSchema("log"); Statement stmt = con.createStatement(); String tableName = "sample"; ResultSet res = stmt.executeQuery("create table access_log2 (cip string, csusername string, cscomputername string)"); System.out.println("Table employee created."); con.close(); }} Exception in thread "main" java.sql.SQLException: Query failed (#20150731_101653_00008_hv68j): Unknown type for column 'cip'