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)