dongjoon-hyun commented on a change in pull request #26927: [SPARK-29505][SQL]
desc extended <table name> <column name> to be case insensitive
URL: https://github.com/apache/spark/pull/26927#discussion_r358938362
##########
File path: sql/core/src/test/scala/org/apache/spark/sql/SQLQuerySuite.scala
##########
@@ -3336,6 +3336,30 @@ class SQLQuerySuite extends QueryTest with
SharedSparkSession {
checkAnswer(df5, Array.empty[Row])
}
}
+
+ test("SPARK-29505: desc columnname - case insensitive search") {
+ withTable("customer") {
+ sql(s"create table customer(id int, name String, CName String, address
String, city String, pin int, country String)")
+ sql("insert into customer values(1,'Alfred','Maria','Obere Str
57','Berlin',12209,'Germany')")
+ sql("insert into customer values(2,'Ana','trujilo','Adva de la','Maxico
D.F.',05021,'Maxico')")
+ sql("insert into customer values(3,'Antonio','Antonio Moreno','Mataderos
2312','Maxico D.F.',05023,'Maxico')")
+ sql("analyze table customer compute statistics for columns cname")
Review comment:
`ANALYZE TABLE customer COMPUTE STATISTICS FOR COLUMNS cname`
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
