Apache Doris v1.0 Documentation
首页
白天
夜间
下载
阅读记录
书签管理
我的书签
添加书签
移除书签
编辑文档
datediff
来源 1
浏览
187
扫码
打印
2022-06-18 08:44:50
datediff
example
keyword
上一篇:
下一篇:
发布点评
Administrator Guide
BloomFilter index
Time zone
LDAP
Orthogonal BITMAP calculation
Dynamic Partition
File Manager
SQL MODE
Materialized view
Bucket Shuffle Join
Export Query Result
Runtime Filter
Backup and Recovery
Broker
Statistics of query execution
Colocation Join
Authority Management
Block Rule
SQL Block Rule
Configuration
FE Configuration
BE Configuration
User Property
HTTP API
get_log_file
CANCEL LABEL
SHOW DATA
RESTORE TABLET
Compaction Action
CONNECTION
GET TABLETS ON A PARTICULAR BE
CHECK/RESET Stub Cache
GET LABEL STATE
FE
Upload Action
Query Detail Action
Check Storage Type Action
Get FE log file
Health Action
Statement Execution Action
Log Action
Show Data Action
Config Action
Query Profile Action
Session Action
Get DDL Statement Action
Bootstrap Action
System Action
Connection Action
Row Count Action
Set Config Action
Backends Action
Meta Action
Table Schema Action
Meta Replay State Action
Get Small File Action
Table Row Count Action
Cancel Load Action
Table Query Plan Action
Show Proc Action
HA Action
MANAGER
Query Profile Action
Node Action
Cluster Action
Show Meta Info Action
Check Decommission Action
Get Load Info Action
Meta Info Action
Logout Action
Show Runtime Info Action
Profile Action
Get Load State
Hardware Info Action
GET TABLETS DISTRIBUTION BETWEEN DIFFERENT DISKS
MIGRATE SINGLE TABLET TO A PARTICULAR DISK
QUERY DETAIL
PROFILE
Load Data
Stream load
Batch Delete
Sequence Column
Broker Load
Spark Load
Insert Into
S3 Load
Routine Load
Binlog Load
Delete
Load Json Format Data
Introduction Overview
Maintainence Operation
Description of the return value of the OLAP function on the BE side
Tablet metadata management tool
Doris Error Table
Disk Capacity Management
Metadata Operations and Maintenance
Data replica management
Multi-tenancy(Deprecated)
Metrics
FE Metrics
BE Metrics
Tablet Restore Tool
Monitoring and alarming
Schema Change
Rollup
Bitmap Index
Temporary partition
Replace Table
Schema Change
Multi-tenancy
update
Resource management
Variable
Use mysqldump data to export table structure or data
Data export
Apache Community
Security
How to Contribute
Contribute to Doris
Commit Format Specification
Code Submission Guide
Committer Guide
Release Process & Verification
Release Doris Core
Verify the Apache release version
Complete Release
Release Preparation
Release Doris Connectors
Subscribe to mailing lists
Feedback
Gitter Manual
Doris Team
Benchmark & Sample
Systemd
Star-Schema-Benchmark
Samples
Compilation and Deployment
Compilation
Installation and deployment
Cluster upgrade
Compile on ARM platform
Compiling with LDB toolchain
Design Documents
GROUPING SETS DESIGN
Doris Storage File Format Optimization
Metadata Design Document
Developer Guide
Bitmap/HLL data format
Minidump
BE development and debugging environment under Linux
Java Format Code
C++ Format Code
Debug Tool
Setting FE dev env - Eclipse
How to Share blogs
Setting Up dev env for FE - IntelliJ IDEA
Doris BE Storage Layer Benchmark Tool
Doris Docker quick build development environment
Doris User
user case
Downloads
Extending Ability
ODBC of Doris
Plugin Development Manual
Iceberg of Doris
Doris On ES
DataX doriswriter
Flink Doris Connector
Hive of Doris
Logstash Doris Output Plugin
Spark Doris Connector
Seatunnel
Seatunnel Connector Spark Doris
Seatunnel Connector Flink Doris
UDF
Contribute UDF
Remote User Defined Function Service
Native User Defined Function
Audit log plugin
FAQ
Common Error
FAQ
Getting Started
Advanced Use Guide
Data Model, ROLLUP and Prefix Index
Rollup and query
Best Practices
Data Partition
Guidelines for Basic Use
SQL Manual
SQL Functions
CAST
Encryption and Digest Functions
MD5SUM
AES
MD5
SM3
SM4
SM3SUM
window function
DIGITAL-MASKING
Aggregate Functions
GROUP_CONCAT
BITMAP_UNION
APPROXCOUNTDISTINCT
MIN
STDDEV,STDDEV_POP
MAX
PERCENTILE
VARIANCE,VARPOP,VARIANCEPOP
AVG
SUM
COUNT
VARIANCESAMP,VARIANCESAMP
TOPN
HLLUNIONAGG
PERCENTILE_APPROX
STDDEV_SAMP
bitmap functions
bitmapsubsetin_range
bitmap_and
bitmap_empty
bitmaptostring
bitmap_xor
bitmap_hash
bitmaphasany
bitmapxorcount
orthogonalbitmapunion_count
bitmaphasall
bitmapsubsetlimit
bitmapandcount
sub_bitmap
bitmapfromstring
bitmapandnot_count
bitmaporcount
bitmap_intersect
bitmap_not
to_bitmap
bitmap_or
bitmap_max
bitmapandnot
orthogonalbitmapintersect
bitmap_contains
bitmap_union
orthogonalbitmapintersect_count
bitwise function
bitnot
bitxor
bitor
bitand
Date Time Functions
Dayofyear
to_days
day
Monthname
curdate
date_format
weekday
week
dayname
makedate
datediff
timediff
unix_timestamp
time_round
Strtodate
Dayofmonth
yearweek
second
timestampadd
hour
year
date_add
from_days
from_unixtime
month
current_timestamp
weekofyear
date_sub
timestampdiff
dayofweek
minute
utc_timestamp
now
Hash Functions
murmurhash332
json function
getjsondouble
json_quote
json_array
getjsonint
json_object
getjsonstring
Math Functions
pmod
conv
Sptial Functions
ST_AsText,ST_AsWKT
`ST_Contains’
ST_Distance_Sphere
ST_Y
ST_X
ST_Circle
ST_GeometryFromText,ST GeomFromText
St_Point’
ST_LineFromText,ST_LineStringFromText
ST_Polygon,ST_PolyFromText,ST_PolygonFromText
String Functions
unhex
lpad
left
instr
hex
ASCII
replace
concat
lower
split_part
CHAR_LENGTH
ltrim
ends_with
length
appendtrailingcharifabsent
money_format
REVERSE
strright
rpad
nullorempty
locate
Concat_ws
strleft
regular match
not regexp
regexp_extract
regexp
regexp_replace
right
findinset
substring
repeat
starts_with
lcase
bit_length
fuzzy match
like
not like
table functions
explodejsonarray
explode_split
explode_bitmap
SQL Statements
Account Management
CREATE ROLE
SHOW GRANTS
SHOW ROLES
DROP ROLE
SET PASSWORD
SET PROPERTY
REVOKE
DROP USER
CREATE USER
Grant
Administration
SHOW BROKER
SET LDAPADMINPASSWORD
ADMIN COMPACT
INSTALL PLUGIN
ADMIN SHOW REPLICA DISTRIBUTION
SHOW TRASH
ENTER
UNINSTALL PLUGIN
ADMIN SHOW CONFIG
ALTER CLUSTER
SHOW FULL COLUMNS
MIGRATE DATABASE
SHOW PLUGINS
DROP CLUSTER
ADMIN CHECK TABLET
SHOW BACKENDS
SHOW TABLE STATUS
ADMIN SET CONFIG
ADMIN REPAIR
DROP FILE
LINK DATABASE
SHOW INDEX
ADMIN CANCEL REPAIR
SHOW FILE
ALTER SYSTEM
CREATE FILE
CANCEL DECOMMISSION
ADMIN SET REPLICA STATUS
ADMIN SHOW REPLICA STATUS
SHOW MIGRATIONS
SHOW FRONTENDS
ADMIN CLEAN TRASH
CREATE CLUSTER
Data Definition
ALTER DATABASE
CANCEL RESTORE
CANCEL ALTER
CREATE FUNCTION
CREATE INDEX
DROP INDEX
BACKUP
CREATE REPOSITORY
CREATE MATERIALIZED VIEW
REFRESH TABLE
CREATE ENCRYPTKEY
REFRESH DATABASE
DROP ENCRYPTKEY
SHOW ENCRYPTKEYS
SHOW FUNCTIONS
DROP TABLE
DROP REPOSITORY
CREATE TABLE
TRUNCATE TABLES
ALTER VIEW
DROP DATABASE
HLL
DROP FUNCTION
CREATE VIEW
RESTORE
DROP VIEW
CREATE TABLE LIKE
RECOVER
CANCEL BACKUP
Colocate Join
DROP MATERIALIZED VIEW
CREATE DATABASE
ALTER TABLE
Data Manipulation
MULTI LOAD
SHOW SYNC JOB
LOAD
SHOW DATA
STOP SYNC JOB
Cancel Label
SHOW TABLE CREATION
STOP ROUTINE LOAD
SHOW PARTITIONS
BEGIN
OUTFILE
UPDATE
SHOW TABLET
Lateral View
ROUTINE LOAD
SHOW REPOSITORIES
CANCEL DELETE
SHOW DATA SKEW
CANCEL LOAD
SHOW BACKUP
CREATE SYNC JOB
SHOW DATABASES
GET LABEL STATE
DELETE
PAUSE ROUTINE LOAD
SHOW DELETE
SHOW LAST INSERT
RESTORE TABLET
GROUP BY
EXPORT
RESUME ROUTINE LOAD
SHOW PROPERTY
MINI LOAD
SHOW LOAD
SHOW RESTORE
SHOW DYNAMIC PARTITION TABLES
SHOW ROUTINE LOAD
SHOW TABLES
INSERT
SHOW TRANSACTION
SHOW SNAPSHOT
STREAM LOAD
SHOW CREATE FUNCTION
RESUME SYNC JOB
SHOW EXPORT
SHOW ROUTINE LOAD TASK
BROKER LOAD
SHOW CREATE ROUTINE LOAD
ALTER ROUTINE LOAD
SHOW ALTER
PAUSE SYNC JOB
Data Types
DATETIME
SMALLINT
INT
CHAR
DECIMAL
BITMAP
date
FLOAT
VARCHAR
BIGINT
BOOLEAN
STRING
Double
HLL (HyperLogLog)
TINYINT
Utility
Describe
暂无相关搜索结果！
本文档使用
全库网
构建
×
思维导图备注
×
文章二维码
手机扫一扫，轻松掌上读
×
文档下载
请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
PDF
文档
EPUB
文档
MOBI
文档
×
书签列表
×
阅读记录
阅读进度:
0.00%
(
0/0
)
重置阅读进度
我的书签
添加书签
移除书签