ElemDDLNode.h

Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
CTAS fixes for ddl on hive objects

  1. … 26 more files in changeset.
TRAFODION-3086 Traf support for DDL operations on Hive objects

-- Support for TRAFODION-3086. Details in document attached to jira.

Other changes:

-- support for "if not exists", "if exists" clause for create/drop view

-- Support for: truncate T, truncate table T.

-- same as purgedata

-- showddl <tab>, detail

-- unregister hive schema <sch>

-- will unregister all objects in specified schema

-- Support for "if not registered", "if registered" clauss for

register/unregister command.

  1. … 90 more files in changeset.
new COMMENT-ON SQL statement: init

1. new SQL syntax: COMMENT ON

2. new component privilege: SQL_OPERATIONS::COMMENT

3. MD table changes: add new column for tables "_MD_".OBJECTS and

"_MD_".COLUMNS

4. SHOWDDL changes: add COMMENT-ON output for each object

5. new build-in views: "_MD_".OBJECT_COMMENT_VIEW and

"_MD_".COLUMN_COMMENT_VIEW

  1. … 25 more files in changeset.
[TRAFODION-2781] Omit LOB columns from update stats sample tables

  1. … 13 more files in changeset.
TRAFODION-2610 Register native HBase tables in traf MD plus couple more

-- support for registering hbase native cell/row format tables in traf MD

Syntax:

register [internal] hbase table [if not exists] <table-name>

unregister [internal] hbase table [if exists] <table-name>

-- support to get info related to registered hbase tables

Syntax: get hbase registered table in catalog trafodion

-- enhancements to HBase mapped tables and bug fixes

-- disabling of creation of external tables on native hbase

tables unless they are mapped tables

-- support for case-insensitive format string in TO_DATE function

(exp/exp_datetime.h)

-- regress/seabase/TEST022 enhanced with additional tests

  1. … 48 more files in changeset.
[TRAFODION-2603] Remove obsolete utilities and component privileges

  1. … 15 more files in changeset.
[TRAFODION-2584] Add support to register hive objects in traf metadata

Syntax:

register hive table/view [if not exists] <object-name> [cascade]

unregister hive table/view [if exists] <object-name> [cascade]

cascade option: register/unregister all underlying objects that are

part of the specified view

update statistics, grant/revoke, traf views or external table creation

on hive objects will automatically and internally register those objects

in trafodion metadata.

invoke/showddl will show if this object is registered and whether

that registration was internal or explicit.

Get command extensions:

get hive registered tables/view/objects in catalog trafodion;

get hive external tables in catalog trafodion;

Cleanup command extensions:

cleanup metadata command will clean up inconsistent hive objects

(underlying hive object is missing but object is registered or

an external table exists)

cleanup [hive table | hive view] on <object-name>;

Existing hive objects that had implicit or explicit external tables

created prior to this checkin will have no change in behavior.

ObjectUID of those external tables will continue to be used for

relevant operations.

One can drop those external tables and explicitly register them,

or a subsequent operation(upd stats, grant, etc) that needs objectUID will

automatically register them.

minor changes based on review comments of previous checkin

get all objects command on hive metadata no longer fails.

get views on objects return 3-part name that could be used to

differentiate between a traf and hive view.

regress/hive/TEST007 has been extended.

TBD: Add register/unregister privileges

  1. … 52 more files in changeset.
TRAFODION-1586 Add support for external Traf tables mappedd to HBase tables

This is the initial support for HBase mapped tables.

A doc for external manuals will be added later.

regress/seabase/TEST022 contains various testcases.

  1. … 77 more files in changeset.
[TRAFODION-2322] Improve UPDATE STATS performance on long char columns

  1. … 24 more files in changeset.
metadata access performance improvement for accessing traf objects

Packed version of descriptor structures is now stored in traf TEXT

table during various DDL operations.

During dml, if packed descriptors exist, then they are read and used.

If they dont exist, then descriptors are generated on the fly.

Descriptor classes are defined in file sqlcat/TrafDDLdesc.h and

are based off the older desc structures from desc.h.

These are simplified and class'ified version of the older structures

and are versioned. Changes to these classes should be done carefully

by either using filler bytes or versioning them.

2 new cqds, traf_store_object_descriptor and traf_read_object_descriptor,

are added to control if packed descs should be stored/read.

These are currently set to OFF by default but are enabled during

regressions run. Once this feature is tested, these cqds will be turned

on by default.

In addition, some helper commands have been added to manipulate descrs.

Syntax:

alter table t [check|generate|delete|disable|enable] stored descritors

If authorization is enabled, then auth/priv specific info

is generated on the fly and currently not stored in metadata.

In a later checkin, these will also be stored in metadata.

  1. … 74 more files in changeset.
[TRAFODION-2044] Support SALT clause on CREATE TABLE LIKE

  1. … 16 more files in changeset.
update

  1. … 298 more files in changeset.
JIRA 1849 Add support for alter column rename (details below)

-- support for 'add column c rename to newc'

-- fixed issue with ddl stmts and aqr, it now works correctly

if ddl_transactions are being used

-- drop table with views now drops them in reverse creation order.

That way dependent views are dropped correctly.

-- views are dropped before and recreated after an alter column

statement.

-- dev regressions tests now show system columns in invoke.

-- index uid is now stored in desc and NATable structs

  1. … 51 more files in changeset.
JIRA TRAFODION-19 && TRAFODION-1483

JIRA TRAFODION-19:

Made the following changes:

Removed support for locklength from the parser

Test and fix issues with create table variants

Made recommended changes as mentioned in the initial delivery

Rename some of the variable names to make them more informative

Assume prefix length for HIVE and HBASE tables can be different and verify code works correctly

Fix commented code to be correct and remove lines no longer needed

Update error text for messages 1180 to include external table type

Beefed up the new regression test (hive/TEST009)

Check column list from hive descriptor with external table description and return an error if there is a mismatch

Add an error if the user specifies a different target schema name than the source

Allow someone with privileges to drop HIVE exernal schemas

JIRA TRAFODION-1483:

Added support for external HBase tables similar to Hive table support

  1. … 33 more files in changeset.
Fixes for Jira's trafodion-19 & trafodion-29

See Jira's for a description.

Also removed obsolete code from the parser

  1. … 46 more files in changeset.
Merge remote branch 'origin/master' into fix1

Conflicts:

core/sql/sqlcomp/DefaultConstants.h

  1. … 27 more files in changeset.
Part 2 of changes to update license text in Trafodion source

This check-in updates license text in all source files in the

core/sql directory. Remaining directories will be done in

later check-ins.

  1. … 3147 more files in changeset.
commit #1

  1. … 27 more files in changeset.
support for alter column datatype(TRAFODION-18).

Syntax: alter table <t> alter column <a> <new_datatype>;

Following conditions need to be met for alter to work:

-- old and new column datatype must be VARCHAR (variable length string datatype)

-- new col length must be greater than or equal to old length

-- old and new character sets must be the same

-- altered columns cannot be part of primary key or secondary index key

-- table cannot be a volatile table.

An error (1404) will be returned if these conditions are not met.

  1. … 17 more files in changeset.
Move core into subdir to combine repos

  1. … 10768 more files in changeset.
Move core into subdir to combine repos

  1. … 10622 more files in changeset.
Move core into subdir to combine repos

Use: git log --follow -- <file>

to view file history thru renames.

  1. … 10837 more files in changeset.