Tool/Solution for transferring/replicating data from Memsql to other data source

Help Connectors and Pipelines
1

Hey Team,

Like we have SingleStore Replicate tool for transferring/replicating data from different data sources to SingleStore, Do we have any tool/solution which can transfer/replicate data from Single Store tables to Cornerstone (Hive) Table

2

See some data integration vendors listed on our partner integrations page:

This includes Informatica and Qlik now and is being updated actively. Many data integration tools will work against SingleStore in MySQL mode.

What are you trying to do? How much data do you want to move?

If it’s real simple you could try SELECT INTO … HDFS. There is a gap in our docs now that doesn’t show this is supported, but I believe it works, with notation similar to HDFS pipelines. See also the LINKs feature. We’ll bump the priority of a task to get that fixed in the documentation.

Also, if you want to follow a fully documented path, you can select into an FS and then copy to HDFS.

3

We confirmed that SELECT INTO … HDFS works. The syntax would be something like this.

select * from t into HDFS 'hdfs://hadoop-namenode:8020/dir/file.csv'

We have a documentation task opened to document it.