You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Vineet Garg (JIRA)" <ji...@apache.org> on 2018/04/05 20:52:00 UTC
[jira] [Resolved] (HIVE-18950) DESCRIBE EXTENDED missing details of
default constraint
[ https://issues.apache.org/jira/browse/HIVE-18950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vineet Garg resolved HIVE-18950.
--------------------------------
Resolution: Won't Fix
This is fixed by HIVE-18953
> 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
> Priority: Major
> 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)