'Reading Greenplam data from SingleStore without copying the data
Is there any way we can read data from Greenplam database in Singlestore database over the network without physically copying the data from Greenplum to Singlestore.
Solution 1:[1]
yes you can create a PXF external table using JDBC connector to Single Store and query it via Greenplum.
Solution 2:[2]
The usql tools support 'copy' command for a lot of databases, including SingleStore and Postgres. you can try to copy from SingleStore to Greenplum directly. I don't have Singlesotre but I have tried with mysql.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Ivan Novick |
| Solution 2 |