Statements (106)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
SQL dialect
|
| gptkbp:basedOn |
gptkb:PostgreSQL
|
| gptkbp:compatibleWith |
gptkb:JDBC
gptkb:ODBC BI tools |
| gptkbp:function |
gptkb:MAX
gptkb:LEAD gptkb:CAST gptkb:LAG gptkb:MIN gptkb:CASE gptkb:MD5 gptkb:SHA1 gptkb:TRIM gptkb:AVG gptkb:LIMIT gptkb:RANK gptkb:HASH gptkb:NVL REPLACE GROUP BY ORDER BY SUM DISTINCT APPROXIMATE COUNT DISTINCT CASE WHEN CHARINDEX COALESCE CONCAT CONCAT_WS COUNT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP DATEADD DATEDIFF DATE_TRUNC DECODE EXTRACT GETDATE GREATEST INITCAP ISNULL JSON_EXTRACT_PATH_TEXT JSON_PARSE LEAST LEFT LISTAGG LOWER LPAD NTILE NULLIF NULLIFZERO NVL2 PERCENTILE_CONT PERCENTILE_DISC POSITION REGEXP REGEXP_COUNT REGEXP_INSTR REGEXP_REPLACE REGEXP_SUBSTR REVERSE RIGHT ROW_NUMBER RPAD SPLIT_PART STDDEV SUBSTRING SYSDATE TO_CHAR TO_DATE TO_TIMESTAMP UPPER VARIANCE ZEROIFNULL |
| https://www.w3.org/2000/01/rdf-schema#label |
Amazon Redshift SQL
|
| gptkbp:supports |
gptkb:CTAS_(CREATE_TABLE_AS_SELECT)
time travel data warehousing federated queries subqueries OLAP materialized views stored procedures user-defined functions window functions SQL queries columnar storage data types joins concurrency scaling RA3 nodes COPY command DISTKEY JSON functions SORTKEY Spectrum (external tables) UNLOAD command VACUUM command analyze command compression encodings distribution styles |
| gptkbp:usedBy |
gptkb:Amazon_Redshift
|
| gptkbp:bfsParent |
gptkb:Amazon_Redshift_ML
|
| gptkbp:bfsLayer |
6
|