Aswathy Chellammal Sreekumar created HIVE-18950:
---------------------------------------------------
Summary: DESCRIBE EXTENDED missing details of default constraint
Key: HIVE-18950
URL: https://issues.apache.org/jira/browse/HIVE-18950
Project: Hive
Issue Type: Bug
Components: Hive
Affects Versions: 3.0.0
Reporter: Aswathy Chellammal Sreekumar
Assignee: Vineet Garg
Fix For: 3.0.0
Describe extended output is missing default constraint details
{noformat}
0: jdbc:hive2://ctr-e138-1518143905142-95188-> create table t1(j int constraint
c1 default 4);
INFO : Compiling
command(queryId=hive_20180313202851_de315f0e-4064-467d-9dcc-f8dd7f737318):
create table t1(j int constraint c1 default 4)
INFO : Semantic Analysis Completed
INFO : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
INFO : Completed compiling
command(queryId=hive_20180313202851_de315f0e-4064-467d-9dcc-f8dd7f737318); Time
taken: 0.015 seconds
INFO : Executing
command(queryId=hive_20180313202851_de315f0e-4064-467d-9dcc-f8dd7f737318):
create table t1(j int constraint c1 default 4)
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing
command(queryId=hive_20180313202851_de315f0e-4064-467d-9dcc-f8dd7f737318); Time
taken: 0.048 seconds
INFO : OK
No rows affected (0.087 seconds)
{noformat}
{noformat}
0: jdbc:hive2://ctr-e138-1518143905142-95188-> DESCRIBE EXTENDED t1;
INFO : Compiling
command(queryId=hive_20180313215805_0596cea8-918c-46f7-bd9a-8611972eb3cc):
DESCRIBE EXTENDED t1
INFO : Semantic Analysis Completed
INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name,
type:string, comment:from deserializer), FieldSchema(name:data_type,
type:string, comment:from deserializer), FieldSchema(name:comment, type:string,
comment:from deserializer)], properties:null)
INFO : Completed compiling
command(queryId=hive_20180313215805_0596cea8-918c-46f7-bd9a-8611972eb3cc); Time
taken: 0.029 seconds
INFO : Executing
command(queryId=hive_20180313215805_0596cea8-918c-46f7-bd9a-8611972eb3cc):
DESCRIBE EXTENDED t1
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing
command(queryId=hive_20180313215805_0596cea8-918c-46f7-bd9a-8611972eb3cc); Time
taken: 0.03 seconds
INFO : OK
+-----------------------------+----------------------------------------------------+----------+
| col_name | data_type
| comment |
+-----------------------------+----------------------------------------------------+----------+
| j | int
| |
| | NULL
| NULL |
| Detailed Table Information | Table(tableName:t1, dbName:default,
owner:hrt_qa, createTime:1520972931, lastAccessTime:0, retention:0,
sd:StorageDescriptor(cols:[FieldSchema(name:j, type:int, comment:null)],
location:hdfs://mycluster/apps/hive/warehouse/t1,
inputFormat:org.apache.hadoop.mapred.TextInputFormat,
outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat,
compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null,
serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe,
parameters:{serialization.format=1}), bucketCols:[], sortCols:[],
parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[],
skewedColValueLocationMaps:{}), storedAsSubDirectories:false),
partitionKeys:[], parameters:{totalSize=0, numRows=0, rawDataSize=0,
transactional_properties=insert_only,
COLUMN_STATS_ACCURATE={\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"j\":\"true\"}},
numFiles=0, transient_lastDdlTime=1520972931, transactional=true},
viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE,
rewriteEnabled:false) | |
+-----------------------------+----------------------------------------------------+----------+
3 rows selected (0.099 seconds){noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
