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
- links to