Apache Pinot Docs
latest
Ask or search…
⌃
K
Introduction
Basics
Concepts
Architecture
Components
Getting Started
Import Data
Indexing
Releases
Recipes
For Users
Query
APIs
External Clients
Tutorials
For Developers
Basics
Advanced
Plugins
Design Documents
For Operators
Deployment and Monitoring
Command-Line Interface (CLI)
Configuration Recommendation Engine
Tutorials
Configuration Reference
Cluster
Controller
Broker
Server
Table
Schema
Ingestion Job Spec
Monitoring Metrics
Functions
ABS
ADD
ago
EXPR_MIN / EXPR_MAX
arrayConcatDouble
arrayConcatFloat
arrayConcatInt
arrayConcatLong
arrayConcatString
arrayContainsInt
arrayContainsString
arrayDistinctInt
arrayDistinctString
arrayIndexOfInt
arrayIndexOfString
ARRAYLENGTH
arrayRemoveInt
arrayRemoveString
arrayReverseInt
arrayReverseString
arraySliceInt
arraySliceString
arraySortInt
arraySortString
arrayUnionInt
arrayUnionString
AVGMV
Base64
caseWhen
ceil
CHR
codepoint
concat
count
COUNTMV
COVAR_POP
COVAR_SAMP
day
dayOfWeek
dayOfYear
DISTINCT
DISTINCTAVG
DISTINCTAVGMV
DISTINCTCOUNT
DISTINCTCOUNTBITMAP
DISTINCTCOUNTHLLMV
DISTINCTCOUNTHLL
DISTINCTCOUNTBITMAPMV
DISTINCTCOUNTMV
DISTINCTCOUNTRAWHLL
DISTINCTCOUNTRAWHLLMV
DISTINCTCOUNTRAWTHETASKETCH
DISTINCTCOUNTTHETASKETCH
DISTINCTSUM
DISTINCTSUMMV
DIV
DATETIMECONVERT
DATETRUNC
exp
FIRSTWITHTIME
FLOOR
FrequentLongsSketch
FrequentStringsSketch
FromDateTime
FromEpoch
FromEpochBucket
FUNNELCOUNT
Histogram
hour
isSubnetOf
JSONFORMAT
JSONPATH
JSONPATHARRAY
JSONPATHARRAYDEFAULTEMPTY
JSONPATHDOUBLE
JSONPATHLONG
JSONPATHSTRING
jsonextractkey
jsonextractscalar
LASTWITHTIME
length
ln
lower
lpad
ltrim
max
MAXMV
MD5
millisecond
min
minmaxrange
MINMAXRANGEMV
MINMV
minute
MOD
mode
month
mult
now
percentile
percentileest
percentileestmv
percentilemv
percentiletdigest
percentiletdigestmv
percentilekll
percentilerawkll
percentilekllmv
percentilerawkllmv
quarter
regexpExtract
regexpReplace
remove
replace
reverse
round
ROW_NUMBER
rpad
rtrim
second
SEGMENTPARTITIONEDDISTINCTCOUNT
sha
sha256
sha512
sqrt
startswith
ST_AsBinary
ST_AsText
ST_Contains
ST_Distance
ST_GeogFromText
ST_GeogFromWKB
ST_GeometryType
ST_GeomFromText
ST_GeomFromWKB
STPOINT
ST_Polygon
strpos
ST_Union
SUB
substr
sum
summv
TIMECONVERT
timezoneHour
timezoneMinute
ToDateTime
ToEpoch
ToEpochBucket
ToEpochRounded
TOJSONMAPSTR
toGeometry
toSphericalGeography
trim
upper
Url
UTF8
VALUEIN
week
year
yearOfWeek
Extract
Plugin Reference
Reference
Single-stage query engine (v1)
Multi-stage query engine (v2)
RESOURCES
Community
Team
Blogs
Presentations
Videos
Integrations
Tableau
Trino
ThirdEye
Superset
Presto
Spark-Pinot Connector
Contributing
Contribute Pinot documentation
Style guide
Powered By
GitBook
Comment on page
rpad
This section contains reference documentation for the RPAD function.
string padded from the right side with
pad
to reach final
size
Signature
RPAD(col, size, pad)
Usage Examples
SELECT
RPAD
(
'Hello, World'
,
'20'
,
'*'
)
AS
value
FROM
ignoreMe
value
Hello, World********
Previous
ROW_NUMBER
Next
rtrim
Last modified
1yr ago