[
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
