hue的元数据库数据字典梳理

1.?数据库表项说明

1.1.?auth_group客户组认证表

— id??? ?

— name//客户组（groups）的名字

1.2.?auth_group_permission客户组认证权限管理表

?– id?????

?– group_id????

?– permission_id

1.3.?auth_permission客户组认证权限表

??? ?– id??? ?

— name//权限具体名称????

?– content_type_id????

?–codename//权限code

1.4.?auth_user客户认证表

?– id

??? ?– password//客户登陆密码

??? ?– last_login//最近一次登陆时间

??? ?– is_superuser//能否是superuser，1表示是，0表示不是

??? ?– username//客户名

??? ?– first_name//客户first_name?

??? ?– last_name//客户last_name

??? ?– email//客户email

??? ?– is_staff?????//

??? ?– is_active//能否active?

??? ?– date_joined//创立时间

1.5.auth_user_group客户组认证组

??? ?– id??? ?

— user_id????

?– group_id

1.6.auth_user_user_permissions客户认证权限表

??? ?– id??? ?

— user_id????

?– permission_id

1.7.?beeswax_metainstall?beewax（hive） 元数据安装表

??? ?– installed_example

??? ?– id

1.8.?beeswax_queryhostory?beewax(hive最近查询摘要) ?查询历史

??? ?– submission_date//提交时间

??? ?– last_state????????//

??? ?– server_id

??? ?– log_context

??? ?– designed_id

??? ?– owner_id

??? ?– query//查询sql语句

??? ?– has_results//能否有结果

??? ?– id

??? ?– notify

??? ?– server_name//使用什么查看的（hive/mysql）

??? ?– server_host//查询使用的主机ip

??? ?– server_port//查询使用的端口

??? ?– server_type//查询使用的服务

??? ?– server_guid

??? ?– operation_type

??? ?– modified_row_count

??? ?– statement_number

??? ?– query_type

??? ?– is_redacted

??? ?– extra

??? ?– is_cleared

1.9.?beeswax_savedquery?beeswax查询保存表

??? ?– name??//My saved query

??? ?– type???

??? ?– is_auto

??? ?– mtime//时间

??? ?– owner_id

??? ?– data//查询的信息

??? ?– id

??? ?– desc

??? ?– is_trashed

??? ?– is_redacted

1.10.?beeswax_session?? beewax会话

??? ?– last_used

??? ?– status_code

??? ?– server_protocol_version

??? ?– secret

??? ?– owner_id

??? ?– guid

??? ?– id

??? ?– application

??? ?– properties

1.11.?desktop_document??desktop保存查询记录表

??? ?– description

??? ?– extra

??? ?– object_id

??? ?– last_modified

??? ?– content_type_id

??? ?– version

??? ?– owner_id

??? ?– id

??? ?– name

1.12.desktop_document_tags?desktop文档标签

??? ?– id

??? ?– document

??? ?– documenttag_id

1.13.?desktop_document2?? desktop所有查询历史

??? ?– id

??? ?– owner_id

??? ?– name

??? ?– description

??? ?– uuid

??? ?– type

??? ?– data

??? ?– extra

??? ?– last_modified

??? ?– version

??? ?– is_history

??? ?– parent_directory_id

??? ?– search

??? ?– is_managed

??? ?– is_trashed

1.14.desktop_document2_dependencies

??? ?– id

??? ?– from_document2_id

??? ?– to_document2_id

1.15.?desktop_document2permission

??? ?– id

??? ?– doc_id

??? ?– perms

1.16.desktop_documentpermission

??? ?– perms

??? ?– doc_id

??? ?– id

1.17.?desktop_documenttag

??? ?– owner_id

??? ?– tag

??? ?– id

1.18.?desktop_settings

??? ?– collect_usage

??? ?– id

??? ?– tours_and_tutorials

1.19.?desktop_userpreferences

??? ?– value

??? ?– id

??? ?– key

??? ?– user_id

1.20.?django_admin_log前台django admin客户日志

??? ?– id

??? ?– action_time

??? ?– user_id

??? ?– content_type_id

??? ?– object_id

??? ?– object_repr

??? ?– action_flag

??? ?– change_message

1.21.?django_XXXX?? django前台配置数据表

1.22.?documentpermission_groups

??? ?– id

??? ?– documentpermissi

??? ?– group_id

1.23.?documentpermission_users

??? ?– id

??? ?– documentmissi

??? ?– user_id

1.24.?documentpermission2_groups

??? ?– id

??? ?– document2permis

??? ?– group_id

1.25.?documentpermission2_users?? ?

??? ?– id

??? ?– document2permis

??? ?– user_id

1.26.?jobsub_XXX?? ?job查询子任务表

1.27.?oozie_XXXXXX ?oozie存储表

1.28.pig_XX ?pig存储表

1.29.search_collection搜索收藏

1.30.search_facet?? ???

1.31.?search_result查询结果

1.32.search_sorting查询排序

1.33.?south_migrationhistory迁移历史

1.34.?useradmin_grouppermission admin客户组权限

–hue_permission_id

–group_id

–id

1.35.?useradmin_huepermission?admin客户hue权限

–action ??//活动

–app ????//hue的app名字（如metastore）

???–id

–description ?//活动形容

1.36.?useradmin_ldapgroup admin客户ldap认证客户组

?–group_id

?–id

1.37.?useradmin_userprofile?? admin客户属性

— home_directort?? ??? ?//客户存储路径

??? ?– id ?? ??? ??? ??? ??? ?

??? ?– user_id

??? ?– creation_method//客户路径创立方法

??? ?– first_login

参考原文https://blog.csdn.net/u012965373/article/details/82119552