Tag: replicate

How to keep SQL data and Elasticsearch in-sync, and which to search from?

elasticsearch replicate search sql synchronization

I’ve seen two solutions mentioned, and was wondering what most people do. Use logstash Code your application to make writes to Elasticsearch alongside SQL. For example, Another question is how to handle actually searching the entity? Do you ONLY use Elasticsearch? If not, I would assume you fetch from Elasticsearch based on keywords and use the IDs returned to filter

Teradata REPLICATE function?

replicate sql teradata

I’m converting MS SQL Server codes to Teradata. I found out that Teradata has no replicate function. Below is the sample code Is there an alternative function for replicate in Teradata? Thanks Answer Try this: This will repeat the character ‘0’ two minus the length of the column, which is effectively doing the same thing as REPLICATE in SQL Server.