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
1
vote
1 answer

Yugabyte C# driver Found too many matches for builtin function '+'

I tried run this query with yugabyte-cassandra-driver (C#): public async Task IncreaseUnread(int userId, long peerId, int count) { var statement = await Session.PrepareAsync("UPDATE messaging_db.dialog SET unreadCount =…
Ali Zeinali
  • 551
  • 4
  • 16
1
vote
1 answer

Is it possible to model one-to-many mappings in Yugabyte YCQL?

For example, key | value -------------+------- primary_key1 | v1 primary_key1 | v2 Is the above allowed where the same key has multiple values? Or does one need to have an explicit clustering key? If I have a table with 2 columns, can the…
David Bruner
  • 27
  • 6
1
vote
1 answer

How does Yugabyte handle single disk failure?

I want to know what is the behavior of Yugabyte in case of single disk failures. Specifically: What procedure should the sysadmin follow while dealing with a single disk failure? e.g. does stopping the TServer momentarily, changing the disk and…
user2101712
  • 85
  • 6
1
vote
1 answer

In YugabyteDB, when a node fails, is the load of tablets on the failed node spread evenly among other nodes?

Are the tablets distributed randomly? What I mean is: if a node goes down, does the load of the tablets on the failed node get distributed evenly among the remaining available nodes or does it shift to just one other peer node? The former would be…
sai
  • 165
  • 1
  • 10
1
vote
1 answer

Is there any difference between CassandraCSharpDriver and YugaByteCassandraCSharpDriver?

I found there is a YugaByteCassandraCSharpDriver on NuGet package manager while in yugabyte official site docs showed using CassandraCSharpDriver. which one should we use for C#? what is the difference between YugaByteCassandraCSharpDriver and…
Ali Zeinali
  • 551
  • 4
  • 16
1
vote
1 answer

Is there a performance impact of delete tombstones in YugabyteDB?

We have high throughput use case (TPS of 50k, or 180M txn per hour); about 15-30 million of these ops per hour are deletes. Given that YugabyteDB is a log structured database and overwritten data is reclaimed only at compactions, what would be the…
sai
  • 165
  • 1
  • 10
1
vote
1 answer

How to install only the YugaByte client programs

How to install only the YugaByte client programs like cqlsh, ysqlsh, csv loaders, jdbc driver etc without the server stuff? It seems that the installation instructions cover only the server side installation:…
user4955663
  • 1,039
  • 2
  • 13
  • 21
1
vote
1 answer

YugaByte CREATE DATABASE failure

I tried to run the yugabyte 2.0.8.0 quick start demo according to these instructions: https://docs.yugabyte.com/latest/quick-start/install/ https://docs.yugabyte.com/latest/quick-start/create-local-cluster/ with 3 local nodes ./bin/yb-ctl --rf 3…
user4955663
  • 1,039
  • 2
  • 13
  • 21
1
vote
1 answer

Working of compactions work in YugaByte DB

What flavors of compaction (e.g., size-tier/level compactions) are supported? And what parameters control the behavior of compactions?
Diana Garcia
  • 39
  • 6
1
vote
1 answer

Granting all permissions on all tables in a database to a user in YugabyteDB

I have created a database foo and tables bar1 and bar2 in this database. I am trying to grant all permissions on these tables to a user myuser - specifically DML. I created the user as follows: yugabyte=# CREATE USER myuser I have also created the…
Karthik Ranganathan
  • 677
  • 4
  • 9
1
vote
1 answer

Is there Javascript driver support for YCQL JSONB type in YugaByte DB?

We are trying to use JSONB of YugaByte’s YCQL (Cassandra) API. We were able to insert using the node’s Cassandra-driver but have not able to SELECT the JSONB column back. It looks like we are hitting the issue mentioned here:…
Edward Ribbery
  • 37
  • 5
1
vote
1 answer

Does YugaByte DB’s YSQL API support array types

Does YugaByte’s SQL support array data type present in PostgreSQL (like https://www.postgresql.org/docs/9.1/arrays.html)?
Charlie O'Riely
  • 87
  • 6
1
vote
1 answer

Creating a prepare-bind insert statement with a TIMESTAMP datatype

I am trying to insert some rows using a prepare-bind statement. One of the columns is of type TIMESTAMP. How do I bind the variable for this column with the current epoch time? I have the following table: CREATE TABLE orders { user_id TEXT, …
Karthik Ranganathan
  • 677
  • 4
  • 9
1
vote
1 answer

What is the correct way to export/import data using cassandra-loader/cassandra-unloader for YugaByte DB on a table with JSONB column(s)

I tried to use the steps described here https://docs.yugabyte.com/v1.1/manage/data-migration/cassandra/bulk-export/ wget https://github.com/YugaByte/cassandra-loader/releases/download/v0.0.27-yb-2/cassandra-loader wget…
Ricardo Adam
  • 115
  • 5
1
vote
1 answer

Rebalancing rate when new node is added

When a new node is added, we see that it is starting to receive new tablets (in the http://:7000/tablet-servers page) and the system is rebalancing. But the default rate seems low. Are there any knobs to determine this rate?
Charlie O'Riely
  • 87
  • 6
1 2 3
…
22 23