[ https://issues.apache.org/jira/browse/SPARK-34179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chetan Bhat updated SPARK-34179: -------------------------------- Description: *Issue 1 :* *array_sort examples provided in [https://spark.apache.org/docs/latest/api/sql/index.html#array_sort] link not working.* SELECT array_sort(array(5, 6, 1), (left, right) -> case when left < right then -1 when left > right then 1 else 0 end); –> *this example when executed in spark-sql fails with below error* SELECT array_sort(array(5, 6, 1), (left, right) -> case when left < right then -1 when left > right then 1 else 0 end); Error in query: extraneous input '->' expecting \{')', ','}(line 1, pos 48) == SQL == SELECT array_sort(array(5, 6, 1), (left, right) -> case when left < right then -1 when left > right then 1 else 0 end) ------------------------------------------------^^^ spark-sql> SELECT array_sort(array('bc', 'ab', 'dc'), (left, right) -> case when left is null and right is null then 0 when left is null then -1 when right is null then 1 when left < right then 1 when left > right then -1 else 0 end); --> *This example when executed fails with below error* spark-sql> > > > > > > > > > > > > > > > > > SELECT array_sort(array('bc', 'ab', 'dc'), (left, right) -> case when left > is null and right is null then 0 when left is null then -1 when right is > null then 1 when left < right then 1 when left > right then -1 else 0 end); Error in query: extraneous input '->' expecting \{')', ','}(line 1, pos 57) == SQL == SELECT array_sort(array('bc', 'ab', 'dc'), (left, right) -> case when left is null and right is null then 0 when left is null then -1 when right is null then 1 when left < right then 1 when left > right then -1 else 0 end) ---------------------------------------------------------^^^ spark-sql> *Issue 2 :-* *Examples for overlay functions are not working in link - https://spark.apache.org/docs/latest/api/sql/index.html* spark-sql> SELECT overlay('Spark SQL' PLACING '_' FROM 6); Error in query: mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 27) == SQL == SELECT overlay('Spark SQL' PLACING '_' FROM 6) ---------------------------^^^ spark-sql> SELECT overlay('Spark SQL' PLACING 'CORE' FROM 7); Error in query: mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 27) == SQL == SELECT overlay('Spark SQL' PLACING 'CORE' FROM 7) ---------------------------^^^ spark-sql> SELECT overlay('Spark SQL' PLACING 'ANSI ' FROM 7 FOR 0); Error in query: mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 27) == SQL == SELECT overlay('Spark SQL' PLACING 'ANSI ' FROM 7 FOR 0) ---------------------------^^^ spark-sql> SELECT overlay('Spark SQL' PLACING 'tructured' FROM 2 FOR 4); Error in query: mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 27) == SQL == SELECT overlay('Spark SQL' PLACING 'tructured' FROM 2 FOR 4) ---------------------------^^^ spark-sql> SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('_', 'utf-8') FROM 6); Error in query: mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 44) == SQL == SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('_', 'utf-8') FROM 6) --------------------------------------------^^^ spark-sql> SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('CORE', 'utf-8') FROM 7); Error in query: mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 44) == SQL == SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('CORE', 'utf-8') FROM 7) --------------------------------------------^^^ spark-sql> SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('ANSI ', 'utf-8') FROM 7 FOR 0); Error in query: mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 44) == SQL == SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('ANSI ', 'utf-8') FROM 7 FOR 0) --------------------------------------------^^^ spark-sql> SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('tructured', 'utf-8') FROM 2 FOR 4); Error in query: mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 44) == SQL == SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('tructured', 'utf-8') FROM 2 FOR 4) --------------------------------------------^^^ was: *array_sort examples provided in [https://spark.apache.org/docs/latest/api/sql/index.html#array_sort] link not working.* SELECT array_sort(array(5, 6, 1), (left, right) -> case when left < right then -1 when left > right then 1 else 0 end); –> *this example when executed in spark-sql fails with below error* SELECT array_sort(array(5, 6, 1), (left, right) -> case when left < right then -1 when left > right then 1 else 0 end); Error in query: extraneous input '->' expecting \{')', ','}(line 1, pos 48) == SQL == SELECT array_sort(array(5, 6, 1), (left, right) -> case when left < right then -1 when left > right then 1 else 0 end) ------------------------------------------------^^^ spark-sql> SELECT array_sort(array('bc', 'ab', 'dc'), (left, right) -> case when left is null and right is null then 0 when left is null then -1 when right is null then 1 when left < right then 1 when left > right then -1 else 0 end); --> *This example when executed fails with below error* spark-sql> > > > > > > > > > > > > > > > > > SELECT array_sort(array('bc', 'ab', 'dc'), (left, right) -> case when left > is null and right is null then 0 when left is null then -1 when right is > null then 1 when left < right then 1 when left > right then -1 else 0 end); Error in query: extraneous input '->' expecting \{')', ','}(line 1, pos 57) == SQL == SELECT array_sort(array('bc', 'ab', 'dc'), (left, right) -> case when left is null and right is null then 0 when left is null then -1 when right is null then 1 when left < right then 1 when left > right then -1 else 0 end) ---------------------------------------------------------^^^ spark-sql> > examples provided in https://spark.apache.org/docs/latest/api/sql/index.html > link not working > ----------------------------------------------------------------------------------------------- > > Key: SPARK-34179 > URL: https://issues.apache.org/jira/browse/SPARK-34179 > Project: Spark > Issue Type: Bug > Components: docs > Affects Versions: 2.4.5 > Environment: Spark 2.4.5 > Reporter: Chetan Bhat > Priority: Minor > > *Issue 1 :* > *array_sort examples provided in > [https://spark.apache.org/docs/latest/api/sql/index.html#array_sort] link not > working.* > > SELECT array_sort(array(5, 6, 1), (left, right) -> case when left < right > then -1 when left > right then 1 else 0 end); –> *this example when executed > in spark-sql fails with below error* > SELECT array_sort(array(5, 6, 1), (left, right) -> case when left < right > then -1 when left > right then 1 else 0 end); > Error in query: > extraneous input '->' expecting \{')', ','}(line 1, pos 48) > == SQL == > SELECT array_sort(array(5, 6, 1), (left, right) -> case when left < right > then -1 when left > right then 1 else 0 end) > ------------------------------------------------^^^ > spark-sql> > > SELECT array_sort(array('bc', 'ab', 'dc'), (left, right) -> case when left is > null and right is null then 0 when left is null then -1 when right is null > then 1 when left < right then 1 when left > right then -1 else 0 end); --> > *This example when executed fails with below error* > > spark-sql> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > SELECT array_sort(array('bc', 'ab', 'dc'), (left, right) -> case when left > is null and right is null then 0 when left is null then -1 when right is null > then 1 when left < right then 1 when left > right then -1 else 0 end); > Error in query: > extraneous input '->' expecting \{')', ','}(line 1, pos 57) > == SQL == > SELECT array_sort(array('bc', 'ab', 'dc'), (left, right) -> case when left > is null and right is null then 0 when left is null then -1 when right is null > then 1 when left < right then 1 when left > right then -1 else 0 end) > ---------------------------------------------------------^^^ > spark-sql> > > *Issue 2 :-* > *Examples for overlay functions are not working in link - > https://spark.apache.org/docs/latest/api/sql/index.html* > > spark-sql> SELECT overlay('Spark SQL' PLACING '_' FROM 6); > Error in query: > mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 27) > == SQL == > SELECT overlay('Spark SQL' PLACING '_' FROM 6) > ---------------------------^^^ > spark-sql> SELECT overlay('Spark SQL' PLACING 'CORE' FROM 7); > Error in query: > mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 27) > == SQL == > SELECT overlay('Spark SQL' PLACING 'CORE' FROM 7) > ---------------------------^^^ > spark-sql> SELECT overlay('Spark SQL' PLACING 'ANSI ' FROM 7 FOR 0); > Error in query: > mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 27) > == SQL == > SELECT overlay('Spark SQL' PLACING 'ANSI ' FROM 7 FOR 0) > ---------------------------^^^ > spark-sql> SELECT overlay('Spark SQL' PLACING 'tructured' FROM 2 FOR 4); > Error in query: > mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 27) > == SQL == > SELECT overlay('Spark SQL' PLACING 'tructured' FROM 2 FOR 4) > ---------------------------^^^ > spark-sql> SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('_', > 'utf-8') FROM 6); > Error in query: > mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 44) > == SQL == > SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('_', 'utf-8') FROM > 6) > --------------------------------------------^^^ > spark-sql> SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('CORE', > 'utf-8') FROM 7); > Error in query: > mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 44) > == SQL == > SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('CORE', 'utf-8') > FROM 7) > --------------------------------------------^^^ > spark-sql> SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('ANSI > ', 'utf-8') FROM 7 FOR 0); > Error in query: > mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 44) > == SQL == > SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('ANSI ', 'utf-8') > FROM 7 FOR 0) > --------------------------------------------^^^ > spark-sql> SELECT overlay(encode('Spark SQL', 'utf-8') PLACING > encode('tructured', 'utf-8') FROM 2 FOR 4); > Error in query: > mismatched input 'PLACING' expecting \{')', ','}(line 1, pos 44) > == SQL == > SELECT overlay(encode('Spark SQL', 'utf-8') PLACING encode('tructured', > 'utf-8') FROM 2 FOR 4) > --------------------------------------------^^^ -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org