[SQL] Missing SQL functions

[mihaibudiu]

This is a list of functions that we plan to add to the SQL compiler in the near future. The functions must be already supported by Calcite. https://calcite.apache.org/docs/reference.html Not all of these have the same priority. For example, we probably won't do XML until we have use cases.

• [x] ACOSH
• [x] ARRAY_APPEND
• [x] ARRAY_COMPACT
• [x] ARRAY_CONCAT
• [x] ARRAY_CONTAINS
• [x] ARRAY_DISTINCT
• [x] ARRAY_EXCEPT
• [x] ARRAY_INSERT
• [x] ARRAY_INSERSECT
• [x] ARRAY_MAX
• [x] ARRAY_MIN
• [x] ARRAY_POSITION
• [x] ARRAY_REMOVE
• [x] ARRAY_PREPEND
• [x] ARRAY_REPEAT
• [x] ARRAY_REVERSE
• [ ] ARRAY_UNION
• [x] ARRAYS_OVERLAP
• [ ] ARRAYS_ZIP
• [x] SORT_ARRAY
• [x] ASINH
• [x] ATANH
• [ ] BIT_LENGTH
• [ ] BIT_GET
• [ ] CODE_POINTS_TO_BYTES
• [ ] CODE_POINTS_TO_STRINGS
• [ ] CONCAT_WS
• [ ] COMPRESS
• [x] COSH
• [x] COTH
• [x] CSC
• [x] CSCH
• [ ] DECODE
• [ ] EXTRACT
• [ ] EXISTSNODE
• [x] EXP
• [ ] EXTRACTVALUE
• [ ] FACTORIAL
• [ ] FIND_IN_SET
• [ ] FORMAT_DATE
• [ ] FORMAT_DATETIME
• [ ] FORMAT_NUMBER
• [ ] FORMAT_TIME
• [ ] GETBIT
• [ ] IF
• [ ] IFNULL
• [ ] INSTR
• [x] IS_INF
• [x] IS_NAN
• [x] LOG
• [ ] TO_BASE32
• [ ] FROM_BASE32
• [ ] TO_BASE64
• [ ] FROM_BASE64
• [ ] MD5
• [ ] PARSE_DATE
• [ ] PARSE_DATETIME
• [ ] PARSE_TIME
• [ ] PARSE_URL
• [ ] REGEXP_EXTRACT
• [ ] REGEXP_EXTRACT_ALL
• [ ] REGEXP_INSTR
• [ ] REGEXP_REPLACE
• [ ] REGEXP_SUBSTR
• [ ] REVERSE
• [ ] RPAD
• [ ] RTRIM
• [x] SEC
• [x] SECH
• [ ] SHA1
• [ ] SHA256
• [ ] SHA512
• [x] SINH
• [ ] SPACE
• [ ] STRCMP
• [ ] STRPOS
• [x] TAHN
• [ ] TO_CODE_POINTS
• [ ] TO_DATE
• [ ] TO_TIMESTAMP
• [ ] TRANSLATE
• [ ] URL_DECODE
• [ ] URL_ENCODE
• [ ] XMLTRANSFORM

[Drsynos]

check schema , missing permissions, incorrect database, incorrect syntax, missing package

if there is problem in database so you will need to prefix the function name with the database name like this

database_name.schema_name.function_name() .