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.
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
[TRAFODION-2584] Add support to register hive objects in traf metadataSyntax: 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 viewupdate statistics, grant/revoke, traf views or external table creationon hive objects will automatically and internally register those objectsin trafodion metadata.invoke/showddl will show if this object is registered and whetherthat 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 tablescreated prior to this checkin will have no change in behavior.ObjectUID of those external tables will continue to be used forrelevant operations.One can drop those external tables and explicitly register them,or a subsequent operation(upd stats, grant, etc) that needs objectUID willautomatically register them.minor changes based on review comments of previous checkinget 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
Part 1 of updates to licensing info in Trafodion sourceAdded NOTICE.txt file in root directory per ASF guidelines.Updated copyright text in one directory (core/sql/sqlcomp)as a test of a tool to update such text. One or more latercheck-ins will take care of the remaining directories.