Soumyakanti Das created HIVE-25652:
--------------------------------------
Summary: Add constraints in result of “SHOW CREATE TABLE ”
Key: HIVE-25652
URL: https://issues.apache.org/jira/browse/HIVE-25652
Project: Hive
Issue Type: Improvement
Reporter: Soumyakanti Das
Assignee: Soumyakanti Das
Currently show create table doesn’t pull any constraint info like not null,
defaults, primary key.
Example:
Create table
{code:java}
CREATE TABLE TEST(
col1 varchar(100) NOT NULL COMMENT "comment for column 1",
col2 timestamp DEFAULT CURRENT_TIMESTAMP() COMMENT "comment for column 2",
col3 decimal,
col4 varchar(512) NOT NULL,
col5 varchar(100),
primary key(col1, col2) disable novalidate)
ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat';
{code}
Currently {{SHOW CREATE TABLE TEST}} doesn't show the column constraints.
{code:java}
CREATE TABLE `test`(
`col1` varchar(100) COMMENT 'comment for column 1',
`col2` timestamp COMMENT 'comment for column 2',
`col3` decimal(10,0),
`col4` varchar(512),
`col5` varchar(100))
ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)