|
|
|
SPARK-33126
|
SPARK-27764
Simplify offset window function(Remove direction field)
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-33125
|
SPARK-27764
Improve the error when Lead and Lag are not allowed to specify window frame
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-32760
|
SPARK-27764
Support for INET data type
|
Unassigned
|
Ruslan Dautkhanov
|
|
Resolved |
Later
|
|
|
|
|
|
|
|
SPARK-31617
|
SPARK-27764
support drop multiple functions
|
Unassigned
|
jobit mathew
|
|
Open |
Unresolved
|
|
|
30/May/20
|
|
|
|
|
SPARK-30796
|
SPARK-27764
Add parameter position for REGEXP_REPLACE
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-30189
|
SPARK-27764
Interval from year-month/date-time string handling whitespaces
|
Kent Yao 2
|
Kent Yao 2
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-30182
|
SPARK-27764
Support nested aggregates
|
Unassigned
|
Jiaan Geng
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-30026
|
SPARK-27764
Support all whitespaces as delimiter for inside a interval value
|
Kent Yao 2
|
Kent Yao 2
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-30000
|
SPARK-27764
Trim the string when cast string type to decimals
|
Kent Yao 2
|
Kent Yao 2
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-29980
|
SPARK-27764
Whitespaces handling for Cast and BinaryOperation between StringType and NumericTypes
|
Unassigned
|
Kent Yao 2
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-29713
|
SPARK-27764
Support Interval Unit Abbreviations in Interval Literals
|
Unassigned
|
Kent Yao 2
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-29708
|
SPARK-27764
Different answers in aggregates of duplicate grouping sets
|
Takeshi Yamamuro
|
Takeshi Yamamuro
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-29706
|
SPARK-27764
Support an empty grouping expression
|
Unassigned
|
Takeshi Yamamuro
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29705
|
SPARK-27764
Support more expressive forms in GroupingSets/Cube/Rollup
|
Unassigned
|
Takeshi Yamamuro
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29704
|
SPARK-27764
Support the combinations of grouping operations
|
Unassigned
|
Takeshi Yamamuro
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29703
|
SPARK-27764
Support grouping() in GROUP BY without GroupingSets/Cube/Rollup
|
Unassigned
|
Takeshi Yamamuro
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29702
|
SPARK-27764
Resolve group-by columns with integrity constraints
|
Unassigned
|
Takeshi Yamamuro
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29700
|
SPARK-27764
Support nested grouping sets
|
Unassigned
|
Takeshi Yamamuro
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29699
|
SPARK-27764
Different answers in nested aggregates with window functions
|
Unassigned
|
Takeshi Yamamuro
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29698
|
SPARK-27764
Support grouping function with multiple arguments
|
Unassigned
|
Takeshi Yamamuro
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29688
|
SPARK-27764
Support average with interval type values
|
Unassigned
|
Kent Yao 2
|
|
Reopened |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29684
|
SPARK-27764
Support divide/multiply for interval types
|
Unassigned
|
Kent Yao 2
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-29679
|
SPARK-27764
Make interval type camparable and orderable
|
Kent Yao 2
|
Kent Yao 2
|
|
Resolved |
Won't Do
|
|
|
|
|
|
|
|
SPARK-29663
|
SPARK-27764
Support sum with interval type values
|
Unassigned
|
Kent Yao 2
|
|
Reopened |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29661
|
SPARK-27764
Support cascaded syntax in CREATE SCHEMA
|
Unassigned
|
Takeshi Yamamuro
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-29660
|
SPARK-27764
Dropping columns and changing column names/types are prohibited in VIEW definition
|
Unassigned
|
Takeshi Yamamuro
|
|
Resolved |
Invalid
|
|
|
|
|
|
|
|
SPARK-29659
|
SPARK-27764
Support COMMENT ON syntax
|
Unassigned
|
Takeshi Yamamuro
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29650
|
SPARK-27764
Discard a NULL constant in LIMIT
|
Unassigned
|
Takeshi Yamamuro
|
|
Resolved |
Invalid
|
|
|
|
|
|
|
|
SPARK-29638
|
SPARK-27764
Spark handles 'NaN' as 0 in sums
|
Unassigned
|
Dylan Guedes
|
|
Resolved |
Cannot Reproduce
|
|
|
|
|
|
|
|
SPARK-29636
|
SPARK-27764
Can't parse '11:00 BST' or '2000-10-19 10:23:54+01' signatures to timestamp
|
Unassigned
|
Dylan Guedes
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29633
|
SPARK-27764
Make COLUMN optional in ALTER TABLE
|
Unassigned
|
Takeshi Yamamuro
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29630
|
SPARK-27764
Not allowed to create a permanent view by referencing a temporary view in EXISTS
|
Terry Kim
|
Takeshi Yamamuro
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-29629
|
SPARK-27764
Support typed integer literal expression
|
Unassigned
|
Kent Yao 2
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-29628
|
SPARK-27764
Forcibly create a temporary view in CREATE VIEW if referencing a temporary view
|
Unassigned
|
Takeshi Yamamuro
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-29591
|
SPARK-27764
Support data insertion in a different order if you wish or even omit some columns in spark sql also like postgresql
|
Unassigned
|
jobit mathew
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29584
|
SPARK-27764
NOT NULL is not supported in Spark
|
Unassigned
|
ABHISHEK KUMAR GUPTA
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-29573
|
SPARK-27764
Spark should work as PostgreSQL when using + Operator
|
Unassigned
|
ABHISHEK KUMAR GUPTA
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-29540
|
SPARK-27764
Thrift in some cases can't parse string to date
|
Unassigned
|
Dylan Guedes
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-29524
|
SPARK-27764
Unordered interval units
|
Unassigned
|
Max Gekk
|
|
In Progress |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29451
|
SPARK-27764
Some queries with divisions in SQL windows are failling in Thrift
|
Unassigned
|
Dylan Guedes
|
|
Resolved |
Cannot Reproduce
|
|
|
|
|
|
|
|
SPARK-29408
|
SPARK-27764
Support interval literal with negative sign `-`
|
Max Gekk
|
Max Gekk
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-29407
|
SPARK-27764
Support syntax for zero interval
|
Unassigned
|
Max Gekk
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29406
|
SPARK-27764
Interval output styles
|
Unassigned
|
Max Gekk
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29395
|
SPARK-27764
Precision of the interval type
|
Unassigned
|
Max Gekk
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29394
|
SPARK-27764
Support ISO 8601 format for intervals
|
Unassigned
|
Max Gekk
|
|
In Progress |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29391
|
SPARK-27764
Default year-month units
|
Unassigned
|
Max Gekk
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-29389
|
SPARK-27764
Support synonyms for interval units
|
Unassigned
|
Max Gekk
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29388
|
SPARK-27764
Construct intervals from the `millenniums`, `centuries` or `decades` units
|
Unassigned
|
Max Gekk
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29385
|
SPARK-27764
Make `INTERVAL` values comparable
|
Unassigned
|
Max Gekk
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-29384
|
SPARK-27764
Support `ago` in interval strings
|
Unassigned
|
Max Gekk
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29383
|
SPARK-27764
Support the optional prefix `@` in interval strings
|
Unassigned
|
Max Gekk
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29382
|
SPARK-27764
Support writing `INTERVAL` type to datasource table
|
Unassigned
|
Max Gekk
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29371
|
SPARK-27764
Support interval field values with fractional parts
|
Unassigned
|
Max Gekk
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-29370
|
SPARK-27764
Interval strings without explicit unit markings
|
Unassigned
|
Max Gekk
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29369
|
SPARK-27764
Accept strings without `interval` prefix in casting to intervals
|
Max Gekk
|
Max Gekk
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-29342
|
SPARK-27764
Make casting strings to intervals case insensitive
|
Max Gekk
|
Max Gekk
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-29119
|
SPARK-27764
DEFAULT option is not supported in Spark
|
Unassigned
|
ABHISHEK KUMAR GUPTA
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-29117
|
SPARK-27764
char data type should support in Spark
|
Unassigned
|
ABHISHEK KUMAR GUPTA
|
|
Closed |
Won't Do
|
|
|
|
|
|
|
|
SPARK-29034
|
SPARK-27764
String Constants with C-style Escapes
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29025
|
SPARK-27764
Support seconds precision by the timestamp type
|
Unassigned
|
Max Gekk
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29024
|
SPARK-27764
Ignore case while resolving time zones
|
Unassigned
|
Max Gekk
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29006
|
SPARK-27764
Support special date/timestamp values `infinity`/`-infinity`
|
Unassigned
|
Max Gekk
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28973
|
SPARK-27764
Add TimeType to Catalyst
|
Unassigned
|
Max Gekk
|
|
Closed |
Won't Do
|
|
|
|
|
|
|
|
SPARK-28754
|
SPARK-27764
[UDF] Supports for alter, rename, owner change should be supported in Spark
|
Unassigned
|
ABHISHEK KUMAR GUPTA
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28731
|
SPARK-27764
Support limit on recursive queries
|
Unassigned
|
Peter Toth
|
|
Resolved |
Later
|
|
|
|
|
|
|
|
SPARK-28664
|
SPARK-27764
ORDER BY in aggregate function
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28648
|
SPARK-27764
Adds support to `groups` unit type in window clauses
|
Unassigned
|
Dylan Guedes
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28646
|
SPARK-27764
Allow usage of `count` only for parameterless aggregate function
|
Jiaan Geng
|
Dylan Guedes
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28645
|
SPARK-27764
Throw an error on window redefinition
|
Jiaan Geng
|
Dylan Guedes
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28602
|
SPARK-27764
Recognize interval as a numeric type
|
Unassigned
|
Dylan Guedes
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-28566
|
SPARK-27764
window functions should not be allowed in window definitions
|
Unassigned
|
Dylan Guedes
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-28557
|
SPARK-27764
Support empty select list
|
Unassigned
|
Yuming Wang
|
|
Closed |
Duplicate
|
|
|
|
|
|
|
|
SPARK-28553
|
SPARK-27764
subqueries must be aggregated before hand
|
Unassigned
|
Dylan Guedes
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-28508
|
SPARK-27764
Support for range frame+row frame in the same query
|
Unassigned
|
Dylan Guedes
|
|
Resolved |
Invalid
|
|
|
|
|
|
|
|
SPARK-28506
|
SPARK-27764
not handling usage of group function and window function at some conditions
|
Unassigned
|
Dylan Guedes
|
|
Resolved |
Cannot Reproduce
|
|
|
|
|
|
|
|
SPARK-28501
|
SPARK-27764
frame bound must be a literal
|
Unassigned
|
Dylan Guedes
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28490
|
SPARK-27764
Support `TIME` type in Spark
|
Unassigned
|
Zhu, Lipeng
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-28471
|
SPARK-27764
Formatting dates with negative years
|
Max Gekk
|
Max Gekk
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28461
|
SPARK-27764
Pad Decimal numbers with trailing zeros to the scale of the column
|
Yuming Wang
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28453
|
SPARK-27764
Support recursive view syntax
|
Unassigned
|
Peter Toth
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-28437
|
SPARK-27764
Different format when casting interval type to string type
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28435
|
SPARK-27764
Support accepting the interval keyword in the schema string
|
Yuming Wang
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28429
|
SPARK-27764
SQL Datetime util function being casted to double instead of timestamp
|
Unassigned
|
Dylan Guedes
|
|
Reopened |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28428
|
SPARK-27764
Spark `exclude` always expecting `()`
|
Unassigned
|
Dylan Guedes
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28425
|
SPARK-27764
Add more Date/Time Operators
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28424
|
SPARK-27764
Support typed interval expression
|
Yuming Wang
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28409
|
SPARK-27764
SELECT FROM syntax
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28405
|
SPARK-27764
Join with USING caluse doesn't hide original tables
|
Unassigned
|
Peter Toth
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28395
|
SPARK-27764
Division operator support integral division
|
Yuming Wang
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28389
|
SPARK-27764
Use Java 8 API to add months to dates
|
Max Gekk
|
Max Gekk
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28379
|
SPARK-27764
Correlated scalar subqueries must be aggregated
|
Allison Wang
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28318
|
SPARK-27764
Decimal can only support precision up to 38
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28316
|
SPARK-27764
Decimal precision issue
|
Unassigned
|
Yuming Wang
|
|
Resolved |
Later
|
|
|
|
|
|
|
|
SPARK-28315
|
SPARK-27764
Decimal can not accept NaN as input
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28307
|
SPARK-27764
Support Interval comparison
|
Unassigned
|
Dongjoon Hyun
|
|
Closed |
Duplicate
|
|
|
|
|
|
|
|
SPARK-28299
|
SPARK-27764
Evaluation of multiple CTE uses
|
Unassigned
|
Peter Toth
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-28297
|
SPARK-27764
Handling outer links in CTE subquery expressions
|
Unassigned
|
Peter Toth
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28296
|
SPARK-27764
Improved VALUES support
|
Unassigned
|
Peter Toth
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28259
|
SPARK-27764
Date/Time Output Styles and Date Order Conventions
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28253
|
SPARK-27764
Date/Timestamp type have different low value and high value with Spark
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28228
|
SPARK-27764
Fix substitution order of nested WITH clauses
|
Peter Toth
|
Peter Toth
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28107
|
SPARK-27764
Interval type conversion syntax support
|
Zhu, Lipeng
|
Zhu, Lipeng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28068
|
SPARK-27764
`lag` second argument must be a literal
|
Unassigned
|
Dylan Guedes
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28065
|
SPARK-27764
ntile only accepting positive (>0) values
|
Unassigned
|
Dylan Guedes
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28064
|
SPARK-27764
Order by does not accept a call to rank()
|
Unassigned
|
Dylan Guedes
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28060
|
SPARK-27764
Float/Double type can not accept some special inputs
|
Unassigned
|
Yuming Wang
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-28033
|
SPARK-27764
String concatenation should low priority than other operators
|
Unassigned
|
Yuming Wang
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-28023
|
SPARK-27764
Trim the string when cast string type to other types
|
Kent Yao 2
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28010
|
SPARK-27764
Support ORDER BY ... USING syntax
|
Unassigned
|
Lantao Jin
|
|
Resolved |
Workaround
|
|
|
|
|
|
|
|
SPARK-28002
|
SPARK-27764
Support WITH clause column aliases
|
Peter Toth
|
Peter Toth
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-27987
|
SPARK-27764
Support POSIX Regular Expressions
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-27923
|
SPARK-27764
List all cases that PostgreSQL throws an exception but Spark SQL is NULL
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-27769
|
SPARK-27764
Handling of sublinks within outer-level aggregates.
|
Unassigned
|
Xiao Li
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-27578
|
SPARK-27764
Support INTERVAL ... HOUR TO SECOND syntax
|
Zhu, Lipeng
|
Zhu, Lipeng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-23264
|
SPARK-27764
Support interval values without INTERVAL clauses
|
Takeshi Yamamuro
|
Takeshi Yamamuro
|
|
Resolved |
Later
|
|
|
|
|
|
|
|
SPARK-20856
|
SPARK-27764
support statement using nested joins
|
Unassigned
|
N Campbell
|
|
Reopened |
Unresolved
|
|
|
|
|