[
https://issues.apache.org/jira/browse/SPARK-23616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tathagata Das resolved SPARK-23616.
-----------------------------------
Resolution: Duplicate
This is the same underlying issue as SPARK-23406. However the error is
different due to the use of pure SQL join instead of Dataset join.
> Streaming self-join using SQL throws resolution exceptions
> ----------------------------------------------------------
>
> Key: SPARK-23616
> URL: https://issues.apache.org/jira/browse/SPARK-23616
> Project: Spark
> Issue Type: New Feature
> Components: Structured Streaming
> Affects Versions: 2.3.0
> Reporter: Tathagata Das
> Assignee: Tathagata Das
> Priority: Major
>
> Reported on the dev list.
> {code}
> import org.apache.spark.sql.streaming.Trigger
> val jdf = spark.readStream.format("kafka").option("kafka.bootstrap.servers",
> "localhost:9092").option("subscribe", "join_test").option("startingOffsets",
> "earliest").load();
> jdf.createOrReplaceTempView("table")
> val resultdf = spark.sql("select * from table as x inner join table as y on
> x.offset=y.offset")
> resultdf.writeStream.outputMode("update").format("console").option("truncate",
> false).trigger(Trigger.ProcessingTime(1000)).start()
> {code}
> This is giving the following error
> {code}
> org.apache.spark.sql.AnalysisException: cannot resolve '`x.offset`' given
> input columns: [x.value, x.offset, x.key, x.timestampType, x.topic,
> x.timestamp, x.partition]; line 1 pos 50;
> 'Project [*]
> +- 'Join Inner, ('x.offset = 'y.offset)
> :- SubqueryAlias x
> : +- SubqueryAlias table
> : +- StreamingRelation
> DataSource(org.apache.spark.sql.SparkSession@15f3f9cf,kafka,List(),None,List(),None,Map(startingOffsets
> -> earliest, subscribe -> join_test, kafka.bootstrap.servers ->
> localhost:9092),None), kafka, [key#28, value#29, topic#30, partition#31,
> offset#32L, timestamp#33, timestampType#34]
> +- SubqueryAlias y
> +- SubqueryAlias table
> +- StreamingRelation
> DataSource(org.apache.spark.sql.SparkSession@15f3f9cf,kafka,List(),None,List(),None,Map(startingOffsets
> -> earliest, subscribe -> join_test, kafka.bootstrap.servers ->
> localhost:9092),None), kafka, [key#28, value#29, topic#30, partition#31,
> offset#32L, timestamp#33, timestampType#34]
> {code}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
