[jira] [Commented] (SPARK-29713) Support Interval Unit Abbreviations in Interval Literals

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17004671#comment-17004671 ] Takeshi Yamamuro commented on SPARK-29713: -- I'll close this because the corresponding pr has

[jira] [Resolved] (SPARK-29713) Support Interval Unit Abbreviations in Interval Literals

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-29713. -- Resolution: Won't Fix > Support Interval Unit Abbreviations in Interval Literals >

[jira] [Resolved] (SPARK-27930) List all built-in UDFs have different names

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-27930. -- Resolution: Duplicate > List all built-in UDFs have different names >

[jira] [Commented] (SPARK-27930) List all built-in UDFs have different names

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17004669#comment-17004669 ] Takeshi Yamamuro commented on SPARK-27930: -- This ticket is not obvious and it seems this ticket

[jira] [Updated] (SPARK-27930) List all built-in UDFs have different names

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27930: - Parent Issue: SPARK-30375 (was: SPARK-27764) > List all built-in UDFs have different

[jira] [Updated] (SPARK-27764) Feature Parity between PostgreSQL and Spark

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27764: - Description: PostgreSQL is one of the most advanced open source databases. This

[jira] [Updated] (SPARK-27764) Feature Parity between PostgreSQL and Spark

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27764: - Description: PostgreSQL is one of the most advanced open source databases. This

[jira] [Updated] (SPARK-27764) Feature Parity between PostgreSQL and Spark

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27764: - Description: PostgreSQL is one of the most advanced open source databases. This

[jira] [Updated] (SPARK-27764) Feature Parity between PostgreSQL and Spark

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27764: - Description: PostgreSQL is one of the most advanced open source databases. This

[jira] [Updated] (SPARK-28377) Fully support correlation names in the FROM clause

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28377: - Parent Issue: SPARK-30374 (was: SPARK-27764) > Fully support correlation names in the

[jira] [Updated] (SPARK-29737) Concat for array in Spark SQL is not the one in PostgreSQL but array_cat

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29737: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Concat for array in Spark SQL is not

[jira] [Updated] (SPARK-28448) Implement ILIKE operator

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28448: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Implement ILIKE operator >

[jira] [Updated] (SPARK-27879) Implement bitwise integer aggregates(BIT_AND and BIT_OR)

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27879: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Implement bitwise integer

[jira] [Updated] (SPARK-29849) Spark trunc() func does not support for number group as PostgreSQL

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29849: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Spark trunc() func does not support for

[jira] [Updated] (SPARK-28007) Caret operator (^) means bitwise XOR in Spark/Hive and exponentiation in Postgres/Redshift

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28007: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Caret operator (^) means bitwise XOR in

[jira] [Commented] (SPARK-28147) Support RETURNING cause

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17004665#comment-17004665 ] Takeshi Yamamuro commented on SPARK-28147: -- I'll close for now because I think this feature is

[jira] [Resolved] (SPARK-28147) Support RETURNING cause

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-28147. -- Resolution: Won't Fix > Support RETURNING cause > --- > >

[jira] [Updated] (SPARK-28147) Support RETURNING cause

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28147: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Support RETURNING cause >

[jira] [Updated] (SPARK-28298) Fully support char and varchar types

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28298: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Fully support char and varchar types >

[jira] [Commented] (SPARK-28061) Support for converting float/double to binary format

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17004664#comment-17004664 ] Takeshi Yamamuro commented on SPARK-28061: -- I'll close this because these functions are

[jira] [Resolved] (SPARK-28061) Support for converting float/double to binary format

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-28061. -- Resolution: Won't Fix > Support for converting float/double to binary format >

[jira] [Updated] (SPARK-28061) Support for converting float/double to binary format

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28061: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Support for converting float/double to

[jira] [Updated] (SPARK-27880) Implement boolean aggregates(BOOL_AND, BOOL_OR and EVERY)

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27880?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27880: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Implement boolean aggregates(BOOL_AND,

[jira] [Resolved] (SPARK-29718) Support PARTITION BY [RANGE|LIST|HASH] and PARTITION OF in CREATE TABLE

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-29718. -- Resolution: Won't Fix > Support PARTITION BY [RANGE|LIST|HASH] and PARTITION OF in

[jira] [Commented] (SPARK-29718) Support PARTITION BY [RANGE|LIST|HASH] and PARTITION OF in CREATE TABLE

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29718?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17004661#comment-17004661 ] Takeshi Yamamuro commented on SPARK-29718: -- I'll close this for now because I think this is

[jira] [Updated] (SPARK-28690) Date/Time Functions: date_part for timestamps

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28690: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Date/Time Functions: date_part for

[jira] [Updated] (SPARK-28663) Aggregate Functions for Statistics

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28663: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Aggregate Functions for Statistics >

[jira] [Updated] (SPARK-29514) String function: string_to_array

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29514: - Parent Issue: SPARK-30375 (was: SPARK-27764) > String function: string_to_array >

[jira] [Updated] (SPARK-28669) System Information Functions

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28669: - Parent Issue: SPARK-30375 (was: SPARK-27764) > System Information Functions >

[jira] [Updated] (SPARK-28661) Hypothetical-Set Aggregate Functions

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28661: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Hypothetical-Set Aggregate Functions >

[jira] [Resolved] (SPARK-29892) Add built-in Array Functions: array_cat

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-29892. -- Resolution: Duplicate > Add built-in Array Functions: array_cat >

[jira] [Updated] (SPARK-29892) Add built-in Array Functions: array_cat

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29892: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add built-in Array Functions: array_cat

[jira] [Updated] (SPARK-28516) Data Type Formatting Functions: `to_char`

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28516: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Data Type Formatting Functions:

[jira] [Updated] (SPARK-28459) Date/Time Functions: make_timestamp

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28459: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Date/Time Functions: make_timestamp >

[jira] [Updated] (SPARK-28432) Add `make_date` function

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28432?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28432: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add `make_date` function >

[jira] [Updated] (SPARK-28427) Support more Postgres JSON functions

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28427: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Support more Postgres JSON functions >

[jira] [Updated] (SPARK-28420) Date/Time Functions: date_part for intervals

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28420?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28420: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Date/Time Functions: date_part for

[jira] [Updated] (SPARK-28429) SQL Datetime util function being casted to double instead of timestamp

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28429: - Parent Issue: SPARK-30375 (was: SPARK-27764) > SQL Datetime util function being casted

[jira] [Updated] (SPARK-28401) Add built-in Array Functions: element to array concatenation

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28401: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add built-in Array Functions: element

[jira] [Updated] (SPARK-28400) Add built-in Array Functions: array_upper

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28400: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add built-in Array Functions:

[jira] [Updated] (SPARK-28324) The LOG function using 10 as the base, but Spark using E

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28324: - Parent Issue: SPARK-30375 (was: SPARK-27764) > The LOG function using 10 as the base,

[jira] [Commented] (SPARK-28324) The LOG function using 10 as the base, but Spark using E

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17004653#comment-17004653 ] Takeshi Yamamuro commented on SPARK-28324: -- I'll close this based on the discussion above.

[jira] [Resolved] (SPARK-28324) The LOG function using 10 as the base, but Spark using E

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-28324. -- Resolution: Won't Fix > The LOG function using 10 as the base, but Spark using E >

[jira] [Updated] (SPARK-28317) Built-in Mathematical Functions: SCALE

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28317: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Built-in Mathematical Functions: SCALE

[jira] [Updated] (SPARK-28123) String Functions: Add support btrim

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28123?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28123: - Parent Issue: SPARK-30375 (was: SPARK-27764) > String Functions: Add support btrim >

[jira] [Updated] (SPARK-28134) Trigonometric Functions

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28134: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Trigonometric Functions >

[jira] [Updated] (SPARK-28121) String Functions: decode/encode can not accept 'escape' and 'hex' as charset

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28121: - Parent Issue: SPARK-30375 (was: SPARK-27764) > String Functions: decode/encode can not

[jira] [Updated] (SPARK-28075) String Functions: Enhance TRIM function

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28075: - Parent Issue: SPARK-30375 (was: SPARK-27764) > String Functions: Enhance TRIM function

[jira] [Updated] (SPARK-27952) String Functions: regexp_replace is not compatible

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27952: - Parent Issue: SPARK-30375 (was: SPARK-27764) > String Functions: regexp_replace is not

[jira] [Updated] (SPARK-27974) Add built-in Aggregate Function: array_agg

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27974: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add built-in Aggregate Function:

[jira] [Updated] (SPARK-28076) String Functions: SUBSTRING support regular expression

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28076: - Parent Issue: SPARK-30375 (was: SPARK-27764) > String Functions: SUBSTRING support

[jira] [Commented] (SPARK-28402) Array indexing is 1-based

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17004651#comment-17004651 ] Takeshi Yamamuro commented on SPARK-28402: -- I'll close for now because I think this is useless

[jira] [Updated] (SPARK-27980) Ordered-Set Aggregate Functions

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27980: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Ordered-Set Aggregate Functions >

[jira] [Updated] (SPARK-28402) Array indexing is 1-based

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28402: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Array indexing is 1-based >

[jira] [Resolved] (SPARK-28146) Support IS OF () predicate

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-28146. -- Resolution: Won't Fix > Support IS OF () predicate >

[jira] [Commented] (SPARK-28146) Support IS OF () predicate

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17004650#comment-17004650 ] Takeshi Yamamuro commented on SPARK-28146: -- I'll close for now because I think this is useless

[jira] [Updated] (SPARK-28146) Support IS OF () predicate

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28146: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Support IS OF () predicate >

[jira] [Updated] (SPARK-28322) DIV support decimal type

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28322: - Parent Issue: SPARK-30374 (was: SPARK-27764) > DIV support decimal type >

[jira] [Updated] (SPARK-28078) String Functions: Add support other 4 REGEXP functions

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28078: - Parent Issue: SPARK-30375 (was: SPARK-27764) > String Functions: Add support other 4

[jira] [Resolved] (SPARK-29715) Support SELECT statements in VALUES of INSERT INTO

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-29715. -- Resolution: Won't Fix > Support SELECT statements in VALUES of INSERT INTO >

[jira] [Commented] (SPARK-29715) Support SELECT statements in VALUES of INSERT INTO

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17004649#comment-17004649 ] Takeshi Yamamuro commented on SPARK-29715: -- I'll close this because this is pg-specific and

[jira] [Updated] (SPARK-29715) Support SELECT statements in VALUES of INSERT INTO

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29715: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Support SELECT statements in VALUES of

[jira] [Updated] (SPARK-19799) Support WITH clause in subqueries

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-19799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-19799: - Parent Issue: SPARK-30374 (was: SPARK-27764) > Support WITH clause in subqueries >

[jira] [Resolved] (SPARK-28500) adds support for `filter` clause

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-28500. -- Resolution: Duplicate > adds support for `filter` clause >

[jira] [Updated] (SPARK-28500) adds support for `filter` clause

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28500: - Parent Issue: SPARK-30374 (was: SPARK-27764) > adds support for `filter` clause >

[jira] [Updated] (SPARK-27768) Infinity, -Infinity, NaN should be recognized in a case insensitive manner

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27768: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Infinity, -Infinity, NaN should be

[jira] [Updated] (SPARK-28088) String Functions: Enhance LPAD/RPAD function

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28088?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28088: - Parent Issue: SPARK-30375 (was: SPARK-27764) > String Functions: Enhance LPAD/RPAD

[jira] [Updated] (SPARK-28296) Improved VALUES support

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28296: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Improved VALUES support >

[jira] [Resolved] (SPARK-29716) Support User-defined Types

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-29716. -- Resolution: Won't Fix > Support User-defined Types > -- > >

[jira] [Updated] (SPARK-29716) Support User-defined Types

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29716: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Support User-defined Types >

[jira] [Updated] (SPARK-29775) Support truncate multiple tables

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29775: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Support truncate multiple tables >

[jira] [Updated] (SPARK-28017) Enhance DATE_TRUNC

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28017: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Enhance DATE_TRUNC > --

[jira] [Updated] (SPARK-29632) Support ALTER TABLE [relname] SET SCHEMA [dbname]

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29632: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Support ALTER TABLE [relname] SET

[jira] [Updated] (SPARK-28333) NULLS FIRST for DESC and NULLS LAST for ASC

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28333: - Parent Issue: SPARK-30375 (was: SPARK-27764) > NULLS FIRST for DESC and NULLS LAST for

[jira] [Updated] (SPARK-29393) Add make_interval() function

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29393: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add make_interval() function >

[jira] [Updated] (SPARK-28329) SELECT INTO syntax

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28329?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28329: - Parent Issue: SPARK-30374 (was: SPARK-27764) > SELECT INTO syntax > --

[jira] [Updated] (SPARK-28382) Array Functions: unnest

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28382: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Array Functions: unnest >

[jira] [Updated] (SPARK-28122) Binary String Functions: SHA functions

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28122: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Binary String Functions: SHA

[jira] [Updated] (SPARK-27978) Add built-in Aggregate Functions: string_agg

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-27978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-27978: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add built-in Aggregate Functions:

[jira] [Updated] (SPARK-28087) String Functions: Add support split_part

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28087: - Parent Issue: SPARK-30375 (was: SPARK-27764) > String Functions: Add support

[jira] [Updated] (SPARK-29941) Support dec as shorthand for decimal

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29941: - Parent Issue: SPARK-30374 (was: SPARK-27764) > Support dec as shorthand for decimal >

[jira] [Updated] (SPARK-29926) interval `1. second` should be invalid as PostgreSQL

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29926: - Parent Issue: SPARK-30375 (was: SPARK-27764) > interval `1. second` should be invalid

[jira] [Updated] (SPARK-30147) Trim the string when cast string type to booleans

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-30147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-30147: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Trim the string when cast string type

[jira] [Commented] (SPARK-29717) Support [CREATE|DROP] RULE - define a new plan rewrite rule

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29717?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17004643#comment-17004643 ] Takeshi Yamamuro commented on SPARK-29717: -- I'll close this because I think this feature is

[jira] [Resolved] (SPARK-29717) Support [CREATE|DROP] RULE - define a new plan rewrite rule

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-29717. -- Resolution: Won't Fix > Support [CREATE|DROP] RULE - define a new plan rewrite rule >

[jira] [Updated] (SPARK-29717) Support [CREATE|DROP] RULE - define a new plan rewrite rule

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29717: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Support [CREATE|DROP] RULE - define a

[jira] [Updated] (SPARK-30182) Support nested aggregates

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-30182?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-30182: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Support nested aggregates >

[jira] [Updated] (SPARK-29718) Support PARTITION BY [RANGE|LIST|HASH] and PARTITION OF in CREATE TABLE

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29718: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Support PARTITION BY [RANGE|LIST|HASH]

[jira] [Updated] (SPARK-29982) Add built-in Array Functions: array_append

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29982: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add built-in Array Functions:

[jira] [Updated] (SPARK-29984) Add built-in Array Functions: array_ndims

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29984: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add built-in Array Functions:

[jira] [Updated] (SPARK-28037) Add built-in String Functions: quote_literal

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28037: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add built-in String Functions:

[jira] [Updated] (SPARK-28086) Adds `random()` sql function

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28086: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Adds `random()` sql function >

[jira] [Updated] (SPARK-29891) Add built-in Array Functions: array_length

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-29891: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add built-in Array Functions:

[jira] [Updated] (SPARK-28137) Data Type Formatting Functions: `to_number`

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28137: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Data Type Formatting Functions:

[jira] [Updated] (SPARK-30375) Feature Parity between PostgreSQL and Spark (implementation-dependent behaviours)

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-30375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-30375: - Description: Among the feature parity between Spark/PostgreSQL (SPARK-27764), this

[jira] [Updated] (SPARK-30375) Feature Parity between PostgreSQL and Spark (implementation-dependent behaviours)

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-30375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-30375: - Summary: Feature Parity between PostgreSQL and Spark (implementation-dependent

[jira] [Updated] (SPARK-28036) Support negative length at LEFT/RIGHT SQL functions

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-28036: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Support negative length at LEFT/RIGHT

[jira] [Updated] (SPARK-30042) Add built-in Array Functions: array_dims

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-30042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-30042: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add built-in Array Functions:

[jira] [Updated] (SPARK-30043) Add built-in Array Functions: array_fill

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-30043?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-30043: - Parent Issue: SPARK-30375 (was: SPARK-27764) > Add built-in Array Functions:

[jira] [Updated] (SPARK-30220) Support Filter expression uses IN/EXISTS predicate sub-queries

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-30220?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro updated SPARK-30220: - Parent Issue: SPARK-30374 (was: SPARK-27764) > Support Filter expression uses

<    4   5   6   7   8   9   10   11   12   13   >