[
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
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)
