Stack Overflow
Stack Overflow

Questions tagged [cockroachdb]

A scalable, geo-replicated, transactional SQL datastore developed in Go.

CockroachDB is a scalable, geo-replicated, transactional SQL datastore being developed in .

References:

435 questions
0
votes
2 answers

Cockroachdb Admin UI Not Reachable

I'm trying to deploy a CockroachDB cluster on Digital Ocean. I followed the steps listed in the tutorial here https://www.digitalocean.com/community/tutorials/how-to-deploy-cockroachdb-on-a-three-node-cluster-on-ubuntu-16-04 I can see cockroachdb…
arelangi
  • 225
  • 1
  • 5
  • 9
0
votes
1 answer

How to import from a bucket in the S3 eu-west-1 region?

I try to bulk import into a cockroach db from a S3 bucket in the eu-west-1 region IMPORT TABLE osm.nodes ( id INT PRIMARY KEY, version INT NOT NULL, lat DECIMAL NOT NULL, lon DECIMAL NOT NULL, changeset_id INT…
gubaer
  • 236
  • 2
  • 11
0
votes
2 answers

How to remove duplicate rows in CockroachDB

I have a table in CockroachDB, I have populated the data into the table before applying the constraints to set the primary key, and because some of INSERT statement failed through the data-loading phase, some of the rows are loaded into the table…
Cyrus
  • 912
  • 2
  • 11
  • 21
0
votes
2 answers

Does cockroachdb support extensions?

I am wondering whether cockroachdb supports extensions such as time-scale and others?, because I have a project which requires a third party postgres extension in conjunction with cockroachdb.
Superman
  • 196
  • 1
  • 2
  • 8
0
votes
1 answer

Is there an equivalent to oracle SEGMENT CREATION in cockroachdb

I'm adjusting my oracle table definition for cockroachdb, is there any equivalent to oracle SEGMENT CREATION in cockroachdb? I also asked this question on cockroachDB forum.
Cyrus
  • 912
  • 2
  • 11
  • 21
0
votes
1 answer

What kind of JOINs does CockroachDB support?

I saw that CockroachDB offers JOIN support in this blog post, but it doesn't mention what level of JOINs are supported. Are all of the major types of joins supported, or are there limitations?
Loiselle
  • 472
  • 2
  • 10
-1
votes
1 answer

Distribution on nodes

I started a CockroachDb in a SIngel cluster with 5 nodes and try to store a table on 3 Specific Nodes. Unfortunately it does not work. Since someone has experience with this ALTER TABLE belegdaten CONFIGURE ZONE USING num_replicas = 3, constraints =…
Eugen Itskovich
  • 3
  • 1
-1
votes
1 answer

_ = func (assignment to function) in go

What does this code snippet do? func funcName(para int){} _ = funcName first line define a function, but what does the second line? I know many situations in which underscore assign to object, what about a function? Here is an example from the etcd…
dd.ho
  • 79
  • 4
-1
votes
1 answer

using sql regrex_replace to replace every word that starts with a # symbol with mask(word)

I have text data as following in single column This is a credit card number #341332123-432432-413213-13223. The CC # should be masked This is a email #test@test.com The email address should be masked This is a phone #555-555-5555, The phone number…
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
-1
votes
1 answer

Return query result as a map of json

I have a table user_roles: id role created_at 1 admin 2021-10-27 2 developer 2021-10-28 I would like to have the result returned as a map of json just like the format below: { "1":{ "id":"1", "role":"admin", …
Yonas Kemon
  • 3
  • 3
-1
votes
1 answer

cockroachdb gcp kubernetes error failed to get certificate

While following https://www.cockroachlabs.com/docs/v2.0/orchestrate-cockroachdb-with-kubernetes.html I received an error: textPayload: "2021/07/29 02:32:01 failed to get certificate: CertificateSigningRequest.Create(default.node.cockroachdb-1)…
wahyu eko hadi saputro
  • 367
  • 1
  • 4
  • 15
-1
votes
1 answer

SQL script for joining two tables and only showing results with the most recent timestamp?

Suppose I am a bank: I have a table with a set of user identities called user_identity, and another user_balance with a list of every balance a user has ever had. A new entry is created in user_balance every time a user deposits or withdraws money…
veex
  • 1
  • 1
-1
votes
1 answer

Getting error when trying to INSERT data into CockroachDB on Kubernetes

I am creating an upload file function for my website. When a user clicks upload then my web page will call API that has a function to upload the file into minIO node on my Kubernetes and store metadata of that file into cockroachDB node on my…
Tomson
  • 13
  • 2
-2
votes
1 answer

How can I bulk insert test data into a table in postgresql or cockroachdb?

In procedural SQL, I could write a loop that used an incrementing variable to build data rows and insert them into a table one by one. Is there a way to get the same effect using the regular SQL syntax supported by CockroachDB? I don't want to have…
histocrat
  • 2,291
  • 12
  • 21
-2
votes
1 answer

1 service 1 Database Pattern is not required anymore when using cockroachDB

Since cockroachDB is scalable RDBMS, as per my understanding we do not need the Master-Slave pattern anymore, since every request will be served equally by each node. However, do we still need 1 service 1 database pattern? We could just replicate…
Bondhan Novandy
  • 362
  • 1
  • 4
  • 16
1 2 3
…
28
29