YugabyteDB Tips
  • Home
  • About
  • Featured Videos

Category: SQL Functions

YugabyteDB Tips > SQL Functions

List Tablet Details for a YSQL Table From the Command Line

Jim KnicelyNovember 30, 2022

YugabyteDB automatically splits user YSQL tables into multiple shards, called tablets, using either a hash– or range– based strategy. You can see the Tablets […]

Read More

Access Data In An External File Like a Database Table

Jim KnicelyNovember 8, 2022

If you have some data sitting in an external file and would like to use it in your database queries, you can […]

Read More

Convert an INTERVAL to Seconds

Jim KnicelyNovember 3, 2022

In YugabyteDB’s YSQL API, the interval data type is used to store and manipulate a time period. Examples: yugabyte=# SELECT ‘1 Minute […]

Read More

Display Unique Schema Name for Your Temp Tables

Jim KnicelyAugust 8, 2022

Using the YSQL API, temporary tables exist in their own unique schema, so you can’t assign a schema name when you create […]

Read More

Display the Number of Tablets (Shards) for a Table

Jim KnicelyJune 21, 2022

By default, YugabyteDB presplits a table in ysql_num_shards_per_tserver * num_of_tserver shards.  We can display the number of tablets for a table using the […]

Read More

Posts navigation

Older posts
Newer posts

NOTICE

This site is not affiliated, endorsed or associated with YugabyteDB. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.

Find Us

Address
Here!

Hours
24×7

Recommended YugabyteDB Links

  • Home
  • Key Concepts
  • Docs
  • Blog
  • Forum
  • Content Library
  • Support



YugabyteDB Tips

Copyright 2025 - Knicely/Li