[jira] [Updated] (SPARK-28449) Missing escape_string_warning and standard_conforming_strings config

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

[jira] [Commented] (SPARK-28449) Missing escape_string_warning and standard_conforming_strings config

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

[jira] [Resolved] (SPARK-28449) Missing escape_string_warning and standard_conforming_strings config

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

[jira] [Resolved] (SPARK-28385) SELECT DISTINCT ON ( expression [, ...] ) syntax

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-28385. -- Resolution: Won't Fix > SELECT DISTINCT ON ( expression [, ...] ) syntax > ---

[jira] [Commented] (SPARK-28385) SELECT DISTINCT ON ( expression [, ...] ) syntax

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17004676#comment-17004676 ] Takeshi Yamamuro commented on SPARK-28385: -- Based on the document, this is an e

[jira] [Updated] (SPARK-28385) SELECT DISTINCT ON ( expression [, ...] ) syntax

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

[jira] [Updated] (SPARK-28126) Support TRIM(trimStr FROM str) syntax

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

[jira] [Resolved] (SPARK-29658) Support geometric types

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

[jira] [Commented] (SPARK-29658) Support geometric types

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

[jira] [Resolved] (SPARK-29697) Support bit string types/literals

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

[jira] [Commented] (SPARK-29697) Support bit string types/literals

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

[jira] [Updated] (SPARK-29658) Support geometric types

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

[jira] [Updated] (SPARK-29697) Support bit string types/literals

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

[jira] [Updated] (SPARK-28451) substr returns different values

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

[jira] [Updated] (SPARK-27949) Support SUBSTRING(str FROM n1 [FOR n2]) syntax

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

[jira] [Resolved] (SPARK-29119) DEFAULT option is not supported in Spark

2019-12-28 Thread Takeshi Yamamuro (Jira)
[ https://issues.apache.org/jira/browse/SPARK-29119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takeshi Yamamuro resolved SPARK-29119. -- Resolution: Duplicate > DEFAULT option is not supported in Spark > ---

[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&focusedCommentId=17004671#comment-17004671 ] Takeshi Yamamuro commented on SPARK-29713: -- I'll close this because the corresp

[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&focusedCommentId=17004669#comment-17004669 ] Takeshi Yamamuro commented on SPARK-27930: -- This ticket is not obvious and it s

[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 na

[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 umbrella

[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 umbrella

[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 umbrella

[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 umbrella

[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 F

[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 the

[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 aggregates(BIT

[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&focusedCommentId=17004665#comment-17004665 ] Takeshi Yamamuro commented on SPARK-28147: -- I'll close for now because I think

[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&focusedCommentId=17004664#comment-17004664 ] Takeshi Yamamuro commented on SPARK-28061: -- I'll close this because these funct

[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 b

[jira] [Created] (SPARK-30379) Avoid OOM when using collection accumulator

2019-12-28 Thread L. C. Hsieh (Jira)
L. C. Hsieh created SPARK-30379: --- Summary: Avoid OOM when using collection accumulator Key: SPARK-30379 URL: https://issues.apache.org/jira/browse/SPARK-30379 Project: Spark Issue Type: Improve

[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, B

[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 CRE

[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&focusedCommentId=17004661#comment-17004661 ] Takeshi Yamamuro commented on SPARK-29718: -- I'll close this for now because I t

[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 times

[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: `to_char

[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 inter

[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] [Commented] (SPARK-30378) FM support getter of training prams

2019-12-28 Thread Huaxin Gao (Jira)
[ https://issues.apache.org/jira/browse/SPARK-30378?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17004657#comment-17004657 ] Huaxin Gao commented on SPARK-30378: Yes, I will work on this. Thanks a lot for ping

[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 to

[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: array_uppe

[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&focusedCommentId=17004653#comment-17004653 ] Takeshi Yamamuro commented on SPARK-28324: -- I'll close this based on the discus

[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-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, b

[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: array_a

[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 regu

[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&focusedCommentId=17004651#comment-17004651 ] Takeshi Yamamuro commented on SPARK-28402: -- I'll close for now because I think

[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&focusedCommentId=17004650#comment-17004650 ] Takeshi Yamamuro commented on SPARK-28146: -- I'll close for now because I think

[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 RE

[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&focusedCommentId=17004649#comment-17004649 ] Takeshi Yamamuro commented on SPARK-29715: -- I'll close this because this is pg-

[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 I

[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 recog

[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 func

[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 SCHEMA

[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 functi

[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: string

[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 split_part

[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 a

  1   2   >