ql/src/test/queries/clientpositive/jdbc_table_dml_postgres.q

--! qt:database:postgres:q_test_country_table.sql

CREATE EXTERNAL TABLE country (id int, name varchar(20))
STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
TBLPROPERTIES (
    "hive.sql.database.type" = "POSTGRES",
    "hive.sql.jdbc.driver" = "org.postgresql.Driver",
    "hive.sql.jdbc.url" = "jdbc:postgresql://localhost:5432/qtestDB",
    "hive.sql.dbcp.username" = "qtestuser",
    "hive.sql.dbcp.password" = "qtestpassword",
    "hive.sql.table" = "country");

SELECT * FROM country ORDER BY id;
EXPLAIN CBO INSERT INTO country VALUES (8, 'Hungary');
EXPLAIN INSERT INTO country VALUES (8, 'Hungary');
INSERT INTO country VALUES (8, 'Hungary');
SELECT * FROM country ORDER BY id;