Thanks These are the list of tables and views
Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com On 19 May 2016 at 19:10, Thejas Nair <the...@hortonworks.com> wrote: > The pdf is not upside for me, in chrome browser. > > > However, there seems to be many tables that are not related to (or > rather used by) hive, specifically DMRV_* and DMRS_* ones. > > > Thanks, > > Thejas > > > ------------------------------ > *From:* Mich Talebzadeh <mich.talebza...@gmail.com> > *Sent:* Thursday, May 19, 2016 10:53 AM > *To:* user > *Cc:* user @spark > > *Subject:* Re: Hive 2 database Entity-Relationship Diagram > > thanks Dudu for your comments > > I will check. > > I will realign the overlapping tables > > Only partial tables have relationship not all I am afraid. Most DMRS_% > tables are standalone. > > I can see the PDF as it is can you kindly check the top left hand corner. > The one below > > > > > > Do you see this upside down > > Thanks[image: Inline images 1] > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > > On 19 May 2016 at 18:44, Markovitz, Dudu <dmarkov...@paypal.com> wrote: > >> Thanks Mich >> >> >> >> I’m afraid the current format is not completely user friendly. >> >> I would suggest to divide the tables to multiple sets by subjects / graph >> connectivity (BTW, it seems odd that most of the tables are disconnected) >> >> >> >> Also – >> >> · HIVEUSER.PARTITION_KEY_VALS is partially covering another table >> >> · The PDF is upside-down >> >> >> >> Dudu >> >> >> >> *From:* Mich Talebzadeh [mailto:mich.talebza...@gmail.com] >> *Sent:* Thursday, May 19, 2016 8:04 PM >> *To:* user <u...@hive.apache.org>; user @spark <user@spark.apache.org> >> *Subject:* Re: Hive 2 database Entity-Relationship Diagram >> >> >> >> Attachement >> >> >> Dr Mich Talebzadeh >> >> >> >> LinkedIn >> *https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> >> >> >> On 19 May 2016 at 18:02, Mich Talebzadeh <mich.talebza...@gmail.com> >> wrote: >> >> Hi All, >> >> >> >> I use Hive 2 with metastore created for Oracle Database with >> hive-txn-schema-2.0.0.oracle.sql. >> >> >> >> It already includes concurrency stuff added into metastore >> >> >> >> The RDBMS is Oracle Database 12c Enterprise Edition Release 12.1.0.2.0. >> >> >> >> I created an Entity-Relationship (ER) diagram from the physical model. >> There are 194 tables, 127 views and 38 relationships. The relationship >> notation is Bachman >> <https://www.google.co.uk/search?q=bachman+notation&biw=1920&bih=883&tbm=isch&tbo=u&source=univ&sa=X&sqi=2&ved=0ahUKEwjUx4e2zebMAhVMBsAKHTvOAcwQsAQILQ&dpr=1> >> >> >> >> Fairly big diagram in PDF format. However, you can zoom into it. >> >> >> >> >> >> Please have a kook and appreciate comments to me and if it is useful we >> can load it into wiki. >> >> >> >> >> >> HTH >> >> >> Dr Mich Talebzadeh >> >> >> >> LinkedIn >> *https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> >> >> > >
select table_name from user_tables order by 1; TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------- AUX_TABLE BUCKETING_COLS CDS COLUMNS_V2 COMPACTION_QUEUE COMPLETED_COMPACTIONS COMPLETED_TXN_COMPONENTS DATABASE_PARAMS DBS DB_PRIVS DELEGATION_TOKENS DMRS_ADDITIONAL_CT_OBJECTS DMRS_AGGR_FUNC_DIMENSIONS DMRS_AGGR_FUNC_LEVELS DMRS_ATTRIBUTES DMRS_AVT DMRS_BUSINESS_INFO DMRS_CHANGE_REQUESTS DMRS_CHANGE_REQUEST_ELEMENTS DMRS_CHECK_CONSTRAINTS DMRS_CLASSIFICATION_TYPES DMRS_COLLECTION_TYPES DMRS_COLUMNS DMRS_COLUMN_GROUPS DMRS_COLUMN_UI DMRS_CONSTR_FK_COLUMNS DMRS_CONSTR_INDEX_COLUMNS DMRS_CONTACTS DMRS_CONTACT_EMAILS DMRS_CONTACT_LOCATIONS DMRS_CONTACT_RES_LOCATORS DMRS_CONTACT_TELEPHONES DMRS_CUBES DMRS_CUBE_DIMENSIONS DMRS_DATA_FLOW_DIAGRAM_INFOS DMRS_DESIGNS DMRS_DIAGRAMS DMRS_DIAGRAM_ELEMENTS DMRS_DIMENSIONS DMRS_DIMENSION_CALC_ATTRS DMRS_DIMENSION_LEVELS DMRS_DISTINCT_TYPES DMRS_DOCUMENTS DMRS_DOCUMENT_ELEMENTS DMRS_DOMAINS DMRS_DOMAIN_AVT DMRS_DOMAIN_CHECK_CONSTRAINTS DMRS_DOMAIN_VALUE_RANGES DMRS_DYNAMIC_PROPERTIES DMRS_EMAILS DMRS_ENTITIES DMRS_ENTITYVIEWS DMRS_ENTITY_ARCS DMRS_EVENTS DMRS_EXISTENCE_DEP DMRS_EXISTENCE_DEP_COLUMNS DMRS_EXTERNAL_AGENTS DMRS_EXTERNAL_DATAS DMRS_EXT_AGENT_EXT_DATAS DMRS_EXT_AGENT_FLOWS DMRS_FACT_ENTITIES DMRS_FACT_ENTITIES_JOINS DMRS_FK_CD_CONSTRAINTS DMRS_FK_CD_CONSTRAINTS_COLS DMRS_FLOWS DMRS_FLOW_INFO_STRUCTURES DMRS_FOREIGNKEYS DMRS_GLOSSARIES DMRS_GLOSSARY_TERMS DMRS_HIERARCHIES DMRS_HIERARCHY_LEVELS DMRS_HIERARCHY_ROLLUP_LINKS DMRS_INDEXES DMRS_INFO_STORES DMRS_INFO_STRUCTURES DMRS_INFO_STRUCT_ATTRS DMRS_KEYS DMRS_KEY_ATTRIBUTES DMRS_KEY_ELEMENTS DMRS_LARGE_TEXT DMRS_LEVELS DMRS_LEVEL_ATTRS DMRS_LOCATIONS DMRS_LOGICAL_TO_NATIVE DMRS_LOGICAL_TYPES DMRS_MAPPINGS DMRS_MAPPING_TARGETS DMRS_MAPPING_TARGET_SOURCES DMRS_MASK_TEMPLATES DMRS_MEASUREMENTS DMRS_MEASURES DMRS_MEASURE_AGGR_FUNCS DMRS_MEASURE_FOLDERS DMRS_MEASURE_FOLDER_MEASURES DMRS_MODELS DMRS_MODEL_DISPLAYS DMRS_MODEL_NAMING_OPTIONS DMRS_MODEL_SUBVIEWS DMRS_NATIVE_TO_LOGICAL DMRS_NOTES DMRS_PK_OID_COLUMNS DMRS_PROCESSES DMRS_PROCESS_ATTRIBUTES DMRS_PROCESS_ENTITIES DMRS_RAGGED_HIER_LINKS DMRS_RAGGED_HIER_LINK_ATTRS DMRS_RDBMS_SITES DMRS_RECORD_STRUCTURES DMRS_RECORD_STRUCT_EXT_DATAS DMRS_RELATIONSHIPS DMRS_RESOURCE_LOCATORS DMRS_RESPONSIBLE_PARTIES DMRS_RES_PARTY_CONTACTS DMRS_RES_PARTY_ELEMENTS DMRS_ROLES DMRS_ROLE_PROCESSES DMRS_ROLLUP_LINKS DMRS_ROLLUP_LINK_ATTRS DMRS_SCHEMA_OBJECT DMRS_SENSITIVE_TYPES DMRS_SLICES DMRS_SLICE_DIM_HIER_LEVEL DMRS_SLICE_MEASURES DMRS_SOURCE_INFO DMRS_SPATIAL_COLUMN_DEFINITION DMRS_SPATIAL_DIMENSIONS DMRS_STRUCTURED_TYPES DMRS_STRUCT_TYPE_ATTRS DMRS_STRUCT_TYPE_METHODS DMRS_STRUCT_TYPE_METHOD_PARS DMRS_TABLES DMRS_TABLEVIEWS DMRS_TABLE_ARCS DMRS_TABLE_CONSTRAINTS DMRS_TABLE_INCLUDE_SCRIPTS DMRS_TASK_PARAMS DMRS_TASK_PARAMS_ITEMS DMRS_TELEPHONES DMRS_TRANSFORMATIONS DMRS_TRANSFORMATION_FLOWS DMRS_TRANSFORMATION_PACKAGES DMRS_TRANSFORMATION_TASKS DMRS_TRANSFORMATION_TASK_INFOS DMRS_TSDP_POLICIES DMRS_TSDP_SUB_POLICIES DMRS_VALUE_RANGES DMRS_VIEW_COLUMNS DMRS_VIEW_CONTAINERS DMRS_VIEW_ORDER_GROUPBY FUNCS FUNC_RU GLOBAL_PRIVS HIVEUSER_STATISTICS HIVE_LOCKS IDXS INDEX_PARAMS MASTER_KEYS NEXT_COMPACTION_QUEUE_ID NEXT_LOCK_ID NEXT_TXN_ID NOTIFICATION_LOG NOTIFICATION_SEQUENCE NUCLEUS_TABLES PARTITIONS PARTITION_EVENTS PARTITION_KEYS PARTITION_KEY_VALS PARTITION_PARAMS PART_COL_PRIVS PART_COL_STATS PART_PRIVS ROLES ROLE_MAP SDS SD_PARAMS SEQUENCE_TABLE SERDES SERDE_PARAMS SKEWED_COL_NAMES SKEWED_COL_VALUE_LOC_MAP SKEWED_STRING_LIST SKEWED_STRING_LIST_VALUES SKEWED_VALUES SORT_COLS TABLE_PARAMS TAB_COL_STATS TBLS TBL_COL_PRIVS TBL_PRIVS TXNS TXN_COMPONENTS TYPES TYPE_FIELDS VERSION 194 rows selected.
select view_name from user_views order by 1; VIEW_NAME -------------------------------------------------------------------------------------------------------------------------------- DMRS_INSTALLATION DMRS_VDIAGRAMS DMRV_AGGR_FUNC_DIMENSIONS DMRV_AGGR_FUNC_LEVELS DMRV_ATTRIBUTES DMRV_AVT DMRV_BUSINESS_INFO DMRV_CHANGE_REQUESTS DMRV_CHANGE_REQUEST_ELEMENTS DMRV_CHECK_CONSTRAINTS DMRV_CLASSIFICATION_TYPES DMRV_COLLECTION_TYPES DMRV_COLUMNS DMRV_COLUMN_GROUPS DMRV_COLUMN_UI DMRV_CONSTR_FK_COLUMNS DMRV_CONSTR_INDEX_COLUMNS DMRV_CONTACTS DMRV_CONTACT_EMAILS DMRV_CONTACT_LOCATIONS DMRV_CONTACT_RES_LOCATORS DMRV_CONTACT_TELEPHONES DMRV_CUBES DMRV_CUBE_DIMENSIONS DMRV_DATA_FLOW_DIAGRAM_INFOS DMRV_DESIGNS DMRV_DIAGRAMS DMRV_DIAGRAM_ELEMENTS DMRV_DIMENSIONS DMRV_DIMENSION_CALC_ATTRS DMRV_DIMENSION_LEVELS DMRV_DISTINCT_TYPES DMRV_DOCUMENTS DMRV_DOCUMENT_ELEMENTS DMRV_DOMAINS DMRV_DOMAIN_AVT DMRV_DOMAIN_CHECK_CONSTRAINTS DMRV_DOMAIN_VALUE_RANGES DMRV_EMAILS DMRV_ENTITIES DMRV_ENTITYVIEWS DMRV_EVENTS DMRV_EXTERNAL_AGENTS DMRV_EXTERNAL_DATAS DMRV_EXT_AGENT_EXT_DATAS DMRV_EXT_AGENT_FLOWS DMRV_FACT_ENTITIES DMRV_FACT_ENTITIES_JOINS DMRV_FLOWS DMRV_FLOW_INFO_STRUCTURES DMRV_FOREIGNKEYS DMRV_GLOSSARIES DMRV_GLOSSARY_TERMS DMRV_HIERARCHIES DMRV_HIERARCHY_LEVELS DMRV_HIERARCHY_ROLLUP_LINKS DMRV_INDEXES DMRV_INFO_STORES DMRV_INFO_STRUCTURES DMRV_INFO_STRUCT_ATTRS DMRV_KEYS DMRV_KEY_ATTRIBUTES DMRV_KEY_ELEMENTS DMRV_LARGE_TEXT DMRV_LEVELS DMRV_LEVEL_ATTRS DMRV_LOCATIONS DMRV_LOGICAL_TO_NATIVE DMRV_LOGICAL_TYPES DMRV_MAPPINGS DMRV_MAPPING_TARGETS DMRV_MAPPING_TARGET_SOURCES DMRV_MEASURES DMRV_MEASURE_AGGR_FUNCS DMRV_MEASURE_FOLDERS DMRV_MEASURE_FOLDER_MEASURES DMRV_MODELS DMRV_MODEL_DISPLAYS DMRV_MODEL_NAMING_OPTIONS DMRV_MODEL_SUBVIEWS DMRV_NATIVE_TO_LOGICAL DMRV_NOTES DMRV_PK_OID_COLUMNS DMRV_PROCESSES DMRV_PROCESS_ATTRIBUTES DMRV_PROCESS_ENTITIES DMRV_RAGGED_HIER_LINKS DMRV_RAGGED_HIER_LINK_ATTRS DMRV_RDBMS_SITES DMRV_RECORD_STRUCTURES DMRV_RECORD_STRUCT_EXT_DATAS DMRV_RELATIONSHIPS DMRV_REPORTS_VERSION_1_0 DMRV_RESOURCE_LOCATORS DMRV_RESPONSIBLE_PARTIES DMRV_RES_PARTY_CONTACTS DMRV_RES_PARTY_ELEMENTS DMRV_ROLES DMRV_ROLE_PROCESSES DMRV_ROLLUP_LINKS DMRV_ROLLUP_LINK_ATTRS DMRV_SLICES DMRV_SLICE_DIM_HIER_LEVEL DMRV_SLICE_MEASURES DMRV_SOURCE_INFO DMRV_SPATIAL_COLUMN_DEFINITION DMRV_SPATIAL_DIMENSIONS DMRV_STRUCTURED_TYPES DMRV_STRUCT_TYPE_ATTRS DMRV_STRUCT_TYPE_METHODS DMRV_STRUCT_TYPE_METHOD_PARS DMRV_TABLES DMRV_TABLEVIEWS DMRV_TABLE_CONSTRAINTS DMRV_TABLE_INCLUDE_SCRIPTS DMRV_TASK_PARAMS DMRV_TASK_PARAMS_ITEMS DMRV_TELEPHONES DMRV_TRANSFORMATIONS DMRV_TRANSFORMATION_FLOWS DMRV_TRANSFORMATION_PACKAGES DMRV_TRANSFORMATION_TASKS DMRV_TRANSFORMATION_TASK_INFOS DMRV_VALUE_RANGES DMRV_VIEW_COLUMNS DMRV_VIEW_CONTAINERS DMRV_VIEW_ORDER_GROUPBY 127 rows selected.
--------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@spark.apache.org For additional commands, e-mail: user-h...@spark.apache.org
