String indexes in Druid are case-sensitive. UPPER (and LOWER) can use the index, but they must do it through index scans, rather than point index lookups. So index usage will be less efficient.
Gian On 2025/04/09 18:50:45 vikas thakur wrote: > On Wed, Apr 9, 2025 at 2:49 PM vikas thakur <[email protected]> > wrote: > > > Can someone help with logic of upper sql function of Druid ? What is > > underlying implementation, does it use case insensitive indexes ? > > Currently, benchmarking performance with upper function and standardizing > > the casing for APIs. > > > > Regards, > > VT > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
