Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-29505

desc extended <table name> <column name> is case sensitive

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • SQL
    • None

    Description

      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 |
      +-----------------+-------------+
       

       

      Attachments

        Issue Links

          Activity

            People

              pavithraramachandran pavithra ramachandran
              abhishek.akg ABHISHEK KUMAR GUPTA
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: