[jira] [Created] (HIVE-27316) Select query on table with remote database returns NULL values with postgreSQL and Redshift data connectors

["Venugopal Reddy K (Jira)" <ji...@apache.org>]

Venugopal Reddy K created HIVE-27316:
----------------------------------------

             Summary: Select query on table with remote database returns NULL values with postgreSQL and Redshift data connectors
                 Key: HIVE-27316
                 URL: https://issues.apache.org/jira/browse/HIVE-27316
             Project: Hive
          Issue Type: Bug
            Reporter: Venugopal Reddy K


*Brief Description:*

Few datatypes are not mapped from postgres/redshift to hive data types. Thus values for unmapped columns are shown as null.

 

*Steps to reproduce:*

1. create connectors for postgres,redshift, and create remote database with the respective connectors.

 
{code:java}
create connector rscon1 type 'postgres' url 'jdbc:redshift://redshift.us-east-2.redshift.amazonaws.com:5439/dev?ssl=false&tcpKeepAlive=true' WITH DCPROPERTIES ('hive.sql.dbcp.username'='cloudera','hive.sql.dbcp.password'='Cloudera#123','hive.sql.jdbc.driver'='com.amazon.redshift.jdbc.Driver','hive.sql.schema' = 'public');

create REMOTE database localdev1 using rscon1 with DBPROPERTIES("connector.remoteDbName"="dev");

create connector pscon1 type 'postgres' url 'jdbc:postgresql://postgre.us-east-2.rds.amazonaws.com:5432/postgres?ssl=false&tcpKeepAlive=true' WITH DCPROPERTIES ('hive.sql.dbcp.username'='postgres','hive.sql.dbcp.password'='Cloudera#123','hive.sql.jdbc.driver'='org.postgresql.Driver','hive.sql.schema' = 'public');

create REMOTE database localdevps1 using pscon1 with DBPROPERTIES("connector.remoteDbName"="postgres");
{code}
2. Execute select query on table(in remote db) having int2, int4, float4, float8, bool, character(n) columns shows NULL values.

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)