hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (Jira)" <j...@apache.org>
Subject [jira] [Work logged] (HIVE-25405) Implement Connector Provider for Amazon Redshift
Date Thu, 29 Jul 2021 11:27:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-25405?focusedWorklogId=631091&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-631091
]

ASF GitHub Bot logged work on HIVE-25405:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 29/Jul/21 11:26
            Start Date: 29/Jul/21 11:26
    Worklog Time Spent: 10m 
      Work Description: vnhive opened a new pull request #2546:
URL: https://github.com/apache/hive/pull/2546


   This PR proposes the addition of a data connector implementation to support amazon redshift.
   
   The data connector enables connecting to and seamlessly working with a redshift database.
   
   0: jdbc:hive2://> CREATE CONNECTOR IF NOT EXISTS redshift_test_7
   . . . . . . . . > TYPE 'redshift'
   . . . . . . . . > URL '<redshift-jdbc-url>'
   . . . . . . . . > COMMENT 'test redshift connector'
   . . . . . . . . > WITH DCPROPERTIES (
   . . . . . . . . > "hive.sql.dbcp.username"="******",
   . . . . . . . . > "hive.sql.dbcp.password"="******");
   No rows affected (0.015 seconds)
   
   0: jdbc:hive2://> CREATE REMOTE DATABASE db_sample_7 USING redshift_test_7 with DBPROPERTIES("connector.remoteDbName"="dbname");
   21/07/29 16:40:06 [HiveServer2-Background-Pool: Thread-217]: WARN exec.DDLTask: metastore.warehouse.external.dir
is not set, falling back to metastore.warehouse.dir. This could cause external tables to use
to managed tablespace.
   No rows affected (0.02 seconds)
   
   0: jdbc:hive2://> use db_sample_7;
   No rows affected (0.014 seconds)
   
   0: jdbc:hive2://> show tables;
   +-----------------+
   |    tab_name     |
   +-----------------+
   | accommodations  |
   | category        |
   | date            |
   | event           |
   | listing         |
   | sales           |
   | sample          |
   | test_time       |
   | test_time_2     |
   | test_timestamp  |
   | users           |
   | venue           |
   | zipcode         |
   +-----------------+
   13 rows selected (8.578 seconds)
   
   
   
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

            Worklog Id:     (was: 631091)
    Remaining Estimate: 0h
            Time Spent: 10m

> Implement Connector Provider for Amazon Redshift
> ------------------------------------------------
>
>                 Key: HIVE-25405
>                 URL: https://issues.apache.org/jira/browse/HIVE-25405
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Narayanan Venkateswaran
>            Assignee: Narayanan Venkateswaran
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>




--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message