showddl does not show the hbase options used when the table was created

Bug #1342465 reported by Anoop Sharma
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Fix Released
Medium
Anoop Sharma

Bug Description

At table create time, users can specify hbase options (like BLOCKCACHE, COMPRESSION, etc).
But a showddl on that table does not show those options.

Ex:
  create table t (a int not null primary key) hbase_options (blockcache = 'TRUE', COMPRESSION = 'LZ4').

  showddl t;
  -- does not show hbase_options.

Need to save these options in metadata and then display them when showddl is issued.

Tags: sql-cmp
summary: - showddl does not show hbase options used when a table is created
+ showddl does not show the hbase options used when the table was created
Changed in trafodion:
status: New → In Progress
Revision history for this message
Anoop Sharma (anoop-sharma) wrote :

showddl will now show hbase options that the table was created with.

>>showddl t;

CREATE TABLE TRAFODION.SCH.T
  (
    A INT NO DEFAULT NOT NULL NOT DROPPABLE
  , PRIMARY KEY (A ASC)
  )
  HBASE_OPTIONS
  (
    BLOCKCACHE = 'TRUE'
  )
;

--- SQL operation complete.
>>

Changed in trafodion:
status: In Progress → Fix Committed
Changed in trafodion:
milestone: none → r0.9
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.