[
https://issues.apache.org/jira/browse/SPARK-29505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyukjin Kwon updated SPARK-29505:
---------------------------------
Description:
{code}
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 |
+-----------------+----------
{code}
But
desc extended customer CName; – SUCCESS
{code}
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 |
+-----------------+-------------+
{code}
was:
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 |
+-----------------+-------------+
> 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
> Priority: Major
>
> {code}
> 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 |
> +-----------------+----------
> {code}
>
> But
> desc extended customer CName; – SUCCESS
> {code}
> 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 |
> +-----------------+-------------+
> {code}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
