Bulk Operation

SPARK-30375 Support window frame ORDER BY i ROWS BETWEEN (('foo' < 'foobar')::integer) PRECEDING AND CURRENT ROW

SPARK-30375 Support submit sql content only contains comments.

SPARK-30375 Trim the string when cast string type to booleans

SPARK-30375 Add built-in Array Functions: array_fill

SPARK-30375 Add built-in Array Functions: array_dims

SPARK-30375 Add built-in Array Functions: array_ndims

SPARK-30375 Add built-in Array Functions: array_append

SPARK-30375 interval `1. second` should be invalid as PostgreSQL

SPARK-30375 Add built-in Array Functions: array_cat

SPARK-30375 Add built-in Array Functions: array_length

SPARK-30375 Spark trunc() func does not support for number group as PostgreSQL

SPARK-30375 Support truncate multiple tables

SPARK-30375 Concat for array in Spark SQL is not the one in PostgreSQL but array_cat

SPARK-30375 Support PARTITION BY [RANGE|LIST|HASH] and PARTITION OF in CREATE TABLE

SPARK-30375 Support [CREATE|DROP] RULE - define a new plan rewrite rule

SPARK-30375 Support User-defined Types

SPARK-30375 Support SELECT statements in VALUES of INSERT INTO

SPARK-30375 Support bit string types/literals

SPARK-30375 Support geometric types

SPARK-30375 Support ALTER TABLE [relname] SET SCHEMA [dbname]

SPARK-30375 Bankers' rounding for double types

SPARK-30375 extract support interval type

SPARK-30375 String function: string_to_array

SPARK-30375 Add make_interval() function

SPARK-30375 Add the justify_days(), justify_hours() and justify_interval() functions

SPARK-30375 Copy data between a file and a table

SPARK-30375 Return seconds with fraction from `date_part`/`extract`

SPARK-30375 Table inheritance

SPARK-30375 Implement more text pattern operators

SPARK-30375 Support field synonyms at `extract`

SPARK-30375 System Information Functions

SPARK-30375 Aggregate Functions for Statistics

SPARK-30375 Hypothetical-Set Aggregate Functions

SPARK-30375 Support `dow`, `isodow` and `doy` at `extract()`

SPARK-30375 Data Type Formatting Functions: `to_char`

SPARK-30375 substr returns different values

SPARK-30375 Missing escape_string_warning and standard_conforming_strings config

SPARK-30375 Implement ILIKE operator

SPARK-30375 Support more Postgres JSON functions

SPARK-30375 Array indexing is 1-based

SPARK-30375 Add built-in Array Functions: element to array concatenation

SPARK-30375 Add built-in Array Functions: array_upper

SPARK-30375 SELECT DISTINCT ON ( expression [, ...] ) syntax

SPARK-30375 Array Functions: unnest

SPARK-30375 NULLS FIRST for DESC and NULLS LAST for ASC

SPARK-30375 The LOG function using 10 as the base, but Spark using E

SPARK-30375 Built-in Mathematical Functions: SCALE

SPARK-30375 Fully support char and varchar types

SPARK-30375 Difference of interval type conversion between SparkSQL and PostgreSQL

SPARK-30375 Support RETURNING cause

SPARK-30375 Support IS OF (<type>) predicate

SPARK-30375 Data Type Formatting Functions: `to_number`

SPARK-30375 Trigonometric Functions

SPARK-30375 Hyperbolic Functions

SPARK-30375 Support TRIM(trimStr FROM str) syntax

SPARK-30375 String Functions: Add support btrim

SPARK-30375 Binary String Functions: SHA functions

SPARK-30375 String Functions: decode/encode can not accept 'escape' and 'hex' as charset

SPARK-30375 String Functions: Enhance LPAD/RPAD function

SPARK-30375 String Functions: Add support split_part

SPARK-30375 Adds `random()` sql function

SPARK-30375 String Functions: Add support other 4 REGEXP functions

SPARK-30375 String Functions: SUBSTRING support regular expression

SPARK-30375 String Functions: Enhance TRIM function

SPARK-30375 Support for converting float/double to binary format

SPARK-30375 Add built-in String Functions: quote_literal

SPARK-30375 Support negative length at LEFT/RIGHT SQL functions

SPARK-30375 Cast numeric to integral type need round

SPARK-30375 Missing some mathematical operators

SPARK-30375 Caret operator (^) means bitwise XOR in Spark/Hive and exponentiation in Postgres/Redshift

SPARK-30375 Ordered-Set Aggregate Functions

SPARK-30375 Add built-in Aggregate Functions: string_agg

SPARK-30375 Add built-in Array Functions: array_append

SPARK-30375 Support ANSI Aggregate Function: array_agg

SPARK-30375 String Functions: regexp_replace is not compatible

SPARK-30375 Support SUBSTRING(str FROM n1 [FOR n2]) syntax

SPARK-30375 Accept 'on' and 'off' as input for boolean data type

SPARK-30375 List all built-in UDFs have different names

SPARK-30375 Implement boolean aggregates(BOOL_AND, BOOL_OR and EVERY)

SPARK-30375 Implement bitwise integer aggregates(BIT_AND and BIT_OR)

SPARK-30375 Support ARRAY(sub-SELECT) expressions

SPARK-30375 Infinity, -Infinity, NaN should be recognized in a case insensitive manner

SPARK-30375 Built-in function: generate_series

SPARK-30375 Data type: POINT(x, y)

SPARK-30375 Type Casts: expression::type

SPARK-30375 Built-in SQL Function Support - WIDTH_BUCKET