[
https://issues.apache.org/jira/browse/HIVE-27316?focusedWorklogId=860868&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-860868
]
ASF GitHub Bot logged work on HIVE-27316:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 06/May/23 06:20
Start Date: 06/May/23 06:20
Worklog Time Spent: 10m
Work Description: VenuReddy2103 opened a new pull request, #4300:
URL: https://github.com/apache/hive/pull/4300
### What changes were proposed in this pull request?
Mapping int2, int4, float4, float8, character, bool, binary varying and
varbinary remotedb datatypes to hive datatypes.
### Why are the changes needed?
Select query on table in remote database returns NULL values with postgreSQL
and Redshift data connectors. This is happening because few datatypes are not
mapped from postgres/redshift to hive data types. Thus values for unmapped
columns are shown as null.
### Does this PR introduce _any_ user-facing change?
No
### How was this patch tested?
Tested manually
Issue Time Tracking
-------------------
Worklog Id: (was: 860868)
Remaining Estimate: 0h
Time Spent: 10m
> 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
> Assignee: Venugopal Reddy K
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> *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)
