[
https://issues.apache.org/jira/browse/HIVE-27316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venugopal Reddy K updated HIVE-27316:
-------------------------------------
Description:
*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 columns shows NULL values.
was:
*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.
> 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
> Priority: Major
>
> *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 columns shows NULL values.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
