[jira] [Commented] (SPARK-13494) Cannot sort on a column which is of type "array"
[ https://issues.apache.org/jira/browse/SPARK-13494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15180289#comment-15180289 ] Xiao Li commented on SPARK-13494: - Can you try the other newer versions? You know, a lot of issues have been fixed in each release. > Cannot sort on a column which is of type "array" > > > Key: SPARK-13494 > URL: https://issues.apache.org/jira/browse/SPARK-13494 > Project: Spark > Issue Type: Bug > Components: SQL >Reporter: Yael Aharon > > Executing the following SQL results in an error if columnName refers to a > column of type array > SELECT * FROM myTable ORDER BY columnName ASC LIMIT 50 > The error is > org.apache.spark.sql.AnalysisException: cannot resolve 'columnName ASC' due > to data type mismatch: cannot sort data type array -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-13494) Cannot sort on a column which is of type "array"
[ https://issues.apache.org/jira/browse/SPARK-13494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15172212#comment-15172212 ] Yael Aharon commented on SPARK-13494: - It is Spark 1.5.0 Using spark-assembly-1.5.0-cdh5.5.2-hadoop2.6.0-cdh5.5.2.jar in local mode > Cannot sort on a column which is of type "array" > > > Key: SPARK-13494 > URL: https://issues.apache.org/jira/browse/SPARK-13494 > Project: Spark > Issue Type: Bug > Components: SQL >Reporter: Yael Aharon > > Executing the following SQL results in an error if columnName refers to a > column of type array > SELECT * FROM myTable ORDER BY columnName ASC LIMIT 50 > The error is > org.apache.spark.sql.AnalysisException: cannot resolve 'columnName ASC' due > to data type mismatch: cannot sort data type array -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-13494) Cannot sort on a column which is of type "array"
[ https://issues.apache.org/jira/browse/SPARK-13494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15172186#comment-15172186 ] Xiao Li commented on SPARK-13494: - Are you saying Spark 1.5.2? > Cannot sort on a column which is of type "array" > > > Key: SPARK-13494 > URL: https://issues.apache.org/jira/browse/SPARK-13494 > Project: Spark > Issue Type: Bug > Components: SQL >Reporter: Yael Aharon > > Executing the following SQL results in an error if columnName refers to a > column of type array > SELECT * FROM myTable ORDER BY columnName ASC LIMIT 50 > The error is > org.apache.spark.sql.AnalysisException: cannot resolve 'columnName ASC' due > to data type mismatch: cannot sort data type array -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-13494) Cannot sort on a column which is of type "array"
[ https://issues.apache.org/jira/browse/SPARK-13494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15172115#comment-15172115 ] Yael Aharon commented on SPARK-13494: - I am using Spark 5.2 from Cloudera distribution CDH 5.2 . Do you think this was fixed since? The Hive schema of the column in question is array > Cannot sort on a column which is of type "array" > > > Key: SPARK-13494 > URL: https://issues.apache.org/jira/browse/SPARK-13494 > Project: Spark > Issue Type: Bug > Components: SQL >Reporter: Yael Aharon > > Executing the following SQL results in an error if columnName refers to a > column of type array > SELECT * FROM myTable ORDER BY columnName ASC LIMIT 50 > The error is > org.apache.spark.sql.AnalysisException: cannot resolve 'columnName ASC' due > to data type mismatch: cannot sort data type array -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-13494) Cannot sort on a column which is of type "array"
[ https://issues.apache.org/jira/browse/SPARK-13494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15170461#comment-15170461 ] Xiao Li commented on SPARK-13494: - Unable to reproduce it. Which version are you using? Can you share the schema of this table. > Cannot sort on a column which is of type "array" > > > Key: SPARK-13494 > URL: https://issues.apache.org/jira/browse/SPARK-13494 > Project: Spark > Issue Type: Bug > Components: SQL >Reporter: Yael Aharon > > Executing the following SQL results in an error if columnName refers to a > column of type array > SELECT * FROM myTable ORDER BY columnName ASC LIMIT 50 > The error is > org.apache.spark.sql.AnalysisException: cannot resolve 'columnName ASC' due > to data type mismatch: cannot sort data type array -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org