Skip to main content
Link
Menu
Expand
(external link)
Document
Search
Copy
Copied
FeatureBase help
Concepts
Bitmap index overview
Equality-encoded bitmaps
Bit-slice bitmaps
Roaring Bitmap Format
RBF page allocation
Glossary
Data modeling overview
Unique identifier
Time Quantums
Ingest workflow
Ingesting from Avro schema registry
Sizing database
Time To Live (TTL)
Examples
Importing low cardinality data
A True Crime Story
Cloud
Cloud Quick Start Guide
Signup to cloud
Connect to cloud db
Login to cloud
Manage API Keys
Create API Key
Update Key Description
Revoke Key
Manage databases
Database shapes
Create serverless database
Create cloud database
Evaluate featurebase at scale
Scale a serverless database
Cloud database metrics
Cloud database versions
Cloud database states
Delete database
Manage cloud ingestion
Manage tables
Create tables
Upload data
Add columns
Copy query endpoint
Drop column
Drop table
Query data
Execute queries
View schema browser
View query history
Analyze query results
Configuration
Manage my account
Activate account
Update account
Move account
Manage users
View users
Invite users
Update user role
Update user details
Activate or deactivate users
Reference - move Cloud users
Reference - Cloud user roles
Reference - Cloud user status
Manage organization
Update organization
Update billing contact
Update technical contact
Upgrade to a paid account
Manage organization billing
Cloud troubleshooting
Cloud status site
Limit reached error
Integer precision loss error
Database "Unknown"
Serverless limitations
Creating database issues
Community
Install on Linux
Install on MacOS
Install on Windows
Setup FeatureBase service
Startup & connect
Import data
CSV datafile reference
CSV ingester reference
CSV ingest examples
SQL source reference
SQL ingester reference
SQL ingest examples
Kafka consumer ingest
Kafka ingest consumer reference
Kafka consumer ingest examples
Kafka delete message reference
Kafka delete ingest consumer
Kafka Avro delete examples
Ingest from Kafka static schema
Kafka static ingest consumer
Kafka static ingest examples
Dataframe consumer
Manage Database
Manage tables
Community configuration
Configuration flags
Data Directory
FeatureBase SQL CLI
Managing services
Max-file-count
Max-map-count
Setup FeatureBase as a systemd service
Query databases
Grafana connector
Python client library
Community authentication
Authentication groups
Azure-AD setup
FeatureBase keygen
Mutual TLS
TLS authentication
TLS user auth tokens
Community backup and restore
Backup FeatureBase
Restore FeatureBase
Community cluster configuration
Create a cluster
Migrate to a new cluster
Safely change parameters
Community troubleshooting
Linux SSD memory issues
Linux atime issues
Linux file limits
Linux memory limits
MacOS SSD memory issues
MacOS atime issues
MacOS file limits
MacOS file limits
MacOS memory limits
MacOS startup issue
Mutex ingest slow
SQL over HTTPS fails
Community API
SQL Queries over HTTP endpoint
APIs
GRPC API
HTTP API
Web API
Community monitoring
Setup logging
Runtime metrics for tools
FeatureBase HTTP endpoints
Setup Datadog monitoring
FeatureBase Metrics
Ingestion Metrics
Runtime Metrics
Transaction Metrics
Community setup
Community Getting started
Community quickstart
PQL guide
PQL Options
PQL Read
PQL ALL
PQL APPLY()
PQL ARROW()
PQL CONSTROW()
PQL COUNT()
PQL DIFFERENCE()
PQL DISTINCT()
PQL EXTRACT()
PQL GROUPBY()
PQL INCLUDESCOLUMN()
PQL INTERSECT()
PQL LIMIT()
PQL MAX()
PQL MIN()
PQL NOT()
PQL PERCENTILE()
PQL ROW()
PQL ROWS()
PQL SORT()
PQL SUM()
PQL TOPK()
PQL TOPN()
PQL UNION()
PQL UNIONROWS()
PQL XOR()
PQL Write
PQL CLEAR()
PQL CLEARROW()
PQL DELETE()
PQL SET()
PQL STORE()
SQL guide
Statements
CREATE TABLE
ALTER TABLE
CREATE VIEW
INSERT
BULK INSERT
BULK INSERT CSV example
BULK INSERT Parquet example
BULK INSERT JSON example
DROP DATABASE
SHOW DATABASES
SELECT
SHOW CREATE TABLE
SHOW TABLES
SHOW COLUMNS
KILL QUERY
Data types & constraints
BOOL
DECIMAL
ID
IDSET
IDSETQ
INT
STRING
STRINGSET
STRINGSETQ
TIMESTAMP
VECTOR
Functions
ASCII()
CHAR()
CHARINDEX()
COSINE_DISTANCE()
DATETIMEADD()
DATETIMEDIFF()
DATETIMEFROMPARTS()
DATETIMENAME()
DATETIMEPART()
DATE_TRUNC()
FORMAT()
LEN()
LOWER()
LTRIM()
OFFSET()
PARSETIMESTAMP()
PREFIX()
RANGEQ()
REPLACEALL()
REVERSE()
RTRIM()
SETCONTAINS()
SETCONTAINSALL()
SETCONTAINSANY()
SETEXLCUDES()
STR()
STRINGSPLIT()
SUBSTRING()
SUFFIX()
TANIMOTO()
TOTIMESTAMP()
TRIM()
TUPLE()
UPPER()
Expressions
Operators
SELECT hints
FLATTEN()
System Tables
Tools
CLI SQL tool
Install or upgrade fbsql
Connect to cloud db
Connect to community db
Running SQL queries
Output flags
SQL output flags
Import data using fbsql
fbsql-loader-impala
fbsql-loader-kafka
fbsql-loader-postgres
Python client library
Install python client
Python client library usage example
Featurebase home
Glossary
API docs
Docs on GitHub
Contact us
SQL guide
SELECT hints
SELECT Hints
SELECT hints tell queries how to access data in a specified table.
Table of contents
FLATTEN()