You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:17:15 UTC
[jira] [Created] (TRAFODION-522) LP Bug: 1354228 - showddl does not
display 'no partition' clause
Alice Chen created TRAFODION-522:
------------------------------------
Summary: LP Bug: 1354228 - showddl does not display 'no partition' clause
Key: TRAFODION-522
URL: https://issues.apache.org/jira/browse/TRAFODION-522
Project: Apache Trafodion
Issue Type: Bug
Components: documentation
Reporter: Julie Thai
Assignee: Susan Sandstrom
Priority: Minor
Following create-table-no-partition-as-select, showddl does not display 'no partition' clause.
>>create table nosalt_1reg_orders primary key (o_orderkey) NO PARTITION no load as select * from g_tpch2x.orders;
--- 0 row(s) inserted.
>>showddl nosalt_1reg_orders;
CREATE TABLE TRAFODION.HASH2PART.NOSALT_1REG_ORDERS
(
O_ORDERKEY INT NO DEFAULT NOT NULL NOT DROPPABLE
, O_CUSTKEY INT NO DEFAULT NOT NULL NOT DROPPABLE
, O_ORDERSTATUS CHAR(1) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, O_TOTALPRICE NUMERIC(12, 2) NO DEFAULT NOT NULL NOT
DROPPABLE
, O_ORDERDATE DATE NO DEFAULT NOT NULL NOT DROPPABLE
, O_ORDERPRIORITY CHAR(15) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, O_CLERK CHAR(15) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, O_SHIPPRIORITY INT NO DEFAULT NOT NULL NOT DROPPABLE
, O_COMMENT VARCHAR(79) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, PRIMARY KEY (O_ORDERKEY ASC)
)
;
--- SQL operation complete.
>>showddl g_tpch2x.orders;
CREATE TABLE TRAFODION.G_TPCH2X.ORDERS
(
O_ORDERKEY INT NO DEFAULT NOT NULL NOT DROPPABLE
, O_CUSTKEY INT NO DEFAULT NOT NULL NOT DROPPABLE
, O_ORDERSTATUS CHAR(1) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, O_TOTALPRICE NUMERIC(12, 2) NO DEFAULT NOT NULL NOT
DROPPABLE
, O_ORDERDATE DATE NO DEFAULT NOT NULL NOT DROPPABLE
, O_ORDERPRIORITY CHAR(15) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, O_CLERK CHAR(15) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, O_SHIPPRIORITY INT NO DEFAULT NOT NULL NOT DROPPABLE
, O_COMMENT VARCHAR(79) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, PRIMARY KEY (O_ORDERKEY ASC)
)
SALT USING 8 PARTITIONS
;
--- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)