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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
