Stack Overflow
Stack Overflow

Questions tagged [yugabytedb]

Use for programming questions related to the YugabyteDB distributed SQL database.

YugabyteDB is an open source, high-performance, distributed SQL database for powering global, massively-scalable applications. At its core is a distributed document store whose sharding, replication and ACID transactions architecture is inspired by Google Spanner. It provides two APIs on top of this core - YSQL for fully relational workloads and YCQL for semi-relational workloads.

335 questions
0
votes
1 answer

How to escape quotes when importing csv file in PostgreSQL / YugabyteDB

Using YugabyteDB 2.5.3.1 (PostgreSQL 11.2). I currently have this table: create table bum2(id int, the_t text); Looking to import this "a"bc" from a csv file into the text column. Tried with this csv file: 6,""a""bc"" And: \copy bum2 from data.csv…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

How can I create Yugabyte Job for my Stored-procedure?

In Oracle, we can create JOBs and configure them to run every 2 hours / every morning / etc. as per project requirement. Does Yugabyte also support such JOBs - i.e. periodic automatic re-execution of stored-procedures?
Kunal Shah
  • 1
0
votes
1 answer

Spark cassendra yugabyte connector issue to fetch records from table

For example below is my code : spark = SparkSession.builder.appName('SparkCassandraApp')\ .config('spark.cassandra.connection.host', 'xx.xx.xx.xx') \ .config('spark.cassandra.connection.port', '9042') \ …
Rutunj sheladiya
  • 629
  • 7
  • 21
0
votes
1 answer

What's the recommended way to use pg_dump/ysql_dump with YugabyteDB to export data when a table is still receiving inserts?

When this workload (SqlSecondaryIndex workload from https://github.com/YugaByte/yb-sample-apps/) is still running % java -jar yb-sample-apps.jar --workload SqlSecondaryIndex --nodes 127.0.0.1:5433 --num_threads_read 4 --num_threads_write 2 an…
Ricardo Adam
  • 115
  • 5
0
votes
2 answers

JOOQ optimistic locking and DataChangedException: Database record has been changed on record.update

Summary of the problem: I have a case class Test04(...) with values from e.g. mobile client to be updated into db. Table uses tSt field of type timestamptz for optimistic locking and the tSt value is the current value in the db. So I have unique id…
user4955663
  • 1,039
  • 2
  • 13
  • 21
0
votes
1 answer

Examining which rows are indexed when using partial indexes in YugabyteDB

I created a table, along with a partial index as shown below. CREATE TABLE users ( id SERIAL PRIMARY KEY, email VARCHAR DEFAULT NULL, name VARCHAR ); CREATE UNIQUE INDEX users_idx1 ON users (email) WHERE email IS NOT NULL; Now, I insert…
Karthik Ranganathan
  • 677
  • 4
  • 9
0
votes
1 answer

How does the master bootstrap process work and how can I debug it?

I am working to stand up 3 instances of the yugabyte master and tserver in separate k8s clusters connected over LoadBalancer services on bare metal. However, on all three master instances it looks like the bootstrap process is failing: I0531…
zanegray
  • 768
  • 7
  • 13
0
votes
1 answer

Group by not taken into account Yugabyte

I am struggling for some time with performing a group by. After seeing all examples, I am still not able to perform a correct group by for some reason. My table is created like this: CREATE TABLE IF NOT EXISTS itvance.identityuserdata ( id TEXT,…
Malaf
  • 43
  • 6
0
votes
1 answer

Does YugaByte plan to be one Pluggable Storage for PostgreSQL 12+?

I am new to YugaByte, but impressed by the things I have read about it so far. One thing which might be beneficial for both YugaByte and Postgres community is to use YugaByte as one of the Pluggable Storages for PostgreSQL (>= version 12), thus…
jfbaro
  • 301
  • 2
  • 10
0
votes
1 answer

Yugabyte DB error : Already present: Keyspace 'masterdb' already exists

I am using yugabyte-2.0.11.0,I was trying to create one schema named "MasterDB" but it was taking a long time, so I cancelled the request and tried to recreate the same, but it shows the error " Already present: Keyspace "masterdb" already exists".I…
Draga
  • 43
  • 6
0
votes
1 answer

How can I configure the client timeout to yugabyte db server when running queries from psql?

It seems like some queries are taking too long and I want to make the client wait longer for the query results?
David Bruner
  • 27
  • 6
0
votes
1 answer

How do I setup the deletion of old logs?

After running yugabyte db for some time, I see that the logs are never deleted. How can I configure the server to delete old logs ?
Edward Ribbery
  • 37
  • 5
0
votes
1 answer

How to configure yugabytedb for strict serialization?

It is understood from dbmsmusings portal that financial transactions require strict serialization and non-adherence will lead to anomalies. Please guide me in configuring yugabytedb for strict serialization and also it's cost on performance and/or…
AVA
  • 2,474
  • 2
  • 26
  • 41
0
votes
1 answer

How to replace default json serializer in YugaByteCassandraCSharpDriver?

Is there any way to replace json default serializer? I implement a serializer which convert json to objects, so i can use Custome classes in my model instead of string public class JsonSerializer : TypeSerializer { public…
Ali Zeinali
  • 551
  • 4
  • 16
0
votes
1 answer

Is one source to many target cluster replication supported by YugabyteDB’s 2-DC async replication mechanism?

For the 2-DC feature described here (https://docs.yugabyte.com/latest/deploy/multi-dc/2dc-deployment/), is one source to multiple target cluster configuration supported?
Ricardo Adam
  • 115
  • 5
1 2 3
…
22 23