添加链接
link管理
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接
相关文章推荐
发财的山寨机  ·  高级查询 · ...·  1 周前    · 
阳刚的板凳  ·  JavaEE 使用 JQuery 完成 ...·  5 天前    · 
爱搭讪的蚂蚁  ·  Compare schemas false ...·  4 天前    · 
路过的大象  ·  Apache OpenOffice ...·  4 天前    · 
想出国的豆腐  ·  PostgreSQL Python: ...·  2 天前    · 
痴情的凉面  ·  2D 盒型碰撞体 (Box ...·  3 月前    · 
买醉的花卷  ·  [Day 21] 媽! Keras 和 ...·  4 月前    · 
怕考试的仙人球  ·  OracleDataWriter ...·  8 月前    · 
稳重的包子  ·  Talend Fatal Error - ...·  9 月前    · 
  • User-defined aggregate functions (UDAFs)
  • Integration with Hive UDFs, UDAFs, and UDTFs
  • External user-defined scalar functions (UDFs)
  • Function invocation
  • SQL data type rules
  • Datetime patterns
  • H3 geospatial functions
  • Lambda functions
  • Window functions
  • Identifiers
  • Names
  • IDENTIFIER clause
  • NULL semantics
  • Expressions
  • Parameter markers
  • Name resolution
  • JSON path expressions
  • Partitions
  • ANSI compliance in Databricks Runtime
  • Apache Hive compatibility
  • Principals
  • Privileges and securable objects in Unity Catalog
  • Privileges and securable objects in the Hive metastore
  • Refresh Unity Catalog metadata
  • External locations
  • External tables
  • Storage credentials
  • Volumes
  • Delta Sharing
  • Federated queries (Lakehouse Federation)
  • Information schema
  • Reserved words
  • ALTER CATALOG
  • ALTER CONNECTION
  • ALTER CREDENTIAL
  • ALTER DATABASE
  • ALTER LOCATION
  • ALTER PROVIDER
  • ALTER RECIPIENT
  • ALTER STREAMING TABLE
  • ADD CONSTRAINT clause
  • DROP CONSTRAINT clause
  • ALTER TABLE
  • ALTER SCHEMA
  • ALTER SHARE
  • ALTER VIEW
  • ALTER VOLUME
  • COMMENT ON
  • CREATE BLOOMFILTER INDEX
  • CREATE CATALOG
  • CREATE CONNECTION
  • CREATE DATABASE
  • CREATE FUNCTION (SQL)
  • CREATE FUNCTION (External)
  • CREATE LOCATION
  • CREATE MATERIALIZED VIEW
  • CREATE RECIPIENT
  • CREATE SCHEMA
  • CREATE SERVER
  • CREATE SHARE
  • CREATE STREAMING TABLE
  • CREATE TABLE [USING]
  • CREATE TABLE LIKE
  • CONSTRAINT clause
  • CREATE TABLE CLONE
  • Table properties and table options
  • CREATE TABLE with Hive format
  • CREATE TABLE
  • CREATE VIEW
  • CREATE VOLUME
  • DROP BLOOMFILTER INDEX
  • DROP CATALOG
  • DROP CONNECTION
  • DROP DATABASE
  • DROP CREDENTIAL
  • DROP FUNCTION
  • DROP LOCATION
  • DROP PROVIDER
  • DROP RECIPIENT
  • DROP SCHEMA
  • DROP SHARE
  • DROP TABLE
  • DROP VIEW
  • DROP VOLUME
  • MSCK REPAIR TABLE
  • REFRESH FOREIGN (CATALOG, SCHEMA, or TABLE)
  • REFRESH (MATERIALIZED VIEW or STREAMING TABLE)
  • TRUNCATE TABLE
  • UNDROP TABLE
  • COPY INTO
  • DELETE FROM
  • INSERT INTO
  • INSERT OVERWRITE DIRECTORY
  • INSERT OVERWRITE DIRECTORY with Hive format
  • LOAD DATA
  • MERGE INTO
  • UPDATE
  • Query
  • SELECT
  • VALUES
  • EXPLAIN
  • CACHE SELECT
  • CONVERT TO DELTA
  • DESCRIBE HISTORY
  • FSCK REPAIR TABLE
  • GENERATE
  • OPTIMIZE
  • REORG TABLE
  • RESTORE
  • VACUUM
  • ANALYZE TABLE
  • CACHE TABLE
  • CLEAR CACHE
  • REFRESH CACHE
  • REFRESH FUNCTION
  • REFRESH TABLE
  • UNCACHE TABLE
  • DESCRIBE CATALOG
  • DESCRIBE CONNECTION
  • DESCRIBE CREDENTIAL
  • DESCRIBE DATABASE
  • DESCRIBE FUNCTION
  • DESCRIBE LOCATION
  • DESCRIBE PROVIDER
  • DESCRIBE QUERY
  • DESCRIBE RECIPIENT
  • DESCRIBE SCHEMA
  • DESCRIBE SHARE
  • DESCRIBE TABLE
  • DESCRIBE VOLUME
  • SHOW ALL IN SHARE
  • SHOW CATALOGS
  • SHOW COLUMNS
  • SHOW CONNECTIONS
  • SHOW CREATE TABLE
  • SHOW CREDENTIALS
  • SHOW DATABASES
  • SHOW FUNCTIONS
  • SHOW GROUPS
  • SHOW LOCATIONS
  • SHOW PARTITIONS
  • SHOW PROVIDERS
  • SHOW RECIPIENTS
  • SHOW SCHEMAS
  • SHOW SHARES
  • SHOW SHARES IN PROVIDER
  • SHOW TABLE
  • SHOW TABLES
  • SHOW TABLES DROPPED
  • SHOW TBLPROPERTIES
  • SHOW USERS
  • SHOW VIEWS
  • SHOW VOLUMES
  • RESET
  • SET TIMEZONE
  • USE CATALOG
  • USE DATABASE
  • USE SCHEMA
  • ADD ARCHIVE
  • ADD FILE
  • ADD JAR
  • LIST ARCHIVE
  • LIST FILE
  • LIST JAR
  • ALTER GROUP
  • CREATE GROUP
  • DROP GROUP
  • GRANT
  • GRANT SHARE
  • REPAIR PRIVILEGES
  • REVOKE
  • REVOKE SHARE
  • SHOW GRANTS
  • SHOW GRANTS ON SHARE
  • SHOW GRANTS TO RECIPIENT
  • regexp_count function

    Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 11.2 and above

    Returns the number of times str matches the regexp pattern.

    Syntax

    regexp_count( str, regexp )
    

    An INTEGER.

    The regexp string must be a Java regular expression. String literals are unescaped. For example, to match '\abc', a regular expression for regexp can be '^\\abc$'.

    In case of a malformed regexp the function returns an INVALID_PARAMETER_VALUE error.

    If either argument is NULL the result is NULL.

    Examples

    > SELECT regexp_count('Steven Jones and Stephen Smith are the best players', 'Ste(v|ph)en');
    > SELECT regexp_count('Mary had a little lamb', 'Ste(v|ph)en');
    > SELECT regexp_count(NULL, 'Ste(v|ph)en');
    > SELECT regexp_instr('Mary had a little lamb', NULL);