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
2 answers

Yugabyte YCQL check if a set contain a value?

Is there there any way to query on a SET type(or MAP/LIST) to find does it contain a value or not? Something like this: CREATE TABLE test.table_name( id text, ckk SET, PRIMARY KEY((id)) ); Select * FROM table_name WHERE id = 1 AND…
Ali Zeinali
  • 551
  • 4
  • 16
0
votes
1 answer

Is there support for BLOBs in YugabyteDB like in Oracle or Postgres?

Since YugabyteDB is a Postgres based implementation, will Postgres large objects( https://www.postgresql.org/docs/9.2/largeobjects.html) work in YSQL?
Diana Garcia
  • 39
  • 6
0
votes
1 answer

Does Yugabyte JSONB Keep the order of json properties?

Is there any guarantee that JSONB keep the order of json properties in which they were inserted? Update: In Docs, I found it sort json keys for efficiency. What should i do if i gonna a key always be the first one?
Ali Zeinali
  • 551
  • 4
  • 16
0
votes
1 answer

How to configure yb-cdc-connector to resume printing logs upon yugabyte db restart (stop and start)?

Following, How to capture data change in yugabyte db? to publish the change logs. It works properly. But, yb-connector.jar is not resuming the publishing change data logs, after restarting yugabyte db. Commands Executed: wget -O yb-cdc-connector.jar…
AVA
  • 2,474
  • 2
  • 26
  • 41
0
votes
1 answer

How to capture data change in yugabyte db?

terminal 1: postgres=# \c yugastore You are now connected to database "yugastore" as user "postgres". yugastore=# select count(*) from yugastore.users; count ------- 2500 (1 row) yugastore=# delete from yugastore.users; DELETE 2500 (After…
AVA
  • 2,474
  • 2
  • 26
  • 41
0
votes
1 answer

Can a yugabyte TServer use multiple disk?

Let's imagine we have a server with 10 disk storage and i gonna create a yugabyte cluster with replication factor of 5 (and 20 tablet sharding). I have two option to do that: Create 5 node and give each tserver 2 disk to use with 100 tablet per…
Ali Zeinali
  • 551
  • 4
  • 16
0
votes
1 answer

Maximum number of keys in Yedis (Yugabyte Redis)?

Redis FAQ says maximum number of keys in a database is 2^32 - 1. However, that page has not been updated since 2010. In a Google groups thread, somebody said that the max number of keys is 2^32 - 1 on a 32 bit system, and 2^64 - 1 on a 64 bit…
user2101712
  • 85
  • 6
0
votes
1 answer

How to create user with password, drop roles and database with ownership in yugabyte db?

Objective: To create user with password, drop roles and database with ownership in yugabyte Commands Executed: cd /opt/yugabyte/yugabyte-1.3.0.0/bin psql -h localhost -p 5433 -U postgres -d postgres -W \i…
AVA
  • 2,474
  • 2
  • 26
  • 41
0
votes
1 answer

How to compose and execute column-oriented queries in yugabyte?

How to compose and execute column-oriented queries in yugabytedb to support data science operations.
AVA
  • 2,474
  • 2
  • 26
  • 41
0
votes
1 answer

How does yugabytedb achieve high data density?

It is understood that yugabytedb creates n key/value records per SQL row. Still, how does it manage to achieve high data density?
AVA
  • 2,474
  • 2
  • 26
  • 41
0
votes
2 answers

How to create range partioned, date partitioned, geo partioned tables in yugabyte-db?

It is understood that yugabyte creates hash partitioned tables by default. Please guide me in creating range partioned, date partitioned, geo partioned tables in yugabyte-db with multiple tablets.
AVA
  • 2,474
  • 2
  • 26
  • 41
0
votes
2 answers

How to install yugabyte-2.0.10.0 on CentOS7?

I am trying install yugabyte-2.0.10.0: a) environment: os: centos7.6 cpu Model: Intel(R) Core(TM) i7 CPU M 620 kernel: 3.10.0-957.el7.x86_64 gcc version 4.8.5 Python 2.7.5 b) commands: cd ~ rm -rf /opt/yugabyte mkdir -p /opt/yugabyte mkdir -p…
AVA
  • 2,474
  • 2
  • 26
  • 41
0
votes
1 answer

How to run yugabyte-db yugastore application locally?

I am using yugabyte-db-1.3.0 and am trying to run yugabyte e-commerce example application, yugastore locally on CentOS7 by following instructions in its README.md, as follows: a) downloaded and extracted application, yugastore to…
AVA
  • 2,474
  • 2
  • 26
  • 41
0
votes
1 answer

Yugabyte replication and clustring per Database or Keyspace

Is it possible to config replication factor and clustering for each database(or keyspace) or we must just config it for hole yugabyte instance?
Ali Zeinali
  • 551
  • 4
  • 16
0
votes
1 answer

Can I take advantage of Yugabytes compatability?

Yugabyte seems to support Redis, Cassandra and SQL queries. Do they work with each other? For example, can I write data with Cassandra API and later perform SQL queries against them?
Edward Ribbery
  • 37
  • 5
1 2 3
…
22 23