[
https://issues.apache.org/jira/browse/HIVE-18950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aswathy Chellammal Sreekumar reassigned HIVE-18950:
---------------------------------------------------
> 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)
