11/9/2023 0 Comments Mysql create user for hiveYour database has been imported to new documentation in the repository. Once import is done, close import window with Finish button. Next screen allow you to change default name of the documentation under which it will be visible in Dataedo repository.Ĭlick Import to start the import. You can also use advanced filter to narrow down list of objects.Ĭonfirm list of objects to import by clicking Next. When connection was successful Dataedo will read objects and show a list of objects found. Previous example of configuration uses MySQL jdbc connector, although others database engines follow convention. - here you need to extract infromation from jdbc connection string which has format: jdbc:://:/?others_options.Once you have all the properties, you need to extract details: You should find all of them in configuration element of hive-site.xml file. In this file you need to look for properties: In most cases it will be: /etc/hive/conf/hive-site.xml. File is located in Hive installation directory in conf catalog. You can find all required details in hive-site.xml file which contains a configuration of Hive Metastore database connection. CREATE USER 'hive''localhost' IDENTIFIED BY 'hive' password expire never The following SQL statement. The following code snippet creates a user named 'hive' with password ('hive') that never expires. How to get connection details of Hive Metastore database This code snippet shows you how to create a database user with password in MySQL or MariaDB. Obtaining all details is described in chapter How to get connection details of Hive Metastore database. You will get a table of Hive databases with Database Name, Description, Catalog Name and Catalog description columns: You can expand list of databases by clicking. Metastore database - name of MySQL database hosting the metastore.Port - port under which database is available,.Host - hostname or IP address of server on which database is available,.Then you need to provide connection details accordingly for selected database:įollowing connection example will be based on MySQL, although others databases will have similar fields required for connection: You need to select database engine hosting Hive Metastore: On the connection screen choose Apache Hive Metastore as DBMS. To connect to Hive Metastore and create new documentation by clicking Add documentation and choosing Database connection. to hiveuserlocalhost identified by hivepassword. Applies to: Dataedo 23.x (current) versions, mysql> CREATE USER hiveuser IDENTIFIED BY hivepassword mysql> GRANT all on.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |