[jira] [Created] (SPARK-29505) desc extended is case sensitive

ABHISHEK KUMAR GUPTA created SPARK-29505:
--------------------------------------------

             Summary: desc extended <table name> <column name> is case sensitive
                 Key: SPARK-29505
                 URL: https://issues.apache.org/jira/browse/SPARK-29505
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: ABHISHEK KUMAR GUPTA


create table customer(id int, name String, *CName String*, address String, city String, pin int, country String);
insert into customer values(1,'Alfred','Maria','Obere Str 57','Berlin',12209,'Germany');
insert into customer values(2,'Ana','trujilo','Adva de la','Maxico D.F.',05021,'Maxico');
insert into customer values(3,'Antonio','Antonio Moreno','Mataderos 2312','Maxico D.F.',05023,'Maxico');

analyze table customer compute statistics for columns cname; – *Success( Though cname is not as CName)*

desc extended customer cname; – Failed

jdbc:hive2://10.18.19.208:23040/default> desc extended customer *cname;*
+-----------------+-------------+
| info_name | info_value |
+-----------------+-------------+
| col_name | cname |
| data_type | string |
| comment | NULL |
| min | NULL |
| max | NULL |
| num_nulls | NULL |
| distinct_count | NULL |
| avg_col_len | NULL |
| max_col_len | NULL |
| histogram | NULL |
+-----------------+----------

 

But 

desc extended customer CName; – SUCCESS

0: jdbc:hive2://10.18.19.208:23040/default> desc extended customer *CName;*
+-----------------+-------------+
| info_name | info_value |
+-----------------+-------------+
| col_name | CName |
| data_type | string |
| comment | NULL |
| min | NULL |
| max | NULL |
| num_nulls | 0 |
| distinct_count | 3 |
| avg_col_len | 9 |
| max_col_len | 14 |
| histogram | NULL |
+-----------------+-------------+

 

 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org

---