[jira] [Created] (HIVE-25652) Add constraints in result of “SHOW CREATE TABLE ”

[Soumyakanti Das (Jira)]

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)