Blocker Description
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))
}
The column names of persistent view stored in Hive metastore should be case preserving.
