[jira] [Issue Comment Deleted] (SPARK-30758) Spark SQL can't display bracketed comments well in generated golden files

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-30758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-30758: --- Comment: was deleted (was: I'm working on.) > Spark SQL can't display bracketed comments well in

[jira] [Issue Comment Deleted] (SPARK-32540) Eliminate filter clause in aggregate

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-32540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-32540: --- Comment: was deleted (was: I'm working on.) > Eliminate filter clause in aggregate >

[jira] [Issue Comment Deleted] (SPARK-30825) Add documents information for window function.

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-30825?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-30825: --- Comment: was deleted (was: I'm working on.) > Add documents information for window function. >

[jira] [Issue Comment Deleted] (SPARK-33443) LEAD/LAG should support [ IGNORE NULLS | RESPECT NULLS ]

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-33443: --- Comment: was deleted (was: I am working on.) > LEAD/LAG should support [ IGNORE NULLS | RESPECT

[jira] [Issue Comment Deleted] (SPARK-34096) Improve performance for nth_value ignore nulls over offset window

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34096: --- Comment: was deleted (was: I'm working on.) > Improve performance for nth_value ignore nulls over

[jira] [Commented] (SPARK-34257) Improve performance for last_value over unbounded window frame

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17341252#comment-17341252 ] jiaan.geng commented on SPARK-34257: Because it's not worth do the optimization for last_value only.

[jira] [Issue Comment Deleted] (SPARK-34257) Improve performance for last_value over unbounded window frame

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34257: --- Comment: was deleted (was: I'm working on.) > Improve performance for last_value over unbounded

[jira] [Issue Comment Deleted] (SPARK-35348) Support the utils for escapse the regex for ANSI SQL: SIMILAR TO ... ESCAPE syntax

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-35348: --- Comment: was deleted (was: I'm working on.) > Support the utils for escapse the regex for ANSI

[jira] [Commented] (SPARK-35348) Support the utils for escapse the regex for ANSI SQL: SIMILAR TO ... ESCAPE syntax

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17341186#comment-17341186 ] jiaan.geng commented on SPARK-35348: I'm working on. > Support the utils for escapse the regex for

[jira] [Created] (SPARK-35348) Support the utils for escapse the regex for ANSI SQL: SIMILAR TO ... ESCAPE syntax

2021-05-08 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-35348: -- Summary: Support the utils for escapse the regex for ANSI SQL: SIMILAR TO ... ESCAPE syntax Key: SPARK-35348 URL: https://issues.apache.org/jira/browse/SPARK-35348

[jira] [Issue Comment Deleted] (SPARK-30727) ANSI SQL: LAST_VALUE function

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-30727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-30727: --- Comment: was deleted (was: I'm working on.) > ANSI SQL: LAST_VALUE function >

[jira] [Comment Edited] (SPARK-34274) Improve performance for last_value over unbounded preceding window frame

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34274?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17273290#comment-17273290 ] jiaan.geng edited comment on SPARK-34274 at 5/8/21, 6:01 AM: - Because it's

[jira] [Resolved] (SPARK-34274) Improve performance for last_value over unbounded preceding window frame

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng resolved SPARK-34274. Resolution: Later > Improve performance for last_value over unbounded preceding window frame >

[jira] [Issue Comment Deleted] (SPARK-30726) ANSI SQL: FIRST_VALUE function

2021-05-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-30726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-30726: --- Comment: was deleted (was: I'm working on) > ANSI SQL: FIRST_VALUE function >

[jira] [Issue Comment Deleted] (SPARK-35062) Group exception messages in sql/streaming

2021-05-06 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-35062: --- Comment: was deleted (was: I'm working on.) > Group exception messages in sql/streaming >

[jira] [Commented] (SPARK-35062) Group exception messages in sql/streaming

2021-05-06 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17340528#comment-17340528 ] jiaan.geng commented on SPARK-35062: I'm working on. > Group exception messages in sql/streaming >

[jira] [Created] (SPARK-35283) Support query some DDL with CTES

2021-04-30 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-35283: -- Summary: Support query some DDL with CTES Key: SPARK-35283 URL: https://issues.apache.org/jira/browse/SPARK-35283 Project: Spark Issue Type: New Feature

[jira] [Issue Comment Deleted] (SPARK-35021) Group exception messages in connector/catalog

2021-04-28 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-35021: --- Comment: was deleted (was: I'm working on.) > Group exception messages in connector/catalog >

[jira] [Commented] (SPARK-35021) Group exception messages in connector/catalog

2021-04-28 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17334524#comment-17334524 ] jiaan.geng commented on SPARK-35021: I'm working on. > Group exception messages in

[jira] [Issue Comment Deleted] (SPARK-35020) Group exception messages in catalyst/util

2021-04-27 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-35020: --- Comment: was deleted (was: I'm working on.) > Group exception messages in catalyst/util >

[jira] [Issue Comment Deleted] (SPARK-35060) Group exception messages in sql/types

2021-04-27 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35060?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-35060: --- Comment: was deleted (was: I'm working on.) > Group exception messages in sql/types >

[jira] [Commented] (SPARK-35020) Group exception messages in catalyst/util

2021-04-27 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17333101#comment-17333101 ] jiaan.geng commented on SPARK-35020: I'm working on. > Group exception messages in catalyst/util >

[jira] [Commented] (SPARK-35110) Handle ANSI intervals in WindowExecBase

2021-04-21 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35110?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17327034#comment-17327034 ] jiaan.geng commented on SPARK-35110: I'm working on. > Handle ANSI intervals in WindowExecBase >

[jira] [Commented] (SPARK-35161) Safe version SQL functions

2021-04-21 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17327032#comment-17327032 ] jiaan.geng commented on SPARK-35161: I see. > Safe version SQL functions >

[jira] [Commented] (SPARK-35088) Accept ANSI intervals by the Sequence expression

2021-04-20 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17325639#comment-17325639 ] jiaan.geng commented on SPARK-35088: Let me take a look! > Accept ANSI intervals by the Sequence

[jira] [Commented] (SPARK-35085) Get columns operation should handle ANSI interval column properly

2021-04-20 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17325572#comment-17325572 ] jiaan.geng commented on SPARK-35085: I'm working on. > Get columns operation should handle ANSI

[jira] [Commented] (SPARK-35060) Group exception messages in sql/types

2021-04-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17324939#comment-17324939 ] jiaan.geng commented on SPARK-35060: I'm working on. > Group exception messages in sql/types >

[jira] [Commented] (SPARK-34715) Add round trip tests for period <-> month and duration <-> micros

2021-04-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17324908#comment-17324908 ] jiaan.geng commented on SPARK-34715: I'm working on. > Add round trip tests for period <-> month

[jira] [Updated] (SPARK-35116) The generated data fits the precision of DayTimeIntervalType in spark

2021-04-17 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-35116: --- Summary: The generated data fits the precision of DayTimeIntervalType in spark (was: Improve

[jira] [Commented] (SPARK-35116) Improve RandomDataGenerator so that the generated data fits the precision of DayTimeIntervalType in spark

2021-04-17 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-35116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17324262#comment-17324262 ] jiaan.geng commented on SPARK-35116: I'm working on. > Improve RandomDataGenerator so that the

[jira] [Created] (SPARK-35116) Improve RandomDataGenerator so that the generated data fits the precision of DayTimeIntervalType in spark

2021-04-17 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-35116: -- Summary: Improve RandomDataGenerator so that the generated data fits the precision of DayTimeIntervalType in spark Key: SPARK-35116 URL:

[jira] [Commented] (SPARK-34837) Support ANSI SQL intervals by the aggregate function `avg`

2021-04-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17317639#comment-17317639 ] jiaan.geng commented on SPARK-34837: I'm doing now. > Support ANSI SQL intervals by the aggregate

[jira] [Commented] (SPARK-34716) Support ANSI SQL intervals by the aggregate function `sum`

2021-04-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17317589#comment-17317589 ] jiaan.geng commented on SPARK-34716: OK. I will take a look. > Support ANSI SQL intervals by the

[jira] [Issue Comment Deleted] (SPARK-33604) Group exception messages in sql/execution

2021-03-21 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33604?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-33604: --- Comment: was deleted (was: I'm working on.) > Group exception messages in sql/execution >

[jira] [Issue Comment Deleted] (SPARK-33604) Group exception messages in sql/execution

2021-03-17 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33604?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-33604: --- Comment: was deleted (was: I'm working on.) > Group exception messages in sql/execution >

[jira] [Commented] (SPARK-34782) Not equal functions (!=, <>) are missing in SQL doc

2021-03-17 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17303813#comment-17303813 ] jiaan.geng commented on SPARK-34782: I'm working on. > Not equal functions (!=, <>) are missing in

[jira] [Commented] (SPARK-33604) Group exception messages in sql/execution

2021-03-17 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33604?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17303513#comment-17303513 ] jiaan.geng commented on SPARK-33604: I'm working on. > Group exception messages in sql/execution >

[jira] [Commented] (SPARK-33604) Group exception messages in sql/execution

2021-03-17 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33604?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17303514#comment-17303514 ] jiaan.geng commented on SPARK-33604: I'm working on. > Group exception messages in sql/execution >

[jira] [Created] (SPARK-34755) Support the utils for transform number format

2021-03-15 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34755: -- Summary: Support the utils for transform number format Key: SPARK-34755 URL: https://issues.apache.org/jira/browse/SPARK-34755 Project: Spark Issue Type: New

[jira] [Commented] (SPARK-33602) Group exception messages in execution/datasources

2021-02-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17287492#comment-17287492 ] jiaan.geng commented on SPARK-33602: ping [~allisonwang-db] Should we put AnalysisException in

[jira] [Issue Comment Deleted] (SPARK-33601) Group exception messages in catalyst/parser

2021-02-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-33601: --- Comment: was deleted (was: I'm working on.) > Group exception messages in catalyst/parser >

[jira] [Issue Comment Deleted] (SPARK-33541) Group exception messages in catalyst/expressions

2021-02-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-33541: --- Comment: was deleted (was: I'm working on.) > Group exception messages in catalyst/expressions >

[jira] [Commented] (SPARK-33602) Group exception messages in execution/datasources

2021-02-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17287485#comment-17287485 ] jiaan.geng commented on SPARK-33602: I'm working on. > Group exception messages in

[jira] [Issue Comment Deleted] (SPARK-33542) Group exception messages in catalyst/catalog

2021-02-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33542?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-33542: --- Comment: was deleted (was: I'm working on.) > Group exception messages in catalyst/catalog >

[jira] [Issue Comment Deleted] (SPARK-33599) Group exception messages in catalyst/analysis

2021-02-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-33599: --- Comment: was deleted (was: I'm working on.) > Group exception messages in catalyst/analysis >

[jira] [Comment Edited] (SPARK-34459) map_from_arrays() throws UnsupportedOperationException with array of ColumnarMap

2021-02-18 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17286414#comment-17286414 ] jiaan.geng edited comment on SPARK-34459 at 2/18/21, 11:03 AM: ---

[jira] [Comment Edited] (SPARK-34459) map_from_arrays() throws UnsupportedOperationException with array of ColumnarMap

2021-02-18 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17286414#comment-17286414 ] jiaan.geng edited comment on SPARK-34459 at 2/18/21, 10:57 AM: ---

[jira] [Commented] (SPARK-34459) map_from_arrays() throws UnsupportedOperationException with array of ColumnarMap

2021-02-18 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17286414#comment-17286414 ] jiaan.geng commented on SPARK-34459: [~allisonwang-db] I test and cannot reproduce it. {code:java}

[jira] [Commented] (SPARK-34459) map_from_arrays() throws UnsupportedOperationException with array of ColumnarMap

2021-02-17 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17286311#comment-17286311 ] jiaan.geng commented on SPARK-34459: [~smilegator] I see. Let me do it. > map_from_arrays() throws

[jira] [Issue Comment Deleted] (SPARK-34394) Unify output of SHOW FUNCTIONS and pass output attributes properly

2021-02-07 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34394?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34394: --- Comment: was deleted (was: I'm working on.) > Unify output of SHOW FUNCTIONS and pass output

[jira] [Commented] (SPARK-34394) Unify output of SHOW FUNCTIONS and pass output attributes properly

2021-02-07 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17280456#comment-17280456 ] jiaan.geng commented on SPARK-34394: I'm working on. > Unify output of SHOW FUNCTIONS and pass

[jira] [Created] (SPARK-34394) Unify output of SHOW FUNCTIONS and pass output attributes properly

2021-02-07 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34394: -- Summary: Unify output of SHOW FUNCTIONS and pass output attributes properly Key: SPARK-34394 URL: https://issues.apache.org/jira/browse/SPARK-34394 Project: Spark

[jira] [Issue Comment Deleted] (SPARK-34393) Unify output of SHOW VIEWS and pass output attributes properly

2021-02-07 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34393: --- Comment: was deleted (was: I'm working on.) > Unify output of SHOW VIEWS and pass output

[jira] [Commented] (SPARK-34393) Unify output of SHOW VIEWS and pass output attributes properly

2021-02-07 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17280439#comment-17280439 ] jiaan.geng commented on SPARK-34393: I'm working on. > Unify output of SHOW VIEWS and pass output

[jira] [Created] (SPARK-34393) Unify output of SHOW VIEWS and pass output attributes properly

2021-02-07 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34393: -- Summary: Unify output of SHOW VIEWS and pass output attributes properly Key: SPARK-34393 URL: https://issues.apache.org/jira/browse/SPARK-34393 Project: Spark

[jira] [Updated] (SPARK-34359) add a legacy config to restore the output schema of SHOW DATABASES

2021-02-04 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34359?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34359: --- Parent: SPARK-34156 Issue Type: Sub-task (was: Improvement) > add a legacy config to

[jira] [Created] (SPARK-34352) Improve SQLQueryTestSuite so as could run on windows system

2021-02-03 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34352: -- Summary: Improve SQLQueryTestSuite so as could run on windows system Key: SPARK-34352 URL: https://issues.apache.org/jira/browse/SPARK-34352 Project: Spark

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

2021-02-02 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng reopened SPARK-28137: to_number is very useful for formatted currency to number conversion. > Data Type Formatting

[jira] [Updated] (SPARK-34257) Improve performance for last_value over unbounded window frame

2021-01-27 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34257: --- Description: The current implement of `last_value` over unbounded window frame will execute

[jira] [Commented] (SPARK-34274) Improve performance for last_value over unbounded preceding window frame

2021-01-27 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34274?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17273290#comment-17273290 ] jiaan.geng commented on SPARK-34274: I'm working on. > Improve performance for last_value over

[jira] [Updated] (SPARK-34274) Improve performance for last_value over unbounded preceding window frame

2021-01-27 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34274: --- Description: The current implement of `last_value` will execute `updateExpressions` multiple

[jira] [Updated] (SPARK-34274) Improve performance for last_value over unbounded preceding window frame

2021-01-27 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34274: --- Description: The current implement of `last_value` over unbounded preceding window frame will

[jira] [Created] (SPARK-34274) Improve performance for last_value over unbounded preceding window frame

2021-01-27 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34274: -- Summary: Improve performance for last_value over unbounded preceding window frame Key: SPARK-34274 URL: https://issues.apache.org/jira/browse/SPARK-34274 Project: Spark

[jira] [Updated] (SPARK-34257) Improve performance for last_value over unbounded window frame

2021-01-27 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34257: --- Summary: Improve performance for last_value over unbounded window frame (was: Improve performance

[jira] [Updated] (SPARK-34257) Improve performance for last_value ignore nulls

2021-01-26 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34257: --- Description: The current implement of `last_value` will execute `updateExpressions` multiple

[jira] [Updated] (SPARK-34257) Improve performance for last_value ignore nulls

2021-01-26 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34257: --- Description: The current implement > Improve performance for last_value ignore nulls >

[jira] [Commented] (SPARK-34257) Improve performance for last_value ignore nulls

2021-01-26 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17272620#comment-17272620 ] jiaan.geng commented on SPARK-34257: I'm working on. > Improve performance for last_value ignore

[jira] [Created] (SPARK-34257) Improve performance for last_value ignore nulls

2021-01-26 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34257: -- Summary: Improve performance for last_value ignore nulls Key: SPARK-34257 URL: https://issues.apache.org/jira/browse/SPARK-34257 Project: Spark Issue Type:

[jira] [Updated] (SPARK-34244) Remove the Scala function version of regexp_extract_all

2021-01-26 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34244: --- Description: SPARK-24884 implement regexp_extract_all and added the scala function version of it.

[jira] [Updated] (SPARK-34244) Remove the Scala function version of regexp_extract_all

2021-01-26 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34244: --- Description: SPARK-24884 implement regexp_extract_all and added the scala function version of it.

[jira] [Updated] (SPARK-34244) Remove the Scala function version of regexp_extract_all

2021-01-26 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34244: --- Description: SPARK-24884 implement regexp_extract_all and added mplement regexp_extract_all (was:

[jira] [Updated] (SPARK-34244) Remove the Scala function version of regexp_extract_all

2021-01-26 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34244: --- Description: SPARK-24884 implement regexp_extract_all and added > Remove the Scala function

[jira] [Created] (SPARK-34244) Remove the Scala function version of regexp_extract_all

2021-01-26 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34244: -- Summary: Remove the Scala function version of regexp_extract_all Key: SPARK-34244 URL: https://issues.apache.org/jira/browse/SPARK-34244 Project: Spark Issue

[jira] [Updated] (SPARK-34234) Remove TreeNodeException that didn't work

2021-01-25 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34234: --- Description: TreeNodeException causes the error msg not clear and it didn't work well. Because the

[jira] [Created] (SPARK-34234) Remove TreeNodeException that didn't work

2021-01-25 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34234: -- Summary: Remove TreeNodeException that didn't work Key: SPARK-34234 URL: https://issues.apache.org/jira/browse/SPARK-34234 Project: Spark Issue Type:

[jira] [Updated] (SPARK-34156) Unify the output of DDL and pass output attributes properly

2021-01-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34156: --- Description: The current implement of some DDL not unify the output and not pass the output

[jira] [Updated] (SPARK-34156) Unify the output of DDL and pass output attributes properly

2021-01-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34156: --- Description: The current implement of some DDL not unify the output and not (was: The current

[jira] [Updated] (SPARK-34156) Unify the output of DDL and pass output attributes properly

2021-01-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34156: --- Summary: Unify the output of DDL and pass output attributes properly (was: Unify the output of

[jira] [Updated] (SPARK-34156) Unify the output of LogicPlan and pass output attributes properly

2021-01-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34156: --- Description: The current implement of some DDL > Unify the output of LogicPlan and pass output

[jira] [Updated] (SPARK-34156) Unify the output of LogicPlan and pass output attributes properly

2021-01-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34156: --- Summary: Unify the output of LogicPlan and pass output attributes properly (was: Unify the output

[jira] [Updated] (SPARK-34157) Unify output of SHOW TABLES and pass output attributes properly

2021-01-19 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34157: --- Summary: Unify output of SHOW TABLES and pass output attributes properly (was: Unify output of

[jira] [Created] (SPARK-34157) Unify output of SHOW TABLES and fix bug

2021-01-19 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34157: -- Summary: Unify output of SHOW TABLES and fix bug Key: SPARK-34157 URL: https://issues.apache.org/jira/browse/SPARK-34157 Project: Spark Issue Type: Sub-task

[jira] [Created] (SPARK-34156) Unify the output of LogicPlan and fix bug that output attributes not pass properly

2021-01-19 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34156: -- Summary: Unify the output of LogicPlan and fix bug that output attributes not pass properly Key: SPARK-34156 URL: https://issues.apache.org/jira/browse/SPARK-34156

[jira] [Created] (SPARK-34127) Support table valued command

2021-01-15 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34127: -- Summary: Support table valued command Key: SPARK-34127 URL: https://issues.apache.org/jira/browse/SPARK-34127 Project: Spark Issue Type: New Feature

[jira] [Commented] (SPARK-34127) Support table valued command

2021-01-15 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17265874#comment-17265874 ] jiaan.geng commented on SPARK-34127: I'm working on. > Support table valued command >

[jira] [Updated] (SPARK-34096) Improve performance for nth_value ignore nulls over offset window

2021-01-13 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34096: --- Summary: Improve performance for nth_value ignore nulls over offset window (was: Improve

[jira] [Updated] (SPARK-34096) Improve performance for nth_value ignore nulls with offset window

2021-01-13 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34096: --- Summary: Improve performance for nth_value ignore nulls with offset window (was: Improve

[jira] [Updated] (SPARK-34096) Improve performance for nth_value ignore nulls

2021-01-13 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34096: --- Description: The current {code:java} UnboundedOffsetWindowFunctionFrame {code} and {code:java}

[jira] [Updated] (SPARK-34096) Improve performance for nth_value ignore nulls

2021-01-13 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34096: --- Summary: Improve performance for nth_value ignore nulls (was: Improve performance for nth_value

[jira] [Updated] (SPARK-34096) Improve performance for nth_value ignore nulls over unbounded preceding window frame

2021-01-13 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-34096: --- Summary: Improve performance for nth_value ignore nulls over unbounded preceding window frame

[jira] [Commented] (SPARK-34096) Improve performance for nth_value over unbounded preceding window frame

2021-01-13 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-34096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17263972#comment-17263972 ] jiaan.geng commented on SPARK-34096: I'm working on. > Improve performance for nth_value over

[jira] [Created] (SPARK-34096) Improve performance for nth_value over unbounded preceding window frame

2021-01-13 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34096: -- Summary: Improve performance for nth_value over unbounded preceding window frame Key: SPARK-34096 URL: https://issues.apache.org/jira/browse/SPARK-34096 Project: Spark

[jira] [Commented] (SPARK-33245) Add built-in UDF - GETBIT

2021-01-13 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33245?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17263968#comment-17263968 ] jiaan.geng commented on SPARK-33245: I'm working on. > Add built-in UDF - GETBIT >

[jira] [Commented] (SPARK-28065) ntile only accepting positive (>0) values

2021-01-12 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-28065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17263187#comment-17263187 ] jiaan.geng commented on SPARK-28065: After investigation, it is found that most databases require it

[jira] [Updated] (SPARK-33539) Standardize exception messages in Spark

2021-01-10 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng updated SPARK-33539: --- Description: In the SPIP: Standardize Exception Messages in Spark, there are three major

[jira] [Commented] (SPARK-33601) Group exception messages in catalyst/parser

2021-01-08 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17261125#comment-17261125 ] jiaan.geng commented on SPARK-33601: I'm working on. > Group exception messages in catalyst/parser

[jira] [Resolved] (SPARK-33947) String functions: Trim/Ltrim/Rtrim support byte array

2021-01-06 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jiaan.geng resolved SPARK-33947. Resolution: Won't Fix > String functions: Trim/Ltrim/Rtrim support byte array >

[jira] [Commented] (SPARK-33947) String functions: Trim/Ltrim/Rtrim support byte array

2021-01-06 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17260239#comment-17260239 ] jiaan.geng commented on SPARK-33947: According to [~srowen]'s suggestion, We not need do this work.

[jira] [Created] (SPARK-34004) Change FrameLessOffsetWindowFunction as sealed abstract class

2021-01-04 Thread jiaan.geng (Jira)
jiaan.geng created SPARK-34004: -- Summary: Change FrameLessOffsetWindowFunction as sealed abstract class Key: SPARK-34004 URL: https://issues.apache.org/jira/browse/SPARK-34004 Project: Spark

[jira] [Commented] (SPARK-33977) Add doc for "'like any' and 'like all' operators"

2021-01-03 Thread jiaan.geng (Jira)
[ https://issues.apache.org/jira/browse/SPARK-33977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17257988#comment-17257988 ] jiaan.geng commented on SPARK-33977: I'm working on. > Add doc for "'like any' and 'like all'

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