You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Hyukjin Kwon (Jira)" <ji...@apache.org> on 2023/01/02 07:25:00 UTC
[jira] [Created] (SPARK-41811) Implement SparkSession.sql's string formatter
Hyukjin Kwon created SPARK-41811:
------------------------------------
Summary: Implement SparkSession.sql's string formatter
Key: SPARK-41811
URL: https://issues.apache.org/jira/browse/SPARK-41811
Project: Spark
Issue Type: Sub-task
Components: Connect
Affects Versions: 3.4.0
Reporter: Hyukjin Kwon
{code}
**********************************************************************
File "/.../spark/python/pyspark/sql/connect/session.py", line 345, in pyspark.sql.connect.session.SparkSession.sql
Failed example:
spark.sql(
"SELECT * FROM range(10) WHERE id > {bound1} AND id < {bound2}", bound1=7, bound2=9
).show()
Exception raised:
Traceback (most recent call last):
File "/.../miniconda3/envs/python3.9/lib/python3.9/doctest.py", line 1336, in __run
exec(compile(example.source, filename, "single",
File "<doctest pyspark.sql.connect.session.SparkSession.sql[1]>", line 1, in <module>
spark.sql(
TypeError: sql() got an unexpected keyword argument 'bound1'
**********************************************************************
File "/.../spark/python/pyspark/sql/connect/session.py", line 355, in pyspark.sql.connect.session.SparkSession.sql
Failed example:
spark.sql(
"SELECT {col} FROM {mydf} WHERE id IN {x}",
col=mydf.id, mydf=mydf, x=tuple(range(4))).show()
Exception raised:
Traceback (most recent call last):
File "/.../miniconda3/envs/python3.9/lib/python3.9/doctest.py", line 1336, in __run
exec(compile(example.source, filename, "single",
File "<doctest pyspark.sql.connect.session.SparkSession.sql[3]>", line 1, in <module>
spark.sql(
TypeError: sql() got an unexpected keyword argument 'col'
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org