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