[
https://issues.apache.org/jira/browse/SPARK-6145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Armbrust updated SPARK-6145:
------------------------------------
Description:
{code}
sqlContext.jsonRDD(sc.parallelize(
"""{"a": {"b": 1}, "c": 1}""" :: Nil)).registerTempTable("nestedOrder")
// Works
sqlContext.sql("SELECT 1 FROM nestedOrder ORDER BY c")
// Fails now
sqlContext.sql("SELECT 1 FROM nestedOrder ORDER BY a.b")
// Fails now
sqlContext.sql("SELECT a.b FROM nestedOrder ORDER BY a.b")
{code}
Relatedly the error message for bad get fields should also include the name of
the field in question.
was:
{code}
sqlContext.jsonRDD(sc.parallelize(
"""{"a": {"b": 1}, "c": 1}""" :: Nil)).registerTempTable("nestedOrder")
// Works
sqlContext.sql("SELECT 1 FROM nestedOrder ORDER BY c")
// Fails now
sqlContext.sql("SELECT 1 FROM nestedOrder ORDER BY a.b")
// Fails now
sqlContext.sql("SELECT a.b FROM nestedOrder ORDER BY a.b")
{code}
> ORDER BY fails to resolve nested fields
> ---------------------------------------
>
> Key: SPARK-6145
> URL: https://issues.apache.org/jira/browse/SPARK-6145
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.3.0
> Reporter: Michael Armbrust
> Priority: Critical
>
> {code}
> sqlContext.jsonRDD(sc.parallelize(
> """{"a": {"b": 1}, "c": 1}""" :: Nil)).registerTempTable("nestedOrder")
> // Works
> sqlContext.sql("SELECT 1 FROM nestedOrder ORDER BY c")
> // Fails now
> sqlContext.sql("SELECT 1 FROM nestedOrder ORDER BY a.b")
> // Fails now
> sqlContext.sql("SELECT a.b FROM nestedOrder ORDER BY a.b")
> {code}
> Relatedly the error message for bad get fields should also include the name
> of the field in question.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
