You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Apache Spark (JIRA)" <ji...@apache.org> on 2017/06/20 08:54:00 UTC
[jira] [Commented] (SPARK-21150) Persistent view stored in Hive
metastore should be case preserving.
[ https://issues.apache.org/jira/browse/SPARK-21150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16055388#comment-16055388 ]
Apache Spark commented on SPARK-21150:
--------------------------------------
User 'cloud-fan' has created a pull request for this issue:
https://github.com/apache/spark/pull/18360
> Persistent view stored in Hive metastore should be case preserving.
> -------------------------------------------------------------------
>
> Key: SPARK-21150
> URL: https://issues.apache.org/jira/browse/SPARK-21150
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.2.0
> Reporter: Xiao Li
> Priority: Blocker
>
> {noformat}
> withView("view1") {
> spark.sql("CREATE VIEW view1 AS SELECT 1 AS cAsEpReSeRvE, 2 AS aBcD")
> val metadata = new MetadataBuilder().putString(types.HIVE_TYPE_STRING, "int").build()
> val expectedSchema = StructType(List(
> StructField("cAsEpReSeRvE", IntegerType, nullable = false, metadata),
> StructField("aBcD", IntegerType, nullable = false, metadata)))
> assert(spark.table("view1").schema == expectedSchema, "Schema should match")
> checkAnswer(
> sql("select aBcD, cAsEpReSeRvE from view1"),
> Row(2, 1))
> }
> {noformat}
> The column names of persistent view stored in Hive metastore should be case preserving.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org